asked on

Transforming .dbf to paradox .db

I have 3 table in dbf format that I want to transform to .db. The Tool I use is ms Access.. I import a table from dbf and then I export to .db.

First Error I have is "Index is read only" when i want to edit a register in delphi 6.

Then I read more and I found that I have to put maintened in database desktop. But I have the problem that the field index_id (primary key)(autoincrement) have no data, and when I save the keyviolate.db appear with the major of records.

What I am doing wrong? What tool i need to transform?

Structure I Have in dbf:

important.dbf (master)
index_id(primary key)
code(text(9))

detail.dbf (detail)
index_id(primary Key)
reference(text(9))

kretzschmar

use two ttables for each table you have
one of the tables you set the tabletype
to ttdbase the other to ttparadox

as databasename neter the directory where the dbase-files are, in the other the directory, where you want to have the paradox tables and supply the tablenames on both,
whereas the paradox-table must not exist

now you can use

ttableOfParadox.BatchMove(ttableOfDBase,batCopy);

meikl ;-)

fisher2k4

ASKER

Yes this is the best and easy way to do that, thanks.

But I just finished the job with another way.. when I was in MS ACCESS this **** import the field increment as number, so when I export... The Database Desktop take that as it is, as number... (keyviolate.db problem) The solution was easy in Ms Access, I changed the field "index_id" from "number" to "autoincrement" and then I export... I run the database desktop, and now yes I can put as primary key (*)

kretzschmar

well, seems you 've solved it in another way byself

you can ask at community-support
for paq this q and refund your points

meikl ;-)

fisher2k4

ASKER

Okay thanks, How I do That?.. Sorry

kretzschmar

go
https://www.experts-exchange.com/Community_Support/

post there a zero-point question, with the title
"paq q and refund points"

and in the content place the link of this q:

https://www.experts-exchange.com/questions/20401233/Transforming-dbf-to-paradox-db.html

meikl ;-)

fisher2k4

ASKER

Thanks, Kretzchmar.

ASKER CERTIFIED SOLUTION

modulo