LiveCode Forums.

Well, I think that maybe using the command line is not an option as the customer will have to learn how to do this. I think it seems the easier option to use the revExecuteSQL command option.

Are there any examples out there that show how to do this. Essentially, I would need to allow the customer ...

I apologies, I should perhaps clarify my requirement and explain the rationale of what I am trying to achieve.

My client, will have an online database, in MySQL. They will download an .sql file containing 'new' records on a (for example) daily basis. They wish then to add the records in the .sql ...

Hello

I have an .sql file (created from MySQL). This file only contains INSERT data like;

INSERT INTO ordersummary VALUES("1","1.95","57.52","Completed")
INSERT INTO ordersummary VALUES("2","1.95","57.52","Completed")
INSERT INTO ordersummary VALUES("3","1.95","57.52","Completed")
INSERT INTO ...

Hello

Has anyone else had this prooblem...

I have created a stack with a rectangle in it called Browser Rect. This renders the web page correctly (according to my script requirements) so no problem there.

However, If I resize the stack (to say maximise) although the Browser Rect resizes (I set it ...

I have two questions:

A) With RR, is it possible to view a recordset (say containing 3500 customer addresses) over multiple pages with first page, previous page, next page and last page navigation type functionality. So maybe each page would contain 50 records (or whatever) and then we simply click ...

Thanks Sparkout

I have altered then to

on mouseUp
global gDataConnectionID
put revOpenDatabase("MySQL","myTestServer.com","myDatabaseName","myDatabaseUser","myDatabasePassword") into dataConnectionID
if dataConnectionID is a number then
put dataConnectionID into field "fdbID"
put ...

Hello

I am new to RR. Currently, I am just testing, creating sample scripts to get used to working in the RR environment. I require a little hint, with regards to revOpenDatabase and revCloseDatabase. Here's the story.

I connect to a MySQL database (a remote one) with this is;

on mouseUp
put ...