----- Using FireDAC you can "MAP" the fields to do this convertion automatically - transparent to end-user!
any other provider like UniDAC, it's similar!
basically, you define the field or fields, or types these fields to be converted in another type, like:
... myfieldx - type integer - type float or ... myfield* - type integer - type float or ... * - type integer* - type float or ... myFieldFloat - type float - type string
some like:
"if" field named "myfieldx", convert integer to float "if" all fields started by "myfield" convert integer to float "if" all fields type "integer" convert to "float" "if" my field "myFieldFloat" convert float to string
you understood?
if FireDAC it's done in "2 clicks" on FDManager, or FDConnection, or FDQuery/FDTable, etc...
--- all start in FDManager and it's inherited to sub-components...
NOTE: of course, you need test if the end value it's correct after convertion!!!
----------------------------------------------
The higher the degree, the greater the respect given to the humblest!RAD 11.3
Numeric --A column with a numeric affinity will store any of the five types. Values with integer and float types, along with NULL and BLOB types, are stored without conversion. Any time a value with a text type is stored, an attempt is made to convert the value to a numeric type (integer or float). Assuming the conversion works, the value is stored in an appropriate numeric type. If the conversion fails, the text value is stored without any type of conversion.
----------------------------------------------
UniKeeper V10.40 -- 您最贴心的个人数据管理助手