# Re: VB recordset SQL return code

Posted by David Wong on June 17, 1998 at 01:58:04:

There are some statements:

Set Tempdatabase = openmdb.CreateQueryDef("")
With Tempdatabase
.SQL = "select * from staff where staff_code = 'A'"
.Execute
End With

How to know the return code (success or failure) of the SQL statement? And, how many rows of record have been retrieved?

Thanks

Follow Ups:

- Re: VB recordset SQL return code ¼ÍÎÄºÍ 05:21:13 6/17/98 (3)
  - Re: VB recordset SQL return code David Wong 02:42:05 6/18/98 (0)
  - Re: VB recordset SQL return code David Wong 02:41:40 6/18/98 (0)
  - Re: VB recordset SQL return code David Wong 20:28:20 6/17/98 (0)