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

[michael.vancanneyt at wisa.be]

On Wed, 19 Jan 2011, Bo Berglund wrote:

> I am investigating Lazarus' capabilities for database work so I  have
> made a very simple test application using ODBC and the SQLdb
> components.
> I am doing this on a Windows XP platform.
>
> The code is a very slightly modified example that I got from the WIKI
> here:
> http://wiki.lazarus.freepascal.org/Lazarus_Database_Tutorial#Lazarus_and_MSSQL
>
> My problem is that I get an exception on the query.Open line when the
> SQL text is something like this:
> 'EXEC SelectSomeData @Parameter=1234'

Hm. Weird MS syntax.

Why could they not use SELECT * FROM SelectSomeData(1234) like everyone else ?

Can you please give the error message ?

Michael