Creating, Receiving info from Database

[Rogue5099]

I am wanting to create a database by entering in Employee information and then making it easyily viewable in a window with rows, columns kinda but not like Excel.

The GUI will get information from each employee like:

Name, TimeIn/Out, Date, Parts Ran, Downtime, Comments, Scrap Parts.

Then to save this info to ??? and retrive it to display in another window. I was trying to store the info to a .ini but making the script create dates and sections then creating new files will become tedioius. I have 3 employees right now and I just want them to enter data then me to view it after my script does a lot of calcuations.

I have made the main GUI to input/retrive info I'm just looking for best solutions to store the Data for easy viewing later. (If thinking SQL I have looked into it but a complete newb to that)

ANY help would be AWSEOME!!! Thanks in advance!

[taietel]

Why not use XML?

[Rogue5099]

I have tried to Read/Write to XML before and was unsuccessful using AutoIt...

<?xml version="1.0"?>
<November23>
  <Employee category="EmployeeA">
    <ClockIn></ClockIn>
    <ClockOut></ClockOut>
  </Employee>
  <Employee category="EmployeeB">
    <ClockIn></ClockIn>
    <ClockOut></ClockOut>
  </Employee>
  <Employee category="EmployeeC">
    <ClockIn></ClockIn>
    <ClockOut></ClockOut>
  </Employee>
</November23>

how would i create above in autoit and then retrieve it?

I know I need this....

Edited December 3, 2010 by rogue5099

[taietel]

I have used  without problem. Take a look!

[Rogue5099]

Edited post above to match more less what I would need.

Like I said I have tried to read/edit/write XML and was unsuccessful? Any help getting started would be awesome. Once I have something to work with I can figure the rest out.

[taietel]

Post some relevant part of the code that is related to xml and you think it gives you trouble.

[Rogue5099]

Thanks for the help but I think I will just stick to .ini easy [section]info [section]info

[jchd]

SQLite is probably your tool of choice for such applicative data storage/retrieval. Manipulation of data is possible with SQL statements and operators, more complex operations can be done from within AutoIt and stored back into relevant tables.

I could help you get started in that direction. But of course you need to expose more about your actual requirements so that the right structure can be devised.