mySQL and Revolution on the web

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
nonamebaby
Posts: 4
Joined: Mon Jan 18, 2010 11:20 am

mySQL and Revolution on the web

Post by nonamebaby » Mon Jan 18, 2010 11:37 am

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

bangkok
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 937
Joined: Fri Aug 15, 2008 7:15 am

Re: mySQL and Revolution on the web

Post by bangkok » Mon Jan 18, 2010 3:22 pm

I don't have the same experience than you : no problem at all to access and use MySQL databases with revlets.

nonamebaby
Posts: 4
Joined: Mon Jan 18, 2010 11:20 am

Re: mySQL and Revolution on the web

Post by nonamebaby » Mon Jan 18, 2010 4:50 pm

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

nonamebaby
Posts: 4
Joined: Mon Jan 18, 2010 11:20 am

Re: mySQL and Revolution on the web

Post by nonamebaby » Mon Jan 18, 2010 5:25 pm

If I run a simple mysql app in revmedia I get the following error:
error.jpg
error.jpg (34.13 KiB) Viewed 7928 times

bangkok
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 937
Joined: Fri Aug 15, 2008 7:15 am

Re: mySQL and Revolution on the web

Post by bangkok » Mon Jan 18, 2010 5:29 pm

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/

nonamebaby
Posts: 4
Joined: Mon Jan 18, 2010 11:20 am

Re: mySQL and Revolution on the web

Post by nonamebaby » Mon Jan 18, 2010 6:40 pm

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

nicoloose
Posts: 99
Joined: Mon Sep 16, 2013 3:35 pm

Re: mySQL and Revolution on the web

Post by nicoloose » Wed Oct 30, 2013 10:50 am

Does the libDatase library work with LiveCode 6.1.2?

icouto
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 92
Joined: Wed May 29, 2013 1:54 am

Re: mySQL and Revolution on the web

Post by icouto » Wed Nov 06, 2013 10:55 pm

@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/

Post Reply