Simplicty and flexibility!


Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.


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

Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

Originally with MSDOS one could define relationships up to 240 and running it under WindowsXP could have many more. I have one application with more than 600. Is the limit set for trials or can it be re-defined?.


Written by Karinda 07/11/17 at 18:41:14 LegEasy 4DOS

Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

Hi Relationships is not counted by the number in your relationship table but the number of open relationships at any given time.

A relationship in DataEase ia an-hoc connection between two tables that can be based on the pre-definition stored in Relationship table or dynamically in a DQL etc.

Funnily the same definition in Relationship table can create a multitude of dynamic relationship ex. if you have a subform that look up data in virtual fields etc.

But back to your problem.

We use the standard DE4.53 setup. This comes with the limitation you mention so you must have an amended version where the ZTERMDEF.DBZ has been modified to allow maximum number of open relationships.

The reason for limiting the number of open relationship is most likely completely obsolete now so I will forward it to the team to look into so they can increase it in ZTERMDEF.DBZ shipped with LegEasy4DOS.

You can use the support files from your own DFD if you like, you can go to advanced in the session and choose the path to your DE16M.exe and your USERFORM.DBS and it will use the files in your old DataEase instead of the ones shipped with LegEasy4DOS.

All the best.


Written by DataEase 08/11/17 at 12:30:45 LegEasy 4DOS

Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

Have tried using my existing DataEase 4.53 system but despite defining the directory LegEasy4DOS should run from it seems that it does not use the userform.dbs from my 4.53 directory. I overwrote the ZTERMDEF.DBZ in the trial LegEasy but then had a failure involving the time change affecting USERFORM.DBS and error "can't open user directory" caused by Microsoft changing the file date & time by an hour for the daylight saving. I tried copying userform.dbs with the required time/date match and despite a straight copy & past the file time was updated by an hour and so I still couldn't open the user directory. Don't understand why the date/time check was ever put into DataEaseDOS and why it hasn't been taken out. So I need assistance to get LegEasy4 to look at my installed DataEase directory and use the userform.dbs within that directory.


Written by Karinda 18/11/17 at 15:17:21 LegEasy 4DOS

Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

Hi.
1. Send us your ZTERMDEF.DBZ and we will look at the differences and incorporate that in the release version of LegEasy4DOS. The documentation on these things in 4.53 is a little scatty so it is nice to be able to compare to insure we make the correct modifications.

2. LegEasy4DOS will adjust the Daylight Saving itself so no need to do that yourself. If your own DE you simply need to point to where your USERFORM is (only if it is not english). If you try to change this yourself, it is the opposite way of what you did in XP as we are now running DOS so the time is 180 degrees opposite which was the initial problem with all of this back in the day.


Written by DataEase 19/11/17 at 12:08:21 LegEasy 4DOS

Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

Have uploaded my current ztermdef.dbz and the original 4.53 ztermdef that I edited to give 240 relationships which I named ztermdef.240 so I could always copy & rename it if I was setting up a new system elsewhere.

Regarding the userform.dbs I cannot define the path to use to access my userform.dbs in the way I need to do to access my de16m.exe . when telling LegEasy4DOS to run from my current DE4.53 directory. I have tried to enter a path to read my userform but it won't let me. So it uses the LegEasy user form which is clashing with the time frame problem and prevents my logging in.

As I am unable to copy my current userform.dbs verbatim, and so retain the date & time, I suspect I may be experiencing an effect of a DataEase copyprotection action to restrict copying of officially licensed floppy disks.



Written by Karinda 19/11/17 at 18:24:52 LegEasy 4DOS

Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

This is my current problem: user directory open error. Until I get round this with a userform.dbs with an expected file date & time I can't use my current ztermdef.240 version.


Written by Karinda 19/11/17 at 22:37:32 LegEasy 4DOS

Re:Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

I'm now trying to use LegEasy 4.5 rather than using my Dease 4.53 as I have overwritten ztermdef with my version for 240 relationships. However I have now a login screen to complete. What login name & password is needed? I've tried my dataease.com login and my dease database name & password but neither are acceptable.  This is the first time I've come over this login screen.


