This may not be the answer you want - but how about packing the file
first, or is that too difficult? You can always make a copy of the
dbase table before you start.
Regards
--
Alan J Davies
Aldis


Quoting rick_roen <rick@...>:

> I am having a frustrating time importing dBase tables into Firebird
> using OCBC. I know this is a long shot, but perhaps it will trigger
> some advise from someone who has faced this problem.
>
> Net ODBC connection string = Driver={{Microsoft dBASE Driver
> (*.dbf)}};DriverID=277;Exclusive=No;Deleted=1;Dbq=<folder name>
>
> ( I have also tried Deleted=0; and left Deleted out altogether)
>
> Query = Select * from [Invoic~1] where Invoicenum = 1234.
>
> This works most of the time, but when the FIRST row of the result
> set is marked Deleted in dBase, nothing is returned. If the second
> row is marked Deleted, the other rows are returned.
>
> For those not familiar with the dBase table structure, a deleted row
> exists in the table until is is Packed (actually removed). Until
> then it is marked as deleted in the row header, but it is still in
> place.
>
> Seems like a bug in the ODBC driver, but I haven't been able to find
> anything on the web about this.
>
> Does this sound familiar to anyone?
>
> If not, can someone recommend a dBase ODBC ng?
>
> Regards,
>
> Rick
>
>