Hi
I read the same row from a database table over and over again.'The field-values are changed from another program (Python) , but I read same values over and over again i.e the query doesn't seem to be updated with the new values.
The code is simply
procedure dbquery ( s : string );
Begin
form2.SQLquery1.close;
form2.SQLquery1.SQL.Text:= s;
form2.sqlquery1.Open;
end;
It works OK first time when the Lazarus program is started, but then I get same r_value over and over again, when I use
sqlstr := 'select Regn from Rain where id=1';
dbquery ( sqlstr);
r_value := Form2.sqlquery1.FieldByName('Regn').AsInteger;
is there anything more to do than sqlquery.close to cleanup?
I use MySQL56Connection for the connection to Mariadb.
Thanks in advance.
Rgds
Lennart Holm
Sweden