Information générale
Titre:
Error 1812 - SQL statement too long
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement