Android Question work with paradox (file .db)

[cncncn]

Hi,

I need to work with paradox. Paradox delivers files .db. It's possible to use SQLite for paradox ?

 

[DonManfred]

No

You need to setup an RDC which connects to this paradox-Database...

android has no build in support for paradox i believe.

 

[cncncn]

and with SQLiteDB ?

 

[Erel]

You can use local SQLite databases with the SQL library.

 

[cncncn]

And if i use smb for upload my file on my server It's works?

 

[Erel]

You can upload the database file with SMB. The SQL library only works with local SQLite databases.

You can however connect to any remote database (including SQLite) with RDC.

 

[cncncn]

ok thank you. I am beginner and I want to be sure. SQLite can works with my table.db and after i use SMB for upload my new table.

 

[DonManfred]

SQLite can NOT work with Paradox-Databases! It works only with SQLite-Databases.

 

[fatman]

Don Manfred is right there is no way using Paradox-Tables under Android.
But there is no need to export from Paradox to csv and importing your data into sqlite.
You can get a dll here http://www.sqlite.org/download.html enabling you to write sqlite tables directly.

 

[cncncn]

ok thanks for your answers.

 

[cncncn]

Don Manfred is right there is no way using Paradox-Tables under Android.
But there is no need to export from Paradox to csv and importing your data into sqlite.
You can get a dll here http://www.sqlite.org/download.html enabling you to write sqlite tables directly.

ok But what dll download?

 

[cncncn]

Sorry but i am beginner. How open my file ("NGAD0401.db") and display?

 

[DonManfred]

Sorry but i am beginner. How open my file ("NGAD0401.db") and display?

What kind of Database is it? PARADOX or SQLite?

 

[cncncn]

Paradox

 

[miquel]

you can user Alex Nolan's PDX Viewer to view and export your Paradox table to different formats including SQL statements.

 

[cncncn]

ok thank you

 

[DonManfred]

Paradox

As i already stated in Post #2 (and #8) here yesterday....
You CAN NOT open a Paradox-Database with Android!

 

[cncncn]

okok. So first I have to change my file to open on my tablet

 

[fatman]

Structuring the discussion:
If you have a paradox-tables you have 3 possibilities (as far as I know):

1. You gonna export all to csv and import the data into sqlite. The import can be done on the tablet.
2. You use a tool like lex Nolan's PDX Viewer as miquel stated above doing the export-things
3. You have Delphi like me and use the sqlite-dll-win32-x86-3080500.zip you can download from http://www.sqlite.org/download.html

To my mind number 3. is the most elegant way- cause you can create sqlite-tables directly out of your Windows/Delphi-Application.

 

[cncncn]

Thanks for your help.
I see with my superior of paradox table can transform to .txt. So i use this method.