Written by Karinda 20/11/17 at 19:09:12 LegEasy 4DOS

Re:Re:Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

Hi again Mike.

We see that you have been busy ;-)

1. You have corrupted your LegEasy4DOS installation so you need to re-install LegEasy4DOS from the original files to move further.

2. Thank you for the ZTERMDEF files. They have been forwarded to our development team to inspect and amend the future settings for allow for 240 relationships out of the box.

3. What you need to do to get it working with your DFD files is as follows.

We are now getting close to the end of this quick tour of L4DPRO but we want to quickly mention the Advanced Options.

Here you can select the code page you are using in your DFD and you can also here map the session to your own Legacy DataEase version.

This is done with international DFD users in mind.

There is a myriad of DFD versions in almost every language so instead of shipping all the versions/language files with L4DPRO we allow you to utilise your own.

We have tested with a number of versions but we can't guarantee that all version will work. If you have a version that won't work, ship it too us and we can see if we can tweak the software so it will run.

When we started this project we could only run DFD 5.53 application in English but we have now run all versions from 4.01 through to 5.53 in a number of different languages.

To get your version to work simply browse to your DFD catalogue and pick the de16m.exe file (we only support de16m.exe at the moment, but are looking into supporting DEASE.EXE too).

If you are running 5.x this is everything you have to do.

If you are running 4.x you also need to pick your userform.xxx file as it will need to be tweaked to run due to the Daylight Saving problem.

When you have selected these files, simply save and hit Testrun...

You should now run your DFD app in your native language trouble free.

The rest is the same as for the built in versions of DFD.

If you like, just let us know and we will do a TeamView session with you to set it up correctly.

PS! Your ZTERMDEF with 240 relationships need to be the on in the same catalogue as your DE16m


Written by DataEase 21/11/17 at 12:30:10 LegEasy 4DOS

Re:Re:Re:Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

Thanks for your prompt response. I now have my copy of v4.53 with all relationships working on two user databases. I have yet to set up printer details and other details but at this time the larger user database that has 781 relationships seems to be working OK thanks to your detailed assistance. I may be quiet for a while now.


Written by Karinda 21/11/17 at 20:31:20 LegEasy 4DOS

Re:Re:Re:Re:Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

That is great news!

Don't be quiet. The forum his here to be used. There are never a stupid quetion!! That goes for you all out there ;-)


Written by DataEase 22/11/17 at 09:54:21 LegEasy 4DOS

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

No silence then. So, we've succesfully used DFD in Ukraine vs dBase, Cliiper and alike products before 2004. After Arun Gupta's death DataEase lost its leading positions here. We insist on wise price policy from new DataEase team for we have great opportunities now. Russian  1c  for business will be illegal in Ukraine soon due to the russian war against Ukraine. DFD is great still and it will work even on iPhone wit Power DOS app but we want DataEase 8.6 or 8.5 for suitable price. Thank You.


Written by Ihor Zakharchenko 22/11/17 at 16:21:49 LegEasy 4DOS

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

When I had all my database files (5) running I found they each started with the login screen showing the specific database file name and stating database does not exist Create one. If i selected "No" it would then show the expected screen with the specific database name listed first which I could click on.  Now, however, after showing the database does not exist and reply "No" it loses the specific database name set up in the menu setup screen. Not sure why this has happened and why I can't get back to "yesterday's" situation. I will try to get screenprints of this problem


Written by Karinda 28/11/17 at 12:52:35 LegEasy 4DOS

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

It sounds like you are a little of track here.

The Sessions should be directed to the correct database. Its better to use one Session setup for each database than try to open the wrong one, answer no and then select what is in the catalogue.

Most likely now you are pointing at a catalogue where there aren't any DataEase applications.

When configuring the session use the Select Application button and let LegEasy for DOS insert the correct path and application name.


Written by DataEase 28/11/17 at 13:34:06 LegEasy 4DOS

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

Thank you for your prompt reply. It is difficult to supply full details of my setup without making it verbose. I have, of course, set up separate sessions for each of my DataEase databases - just as they had separate icons and bat files to run under WinXP. Since my last post I have been able to establish my shortfall was caused by my inaccuracies in the setup definitions form.

