Invalid table declaration[27] Error opening TPS File

I defined a table inside dictionary. When i’m trying to use it in my app getting below error.


How to resolve this ?

Check the basics…
File on disk is latest format.
Run in the debugger to see & make sure latest file format is being used by the program.

Did you update the definition without doing a conversion?

How is the file in question generated - how is data added to the file?

How many users are going to be affected by this?

Answers:

If it’s only you that’s affected then you can try to open the file from your dictionary and it will offer to convert it for you.

If the file is created by your application can you just delete the file and have the application re-create it?

If multiple users will be affected then you might need a tool such as FileManager 3, from Capesoft, it can handle file change updates for you automatically. (I said “such as” FlieManager 3 - so far as I know it is the only such tool, unless you want to try coding file changes yourself.)

Can you open the file in TopScan and see it?
And on the File menu see the File Layout?

Run it thru TpsFix and see if it says its corrupt.

Show the File declaration code?

Do you possibly have an OWNER() defined on the file?

I think people are interpreting this as error 47 = invalid record rather than error 27 = invalid table.
Try sharing the declaration with us, we might spot something.

Hi,

If using IP Driver,
I think this could be that either the IPserver or the EXE program not compiled with current file layout.

Johan

Hello @Ankit_Purohit

Maybe sharing the table definition will make this easier to debug.

Now, based on the screenshot your share, I see the data path with a space between TEST and TO. I think is worth to check.

Based on the Clarion help,

27 Invalid Table Declaration

An attempt to open a table that has an invalid table structure has failed. This is normally found when a Dynamic File has been created incorrectly. Also seen in IP Driver based applications.

So is worth checking the IP driver as johan sugested