Search found 7 matches
- 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...
- 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...
- 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...
- 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...
- 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 ...
- 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...
- 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...