Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

It comes from bypassing the GUI when you define the table. If you look at your database using an archive manager (you can see the table definition in the database/script file) you will find that the defaults are recorded in the table definition. If you add records to the table the defaults are used.

But the defaults appear blank if you edit the table using the base GUI. If you add a different default in the GUI then it will be used while the database is open but when it is closed and reopened the original default will be used. You can use an archive manager to edit the default in the database/script file or by an ALTER TABLE command in the SQL tool.