Sparx Systems Forum

Enterprise Architect => Suggestions and Requests => Topic started by: Thomas Mercer-Hursh on December 19, 2007, 04:33:13 pm

Title: CHAR(1) in OpenEdge SQL script
Post by: Thomas Mercer-Hursh on December 19, 2007, 04:33:13 pm

I seem to have found a BIG problem with the SQL script for creating an OpenEdge repository.  This is that there are a number of columns defined as CHAR(1).  This is mapped into the datatype fixchar which appears to be a datatype that works fine with SQL, but which cannot be accessed from ABL.

The fix would seem to be to convert these to a datatype like VARCHAR which maps to an ordinary ABL datatype, but will this cause EA a problem?

Title: Re: CHAR(1) in OpenEdge SQL script
Post by: Eve on December 19, 2007, 09:06:13 pm

Hi Thomas,

I'd recommend emailing sparx systems support directly with any queries about the underlying datastructure.

Unfortunately, I don't know enough about this area myself to say what problems you may run into.