Hello.

Can anybody explain this, ta.

I am experimenting with IBConsole and a Delphi3 test app utilizing FIB components and connecting to the demo EMPLOYEE.GDB that comes with FB.

With...

execute procedure sub_tot_budget('000')

... via IBConsole it correctly returns values with 2 decimal places (defined in StProc as NUMERIC 15,2). Yet in the FIB dataset it shows more than two digit precision, e.g. 1166666.66666667

Is FB sending Delphi (or the FIB dataset) only two decimal places and Delphi/FIB is fiddling with the precision? This seems likely given the fact that the IBConsole output is as expected.

The selectSQL string for the FIB dataset is:

select tot_budget, avg_budget, min_budget, max_budget from sub_tot_budget(?head_dept)

Any help/thoughts appreciated.

Regards,
Andrew Ferguson


[Non-text portions of this message have been removed]