Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange SQL code Generation from Remote View
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Strange SQL code Generation from Remote View
Miscellaneous
Thread ID:
00131573
Message ID:
00131573
Views:
47
I'm using VFP 5.0 as a front-end to MySQL server running on a linux box. I'm using the remote view designer to create a paramterized view and the SQL code that is generated is quite strange.

Select Projects.qnumber, Projects.suffix, Projects.account from projects Projects where Projects.account=?lcAccount

The part that is stumping me is the FROM PROJECTS PROJECTS WHERE.
Where is this coming from and how do I fix it? If you need anymore info please write me back.

Thank in advance
Rob Bondy
Robert Bondy
Contemporary Computer Concepts, Inc.
E-Mail: rbondy@3c-inc.com
Web: www.3c-inc.com

"You're not the only one with the means
when you're sharing what you mean!"
Next
Reply
Map
View

Click here to load this message in the networking platform