Flash / Access intergration using simple class

Hey Kirupians :kommie:
This is my first contribution to the boards :slight_smile:

Here goes:
Attached is a zipfile containing:

An access database

  • the db has three rows for testing purposes - feel free to delete them as you go along.
  • it also contains 4 columns: FlashKey, Firstname, Lastname and Age. DO NOT DELETE the FlashKey column, as it is essential. Do delete the other columns…

An ASP document

  • Before you upload the files to your server, you shold open the asp doc “extract.asp”, and change the refference to the database in line 4 to whatever it will be on your server.

Flashfiles
use.fla. a very little flashfile i whipped up, so you quikly can test to see if your setup works.
DataSet.as is the DataSet class, where all the goodies are :wink:

So what is this?
Basicly, this helps you extract and input data into a MS Access database, whitout having to get your fingers dirty with sever side coding.
I havn’t had the time to write any documentation for the class, but i’ll post some later on.
Until then, you can look at the functions in the class, the names should give you an idea of what they do. You’ll notice that the delete function is empty - i’m having some problems with it, so you wan’t be able to delete data from the base just yet.
This is really quite beta-ish, and its not tested alot, but all the basics should work.

To load the data, you’ll have to parse an SQL String. If you need help on that, i suggest you take a look here: http://exchange.manifold.net/manifold/manuals/manifold/queries/simple_queries.htm
Important!
Untill i get it fixed, you’ll HAVE to always load the FlashKey column, if you dont nothing will work :-/

Please post any comments you might have :slight_smile:

Last update of attachment: 05-21-05 - fixed som bugs