Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GPF on TableUpdate
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00187843
Message ID:
00188212
Views:
27
>>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform