How to get MSSQL Server Return Status in Delphi after executing SQL commands.
Posted: Fri 23 Sep 2005 12:28
Hi,
I am using MSSQL server 2000 and delphi 7. I am accessing to the database using SDAC components.(SQL Server Direct Access Components)
procedure TFrmAccount.BtnSaveClick(Sender: TObject);
begin
DataModule1.QrTemp.SQL.Text := 'Insert into TabCustomer Values ('+Chr(39)+ Trim(txtAccountNo.Text) + Chr(39)+ ')';
DataModule1.QrTemp.Execute;
end;
How can i get the return status of this Query in Delphi. I need to know the query executed correctly or not.
Thanks in advance.
I am using MSSQL server 2000 and delphi 7. I am accessing to the database using SDAC components.(SQL Server Direct Access Components)
procedure TFrmAccount.BtnSaveClick(Sender: TObject);
begin
DataModule1.QrTemp.SQL.Text := 'Insert into TabCustomer Values ('+Chr(39)+ Trim(txtAccountNo.Text) + Chr(39)+ ')';
DataModule1.QrTemp.Execute;
end;
How can i get the return status of this Query in Delphi. I need to know the query executed correctly or not.
Thanks in advance.