General information
Category:
Forms & Form designer
>>>>>>>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
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