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 -- Dipl. Phys. Jörg Schläger > > > -- > _______________________________________________ > Lazarus mailing list > [email protected] > http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus > ---------------------------------------------------------------- Dip. Phys. Jörg Schläger Auftragsentwicklung MeÃtechnik www.jsdevelop.de
-- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
