PDA

View Full Version : Sql or not



Rikard
08-12-2005, 05:57 AM
Hi i have done a program that in the end show some math results.
Now i want to take these results and store them some where for later use.
exampel i want to se all the results of the year in a diagram.
So my question is do i need a database? I have used databases before in php programing so i know some about sql.
When i have worked with sql before it has always been against a server and in this case its not posible. I dont want the user of my program to be forced to have a database or something like that (maby MS Access then)

So my questions is:
What programs do i need?
Do i need a server?
Can i store all results from AMS5 in a exel file instead of a database

/Rikard

yosik
08-12-2005, 08:02 AM
You can store the data in a txt file, even add a delimiter. Easy to retrieve and import into an excel sheet.
Actions to use are mostly TextFile.WriteFromString or TextFile.WriteFromTable (the latter is better).

Yossi

TJ_Tigger
08-12-2005, 08:12 AM
Or you can store them in an INI file, I think that action requires AMS5Pro.

Tigg

Rikard
08-16-2005, 11:03 AM
First of all thanks for the replies.

Is it possible to tell AMS to get that part in that line on that row?
or can it only read top down?

If someone have the time to explain more about using txt or ini files I would really appreciate it.

Dermot
08-16-2005, 11:40 AM
You can use the SQLite database plugin with AMS. I think that is you best option id you want to collect and store data over time and then analyze later. If you have worked with SQL in the past you should have no problem with SQLite.