S Sinimon Member Jan 16, 2012 #1 Hello. i would like to know the fileformat of a database which can be used by basic4android. is the only format the ".db" - SQLite3 - format? I can not find a way to open this format with Visual Basic 6 ...
Hello. i would like to know the fileformat of a database which can be used by basic4android. is the only format the ".db" - SQLite3 - format? I can not find a way to open this format with Visual Basic 6 ...
Erel B4X founder Staff member Licensed User Longtime User Jan 16, 2012 #2 Android (and Basic4android) support SQLite databases. Other databases formats are not supported. You can export the data to a CSV file with StringUtils. Upvote 0
Android (and Basic4android) support SQLite databases. Other databases formats are not supported. You can export the data to a CSV file with StringUtils.
S Sinimon Member Jan 16, 2012 #4 could you explain what a csv file is and how i can convert the database to this file?? and also important: is it possible to reconvert the csv file to the database? Upvote 0
could you explain what a csv file is and how i can convert the database to this file?? and also important: is it possible to reconvert the csv file to the database?
S Sinimon Member Jan 16, 2012 #5 stevel05 said: Have a look here Steve Click to expand... when iam going to open the database from my phone with this examples there are problems like "Can not open this type of Database"... Upvote 0
stevel05 said: Have a look here Steve Click to expand... when iam going to open the database from my phone with this examples there are problems like "Can not open this type of Database"...
stevel05 Expert Licensed User Longtime User Jan 16, 2012 #6 Sorry, I read your post as though you wanted to work with SQLite databases within VB6. Upvote 0
S Sinimon Member Jan 16, 2012 #7 i have a calender on PC.. i made it 2 years ago. the entrys are saved in a XLS excel file... it is easy to read...now i want to have a mobile version... the program is running on android... the database is running... but when i copy THIS database to my pc i can not open it with vb6.... i don´t know how it could happen.... i would tage every idea... if there is a better solution i would take another way and not sql... there are only problems for me Upvote 0
i have a calender on PC.. i made it 2 years ago. the entrys are saved in a XLS excel file... it is easy to read...now i want to have a mobile version... the program is running on android... the database is running... but when i copy THIS database to my pc i can not open it with vb6.... i don´t know how it could happen.... i would tage every idea... if there is a better solution i would take another way and not sql... there are only problems for me
stevel05 Expert Licensed User Longtime User Jan 16, 2012 #8 OK, well the link from my first post may enable you to read the SQLite database in VB6. Alternatively you could look at Xverhelstx's OfficeWorker Library (Although you have to be a registered user) which could enable you to work with Excel files. I don't know how far it's got I haven't tried it. Upvote 0
OK, well the link from my first post may enable you to read the SQLite database in VB6. Alternatively you could look at Xverhelstx's OfficeWorker Library (Although you have to be a registered user) which could enable you to work with Excel files. I don't know how far it's got I haven't tried it.
S Sinimon Member Jan 16, 2012 #9 hm but... i can not download the library... you know why hm? what can i do now shit. i can not find a way to synchronize the pc with the mobile phone Upvote 0
hm but... i can not download the library... you know why hm? what can i do now shit. i can not find a way to synchronize the pc with the mobile phone
stevel05 Expert Licensed User Longtime User Jan 16, 2012 #10 As I see it, you can either try to create/update an SQLite database from VB6 and import that into your app, or as Erel suggested export the data from the excel spreadsheet as a CSV and import that into your app. Upvote 0
As I see it, you can either try to create/update an SQLite database from VB6 and import that into your app, or as Erel suggested export the data from the excel spreadsheet as a CSV and import that into your app.
klaus Expert Licensed User Longtime User Jan 16, 2012 #11 From what I see, you should: - buy B4A it is it's money woth ! - save your Excel file to a csv file from Excel. - then import it in B4A with StringUtils. - genereate a SQLite database in B4A And when you want to modify it on the PC there do exist free sortware to manage SQLite databases. Best regards. Upvote 0
From what I see, you should: - buy B4A it is it's money woth ! - save your Excel file to a csv file from Excel. - then import it in B4A with StringUtils. - genereate a SQLite database in B4A And when you want to modify it on the PC there do exist free sortware to manage SQLite databases. Best regards.
luke2012 Well-Known Member Licensed User Longtime User Mar 29, 2012 #12 Import directly into SQLite DB It's possible to import a .csv file directly into a SQLite DB within B4A? Upvote 0
Import directly into SQLite DB It's possible to import a .csv file directly into a SQLite DB within B4A?
klaus Expert Licensed User Longtime User Mar 29, 2012 #13 No, not directly. You can load a csv file with LoadCCV or LoadCSV2 from the StringUtils library. But then you must create the database by code, but this is done once. Best regards. Upvote 0
No, not directly. You can load a csv file with LoadCCV or LoadCSV2 from the StringUtils library. But then you must create the database by code, but this is done once. Best regards.
