You'll need at leats two database tables. Table 1 with anme tblComputer has Computer ID and ComputerName. Table 2 with name tblSoftware has SoftwareID and SoftwareName
Then you do SQL like this:
code:
SELECT ComputerID FROM tblComputer WHERE ComputerName=@WKSTA
INSERT INTO tblSoftware (SoftwareName) Values (SoftwareName)
You'll need to do this for every piece of software and also check beforehand if the entry is already present for the specific computer.
Us the DB...() UDFs in the UDF Forum, they do database stuff, and you'll have to use KiXtart 4.12
[ 20. November 2002, 16:06: Message edited by: sealeopard ]
_________________________
There are two types of vessels, submarines and targets.
