Can't get any better than DBCommand() - Executes a SQL statement and returns a recordset if applicable
Code:
$dsn='DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=test.mdb'
$sql="INSERT INTO Table1 VALUES('eee','fff')"
$recordset = DBCommand($dsn,$sql)
? 'Error = '+@ERROR+' - '+@SERROR
$sql="SELECT Field1, Field2 FROM Table1
$recordset = DBCommand($dsn,$sql)
? 'Error = '+@ERROR+' - '+@SERROR
for $row=0 to ubound($recordset,1)
for $column=0 to ubound($recordset,2)
? 'Field(row='+$row+', column='+$column+') ='+$recordset[$row,$column]
next
next
_________________________
There are two types of vessels, submarines and targets.
