On Sun, 23 Jan 2011 18:23:25 +0100, "Dipl. Phys. Jörg Schläger" <[email protected]> wrote:
> >Zitat von Bo Berglund <[email protected]>: > >> 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.;' > >of course you have to change your sql statement to define @@SerialNo > >procedure SelectDongleData @@SerialNo int AS Why? It is already defined as follows: CREATE PROC dbo.SelectDongleData @SerialNo int = 0 AS I don't see the reason to add another @ in the declaration. Can you explain this a bit? -- Bo Berglund Developer in Sweden -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
