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

[Luca Olivetti]

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.

Bye
-- 
Luca Olivetti
Wetron Automatización S.A. http://www.wetron.es/
Tel. +34 93 5883004 (Ext.133)  Fax +34 93 5883007