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

Dipl. Phys. Jörg Schläger js at jsdevelop.de
Mon Jan 24 19:15:13 CET 2011



-- 
Dipl. Phys. Jörg SchlägerZitat von Bo Berglund <bo.berglund at gmail.com>:

> On Mon, 24 Jan 2011 09:28:05 +0200, Graeme Geldenhuys
> <graemeg.lists at gmail.com> wrote:
>
>> Alternatively, add the SqlDB source path to your project, then when you
>> compile your project, it will compile the SqlDB code too - as if it was
>> part of your project source code.
>>
>
> Thanks, this was the simple way I have been looking for!
> Now that I did that the patch activated and I could see that it no
> longer barfs at the EXEC verb.
> Still only returns one record out of 4, though.

is it possible for you to do something like this ?

ii := 0;
Query1.open;
while not Query1.eof do
begin
iii := ii + 1;
Query1.next;
end;

then check ii.

In Delphi the behavour of Query1.recordcount with ODBC and MSsql is mystic

>
>
> --
> Bo Berglund
> Developer in Sweden
>
>
> --
> _______________________________________________
> Lazarus mailing list
> Lazarus at lists.lazarus.freepascal.org
> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
>


----------------------------------------------------------------
Dip. Phys. Jörg Schläger
Auftragsentwicklung Meßtechnik
www.jsdevelop.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20110124/77ce564a/attachment-0003.html>


More information about the Lazarus mailing list