SQL Update Question [SOLVED] lazarus / 8-Other ---------------------------------------------------------------------- IndianaJones · 2009-08-29 17:07 Hi all, I am using Zeos components, inserting works well, but have problem with the update. Here is my update statement but it doesnt work. What could be the problem? Thanks with ZQuery1 do       begin Close; SQL.Clear; SQL.Add('Update rltablo set bscname = :bscname, siteid = :siteid, sitename = :sitename where id = :recno');           Parambyname('bscname').AsString:=Edit2.Text;           Parambyname('siteid').AsString:=Edit3.Text;           Parambyname('sitename').AsString:=Edit4.Text; ExecSQL;       end; ---------------------------------------------------------------------- Silvio Clécio · 2009-08-29 17:36 Hi, Inform other parameter, ...: Code: [Select]Parambyname('recno').AsString:= Edit...; ... should work. Good luck. ---------------------------------------------------------------------- IndianaJones · 2009-08-29 18:46 Hi, I have tried with the following statement, it doesnt work also. I got the recno value from the DBGrid1 onclick event and returns the correct data id. So any clue.           Parambyname('recno').AsInteger:=recno; ---------------------------------------------------------------------- IndianaJones · 2009-08-29 19:01 I changed the SQL statement like this and the parameter, now it works. Thanks. SQL.Add('Update rltablo set bscname = :bscname, siteid = :siteid, sitename = :sitename where id = :id');           Parambyname('id').AsInteger:=id; ---------------------------------------------------------------------- Silvio Clécio · 2009-08-29 19:30 enjoy.