On Sun, 23 Jan 2011 13:53:45 +0100, "Dipl. Phys. Jörg Schläger"
<[email protected]> 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.;'


-- 
Bo Berglund
Developer in Sweden


--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

Reply via email to