Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with SQL statement
Message
 
 
To
08/06/2009 10:49:58
Alp Berker
Defense Finance and Accounting Services
Indianapolis, Indiana, United States
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01403892
Message ID:
01404456
Views:
35
>Hi Naomi,
>Thank you for your suggestions, but I already did a delete tag all and deleted the indexes and recreated all of them for all the tables. It didn't help.
>The qlp-all table has 23 fields, about 468,000. Would 23 fields cause this? I can always test with a few fields from qlp-all.
>I appreciate the suggestions. I hope to have this figured out.

1. Using Cetin's suggestion try to rename qlp-all to qlp_all

2. Try to make your SQL to be ANSI compatible

3. Try with only few fields from q table.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform