This must be a recurrent question for comma separated decimal users: what is
the most practical way for formatting float values founded at a TEdit.text
(such as "1.234,567") to be used in a query?
Is there anything better than doing two StringReplace, one to take the
thousand separator off and other to replace the comma for a "."?
Thanks,
Marcio

Marcio Ehrlich wrote:
> This must be a recurrent question for comma separated decimal users:
> what is the most practical way for formatting float values founded at
> a TEdit.text (such as "1.234,567") to be used in a query?

That is a string, not a number. It just look this way for you. Use any
function that fits your needs to convert it in a float, and then use DBISAMs
AnsiStrToFloat. Everything else is a hack and will bite you back when
started on a machine with different setings.

Ralf

Ralf,

<< That is a string, not a number. It just look this way for you. Use any
function that fits your needs to convert it in a float, and then use DBISAMs
AnsiStrToFloat. >>

Just a note - the AnsiStrToFloat method is in the TDBISAMEngine component,
and you can just use the global dbisamtb.Engine instance to call it.

--
Tim Young
Elevate Software
www.elevatesoft.com