Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GPF Fault on TableUpdate
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00050268
Message ID:
00050438
Views:
27
>>>>>>>I keep getting a GPF fault when doing a tableupdate from my form. When I do it from the command line, it works fine. I have reindexed and packed both my DBF and SCX files. Has anyone seen anything like this or know what might be causing it? Am I doomed to start my formset over again?
>>>>>>
>>>>>>Are you using a private data session? Make sure the table is still in use before the tableupdate. I am racking my brain to remember why this happened to me, and I *think* it was because I had inadvertently closed one of the tables in my DE before issuing the tableupdate.
>>>>>
>>>>>Here is some more information:
>>>>>
>>>>>Yes, I am using a private data session, yes, the table is still in use and is the currently active one.
>>>>>
>>>>>I am running VFP5.0a on Windows 95 on a Novell Network, using a Compaq P133. I have performed almost identical operations in various other forms on the same platform, and have no problems. That is why I am stumped.
>>>>
>>>>Do you have any stored procedures or triggers that may be firing during the update?
>>>
>>>No stored procedures, no triggers, nothing fancy, just a simple table. I have tried it with and without a database container and it still gives me the error. Another interesting thing I noticed is that it does actually commit my changes before the GPF error, so it must be towards the end of the tableupdate function.
>>
>>Have you tried using the trace window to following execution of your form? Do you know for certain that the tableupdate is the last statement executed? (add x = 1 after it and see if that gets executed).
>>
>>I would say that most GPF's I have seen on forms are caused by datatype problems in the fields, or invalid field references.
>
>Actually I did a wait window right before the tableupdate and then right after. The one before shows, but the one right after doesn't. That is how I concluded the tableupdate to be the problem. I tried switching it to a tablerevert just for testing sake and it the tablerevert also gives me a GPF. From the research I've done on this issue, it is becoming apparent that something isn't right with my table or a control on my form, which I was hoping wouldn't be the case.

I found the problem!!!! I had a grid based on the table that I was tableupdating and the grid had a column with a controlsource that wasn't in the table anymore. I removed that column and the GPF is gone! I still appreciate everyone trying to help me out though.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform