First off, let me thank you for offering your help; I greatly appreciate it. I have tried to send this message to you several times but I don't know if you got it.

My programming abilities are limited to kix and batch files. I am well advanced in both, however I trip when confronted with anything OLEish. With that in mind, I can most certainly lookup on the msdn site all of this information that I require, however, I don't know how to tie the two together. I would very much like to make this a BBS project as you offered! I believe that it would be a great service to myself and others to be able to follow the natural progression of learning this advanced topic from a beginners point of view. I would be happy to do homework and figure some things out on my own.

With all of that in perspective, here it what I would like to accomplish. General Network Engineer/Admins like myself are not well pronounced in programming languages. So we need to make up for this deficiency by using a simpler tool to create the same end effect. Enter Kix. I would like to create a script that runs during the logon that creates, adds or updates records in a database. The primary key will be the hostname of the box. The DB will be flat as relational DBs confuse the hell out of me. We can modify this later I suppose with little impact. The fields will include info such as C: free space, last logon time, current DAT file, etc. We have about 20-30 fields we would like to capture and already have the code to capture them. The requirements are this:

Must be a database. CSV and XLS are far to limited in their abilities.
Must be able to be written to by several users at once. Record locking only, not file locking.
Records should be updated, not overwritten?
The updating process should be as quick as possible.

Given all of that, I have tried your script and it worked flawlessly. However, I have no idea what the code is doing. Can you explain line by line what's happening so that I can learn from this and write my own stuff?

Also, where can I find info on the parameters of the SQL command you used so that I can create more elaborate fields; like how to create a combo box instead of a text field or change the data type from CHAR to YES/NO or NUMBER?


Again, THANK YOU!

_________________________
-Jim

...the sort of general malaise that only the genius possess and the insane lament.