A New and Frustrated User

[Steve Lucas]

Hi There Sarah
 
Thank you very much for taking time out to respond and more important to me by directing me to a program which I can study.  Many Many Thanks for that.
 
Regards
Steve


Sarah Reichelt <sarah.reichelt at gmail.com> wrote:
> I have been advised to contact yourselves for assistance in this matter. I have recently purchased the enterprise edition of Revolution and trying hard to get to grips with scripting. I feel that I am making progress, but my main area of concern is working with a database.
>
> Can I be so bold as to ask someone to write a very short program for me so that I can see how all this scripting is put into place. An ideal example would be for a personal record (Name, Address & Telephone) created using Microsoft Access, and then Revolution used to add new records to the database. Revolution used to search for a particular record and Revolution used to edit an existing record. These routines would clearly assist me in how these basic scripts are put together.
>

Hi Steve & welcome to the Revolution!

While teaching myself MySQL, I wrote a test stack that you may find
useful. It doesn't use the Database Query builder, but uses the direct
database commands to connect to a database, read tables & table
structures, read records, add, edit & delete etc.



It does not have a very neat interface as it was designed as a
learning stack for me, but if you examine the scripts, you will get
some ideas about how things can be done.

As I mentioned, I used it with MySQL, but I think if you edit the
"connect" button, you can set it to connect to an ODBC source like
Access instead.

Having said all that, databases are a complex thing requiring
Revolution to interface with external sources, which leaves plenty of
scope for problems. As a new user, you might be better trying
something simpler at first, until you are more familiar with
Revolution's own capabilities.

HTH,
Sarah
_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution