PRB: Conversion of FLOAT & MONEY Columns to INT Fails in Q+E PSS ID Number: Q69921 Article last modified on 12-18-1992
1.10 1.11 4.20
WINDOWS
Summary:
SYMPTOMS During the copy procedure, if the datatypes of columns are changed from MONEY or FLOAT to INT, then when the new table is opened, the MONEY and FLOAT columns only contain NULL values.
RESOLUTION One of the features of the Q+E File Define command is to allow you to copy tables. To provide functionality, Q+E performs the following steps:
- Obtains the table structure of the source table.
- Allows you to make modifications to the structure, such as changes in datatype or length.
- Allows you to issue a File Save As command (from the File menu, choose Save As) and specify a new table name. Upon issuing this command, a destination table is created with the specified table structure and all rows from the source table are inserted into the destination table.
During this process, Q+E will convert data from one datatype to another when possible. For instance, if you want to change an INT column to a CHAR field, Q+E will automatically handle the conversion. However, when attempting to change a MONEY or FLOAT column to INT, the conversion will fail and NULL values will be inserted into the column.
For more information and an updated version of Q+E, contact Pioneer Software Technical Support at (919) 859-2220.
Additional reference words: 1.10 1.11 4.20
=================================================================
Copyright Microsoft Corporation 1992.
