Tables > Changing field types

Changing data types of existing fields on the fly or into derived table

Changing the field types is not possible with PdxEditor except by casting data via SQL using the

SELECT CAST(field AS FieldType) AS DerivedField [, other fields] FROM TableName;

which may in turn be saved as a new table reflecting the chosen derived field types.
However, this method type casting retrieved fields will render fields with casting errors as blanks not warning about type casting errors.

Another method is to export the table, you wish to be data type converted, as a CVS text file, as re-importing data from such a source will raise and display failed convertions.

Whatever method chosen, do be aware, that correct type casting will depend on appropiately selected system settings matching the source data.