Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLExec and Select...
Message
From
10/03/2004 22:36:59
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQLExec and Select...
Miscellaneous
Thread ID:
00885079
Message ID:
00885079
Views:
58
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
Next
Reply
Map
View

Click here to load this message in the networking platform