Can I do this in ESQL/C

Hi there, Inside my file foo.ec i want to do the following . . . $int dataID; $int classTYPE; $char tableName[32]; strcpy(tableName, "foo1"); $SELECT tableName.dataid, tableName.classtype INTO $dataID, $classTYPE FROM tableName WHERE tableName.dataid < 50; . . . I want to use an esql-variable for the tableName instead of the real table-name. The compiler say nothing but i got an 206 - specified table not in DB - when running, because esql didn't recognize, that i want to use a variable. How can i tell esql to use this variable, or is it impossible. Thanks in advanced Dirk Hellmann -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum