Wolfgang Schaible wrote:
hi,
oStmt.executeUpdate("UPDATE "+sJM+ " SET ISPAID= whatever
results in 'wrong datatype'... (Set a not empty date works)
If what you are asking is, how to force a date ( or time or datetime)
column that has a default at the table definition ( a default you set in
create table statement, not a default set in the Base table designer )
level to reapply this default setting then I don't believe it is
possible. The default will be applied only when a new record is inserted
in the table and only if no value is supplied for the column at insert
time, setting the column to NULL later will not do anything other then
store NULL. At least that is how it seems from my experience with the
engine and reading of the documentation.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
