tsqlresult

type tsqlresult = class(tcursorsqlstatement,isqlpropertyeditor,isqlclient,itransactionclient)

public

  constructor create(); override;

  destructor destroy; override;

  procedure prepare; override;

  procedure unprepare; override;

  procedure open();

  procedure close;

  procedure clear;

  procedure refresh();

  procedure next;

  function countrest;

  function rowsaffected;

  function rowsreturned;

  function asvariant();

  function asvariantar();

  function asvariantarar();

  procedure loaddatalists();

  property datacols: tdbcols; [r]

  property cols []: tdbcol; default; [rw]

Call the as* function matching the column's actual SQL type (e.g. asinteger for an integer column, asmsestring for a text one)

  property bof: Boolean; [r]

  property eof: Boolean; [r]

published

  property beforeopen: tmsesqlscript; [rw]

  property afteropen: tmsesqlscript; [rw]

  property active: Boolean; [rw]

  property fielddefs: tsqlresultfielddefs; [rw]

  property onbeforeopen: sqlresulteventty; [rw]

  property onafteropen: sqlresulteventty; [rw]

  property params: tmseparams;

  property sql: tsqlstringlist;

  property database: tcustomsqlconnection;

  property transaction: TSQLTransaction;

  property options: sqlstatementoptionsty;

  property statementtype: TStatementType;

  property onbeforeexecute: sqlstatementeventty;

  property onafterexecute: sqlstatementeventty;

  property onerror: sqlstatementerroreventty;

end;

tsqlresult

A fast, read-only, unidirectional SQL cursor connected directly to a tcustomsqlconnection

tcursorsqlstatement,isqlpropertyeditor,isqlclient,itransactionclient

tcustomsqlstatement

tmsecomponent,itransactionclient,idatabaseclient

Extends the FPC tcomponent with object linking facilities and the like; base of every MSEgui component

tcomponent,ievent,iificommand,iificlient

tpersistent

TObject