Page 1 of 1
revdberr Error when App connect to SQLite Database
Posted: Sun Jan 07, 2018 8:55 pm
by Manu9351
Hi together,
at first i have to say sorry for my bad english, I'm from Austria, but i think nobody here is speaking german
I'm new at programming with Livecode, that's my second App. The whole app is finished, but theres a problem when the App (Android) wanted to connect with my SQLite Database.
I post my code here:
Code: Select all
global dateiPfad
global dbidon mouseUp
put specialFolderPath("Documents") & "/MHDManager.sqlite" into dateiPfad
put revOpenDatabase("MHDManager", dateiPfad, , , , ) into dbid
end mouseUp
I've created the SQLite Database with a Plugin in MozillaFirefox.
When the app connect to the database, dbid contains: revdberr, invalid database type
Does anybody have any ideas what's the problem?... I'm frustrated..
Thank you soo much!!
Re: revdberr Error when App connect to SQLite Database
Posted: Sun Jan 07, 2018 9:00 pm
by bogs
Manu9351 wrote: ↑Sun Jan 07, 2018 8:55 pm
first i have to say sorry for my bad english, I'm from Austria, but i think nobody here is speaking german
I'd say there is no need to apologize, your english is far better than my german
I'd add to that that a few people here do speak german fluently, I'm sure they will pop up soon
I don't do android (or mobile in general), but someone will be along that does
Re: revdberr Error when App connect to SQLite Database
Posted: Sun Jan 07, 2018 9:25 pm
by Klaus
Servus Manu9351,
habe die Ehre, willkommen im Forum!
You need to pass the database
type to the revopendatabase function:
Code: Select all
global dateiPfad
global dbid
on mouseUp
put specialFolderPath("Documents") & "/MHDManager.sqlite" into dateiPfad
## put revOpenDatabase("MHDManager", dateiPfad, , , , ) into dbid
## Hier der erste Parameter:
put revOpenDatabase("sqlite", dateiPfad, , , , ) into dbid
end mouseUp
If in douvt, always consult the dictionary!
Best
Klaus
Re: revdberr Error when App connect to SQLite Database
Posted: Mon Jan 08, 2018 10:55 am
by Manu9351
Habe die Ehre Klaus!
That's it! Everything works fine now!!! THANK YOU SOO MUCH!!
Grüße aus Österreich!
Manuel
Re: revdberr Error when App connect to SQLite Database
Posted: Mon Jan 08, 2018 1:58 pm
by Klaus
Hi Manuel,
we also have a german LC forum here:
http://www.livecode-blog.de/forums/foru ... ode-forum/
Best
Klaus
Re: revdberr Error when App connect to SQLite Database
Posted: Sun Jan 14, 2018 6:11 pm
by Manu9351
Hi Klaus!
Thank you for your Info about the german livecode forum, but i think i'll get more response in the english forum.. the german forum is relatively new I have read.
Sorry for my disturbance again.. i have a another question.
is there any possibility to press the OK button at an ASK-Event with the ENTER Button on a mobile device?
My situation is: I have an Bluetooth-Barcode-Reader, so the App asks with an Ask-command for a barcode.
I scan a barcode with the bluetooth device, and the device inserts a "RETURN" after the line of numbers automatically. But i want that the "RETURN" means "PRESS OK" and not "Go to line 2" like i press Enter in a word document.
Do you know what i mean? If Yes do you have any idea what i have to do?
THANK YOU!!