Sql ask

[fanfalveto]

I must do a program for work with a database with many tables an one of this tables has near 100.000 fields,can android work with this tables or there are any limit?
thank you

 

[eps]

What sort of database is the current DB?

Android can connect to most DB types. It won't be a problem to connecting.

What's the plan going forward, is the App going to connect to the DB you mention or a copy of it? Which may well be a DB of a different type, such as SQLLite which Android handles natively.

 

[fanfalveto]

the database is a .mdb type actually,but i will try to transform to sqllite,the program select elements from diferents tables a see the result.But one of the tables have near 100.000 fields.i don´t know is android can work with that.

 

[rboeck]

When i started with android, my first database project was also an converted access database with 140.000 adresses in it. You wrote fields, i think you mean records?! I am very happy with sqliite, most of the time its fantastic in speed etc.; but there are some features, which you maybe not expect: if you make a field Nr with integer and then you store an string, then you get back this string. You dont get any error message! Also the sort order is strange: the first block is string, then integer an so on.
Greetings
Reinhard

 

[fanfalveto]

thank you,how you convert mdb to sqllite? i see with mdbtool and sqlite3 in linux.

 

[rboeck]

It is a question, which background and tools you have: if you have mostly used access, i would start with on odbc driver, which enables you to link your sqlite file to access. (SQLite ODBC Driver ) So you can mix your data an in queries etc. and transform step by step. A tool, that i licensed is sqlite expert professional: it comes with an data transfer wizard. You can try this tool for 30 days and also use the free personal version. Another free tool is SQLite2009 Pro, with an good help system for SQLite and Lua, an scripting language.
Greetings
Reinhard

 

[fanfalveto]

is an acces database (mdb) and i want to transform to sqllite.I don know very much about databases,sorry:sign0013:

 

[fanfalveto]

i find that to convert .mdb to sqlite and i think runs ok

 

[fredo]

Hmm - download gives virus warning ????

i find that to convert .mdb to sqlite and i think runs ok

Attached Files
MDB2SQLite.zip (309.5 KB, 2 views)

After download of the attachment "MDB2SQLite.zip" I was warned by my virus scanner that the file contains:

"UPX: HEUR:Trojan-Downloader.Win32.Generic 27.02.2013 09:40:49 http://www.b4x.com/forum/attachment...1542-sql-ask-mdb2sqlite.zip//MDB2SQLite.exe// "


Anyone else had this message?

Regards
fredo

 

[fanfalveto]

I'm sorry,i don't see anything in my pc

Enviado desde mi HTC Desire usando Tapatalk 2

 

[Erel]

This file seems to be dangerous: https://www.virustotal.com/en/file/...21c8c9b7f20ff4818986bc6f/analysis/1361959994/

I've removed it.

 

[fanfalveto]

i´m sorry :BangHead: