General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Default values dropped from view
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
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