Forms 4.5 CHAR and VARCHAR2 Data_Types and Informix

Greetings All,

I have a question pertaining to Forms 4.5 (CDE 2) CHAR and VARCHAR2 datatypes.

My Problem.

When developing a form in Forms 4.01??? I tried to set a relationship between two CHAR datatype columns, and after a couple of weeks, I stopped beating my head against the brick wall. It just doesn't work.

The database needs to be accessed by Forms (In some versions or other) and Informix.

The CHAR datatypes cannot be converted to VARCHAR2, because the current version of Informix can't handle that datatype.

Forms 4.0??? can't handle CHAR datatypes in any relationship, or any statement where the contents is compared to anything else.

Now the Question.

Does Forms 4.5 handle CHAR datatypes any better? Say a Master/Detail relationship where both columns contain identical data, and both are CHAR datatypes?

I am hoping someone offers a solution, otherwise it means developing a fairly large application in Forms 3, that works I know, but what a pain!

Looking forward to hearing of a solution, Alex Long

--
                          ,     \    /      ,
                         / \    )\__/(     / \   
                        /   \  (_\  /_)   /   \                
_______________________/_____\__\_at_  @/___/_____\_________________


|paladin.along.dialix.oz.au          I will up-chuck on the next |

|Alex Long                           person who mentions "The    |

|Adelaide, South Australia           Information Superhighway"!  |


|________________________________________________________________|


                   |    /\ /      \\       \ /\    |
                   |  /   V        ))       V   \  |
                   |/     `       //        '     \|
                   `              V                '