Database Tutorial

Mark Stuart mfstuart at cox.net
Thu Dec 23 01:52:04 EST 2004


Hi folks,

 

I'm a brand new user to Dreamcard that needs to access MySQL databases, and
I need a tutorial to guide me thru the steps of building an example
application.

I've looked at Sarah's "MySQLTests.rev" example, and it's great, but it's
not want I want to do.

 

BTW: I'm a software developer and have been using eDeveloper from Magic
Software for many years now, and know what I'm looking to do.

 

Basically, I would like to use a tutorial that brings it all together, in a
"real world" database oriented application.

For example, if you look at any good Contact Manager, or CRM application
that's out there on the web today, you will see that's the kind of
application I would like to try and build.

 

Typically, in a "real world" example, there would be: 

Setup screens for:

-          Database Connection

-          User Name & Password

-          Security

-          Printer Setup

-          Etc.

 

            Data access:

-          List Views - data displayed to the user in a datagrid

-          View Detail forms - modify, create, delete, print - a record from
the List View

-          Form Navigation - viewing different data sets/tables: Customers,
Orders, ToDo's, etc.

-          Record Find, Lookup

-          Etc.

 

The tutorial would explain the following:

Event driven structure to the code to handle all data elements.

Bound Data Combo Box, List Box examples

Combo Box content dependant on prior Combo Box user selection

Drop down menus

Toolbar menu

Form and record Navigation

Data Lookups - Selection screens that display data in a list format, such as
City List. User selects record and that record value is returned to the
previous screen/field.

 

I don't know if the above is asking too much, but other software companies
like RunRev do have tutorials that accompany their tools, to help the
developer get oriented to the tool quickly.

I have searched extensively for the following on the web (MySQL, database,
Dreamcard, Revolution), and have not found anything that guides the
developer thru the steps of database development using either Dreamcard or
Revolution.

 

If you have something that I would be interested in, please reply back to me
personally, and we'll discuss this.

 

Thanx,

 

Mark Stuart

 



More information about the use-livecode mailing list