Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP6 and MySQL connection problems
Message
From
07/06/2005 16:41:49
 
 
To
05/06/2005 19:12:48
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:
01021130
Views:
21
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform