Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Removing table default values...
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00049929
Message ID:
00049977
Views:
48
>I ran into a situation where I entered an invalid default value expression for a field in the table designer. It was the name of a .prg with is not valid. I wrote a stored procedure for the default value and went back to the table designer and backspaced the prg filename and replaced it with a call to the stored procedure. Now when I add a record, it tries to execute the prg which no longer exists. When I click OK on the error dialog it goes ahead and calls the stored procedure and opens a record with the correct default value.
>How do I stop the database from trying to execute the prg which was
>the first (incorrect) expression I entered?
>
>Thanx,
>
>Eric Kleeman Idaho

First backup your DBC files (just in case...) and then try opening them as a table (use mydbc.dbc) and PACKing. You can also browse the DBC and see if you can find the reference to the PRG and delete it by hand. PLEASE remember the backup!!

HTH
Barbara
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform