| Subject | Re: [firebird-support] importing dBase tables via ODBC - problem with rows marked deleted |
|---|---|
| Author | André Knappstein, Controlling |
| Post date | 2010-03-31T12:47:48Z |
news.dbase.com
Group: SQLServers.
A lot of people there who have been converting DBFs _AND_ dBase
applications over to Firebird _AND_ another language.
Which dBase Level are you talking about? MS-ODBC only can manage
Level-5. If the table is Level-7 you would need a BDE installed
additionally.
Somebody over in that NG can surely write a small .exe for you to
pack() a set of tables, to avoid that certain problem. In addition,
some people already wrote datapumps and there is one included in the
full install of the latest BDE.
Also, there are tools to convert DBFs to CSV, which then can be
imported by using the "External" Table function in Firebird.
you see.... many options to get rid off that outdated DBF stuff :)
~~~Ihre Nachricht~~~
r> I am having a frustrating time importing dBase tables into
r> Firebird using OCBC. I know this is a long shot, but perhaps it
r> will trigger some advise from someone who has faced this problem.
r> Net ODBC connection string = Driver={{Microsoft dBASE Driver
r> (*.dbf)}};DriverID=277;Exclusive=No;Deleted=1;Dbq=<folder name>
r> ( I have also tried Deleted=0; and left Deleted out altogether)
r> Query = Select * from [Invoic~1] where Invoicenum = 1234.
r> This works most of the time, but when the FIRST row of the result
r> set is marked Deleted in dBase, nothing is returned. If the second
r> row is marked Deleted, the other rows are returned.
r> For those not familiar with the dBase table structure, a deleted
r> row exists in the table until is is Packed (actually removed).
r> Until then it is marked as deleted in the row header, but it is still in place.
r> Seems like a bug in the ODBC driver, but I haven't been able to
r> find anything on the web about this.
r> Does this sound familiar to anyone?
r> If not, can someone recommend a dBase ODBC ng?
r> Regards,
r> Rick
r> ------------------------------------
r> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
r> Visit http://www.firebirdsql.org and click the Resources item
r> on the main (top) menu. Try Knowledgebase and FAQ links !
r> Also search the knowledgebases at http://www.ibphoenix.com
r> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
r> Yahoo! Groups Links
---
Group: SQLServers.
A lot of people there who have been converting DBFs _AND_ dBase
applications over to Firebird _AND_ another language.
Which dBase Level are you talking about? MS-ODBC only can manage
Level-5. If the table is Level-7 you would need a BDE installed
additionally.
Somebody over in that NG can surely write a small .exe for you to
pack() a set of tables, to avoid that certain problem. In addition,
some people already wrote datapumps and there is one included in the
full install of the latest BDE.
Also, there are tools to convert DBFs to CSV, which then can be
imported by using the "External" Table function in Firebird.
you see.... many options to get rid off that outdated DBF stuff :)
~~~Ihre Nachricht~~~
r> I am having a frustrating time importing dBase tables into
r> Firebird using OCBC. I know this is a long shot, but perhaps it
r> will trigger some advise from someone who has faced this problem.
r> Net ODBC connection string = Driver={{Microsoft dBASE Driver
r> (*.dbf)}};DriverID=277;Exclusive=No;Deleted=1;Dbq=<folder name>
r> ( I have also tried Deleted=0; and left Deleted out altogether)
r> Query = Select * from [Invoic~1] where Invoicenum = 1234.
r> This works most of the time, but when the FIRST row of the result
r> set is marked Deleted in dBase, nothing is returned. If the second
r> row is marked Deleted, the other rows are returned.
r> For those not familiar with the dBase table structure, a deleted
r> row exists in the table until is is Packed (actually removed).
r> Until then it is marked as deleted in the row header, but it is still in place.
r> Seems like a bug in the ODBC driver, but I haven't been able to
r> find anything on the web about this.
r> Does this sound familiar to anyone?
r> If not, can someone recommend a dBase ODBC ng?
r> Regards,
r> Rick
r> ------------------------------------
r> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
r> Visit http://www.firebirdsql.org and click the Resources item
r> on the main (top) menu. Try Knowledgebase and FAQ links !
r> Also search the knowledgebases at http://www.ibphoenix.com
r> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
r> Yahoo! Groups Links
---