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

[Dipl. Phys. Jörg Schläger]

Zitat von Bo Berglund <bo.berglund at gmail.com>:

> On Sun, 23 Jan 2011 13:53:45 +0100, "Dipl. Phys. Jörg Schläger"
> <js at jsdevelop.de> wrote:
>
>>
>> and next you might think of using query.SQL.Text := 'EXEC 
>> SelectDongleData @@SerialNo=2485';
>
> Tried adding an extra @ to parameter.
> Results are as follows:
>
> EXEC SelectDongleData @@SerialNo=2485
>
> 'Cannot open a non-select statement'
>
> EXECUTE SelectDongleData @@SerialNo=2485
>
> 'Could not execute statement. ODBC error details: LastReturnCode:
> SQL_ERROR; Record 1: SqlState: 42000; NativeError: 8145; Message:
> [Microsoft][ODBC SQL Server Driver][SQL Server]@@SerialNo is not a
> parameter for procedure SelectDongleData.;'

of course you have to change your sql statement to define @@SerialNo

procedure SelectDongleData @@SerialNo int AS 

-- 
Dipl. Phys. Jörg Schläger
>
>
> --
> _______________________________________________
> 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/20110123/43cd20f0/attachment-0003.html>