That's why there is DBCommand() - Executes a SQL statement and returns a recordset if applicable , it's a superset of the other database UDFs. Example code, see also the UDF headers
code:
$dsn='DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\\server\writableshare\database.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


[ 26. July 2003, 18:15: Message edited by: sealeopard ]
_________________________
There are two types of vessels, submarines and targets.