Search found 5 matches

by SteveX
Tue Aug 01, 2006 1:42 am
Forum: Databases
Topic: Linking to MS Access Database on Local Drive
Replies: 14
Views: 32722

Jan, I am working with the MySQL database and I am trying to use the SQL command to insert information but it's not working. Here is the code I am using in the script for my button: revsqlexecute "Insert Into Members (Firstname,Lastname) values Field 'FirstName', Field 'LastName'" I have also tried ...
by SteveX
Mon Jul 31, 2006 11:16 pm
Forum: Databases
Topic: Linking to MS Access Database on Local Drive
Replies: 14
Views: 32722

Thank you Jan! That is what I was most unsure about. Do I only use the SQL language for the database commands or will I be using SQL commands for all aspects of Revolution?:roll: I've been away from the coding aspect of programming for a while now so I've got a lot to learn. MS Access doesn't necess...
by SteveX
Mon Jul 31, 2006 1:54 am
Forum: Databases
Topic: Linking to MS Access Database on Local Drive
Replies: 14
Views: 32722

Thanks but I figured out how to connect to the database via ODBC. However, I don't know how to add, modify, delete records.

I'm getting closer but so far - no cigar....

Thanks for any help.. :)

Steve X
by SteveX
Wed Jul 26, 2006 8:55 pm
Forum: Databases
Topic: Linking to MS Access Database on Local Drive
Replies: 14
Views: 32722

Version

Version 2.7.2 I have just recently downloaded MySQL server and associated tools. If that would be easier then I can give it a shot as well. I can get Revolution to connect to the MySQL server running locally, however, I haven't been able to figure out all the commands necessary to be able to write t...
by SteveX
Thu Jul 20, 2006 6:03 pm
Forum: Databases
Topic: Linking to MS Access Database on Local Drive
Replies: 14
Views: 32722

Linking to MS Access Database on Local Drive

I am very new to Revolution and I would like some step by step instructions for accessing data in an existing MS Access database. I would like to eventually learn how to add/modify/remove/query this data. Basically I want to be able to build the database structure in MS Access and then use Revolutio...