Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 1812 - SQL statement too long
Message
From
08/11/1996 02:53:54
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Error 1812 - SQL statement too long
Miscellaneous
Thread ID:
00011796
Message ID:
00011796
Views:
96
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
Map
View

Click here to load this message in the networking platform