LiveCode Forums.

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

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

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

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

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