Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
No question, Marx.
Message
De
27/04/2008 20:01:04
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
No question, Marx.
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP1
Divers
Thread ID:
01313400
Message ID:
01313400
Vues:
61
h=sqlstringconnect("your connect string here")
?sqlexec(h, "-- is this a proper comment?", "none")
You get a nice "SQL parameter is missing." error for this.

Why? Because there's a question mark in the SQL command being sent, and VFP parses it, looking for parameters. Well, the parser isn't too smart - if it was, it would be writing SQL for us, right? - so it finds a question mark followed by nothing that would serve as a variable name, a-ha! Error.

Just in case someone else bangs into this particular corner of the wall, may they escape without this ugly bump on the forehead.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform