Topic: "" is not a valid integer value. where there is not a match in the db
this line causes this error when there is no match in the database
ContID := SQLExecute('SELECT id FROM Containers WHERE containerid=' + trfcontid );
["" is not a valid integer value.]
I would like to catch this error and rather open the form to add the value to the database
I tried this
if ContID = '' then
begin
frmContEdit.contID.Text := trfcontid;
frmContEdit.Show;
end;
and it does get the value and pass it to the add container form, but it still does the error first. how do I get rid of that?