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
thank you
-
Welcome to B4X forum!
B4X is a set of simple and powerful cross platform RAD tools:
- B4A (free) - Android development
- B4J (free) - Desktop and Server development
- B4i - iOS development
- B4R (free) - Arduino, ESP8266 and ESP32 development
Sql ask
- Thread starter fanfalveto
- Start date
- Similar Threads Similar Threads
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.
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.
Upvote
0
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.
Upvote
0
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
Greetings
Reinhard
Upvote
0
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
Greetings
Reinhard
Upvote
0
is an acces database (mdb) and i want to transform to sqllite.I don know very much about databases,sorry:sign0013:
Upvote
0
Hmm - download gives virus warning ????
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
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
Upvote
0
This file seems to be dangerous: https://www.virustotal.com/en/file/...21c8c9b7f20ff4818986bc6f/analysis/1361959994/
I've removed it.
I've removed it.
Upvote
0