Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Default values dropped from view
Message
From
02/07/2008 02:34:02
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Default values dropped from view
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01328176
Message ID:
01328176
Views:
59
Hi All,

I have occasionally had this problem and just wanted to see if others have had similar experiences and know any reason/solutions :

For my projects I almost exclusively use views for IO. I have also use a UDF to create a unique ids for tables. I add the UDF to the default value property of the unique key for each view. Thus, when I create a new record in the view, it gets the new id which then gets written to the table when I do a tableupdate. It is then used to update/modify the values of the view when changes are made.

Every once in a while I get a call because the tableupdate is not working. When I investigate, it turns out the default value property for the unique key is empty. It seems like the DBC just loses the property value.

Everything else is fine, no table or DBC corruption, just the missing defaults.

Any ideas?
Next
Reply
Map
View

Click here to load this message in the networking platform