On Wed, 19 Jan 2011 19:27:58 +0100, Bo Berglund <[email protected]> wrote:
>Did this and indeed now I have the SQLdb tab on my lazarus. More problems: I have created a test application and did a cut-and-paste operation on the example on this page: http://wiki.lazarus.freepascal.org/Lazarus_Database_Tutorial#Lazarus_and_MSSQL After changing the specifics of the database (server, name, user, login) in the code I tried to run it in Lazarus debugger. After fixing the uses clause so it will compile and after creating a datasource pointing to my database I tried running against a real MSSQLServer database but it failed miserably with an exception on line: query.Open; The exception text is: 'Cannot open a non-select statement' The database I run against uses stored procedures to select data and I have specified a call to such a procedure in the test program as follows: query.SQL.Text := 'EXEC SelectDongleData @SerialNo=2485'; This works fine in my Delphi program where I use an ADO connection. There the query object is defined as qryADO: TADOQuery; and the code to get the records is: sSql := 'EXEC SelectDongleData @SerialNo=' + IntToStr(KeyNo); qryADO.SQL.Text := sSql; qryADO.Open; What did I do wrong regarding the use of TSQLQuery to get this error? -- Bo Berglund Developer in Sweden -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
