Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with SQL statement
Message
 
 
À
08/06/2009 10:49:58
Alp Berker
Defense Finance and Accounting Services
Indianapolis, Indiana, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01403892
Message ID:
01404456
Vues:
34
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform