Page 1 of 1

mySQL and Revolution on the web

Posted: Mon Jan 18, 2010 11:37 am
by nonamebaby
I hope that this is in the right place to ask this question but I have written quite an extensive desktop application using Rev Enterprise and mySQL backend. The app is used by a call centre and sits on 5 different desktops, accessing the database on a server. I really want to convert this desktop application into a web application but am unsure how to go about this. Is it possible to convert this app and run it as a revlet? My initial findings seem to indicate that revlets don't support database connectivity??

Any help will be great
Nic

Re: mySQL and Revolution on the web

Posted: Mon Jan 18, 2010 3:22 pm
by bangkok
I don't have the same experience than you : no problem at all to access and use MySQL databases with revlets.

Re: mySQL and Revolution on the web

Posted: Mon Jan 18, 2010 4:50 pm
by nonamebaby
I am using the database library (libDatabase) which is using the revOpenDatabase command and this is where the application crashes! Is it possible to create revlets from the Enterprise version of Runrev or do I have to use revMedia?

Thanks for your help

Re: mySQL and Revolution on the web

Posted: Mon Jan 18, 2010 5:25 pm
by nonamebaby
If I run a simple mysql app in revmedia I get the following error:
error.jpg
error.jpg (34.13 KiB) Viewed 7933 times

Re: mySQL and Revolution on the web

Posted: Mon Jan 18, 2010 5:29 pm
by bangkok
nonamebaby wrote:I am using the database library (libDatabase) which is using the revOpenDatabase command and this is where the application crashes! Is it possible to create revlets from the Enterprise version of Runrev or do I have to use revMedia?

Thanks for your help
Could you give more details about the "crash" ?

And RevMedia does not support databases.

Check the comparison chart :
http://www.runrev.com/products/the-rev- ... omparison/

Re: mySQL and Revolution on the web

Posted: Mon Jan 18, 2010 6:40 pm
by nonamebaby
In one of those inexplicable moments, it started working!! The error went away so I have a feeling it was something I changed in the stand alone settings....

Thanks for your input.
Nic

Re: mySQL and Revolution on the web

Posted: Wed Oct 30, 2013 10:50 am
by nicoloose
Does the libDatase library work with LiveCode 6.1.2?

Re: mySQL and Revolution on the web

Posted: Wed Nov 06, 2013 10:55 pm
by icouto
@nicoloose, you should not need to use an external library to access MySQL databases with the current versions of LiveCode - that functionality is built-in! Have a look at the documentation for the 'revOpenDatabase' command:

http://livecode.com/developers/api/6.0. ... nDatabase/