Error 36 - Invalid Data File.

[muncter]

Hi,

I try to alter the length of a field in a data file using the dictionary in V5.5. When I try to convert the file to reflect the change I get the message "Error (36) - invalid data file"

Can anyone advise me where I may be going wrong?

 

[ShankarJ]

Hi!

Which Database?

The file could be corrupted.

Regards

 

[muncter]

The database is TPS. If I change the length back to the original the file is OK.

There are two relationships to other files as well many to one, and one to many.

 

[ShankarJ]

Hi!

After changing the file layout in the DCT, are you CONVERTING the file to the new format? After converting, have you opened the converted file with TOPScan.exe to check if the data is OK. You could create an empty file with the new layout, rename <FileName>.TPS as <FileName>.TPE and then run TPSFix.exe to rebuild the file using the example TPE file.

Have you check the generated <APPName>.CLW of your application to see if the new layout is being reflected for the file?

Regards

 

[muncter]

It is when I try to convert the file I get the error message. I will try your suggestion though.

 

[muncter]

I tried your tip but it didn't work, I got an answer "There were no errors detected".

Every time I try to convert the file I get the error message. I can't understand why I cannot change the length of one field, from S15 to S30, without getting an error message.

 

[ShankarJ]

Hi!

I asked in a previous post ::

Have you check the generated <APPName>.CLW of your application to see if the new layout is being reflected for the file?

Also, is this column related to another table and has that table also been changed to the new size?

The reason for your error is most likely that the source has not been generated correctly. Have you tried to "Re-Generate All" before compiling?

Regards

 

[muncter]

Thanks for your help Shankar, but I still haven't resolved my problem. I am trying to change the field length in the dictionary which is OK. When I try to convert my existing file to show the new field length in the dictionary I get the error message.

I have done everthing you suggested but nothing has worked.

 

[ShankarJ]

Hi!

That sound more like the Conversion utility failing. Have you tried creating a conversion program instead of using the in-built conversion utility of the DCT editor?

Can you send me the file i.e. if it has no proprietary information and you trust me.

My e-mail is j s h a n k a r (AT) e i m (DOT) a e (Replace the (AT) with @ and (DOT) with .).

Regards

 

[ShankarJ]

Hi Brian,

Replied to your e-mail with an attachment.

Posting here in case my e-mail has got caught in your SPAM box.

Regards

 

[muncter]

Many thanks for all your help, it now works thankfully.