Print Thread
message when the qbe has 0 records
#4293 12/04/02 09:48 PM
Joined: May 2002
Posts: 18
Valladolid
R
rdiez Offline OP
Member
OP Offline
Member
R
Joined: May 2002
Posts: 18
Valladolid
Hi! I need to return a message when the QBE
result is 0 records and then refresh the dataset with the complete records.

Thanks.

Re: message when the qbe has 0 records
#4294 12/04/02 11:01 PM
Joined: Aug 1999
Posts: 22,226
Member
Offline
Member
Joined: Aug 1999
Posts: 22,226
Something like this?
[quote]
Code
procedure TMainForm.EmpNavigatorClick(Sender: TObject; Button: TOracleNavigateBtn);
var DataSet: TOracleDataSet;
begin
  if Button = nbExecuteQBE then
  begin
    DataSet := TOracleNavigator(Sender).DataSource.DataSet as TOracleDataSet;
    if DataSet.RecordCount = 0 then
    begin
      ShowMessage('No matches, showing all records');
      DataSet.QBEMode := True;
      DataSet.ToggleQBEValues;
      DataSet.ExecuteQBE;
    end;
  end;
end;
[/quote]

------------------
Marco Kalter
Allround Automations


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.025s Queries: 13 (0.008s) Memory: 2.4988 MB (Peak: 3.0430 MB) Data Comp: Off Server Time: 2024-06-01 15:38:27 UTC
Valid HTML 5 and Valid CSS