Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error 1812 - SQL statement too long
Message
De
08/11/1996 02:53:54
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
Error 1812 - SQL statement too long
Divers
Thread ID:
00011796
Message ID:
00011796
Vues:
106
I have a table (not free table) with 33 fields, lenght of record is 411 and aprox. 40,000 records.
I made a local view for a certain filter (Table.data = ?varData .AND. Deleted() = .F.), SQL WHERE=Key and Updatable Fields, Send Update = .T., all fields marked as updatable, no. of records filtered is about 100.
My computer: 486DX/120MHz, 16Mb RAM, 850Mb HDD, Windows 95.
Problem is: when I replace value for a field (inside an application) and I move from the record (to send the updates to parent table) I receive the error 1812 and I can do nothing from here (not even close the view).
I mention that I use the database shared (in multiuser environment).
What can I do about it? There are some setings to solve this problem, or the view is too big.
Thanks,
Laurentiu
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform