Re: Can I do this in ESQL/C

On 26 Aug 98 at 9:35, dirk.hellmann@laufenberg.com wrote: > $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. Dirk, I'm really rusty on ESQL/C, but you might want to look into PREPAREing a statement from a character string. HTH. -- Ciao, Billy /Group Managing Director, The West Solutions Group: http://www.west.co.za \\ Drivel @ http://www.west.co.za/tasteless/ / \\ "Granted, Mr Wheeler's ideas are stupid and unreasonable, but he does own the company and I / think we should go along with him..." \\________________________________________________________________________________________________