Hi Richard
> Hi to postgres users of gambas.
>
> I'm passing some information to postges, which gets the data from date type
>
> eg date1 as date
> data2 as date
>
> (N the postgres database the default on the date field is null)
>
> my problem is that postgres baulks when I"ve not put a date into one of the
> gambas date variables with the message:
>
> "invalid syntax for type date '00:00:00'"
>
> my sql is far more complex but reduced to the date part reads something
> like this
>
> insert into mytable (date1, date2) values
>
> ('01/01/2008','00:00:00')
>
> I wondered if anyone could volunteer a solutionYou can use an insert trigger, which checks, if date to be insertet is invalid and set a wanted default i.e. 1.1.1970 or what ever you like. So you will get always a valid date or you even can insert NULL if you insist on an empty date. HTH Rolf
signature.asc
Description: This is a digitally signed message part.
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
