There are obviously records in the table, why can't I find it?

flower

First look at the following code:
//Query in the table bed

  query3.Close;
  query3.SQL.Clear;
  query3.SQL.Add('select * from bed where bed_no = :para_bed_no');
  query3.ParamByName('para_bed_no').AsString := trim(DBedit13.Text);
  query3.Open; //Open the table, there is a record in the table
  if query3.RecordCount >= 1 then //This sentence turned out to be false, what's the matter?
  begin
    query3.Edit;
    query3.FieldByName('bed.s_no').AsString := trim(DBedit1.Text);
    query3.Post;
  end;

Regarding the above problem, I don't know what's going on. I use single-step operation as I said above! !
what the hell is it? I hope you can help me see what is going on?

面面爱面面

Which is the Datasource-->Dataset of DBedit13? If it is Query3, then you have already closed, and DBedit13.Text is naturally empty

面面爱面面

You can use a variable, before query3.Close; read out DBedit13.text, and then use it in Query3.sql

yourapy

if query3.RecordCount >= 1 then
//Try this?
if query3.isempty() then

flower

Thank you! ! !
everyone! ! !