; Call Database.udf which contains
; DBConnOpen()
; DBConnClose()
; DBCommand()
; DBExecuteSQL()
; DBGetRecordset()
; DBRecordsetOpen()
; DBRecordsetClose()

If Exist("database.udf") = 1 call database.udf Else ? "database.udf not found. Aborting..." Sleep 3 goto end Endif

$objConn = DBConnOpen('DRIVER={Microsoft Access Driver (*.mdb)}; UID=; PWD=; DBQ=c:\test.mdb')

:ComputerInfo

$SQL1="INSERT INTO COMPUTERS VALUES ('@WKSTA','@USERID','@PRIV','@DOMAIN','@PRODUCTTYPE','@CSD','@IPADDRESS0','@ADDRESS');"
$execute=DBCommand($objConn,$SQL1)

:UserInfo

$SQL2="INSERT INTO Users VALUES ('@USERID','@FULLNAME','@MAXPWAGE','@WKSTA','@LSERVER');"
$execute=DBCommand($objConn,$SQL2)

:HardwareInfo

$memory=MEMORYSIZE()

$SQL3="INSERT INTO Hardware VALUES ('@WKSTA','$memory','@CPU','@MHz');"
$execute=DBCommand($objConn,$SQL3)


:END
?  Exit

Quote:

---

You'd need to change your SQL code to use UPDATE TABLE instead of INSERT INTO and modify the logic to differentiate between these two.

---

How it is right now is like it was ran for the first time, I am just stuck on the update part. I know the command to update the field but which would be the SQL statements that will filter between first time or update field.