Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLExec and Select...
Message
De
11/03/2004 03:20:28
Suhas Hegde
Dental Surgeon
Sirsi, Inde
 
 
À
10/03/2004 22:36:59
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00885079
Message ID:
00885111
Vues:
22
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform