>>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.
>
>Laurentiu
>
>Not sure if this is it but I 'believe' VFP has a 255 char limit on statments. IE: the list of fields cannot continue on & on... (s) I myself use small SQL's since they are quicker then one massive one (believe it or not). So I have not run into this for awhile & I might be a little foggy on this.
>
>HTH,
>Tom
A workaround for this is to use the '&string' operator for some of the SQL. But ususally if I just copy the code assembled by a designer into a program the length limitation problem disappears. There definitely is a designer char length limit, I've bumped into it more than once...255 sounds reasonable.