Simplicty and flexibility!


dataease 4.5 16M exceeds 100 relationships.


Started by Manjula Perera
Search
You will need to Sign In to be able to add or comment on the forum!

dataease 4.5 16M exceeds 100 relationships.

Hi,dataease 4.5 could define relationships up to 100 and when running a report system popup message "system error : Relationship limit 100 Exceed" . I have application with more than 130. Is the limit set for 4.5 or can it be re-defined?.


Written by Manjula Perera 09/07/18 at 10:25:29 DataEase for Windows 5.x and before...

Re:dataease 4.5 16M exceeds 100 relationships.

Number of Relationships in your relationship table and the relationship limit is not the same thing. 

You can have millions of registered relationships and it wouldn't be a problem. The problem is open relationship handles. 

A relationship in this context is an ad-hoc relationship handle created due to a lookup or any other indirect data relationship caused by an advanced nested DQL or something.

DataEase can handle up to 255 open relationship handles but was configured to 100 to save memory and it was deemed to be enough.

The easiest way around this is to rewrite your DQL so it won't run into the roof.

Alternatively you need to edit the ZTERMDEF.DBZ file (english) to change the number your DataEase 453 would support.

The maximum number of open relationships (default = 100)

Offset:512

Size: 2 int 


Written by DataEase 10/07/18 at 22:46:59 DataEase for Windows 5.x and before...

Re:Re:dataease 4.5 16M exceeds 100 relationships.

How to open and edit the ZTERMDEF.DBZ file

Thank You...


Written by Manjula Perera 11/07/18 at 10:01:34 DataEase for Windows 5.x and before...

Re:Re:Re:dataease 4.5 16M exceeds 100 relationships.

Download: ZTERMDEF.DBZ


You need to use a hex editor. In the olden days (DOS) you could use debug.com which was shipped with DOS but very awkward to use (command line tool with very un-intuitive keyboard shortcuts.

Today there are tools like hexedit.

0x200 is 512 dec.

0x78 is 120, so this version has 120 relationships.

The one attached has 0xff which is maximum of 255.

You can download and use it but it might be different to yours in other aspects too so the safest bet would be to change your own if you want 100% the same behaviour other than more open relationships.

If you run a language version of DataEase the ZTERMDEF will not be DBZ but have the extension of  your country. If this is the case it is even more important that you change the on you have rather than use ours.

You can load ours and yours in the hex editor at the same time and compare them. Then you will see if there is any other differences than 0x200.


Written by DataEase 11/07/18 at 10:11:06 DataEase for Windows 5.x and before...

Re:Re:Re:Re:dataease 4.5 16M exceeds 100 relationships.

Dear Dataease Support Team,

My sincere gratitude to the support team ,for providing me with a solution to the issue with regard to relationship error.

regards,

Manjula Perera


Written by Manjula Perera 13/07/18 at 09:23:04 DataEase for Windows 5.x and before...

Re:Re:Re:Re:Re:dataease 4.5 16M exceeds 100 relationships.

I was under the impression that the number of open relationships had been set at 255 since my concern listed over a year ago when I bought LegEasy4DOS. Do I need to check that my version is still at 255?


Written by Karinda 12/09/18 at 21:37:09 DataEase for Windows 5.x and before...

Re:Re:Re:Re:Re:Re:dataease 4.5 16M exceeds 100 relationships.

This is not related to LegEasy4DOS but people that run DFD native i.e. in 32bit operating systems and hence versions that was published over 25 years ago with default settings of the time.


Written by DataEase 17/09/18 at 15:44:00 DataEase for Windows 5.x and before...