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 »

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 »

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 »

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 »

If I run a simple mysql app in revmedia I get the following error:
error.jpg
error.jpg (34.13 KiB) Viewed 8928 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 »

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 »

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 »

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 »

@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