It would help if I could see all my menu sessions on one screen. The window doesn't or isn't big enough to show all my 5 sessions on one page where I can choose to select/edit/copy or delete a session. Unfortunately I haven't worked out yet how to look at  the LegEasy screens without losing this comment detail.


Written by Karinda 28/11/17 at 18:43:30 LegEasy 4DOS

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

My now problem is that I cannot access the printer form. Message at login form "Unable to open form Printers". Pressing a key to acknowledge the error causes to skip over the password entry to the first startup menu, Going via "system development" to "system administration" followed by "define printers" brings up a message "You don't have access to Printers".

I am logged in as a "high" status user with the Start-up Menu defined as the first user menu. How/what needs setting to permit access the Printer form?


Written by Karinda 01/12/17 at 21:34:26 LegEasy 4DOS

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

the problem is not about security or access rights but missing or wrong files. 

Are you by any chance keeping your application in a catalogue that contain a version of dataease ?

If so you have to delete the dataease files as they get mixed up with the files used in legeasy.


Written by DataEase 05/12/17 at 10:57:39 LegEasy 4DOS

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

I have a policy of not having a program and related datafiles existing together in a common directory.

I am running my original 1998 DataEase v 4.53 system files to retain the 240 open relationships. This is specified in the advanced tab to use:

C:\Program Files(x86)\dataease\Dataease4_53\DE16M.exe . I note that this directory has PRINTER.DAT & PRINTER.DBS files present.

The datafiles are recorded in C:\Data_1\databases\ with 5 separate directories each containing unique datafiles for the specified application.


Written by Karinda 05/12/17 at 11:48:43 LegEasy 4DOS

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

Is this a problem in all application or one in particular?

Can you create a new application without problems?

Have you set a DEPATH and if so is there a printers.dat in the DEPATH?


Written by DataEase 07/12/17 at 15:20:00 LegEasy 4DOS

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

The short answers are;

The problem is on all applications

I can't even create a new application "Database initialization error 2"  - let alone check if the printer remains unaccessable. 

I have no DEPATH set.   -  The DENETWRK.OVL and PRINTERS.DAT are embedded in the DEASE program folder.

----------------------------------------------------------------------------------------------------------------------------------------------------------------

I am now at the point I need to be able to open the form Printers.

I am still of the opinion that some security/status check is stopping me accessing Printers. If I enter Administration Menu and select Define Configuration  I can access either Database Configuration and/or Workstation Configuration.  Whereas if I select Define Printers I get the usual  standard access error message "You don't have access to Printers" which, everywhere else in Dataease DOS, means your status is set too low for the action you are trying to take. 

I assume that when I manage to access Printers I will be able to see what changes have been made to overcome lack of legacy LPT1 ports on modern systems. Is there a lookup file showing changes to Printer file definition?


Written by Karinda 19/03/18 at 16:08:32 LegEasy 4DOS

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

Printers is a little special as it can be located in a number of places.

It can be in the program catalog, the application catalog or in DEPATH.

The problem here is more likely that the printers.dat it is trying to open is corrupt or not found.

For instance if it try to open the printers.dat for 5.x in 4.x


Written by DataEase 19/03/18 at 18:14:55 LegEasy 4DOS

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

Back in my initial comment regarding using my existing v4.53 applications and getting a message "...exceeds 120 relationships" it was told 

You can use the support files from your own DFD if you like, you can go to advanced in the session and choose the path to your DE16M.exe and your USERFORM.DBS and it will use the files in your old DataEase instead of the ones shipped with LegEasy4DOS.

Consequently this got round the 120 relationship limit but I am now finding the "printer files" are proving difficult. I use the same DOSv4.53 program folder for an existing DOS application and have specified the same DE16M to use in the Legeasy4DOS Advanced Configuration table. Consequently, as the DOS app works perfectly, the PRINTER.DAT or other "printer" files can't be corrupt. More likely the Legeasy4DOS spec for those files have a different format causing the "Unable to open form Printers" error message.

