General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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?
Previous
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