revdberr Error when App connect to SQLite Database

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
Manu9351
Posts: 19
Joined: Sun Jan 07, 2018 8:48 pm

revdberr Error when App connect to SQLite Database

Post by Manu9351 » Sun Jan 07, 2018 8:55 pm

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 :D
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!!
Last edited by Manu9351 on Sun Jan 07, 2018 9:10 pm, edited 1 time in total.

bogs
Posts: 5435
Joined: Sat Feb 25, 2017 10:45 pm

Re: revdberr Error when App connect to SQLite Database

Post by bogs » Sun Jan 07, 2018 9:00 pm

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 :D
I'd say there is no need to apologize, your english is far better than my german :wink: I'd add to that that a few people here do speak german fluently, I'm sure they will pop up soon :D

I don't do android (or mobile in general), but someone will be along that does :)
Image

Klaus
Posts: 13793
Joined: Sat Apr 08, 2006 8:41 am
Location: Germany
Contact:

Re: revdberr Error when App connect to SQLite Database

Post by Klaus » Sun Jan 07, 2018 9:25 pm

Servus Manu9351,

habe die Ehre, willkommen im Forum! :D

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
Posts: 19
Joined: Sun Jan 07, 2018 8:48 pm

Re: revdberr Error when App connect to SQLite Database

Post by Manu9351 » Mon Jan 08, 2018 10:55 am

Habe die Ehre Klaus!

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

Grüße aus Österreich!
Manuel

Klaus
Posts: 13793
Joined: Sat Apr 08, 2006 8:41 am
Location: Germany
Contact:

Re: revdberr Error when App connect to SQLite Database

Post by Klaus » Mon Jan 08, 2018 1:58 pm

Hi Manuel,

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

Best

Klaus

Manu9351
Posts: 19
Joined: Sun Jan 07, 2018 8:48 pm

Re: revdberr Error when App connect to SQLite Database

Post by Manu9351 » Sun Jan 14, 2018 6:11 pm

Klaus wrote:
Mon Jan 08, 2018 1:58 pm
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.
Screenshot_2018-01-14-18-03-08.png
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!!

Post Reply

Return to “Databases”