Hi
Data type for date memory variables is not changed, only for logical (to numeric). If the error is related to DATE type columns, I still think that is something else.
Dorin


>Dorin
>I think i found the problem. It's in the DBF2FB code. You SQLPREPARE the insert command prior to doing the adjustments for dates and logical fields, i.e the adjustments do not repercute to the SQL command.
>I'll recheck it and tell you how it goes.
>
>Thanks
>Jaime
>
>>Hi
>>I think that is about empty date or datetime. Firebird doesn't support something like this.
>>These columns can be NULLs though.
>>
>>>Hi Dorin
>>>I tested Firebird with some tables i had, a few hundred-thousand records each, and the speed is impressive.
>>>I used your DBF2FB utility to move my data, and it works ok. I have an error message though, when selecting True for copying the data and when my data has a date field. Am i missing something?
>>>
>>>TIA
>>>Jaime