I know that they work for me so I would like to see a sample of your case so
that I can test it for myself. There is something unique about your
situation.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Yagi" <yagi@...>
To: "IBObjects" <IBObjects@yahoogroups.com>
Sent: Friday, March 16, 2001 1:29 PM
Subject: [IBO] Problem with TIB_Export


> Hi,
>
> I think that there is a bug in TIB_Export with DATE, TIME data type from
IB6
> dialect 3.
>
> I have a query
>
> SELECT
> SESJE.ID, /*INTEGER*/
> SESJE.DATA, /*DATE*/
> SESJE.CZAS_OD, /*TIME*/
> SESJE.CZAS_DO, /*TIME*/
> SESJE.CZAS/60 GODZIN,
> SESJE.CZAS-(SESJE.CZAS/60)*60 MINUT
> FROM SESJE
>
> and the result of the query i something like this:
>
> 1, 2001-03-10, 20:38:00, 21:23:00, 0, 45
> 2, 2001-03-10, 20:38:00, 21:38:00, 1, 0
> 4, 2001-03-10, 20:47:00, 21:47:00, 1, 0
> 7, 2001-03-10, 21:47:00, 22:47:00, 1, 0
>
> when i do the export to CSV file i get:
> 1,,,,,
> 2,,,,,
> 3,,,,,
> 4,,,,,
>
> DBF export dosn't wokr Ok too and no matter what DataTimeFormat is.
>
> I don't check this with TIMESTAMP.
>
> We have TIME, DATE, TIMESTAMP data type in IB6. I think there should be
> three different property for formating this fields (something like
> DataTimeFormat for TIMESTAMP, TimeFormat for TIME and DateFormat for
DATE).
>
> Jason what do you think about it?
>
> Yagi
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>