Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLEXEC not working with variable as parameter
Message
De
24/11/2000 19:11:48
 
 
À
24/11/2000 18:48:12
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00445283
Message ID:
00445297
Vues:
23
lcSQL = 'Select * from Person'

Contents of laError:
[1,1] 1526
[1,2] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Person'.
[1,3] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Person'.
[1,4] S0002
[1,5] 208
[1,6] 13
[1,7] NULL

Sounds like my table name's not specified correctly. I've also tried person.dbf, dbo.person, dbo.peraon.dbf. I'm obviously not specifying the backend table name correctly. This is an upsized VFP database, and the original table in question is person.dbf, in case you hadn't guessed :-)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform