>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