>>>I think I'd start simple in order to find out where the failure is occuring:
>>>
>>>a) try exclusive on table
>>>use enroll exclu
>>>*-- make sure .t. is returned.
>>>llOk = cursorsetprop('buffering', 5, 'enroll')
>>>edit a single record.
>>>x = tableupdate(1, .t., 'enroll')
>>>?Did it work?
>>>
>>>b) try adding a record.
>>>check the primary key - no duplicates?
>>>attempt tableupdate on a single insert.
>>>
>>>In other words - start very simple - working your way up until you remove the exclu, progress onto more than one insert, check and assume nothing. Its vfp you know.
>>>
>>>Robert
>>>
>>>
>>
>>It doesn't have problems outside of the form, so there is definately something going on there. I've traced everything through and if I do a TABLEUPDATE after the first INSERT, I get the GPF. All the data is of the correct type and size. I've rebuilt the indeces.
>
>
>Just for the heck of it, can you get it to work with a append blank and replace commands vs insert sql?
That's on my list of things to try.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer