Hello,
I am trying to make my rule-flow working with a customer's Progress OpenEdge DB (using EDC).
Corticon studio version is 5.5.1
OpenEdge DB version : 10.2B06
I defined as "Entity Identity" an integer attribute I called Party.Id.
I mapped Party.Id to the DB field REU.NUM-REU which is an integer field and makes part of the primary key of REU.
So Integer seems to be the right data-type. Why was it rejected previously?
Did someone else encountred same problems?
I finally defined SQL views with ids.
So,
I created artificially ID columns in my OE tables and vocabulary is valid now. Even if adding such columns will not be accepted by the customer.
But when I execute ruletests, giving an ID value to test entities I have error :
Column "EDEALERCDO0_.CODE" cannot be found or is not specified for query.
This coming perhaps from a special fild having "-" in its name (CODE-CO)?
When I don't filter on a special ID value, nothing is extracted from DB.
So the question is : where are documented the special features of OE databases? Like for field names containing a hyphen symbol? Or like for Extent (array) fields?
I finally defined SQL views with ids.