INFORMIX Dynamic Server 7.3 and field conversion problem.
Posted in 1998
Has anyone else had a problem with an INFORMIX view being created via. any GUI, including INFORMIX's SQL Editor, that has a field type in the view differ from the table it is selected from without explicitly stating it to do so in the create view statement? The problem I get is when the create view syntax is executed via. a GUI and not directly from DBACCESS, any field that is a FLOAT field type gets converted to a DECIMAL(16). I can not get around this except to create all views from a table with this field type via. DBACCESS. Is there a fix? Should I use a different version of their client utilities? Is there even a different version available? Any light would be helpful. We develop front-end software that relies on the customer being able to build easily with precoded scripts and not having to enter DBACCESS to create all these views.