making a Database of Companies information

[motaro]

Hi all


I want make a CD database of about 2000 companies information
for example when a use selected company name from a list box it automaticaly read information from DB and show company information in a page

I want to know how can I do it with Autoplay 5 ?
is there any way to add a database to Autoplay 5
and how can i use it ?


Thanks

[dmla]

Easy - use SQlite plugin

Easy - use SQlite plugin
I think that beter way to use SQGlite Plugin. This is very easy.

[motaro]

Hi thanks alot
but could you tell me how ca I do it.
with that plugins

is there any tutorials
?

thanks

[JimS]

Sure, you can build a database with AMS. I would suppose the best method for you to use, would depend on what format your data is currently in. I think a database consisting of 2000 names and 2000 descriptions, is fairly small. Plus, it doesn’t sound like you are having much in the way of query logic operations going on. If you already have your data in a CSV file, you might consider reading it in to a table using the TextFile.ReadToTable action. Check out the help file and examples for that action, and the other Table actions.

If you need a more robust database, AMS has a great SQLite plug-in you can use.

[motaro]

I downloaded the Pluging but how can I use it in AutoPlay and where is my DB
or how can I insert information in it?
and how can I read information from it?

[JimS]

The plug in that I’m speaking of, is listed here:

http://www.autoplay.org/plugin/sqlite_database.php

I don’t have it yet, but I imagine it should come with a help file and an example or two. Since I have’t used it, I can’t really give you much help with actual code. I’m sure that several other developers here can help with your answers, but since it is a holiday, it might take a day or two before one of them see your post.

[motaro]

I want import information with a form to Database
and after it, I'll write my CDs

Please tell me how can i do it with an easy way

[JimS]

Sorry dmla, I didn't mean to cross-post.

[JimS]

I just realized what time it is, I’ve got to get wrapping presents, so I can’t be of any help for a while. Since it’s the holidays, and the forum is slow, I’d suggest using the search facilities on this web site, I’m sure you’ll find some examples.

Search terms you might use would be SQLite, database, and/or tables.
You should find that lots of people have asked similar questions.

Good luck, I’m sure more people will be here to help you soon, if not today, then after Christmas.

Good luck!

[GAV]

The most simple way - to study example IR
And to look on forums - there were many examples

[Intrigued]

Here is just one of many SQLite links:

http://www.indigorose.com/forums/showpost.php?p=37181&postcount=3

You can find many more by Searching the forum here. (Just type SQLite into the search input field)

Sincerely,