Grid

[topci]

Hi,
What is the best way to convert data from ASCII file (numeric) into currency or float (and write him into SQL table)? Some user have different regional settings (point, comma, ...)?

Please, I need some tip....

Tnx, DaT

 

[SkipVought]

Hi,

If you are converting a string of numeric characters to a numeric variable, take a look at Type Conversion Functions like cDbl,

Skip,
[sub]
[red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it![/sub]

 

[topci]

I know about this function Cdbl (and other functions), but I have problem, while some regional settings have different type (comma is sometimes like separator, sometimes like digit grouping symbol). I need to have "little function", which "translate" a reading string into real double format....

Tnx, DaT