How to know total fetched rows
Posted: 30.06.2010, 19:07
Hi, Im new with Zeos Lib and Im doing some basic test...
For this one, Im trying to know how many rows have a resultset after a simple select, so i try with GetFetchSize but allways return 0.
This is what im doing. (Using ZeosLib 6.6.6 - Delphi 7)
Thanks in advance.
For this one, Im trying to know how many rows have a resultset after a simple select, so i try with GetFetchSize but allways return 0.
This is what im doing. (Using ZeosLib 6.6.6 - Delphi 7)
Code: Select all
var
C : IZConnection;
S : IZStatement;
R : IZResultSet;
begin
C := DriverManager.GetConnection('zdbc:mysql-5://host/testDB?UID=USER;PWD=PASS');
C.Open;
S := C.CreateStatement;
R := S.ExecuteQuery('SELECT * FROM testTable');
ShowMessage(IntToStr(R.GetFetchSize));
C.Close;
end;
