Re: [lazarus] SqlDB query not working at runtime

[Michael Van Canneyt]

On Tue, 19 Sep 2006, Nataraj S Narayan wrote:

Hi

svn update fpc
At revision 4559.

svn update lazarus
At revision 9827.


Anything wrong with the following ? I dont get any result when I should
be getting.



object SQLQuery1: TSQLQuery
 Active = True
 Database = MySQL41Connection1
 Transaction = SQLTransaction1
 SQL.Strings = (
   'select * from purchorders where orderno=:morderno'
 )
 Params = <
   item
     Name = 'morderno'
   end>
 UpdateMode = upWhereKeyOnly
 UsePrimaryKeyAsKey = True
 ParseSQL = True
 left = 80
 top = 192
end


implementation

{ TForm1 }

procedure TForm1.Button1Click(Sender: TObject);
begin
 with SqlQuery1 do
 begin
      close;
      params[0].asinteger:=StrToInt(Edit1.Text);
      ExecSQL;

You must remove the ExecSQL. That is only for insert/update/delete/DDL 
statements.

Michael.

_________________________________________________________________
    To unsubscribe: mail [EMAIL PROTECTED] with
               "unsubscribe" as the Subject
  archives at http://www.lazarus.freepascal.org/mailarchives