I was quite disappointed when I found out that writing to the FileMaker_Fields table doesn't work (using SQL-Runner):

UPDATE FileMaker_Fields SET FieldID = 24 WHERE TableName = 'VL_Test' AND FieldName = 'Enum'

I get the following error:

failed with FileMaker error code 8309: ERROR: FQL0048/(1:10): This statement contains an invalid operation on FileMaker system table "FileMaker_Fields".

 

Is there any workaround? FileMaker mixed up my remote ODBC tables and I want to try to fix it, inserting the «correct» FieldID’s.

Thanks a lot!

Gary

 

OK, I have just found out that it’s impossible to change FileMaker_Fields because it's a virtual table that is built from the FM schema.

BUT — I need to change the FieldID’s! Or at least the order in which FileMaker assigns the FieldID’s. Any possibility?

Thanks a lot!

Gary