Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLExec and Select...
Message
From
11/03/2004 03:20:28
Suhas Hegde
Dental Surgeon
Sirsi, India
 
 
To
10/03/2004 22:36:59
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00885079
Message ID:
00885111
Views:
21
>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

hi João
may be i am missing something or shouldnt this
lcAliasMapa=LOWER(SYS(2015))			
SELECT * FROM &lcAliasTmp INTO TABLE '.\tmp\'+lcAliasMapa
be
lcAliasMapa=LOWER(SYS(2015))			
SELECT * FROM &lcAliasTmp INTO TABLE '.\tmp\' + &lcAliasMapa
Suhas
Previous
Reply
Map
View

Click here to load this message in the networking platform