Simplicty and flexibility!

Edding a new Field causes confused datat...

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

Edding a new Field causes confused datat...

Hello to the Forum....

I have a nice problem here.

If I add a new field in an existing form. Then the data is messed up.

For example, I find Record 10 data in Record 11 in the same field as well.
So whenever the table structure changes, this problem occurs.

Does anyone have an idea about this? 

Yours sincerely

Written by Markus 05/03/19 at 16:50:41 Dataease [{8}]FIVE

Re:Edding a new Field causes confused datat...

Hi Marcus.

Does this happen all the time with all your tables or is it one particular table you have problems with?

If this happens all the time with all tables our guess would be that you don't have full access rights on the drive where your application is stored.

DataEase rename the existing table, create a new one with the changes and then transfer data over from the old one then delete the old table/data file.

If there is problems with access rights, DataEase will for instance not be able to delete files etc and they can get muddled up.

If this is one particular table then our guess is that there is some confusion related to this table either in the TDF/FRM itself or in the RDRR.

Written by DataEase 06/03/19 at 11:08:03 Dataease [{8}]FIVE

Re:Re:Edding a new Field causes confused datat...

Hello to the team,
After a few tests, I found that it affects several forms.
After deleting or adding a field, the data gets confused.
The working environment is Win10 as administrator and the data is stored as a copy on the local machine.
It will use the current 8.5 version from the Download Center.
It's interesting that some forms can not delete. That means: The form but not the table!
With best wishes

Written by Markus 07/03/19 at 09:09:06 Dataease [{8}]FIVE

Re:Re:Re:Edding a new Field causes confused datat...

Have now also made a test on a Windows 7 Prof. system. 
The problem remains the same.
Could it have anything to do with the system files? At the moment I have no possibility to edit any fields in Forms.
Yours sincerely Mark

Written by Markus 08/03/19 at 15:54:29 Dataease [{8}]FIVE

Re:Re:Re:Re:Edding a new Field causes confused datat...

Yes. Sounds like corrupt system files.

What happens when you try to run a status reports on (Records i.e. tables...)

Written by DataEase 12/03/19 at 15:07:56 Dataease [{8}]FIVE

Re:Re:Re:Re:Re:Edding a new Field causes confused datat...

Hello and thanks for the reply. 

There seems to be a problem when I start the status table: See error message.


 This file does not exist in the directory!

I also found that there is not the file RDRRDAAA.DBM, but only RDRSDAAA.DBM without content! (Only 1KB).
Looks a bit confusing overall.
Yours sincerely

Written by Markus 13/03/19 at 15:30:18 Dataease [{8}]FIVE

Re:Re:Re:Re:Re:Re:Edding a new Field causes confused datat...

RDRRxAAA.DBM does not exist in 8.5. It is called RDRRxAAA.RDR.

This had to be done due to a bad version checking model left over from the early days so the only way we could stop people with 8.2 or lower to use a 8.5 application with the disastrous effect that would have was to change the name. We also changed the algorithm so we don't need to do it again ;-)

Missing files is quite common and they are mostly TEMPFORM's that has been left in the RDRR when the files has been deleted. It looks messy but it has no direct effect on your system.

From what you list here it looks OK. 

But something is obviously wrong.

If you copy the application to a local drive and reorganize it, do you then still have the same problems?

Written by DataEase 13/03/19 at 22:29:46 Dataease [{8}]FIVE

Re:Re:Re:Re:Re:Re:Re:Edding a new Field causes confused datat...

I copied the application to a local drive.

At the start of the reorganization (all forms) also the messages come,

that some files are not present. So the problem also persists after that.

Hmmm is a bit stubborn this application .... 



Written by Markus 14/03/19 at 21:42:02 Dataease [{8}]FIVE