| Subject | Tib_Import doesn't fail/throw exception when data type is incorrect ? |
|---|---|
| Author | sshowl09 |
| Post date | 2009-08-23T18:41:15Z |
Hi,
I'm using TIB_Import to import from a CSV file to a table.
One of the columns in the table is a date, interestingly if the CSV file contains values for that column that are no dates, are random strings for example, the import doesn't fail, it simply repeats the last valid value for that column.
Is there a way to make it so it does fail if data does not match the destination column ?
In CSV (note 3rd row has string in place of date):
1,12/21/2007,ELLEN,HUNTER,February
2,07/26/2007,RACHEL,BREWER,March
3,fgg,ELSIE,MEDINA,July
4,01/02/2009,JESSICA,DOUGLAS,January
Ends up in database table (3rd row has inherited date of second),
the 2nd col is indeed a date type in the table):
1,12/21/2007,ELLEN,HUNTER,February
2,07/26/2007,RACHEL,BREWER,March
3,07/26/2007,ELSIE,MEDINA,July
4,01/02/2009,JESSICA,DOUGLAS,January
Help appreciated.
Cheers
Sam
I'm using TIB_Import to import from a CSV file to a table.
One of the columns in the table is a date, interestingly if the CSV file contains values for that column that are no dates, are random strings for example, the import doesn't fail, it simply repeats the last valid value for that column.
Is there a way to make it so it does fail if data does not match the destination column ?
In CSV (note 3rd row has string in place of date):
1,12/21/2007,ELLEN,HUNTER,February
2,07/26/2007,RACHEL,BREWER,March
3,fgg,ELSIE,MEDINA,July
4,01/02/2009,JESSICA,DOUGLAS,January
Ends up in database table (3rd row has inherited date of second),
the 2nd col is indeed a date type in the table):
1,12/21/2007,ELLEN,HUNTER,February
2,07/26/2007,RACHEL,BREWER,March
3,07/26/2007,ELSIE,MEDINA,July
4,01/02/2009,JESSICA,DOUGLAS,January
Help appreciated.
Cheers
Sam