revdberr Error when App connect to SQLite Database

[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!!

[bogs]

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

[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

[Manu9351]

Habe die Ehre Klaus!

That's it! Everything works fine now!!! THANK YOU SOO MUCH!!

Grüße aus Österreich!
Manuel

[Klaus]

Hi Manuel,

we also have a german LC forum here:
http://www.livecode-blog.de/forums/foru ... ode-forum/

Best

Klaus

[Manu9351]

Hi Manuel,

we also have a german LC forum here:
http://www.livecode-blog.de/forums/foru ... ode-forum/

Best

Klaus

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!!