Hi João!
>Hi all,
>After i retrieve a cursor with SQLEXEC from SQL Server, with>lcAliasTmp=LOWER(SYS(2015))
>=SQLEXEC(.cSQLEXECCon,.oDocFac.cSQLQuery,lcAliasTmp)
>and then try to do that,>lcAliasMapa=LOWER(SYS(2015))
>SELECT * FROM &lcAliasTmp INTO TABLE '.\tmp\'+lcAliasMapa
>ALTER TABLE &lcAliasMapa ADD COLUMN DataI d(8)
>VFP gives the error 1491-No update tables are specified. Use the tables property of the cursor.
>Any help here...
>João Batista
I don't know what is the problem, but you can to try this. When you to create the table create also the new field, thus:
lcAliasMapa=LOWER(SYS(2015))
SELECT *, {} DataI FROM &lcAliasTmp INTO TABLE '.\tmp\'+lcAliasMapaI hope this help you.
Bye!
Erick
Força Sempre!
Strength Always!
