hi Drew,
Am Tuesday 01 August 2006 15:06 schrieb Andrew Jensen:
> Wolfgang Schaible wrote:
> >
> >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.
maybe I have misguided you. A date was set in a textfield of a form.
But the input was wrong (notPaid :-) ). The field should be
cleared, the user deletes the input and my Basic script wrote a
empty field to HSQL ->see above
Using SET ISPAID=Null does this job.
Wolfgang
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
