Gadi,
Gadi,
This one worked for me:
USE ___ ALIAS MyTable
CREATE CURSOR Dummy (MyField C(20))
INSERT INTO Dummy VALUES ("MyTable")
SELECT((ALLTRIM(Dummy.MyField)))
>Hi I'm trying to select an open table.
>The name of the table is stored in a field in another table, so I need to get the value out of the field for the SELECT command. I use the EVALUATE command, but I get an error "Alias 'xxx' is not found". The syntax is:
>SELECT evaluate('xxx')
>
>Any ideas?
>
>Many thanks,
>
>Gadi Hutt