[Lazarus] SQLdb not able to retrieve data from stored procedures?

Bo Berglund bo.berglund at gmail.com
Thu Jan 20 12:57:28 CET 2011


On Thu, 20 Jan 2011 12:00:19 +0100, Luca Olivetti <luca at wetron.es>
wrote:

>En/na michael.vancanneyt at wisa.be ha escrit:
>
>>>> Why could they not use SELECT * FROM SelectSomeData(1234) like 
>>>> everyone else ?
>>>
>>> Because the SelectSomeData is not a table, it is a stored procedure
>>> and must be called with the EXEC verb.
>> 
>> I understand that SelectSomeData is not a table.
>> 
>> But in other engines "SELECT * FROM SelectSomeData(1234)" does work on a 
>> stored procedure.
>> I assumed it was standard.
>
>I never used it (my database needs are quite simple) so I don't know how 
>it works, but zeos has a TZStoredProc component, probably meant to 
>encapsulate the different way each database has to execute stored 
>procedures.
>
I might as well use something else than SQLdb even though it would be
a pity since SQLdb seems to be part of the lazarus file set while zeos
is not.

I located this zeos wiki page:
http://wiki.lazarus.freepascal.org/Zeos_tutorial
but it seems VERY old since it refers to the "latset stable lazarus"
as 0.9.12 and dates are 2005-2006....

Of course I am on lazarus 0.9.30_fixes and FPC 2.4.2

Is there some more up-to-date lazarus tutorial for zeos?

-- 

Bo Berglund
Developer in Sweden





More information about the Lazarus mailing list