Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP6 and MySQL connection problems
Message
From
08/06/2005 04:46:37
 
 
To
07/06/2005 16:41:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows XP
Database:
MySQL
Miscellaneous
Thread ID:
01020358
Message ID:
01021266
Views:
16
Hi

I have read this question in the group first, so I have answered it there.

>Thanks a lot man! I really appreciate your help. How to parce the SQL query when "in the game" are character type field in SQLEXEC? I tryied different version of syntax but nothing?
>
>public cquery
>cquery="John"
>=SQLEXEC(chandle,"Select * from salesman where name = ?cquery','CursorS')
>
>or
>
>=SQLEXEC(chandle,"Select * from salesman where name = "John"','CursorS')
>
>won't work? With numeric field working fine. Heeelp.
>
>Thanks in advance!
>
>Elvir
Grigore Dolghin
Class Software.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform