Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How long can a SQL statement be?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00400812
Message ID:
00400824
Vues:
20
Hi Ulises,

Check that the 9th field is not a VFP keyword (type it in the commeand window and see if it turns blue)

Cheers,

Andrew




>I have a grid populated by a SQL Statement. I need 9 fields there.
>It works fine as long as I "Select (8 fields)..." as soon as I try to add the 9th field, I get a "Command contains unrecognized phrase/keyword" error message. I'm positive that my syntax is correct.
>What is the problem?
>Thank you for your time.
>
>Ulises.


If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?


From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."


All my FoxTalk and other articles are available on my web site.


Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform