Search found 7 matches

by manicsurfer
Thu Jul 02, 2009 9:01 am
Forum: Databases
Topic: Use a .sql to insert data into SQLite
Replies: 7
Views: 9268

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 t...
by manicsurfer
Wed Jul 01, 2009 9:10 am
Forum: Databases
Topic: Use a .sql to insert data into SQLite
Replies: 7
Views: 9268

Use a .sql to insert data into SQLite

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 fil...
by manicsurfer
Tue Jun 30, 2009 1:40 pm
Forum: Databases
Topic: Use a .sql to insert data into SQLite
Replies: 7
Views: 9268

Use a .sql to insert data into SQLite

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 orders...
by manicsurfer
Mon Aug 11, 2008 3:40 pm
Forum: Internet
Topic: Browser Rect Not Resizing when holding content?
Replies: 2
Views: 4167

Browser Rect Not Resizing when holding content?

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 to...
by manicsurfer
Tue Jul 29, 2008 2:49 pm
Forum: Databases
Topic: View records over results pages
Replies: 4
Views: 5839

View records over results pages

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 ...
by manicsurfer
Mon Jul 28, 2008 2:04 pm
Forum: Databases
Topic: revOpenDatabase and revCloseDatabase
Replies: 3
Views: 5303

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 dataConnectionID in...
by manicsurfer
Mon Jul 28, 2008 8:04 am
Forum: Databases
Topic: revOpenDatabase and revCloseDatabase
Replies: 3
Views: 5303

revOpenDatabase and revCloseDatabase

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 revOpen...