Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLExec and Select...
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00885079
Message ID:
00886245
Views:
18
Don't know what you have in ,.oDocFac.cSQLQuery, but why not modify if so it include the fields you need:
.oDocFac.cSQLQuery = "Select *, Cast('' As datetime) as DataI From ...." 
=SQLEXEC(.cSQLEXECCon,.oDocFac.cSQLQuery,lcAliasTmp)
Select * From (lcAliasTmp) Into cursor SomeCursor READWRITE
HTH


>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
Previous
Reply
Map
View

Click here to load this message in the networking platform