General information
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only