hi Geoff
Thanks for your trouble
Unfortunately i only have the dcu's so i could not step the code.

We will go ahead and get the ibo4 components now.

Regards;
Ettienne du Plessis
Senior Analyst
First National Battery CO (PTY) LTD
Tel : +27 11 741-3600
Fax : +27 11 421-2739
Web : www.battery.co.za


-----Original Message-----
From: Geoff Worboys [mailto:geoff@...]
Sent: 17 July 2003 14:37
To: Ettienne du Plessis
Subject: Re: [IBO] TIB_Export problem


I got your sample of the problem.

It was bizarre, I was starting to think I was going crazy.
StrToFloat was failing and I could not work out why.

'OCW' - whoever that is, put in some processing that overrides
the global DecimalSeparator but did not initialise the value,
or publish it to allow changes from the designer (or at run
time for that matter).

This results in DecimalSeparator being set to null during the
export process. StrToFloat relies on this value, and it also
relies on a null terminator on a string. With an integer value
it gets to the end of a string at the same time that it looks
for the decimal. The null terminator equals the decimal
separator value so StrToFloat thinks it has found a decimal
and keeps processing past the end of the string!

I am guessing that the OCW changes are recent (its only a guess
since there is no change detail at the top), which is why they
do not effect IB_SQL (have not been compiled into that yet).
The error is also rather inconsistent, presumably because
there are sometimes more than one null terminators at the end
of the string value. For example I was able to an export of
integer values from the employee database without seeing the
error at all.

Anyway...

Not sure if you can do this with the demo distribution of IBO
or not, but I believe you do have the source for IB_Export so
it may work.

Edit IB_Export and comment out every line containing
assignments to or from DecimalSeparator (there are three
lines).

Recompile and it works (or it did for me).

Anyone else using IB_Export should do the same thing. The
code that is there does nothing useful at the moment anyway,
so whoever it was that wanted this capability can try again
later.

--
Geoff Worboys
Telesis Computing



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/