So I have adjusted the Legeasy4DOS Advanced Configuration table to run the "inbult dease4.53 version". Not only can I now access the printer files there is no error message about exceeding 120 relationships.

So it appears the PRINTER.DAT DOS format is not compatible for use by Legeasy4DOS. As I mentioned yesterday, is there information on file regarding defining the use of a USB printer?  Looking at the printer settings displayed via Legeasy4DOS they are vastly different from the DOS printer.dat values. Consequently I need your assistance in gaining full information to adjust the Legeasy4DOS PRINTER.DAT to suit my Brother HL-5440D printer.

Can you also confirm if the current version of Legeasy4DOS now covers more than 120 open relationships.

Regards


Written by Karinda 20/03/18 at 18:10:58 LegEasy 4DOS

Re:Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

Download: touch.zip

If you are using the original DFD 4.53, the solution for the user directory open error is to add the following line to the .BAT that starts DFD:

ECHO Touch USERFORM.DBS file time to 3:14:16 am

C:\DFD453\Touch.COM C:\DFD453I\USERFORM.DBS /T:3:14:16

You should be able to find TOUCH.COM online. It allows you to reset the timestamp on any file...

I will try to attach it here...


Written by Earl Wertheimer 20/03/18 at 22:19:07 LegEasy 4DOS

Re:Re:Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

Many thanks Earl. I lost track of prog to change file dates - probably was Touch.com. Have been getting round the problem by storing USERFORM.dbs under a false name and renaming it after a time change. Now I can go back to the better way. Many many thanks for keeping an eye on this forum. Are you using Legeasy4DOS utilising an original DOS V4.53 system? 


Written by Karinda 21/03/18 at 13:03:50 LegEasy 4DOS

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

Trying a DataEase app that does not need more than 120 open relationships seems to work OK with the inbuilt 4.5DOS within Legeasy4DOS. Consequently using my DOS V4.53 fouls both the relationships limit and one of the printer files. 

Your comment to my first query about relationships, posted on 08/11/17 at 12:30:45, noted I had an edited ZTERMDEF.DBZ and I sent a copy of my edited file with a temporary name of ZTERMDEF.240. This was with a view of editing the LegEasy4DOS ZTERMDEF.DBZ to accomodate a 240 limit. I am now at a point where I cannot proceed further with LegEasy4DOS without that modification. I re-attach a copy of my .240 version.

May I have a prompt reply about availability of this modification.


Written by Karinda 26/03/18 at 17:56:47 LegEasy 4DOS

Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

Dear Michael.


We did fix the ZTERMDEF in LegEasy4DOS and published the changes just after you were kind enough to point out this.

However in the meantime our source control system has for some reason managed to revert the change.

We have fixed it again in the latest published version where you can download here.

http://www.dataease.com/static/files/LegEasy4DOSPRO-1.0.0.3299.exe

We apologies for the inconvenience and hope it is all well now.

Have a Happy Easter.


Written by DataEase 27/03/18 at 13:40:11 LegEasy 4DOS

Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

I have now downloaded the latest version of LegEasy4DOS to gain more open relationships. However I am still being cramped as I have one app exceeding 200 open relationships. I had renamed my sample file as ZTERMDEF.240 as it had been doubled from the original 120. Way back in 1993 the maximum was established at 255 (1 less than 2 to power 8) and thought doubling 120 to 240 would be adequate.

So please can I have a 240 open relationship version. I can't continue using my existing v4.53DOS 'cos the printer files clash with the LegEasy4DOS printer file definitions. Have re-attached my .240 file for reference.


Written by Karinda 31/03/18 at 17:10:21 LegEasy 4DOS

Re:Re:Re:Trial LegEasy4DOS reports my 4.53DOS exceeds 120 relationships.

We have now updated the ZTERMDEF.DBZ in 4.53 to the same as 5.53 i.e. 0xff or 255.

http://www.dataease.com/dg3_Downloads/#de7dev

PS The file you uploaded has only 100 relationships 0x64.


Written by DataEase 03/04/18 at 18:45:05 LegEasy 4DOS