Lions and Tigers and Bears OH MY!

[stickck]

Just kiddin! It's more like Bunches and Bunches of Buttons!

any suggestions?

I'm using an SQLite database to track computer equipment and installed software. I have most of it done except the Installed Software part. Right now I have 54 labels with the checkbox button next to each. I have a text file that has a list of programs we could have installed (not every PC is set up the same). I have it load the text file into a table then step through that table and rename each of the Labels to show a program name. The unused buttons and labels are hidden. (trying to keep it easy to update) When you click the button, it gets the label text associated to it and stores it in a variable.

Here is where I need suggestions. I would like to be able to keep them stored in a way that will let the user be able to edit the list on a later date. This program will be stored on a LAN system and ran from a MAPPED DRIVE. Would it be easier to create a second table in the SQLite Database just for the installed software? Currently we only have 42 programs but I left room for up to 54.

Would it be better to store a number in the database and just have that number stand for the index number in the table of program names?

Also, is there a way to have a string that has commas be converted to a table? I would rather not have to write it to a Text file first and then use the TextFile.ReadToTable if I can help it. Running this across a LAN system slows it down enough without needing to read and write to another text file.


Any suggestions would be great!

I'll post a sample in a little while.

Sorry for the Bad English (now theres a band from the past!) Long day!

chris

[stickck]

I may have come up with a fix. I'll post my scripts later just in case someone else may find them useful. Pretty much what i'm going to do is the programs that are selected are going to be put in one cell of the database with NEW LINE CARRAGE between each of them so they can be previewed by the user in a Paragraph object. In a second Table in the same database file with be Yes / No that represent each installed program, That way I can query from the database into a LUA table then step through the table and have it select the programs that are installed. It SHOULD be easy.

After I'm done, I'll post the APZ file on my BOX.NET account for everyone.


Chris

[longedge]

I may have come up with a fix.

:lol :yes Welcome to the exclusive "Solve Your Own Problem Forum Members Group" - I joined a long time ago. Look forward to seeing your code as I'm continually looking for stuff that could be useful over a LAN.

My most succesful AMS to date app is one that we use for deployment/updating of database front-ends from the server to client machines. I'm still fighting to get an update to AMS6 so anything that can help me to show that it's 'needed'....

The words "mapped drive" send shudders through me - I'm always having to sort out problems with USB memory sticks that don't work because of drive that are mapped via ourt logon scripts but that's another story.

[stickck]

Here's a link to the APZ file. It's not finished but i was able to solve my problem by creating a second table in the database file.

I'm bad about adding comments in my scripts but for the most part it should be commented out.

Download here... 1.7 meg
http://www.box.net/public/h6m5d5bryj

my most successful project so far has been a Quiz program. TJ Tigger, Corey, Intriegued and Worm all gave me a hand with it. I have about 15,000 users so far.

Chris