Unidac's TUniquery Can Not Filter Special Four decimal places on Oracle
I have a TUniquery SQL is 'select 30.3706 as purchase_price, 30.3706 as retail_price from dual' and connect on the ORACLE 19c Enterprise,
While I try to filter like 'purchase=30.76' or 'purchase_price>30.3706 and purchase_price<30.370600000000001', Both of it is empty in the TUniquery。But it's effective when I filter like 'purchase_price>30.3706 and purchase_price<30.37060000000001',Also in SQLSERVER is effective .
Looking forward to a reply, thanks so much。
Below this is code eg.
Code:
UniQuery1.Close;
UniQuery1.SQL.Text := 'select 30.3706 as purchase_price, 30.3706 as retail_price from dual';
UniQuery1.Open;
UniQuery1.Filter := edtFilter.Text;
UniQuery1.Filtered := True;