[Lazarus] Accessing MS SQLServer database from Lazarus/FPC?

José Mejuto joshyfun at gmail.com
Tue Jan 25 20:39:01 CET 2011


Hello Lazarus-List,

Tuesday, January 25, 2011, 8:08:14 PM, you wrote:

>>What happens if you put an explicit .First before the loop?
>>   query.Active:= true;
>>   query.First;
>>   while not query.EOF do
>>   begin
>>     S := S + query.FieldByName('AppNo').AsString + #13#10;
>>     query.Next;
>>   end;
BB> This does not help at all...
BB> The query.Recordcount property shows the number of records as 1 and
BB> this is also what is listed in the loop.

Do not care the RecordCount property, it could be less than real
fetchable records.

Anyway it seems to not affect this case, just a clarification.

-- 
Best regards,
 José





More information about the Lazarus mailing list