I have a complicated problem and I'm running out of ideas to solve it.
I'll try to describe it shortly:
I have a D4 app (which uses BDE and SQL Links to connect to an
Informix DS 7.30 DB Server) wich previews a QuickReport 3.0.8 Prof.
On this app. I have a form for editing table data on which one of its
columns has 2 decimal places. The DB column is of type DECIMAL:
CREATE TABLE informix.rh_rf_item_sopval (
item_sop CHAR(4) NOT NULL,
codrest CHAR(1) NOT NULL,
valor_sop DECIMAL(8,2) NOT NULL,
data_act DATE NOT NULL,
codoper CHAR(8) NOT NULL
) EXTENT SIZE 16 NEXT SIZE 16 LOCK MODE ROW
Delphi and BDE sees this column as:
ODS: SQL Data Out: INFORMIX - Column = 3, Name = valor_sop, Type =
fldFLOAT, Precision = 8, Scale = 2, Data = 0.000000 Process ID:
THE PROBLEM IS:
The decimal places are correctly stored on the DB server. The 2
relevant decimal places appear on DBgrids and DBedits correctly.
After I preview the report (QR 3.0.8) and press a button wich exports
the report to PDF (via Pragnaan export filters) and sends an e-mail
(via MAPI services, MapiLogon, MapiSendMail and MapiLogoff), the
decimal places on DBgrids and DBedits do disappear (values begin to be
0.01 becomes 0.00, 1.55 becomes 1 and so on.
During this process, there are 3 DLLs being loaded (2 from Pragnaan
and 1 from MAPI services I presume):
The only way to see the decimal places is to close the program and
Has anyone experienced such a strange situation like this?
You can e-mail me directly to XXXX@XXXXX.COM after
removing the dashes and the no spam part on this e-mail.
THX in advance for any help on this.