On Thu, 20 Jan 2011 12:00:19 +0100, Luca Olivetti <[email protected]> wrote:
>En/na [email protected] 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 -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
