Subject Odp: [IBO] Problem with TIB_Export
Author Yagi
Hi,

----- Original Message -----
From: Jason Wharton <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, March 16, 2001 9:49 PM
Subject: Re: [IBO] Problem with TIB_Export


> 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.
>

Everything was done by IB_WISQL

I did something like this:

1. Create database in IB_WISQL on IB 6.0.0.627 (Windows version) with SQL
dialect 3
2. Create table

CREATE TABLE SESJE(
ID INTEGER NOT NULL,
DATA DATE NOT NULL,
CZAS_OD TIME NOT NULL,
CZAS INTEGER DEFAULT 0.0 NOT NULL,
CZAS_DO TIME NOT NULL,

CONSTRAINT SESJA_ID_PK PRIMARY KEY (ID)
);

3. Some inserts

INSERT INTO SESJE (ID, DATA, CZAS_OD, CZAS, CZAS_DO)
VALUES (1, '2001-03-14', '21:00:00', 60, '22:00:00');
INSERT INTO SESJE (ID, DATA, CZAS_OD, CZAS, CZAS_DO)
VALUES (2, '2001-03-14', '20:00:00', 45, '20:45:00');
INSERT INTO SESJE (ID, DATA, CZAS_OD, CZAS, CZAS_DO)
VALUES (3, '2001-03-14', '13:00:00', 165, '15:45:00');

3. Launch Query Forms with SQL:

SELECT SESJE.ID, SESJE.DATA, SESJE.CZAS_OD, SESJE.CZAS_DO, SESJE.CZAS,
SESJE.CZAS/60 GODZIN, SESJE.CZAS-(SESJE.CZAS/60)*60 MINUT
FROM SESJE

4. Click Export Button (Delimiter = '"', Separator = ',', Date Format =
'yyyy-MM-dd')
- with CSV i got:
1,,,,60,,
2,,,,45,,
3,,,,165,,
there is no CZAS_OD, CZAS_DO, GODZIN, MINUT fields value

- with DBF:
DATA is OK
CZAS_OD, CZAS_DO i got some integers
GODZIN, MINUT is OK

-with TXT:
000000001000000060
000000002000000060
000000003000000165

Yagi