Re: [Firebird-odbc-devel] No support for database independent Timestamp syntax ??????

[Marten F. <M.F...@t-...>]

Ok, they are called escape sequences for Date, Time or
Timestamp.

  Marten

Marten Feldtmann schrieb:
> oooops, now I'm lost. The ODBC driver does not understand the
> general ODBC syntax for database independent Timestamps
> (Date ?, Time ?):
> 
> 
> Here's an example:
> 
> insert into 
> TDFROBJECT(OID,PARENTDFROBJECTID,DFRTITLE,GROUPTYPE,DFRRESOURCEUSED,DFRDOCDATETIME,OBJECTREFERENCE,DFRATTCRTDODATETIM,INTFLGS,DFRASCORDER,DFRATTMODDODATETIM,DFRCONMODDODATETIM,DFRCONCRTDODATETIM) 
> values ('7S####1#####20#','7Q####1#####1Z#','Firmenweite 
> Unterlagen','company',0,{ts '2004-02-01 10:06:51.000000' 
> },'6S####1#####1M#',{ts '2004-02-01 10:06:51.000000' },0,'1',{ts 
> '2004-02-01 10:06:51.000000' },{ts '2004-02-01 10:06:51.000000' },{ts 
> '2004-02-01 10:06:51.000000' })
> Statement failed, SQLCODE = -104
> 
> Dynamic SQL Error
> -SQL error code = -104
> -Token unknown - line 1, char 294
> -'2004-02-01 10:06:51.000000'
> 
> 
> Any chance to fix it ????
> 
> 
> Marten Feldtmann
> 
> 
> 
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>