Save QBE Values not working

[Jorge Cano]

if I unselect the save QBE Values on OracleDataSet it won't work, if I go into QBE and create a criteria, next time I go in QBE it will remember the last used values.

Any ideas?

I'm using DOA 4.0.6.2 on Delphi 2005

 

[Marco Kalter]

When AllowOperators = True this does indeed not work correctly. We'll fix it.

You could use the following BeforeAction event handler as a work around in the mean time:

procedure TMainForm.OracleNavigatorBeforeAction(Sender: TObject;
  Button: TOracleNavigateBtn);
begin
  if Button = nbEnterQBE then
    TOracleDataSet(TOracleNavigator(Sender).DataSource.DataSet).ToggleQBEValues;
end;

 

[Jorge Cano]

Thanks, it works but I still have a problem with Date/Time fields, the second time I go into QBE mode I get an error message saying 0.0 is not a valid Date/Time, even tough I did not write anything in that field.

 

[Marco Kalter]

I tried to reproduce this with the EmpDataSet of the DeptEmp demo, but all works fine. Can you try this too?

 

[Jorge Cano]

Hi Marco, I think I finally got the scenario where you have this problem.

If you use persistent fields, and set the allowoperators to true, (keep saveqbevalues to false) when you enter QBEMode for the second time it will remember the value.

I think your TQBEField.GetText handler is not taking SaveQBEValues into account.

Thanks.

 

[Jorge Cano]

Any news on this, I found that even if you don't use persistent field you can get the problem.

it all depends on the AllowOperators property, if you set it to true the data set will remember the previous criteria

Thanks

 

[Marco Kalter]

Sorry, I missed this. It seems that if AllowOperators = True, the SaveQBEValues property value is ignored and is always True. We'll fix it. If you need a pre-release, let me know.

 

[Jorge Cano]

Thanks Marco, it will be great to have a pre-release.

 

[Marco Kalter]

Can you let me know your Delphi version?

 

[Jorge Cano]

Delphi 2005

 

[Marco Kalter]

Okay, I will send you something shortly.

 

[Jorge Cano]

Hi Marco, any news on this fix?

Regards
Jorge Cano

 

[Marco Kalter]

Sorry for the delay. We don't have a fix yet, but will get round to this next week.

 

[Marco Kalter]

You can download the Delphi 2005 fix here:

http://www.allroundautomations.com/registered/doa40d2005b.zip