Problem with "Defaults" in database tables

scw2hi · Post by **scw2hi** » Thu 10 May 2007 09:02

Hi,

after switching to new ODACs 6.00.0.6 from 5.80.0.41 I have the following problem:

I have a table in the database where the name of the user who created an entry and the time the entry was created are filled with default values (user and sysdate).

In the program I work with this database table via TOraTable.

I changed following options on TOraTable

AutoCommit = false;
DMLRefresh = true;
Filtered = true;
RequieredFields = false;
StrictUpdate = false;

All other values are default.

So when I try to insert data into the table without providing the user and the time with the old odacs everything works fine.

With the new odacs I get an error message telling me that I have to provide the user.

Any suggestions? Are there new options to set?

Thanks in advance

Plash · Post by **Plash** » Thu 10 May 2007 09:44

We could not reproduce the problem. Please send to odac*crlab*com a complete small sample that demonstrates the problem, including script to create server objects.
If you have created fields for the table in design time, check that the Required property of the field containing the user name is set to False.

scw2hi · Post by **scw2hi** » Fri 01 Jun 2007 10:50

I just installed the newest ODAC version 6.05.0.7 and tried again.

I still get the error message, but now I know why.

When the field KeySequence of a TOraTable object is filled with the name of the corresponding sequence the table can no longer be filled with default values when something is posted.

When the Name of the sequence is removed again everything works fine.

Plash · Post by **Plash** » Fri 01 Jun 2007 12:58

We have fixed this problem. The fix will be included in the next build of ODAC.