General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Losing a field default value
A system I'm working on creates default values for a primary key field by calling an external program that does a lookup into another table that contains the highest keys for each table.
Sometimes, randomly, the default value for a table definition disappears, after which the next created record in the table will get a blank value for the primary key.
So something is detroying the entry in the the DBC that contains the default. The loss seems random and unpredicatable, and has affected several different tables. I do not know when the error occurs until and add to a table fails.
I'm using SDT, and think it may have some connection with the problem - or maybe it's some kind of bug in VFP 7.
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