dinoniom.blogg.se - Filemaker pro 18 advanced add multiple fields at once

Here is the principle of the looping script.Ĭreate a new layout and add all needed fields to it. The file could be damaged and you could try to do a recover and test on the recovered version. Something like this should do the trick, but the underlying issue of not being able to access the file over ODBC because of too many indexes seems strange and should be investigated. There may be other plugins that also will do this. This one seems to support the DROP Index statement. More on page 22 of this document: FileMaker 16 SQL ReferenceĮDIT: You can also try using a plugin and running it from within a calculation in a looping script. You could get a list of column (field) names and iterate over these and performing the DROP INDEX statement on each field. You can however create or drop the index from a field when using the database as an ODBC source. There is no functionality in the script engine or calculation engine to affect the database schema. Set Error Capture Set Variable Set Variable Loop Set Variable Set Variable Execute SQL Exit Loop If End Loop NOTE: _BENTEST is a Layout with all the fields from the table I need to work on.

Loop over the set of fields, dropping the field using Calculated SQLĮasy peezy! Thanks again, You are a golden god!.

Write a script (see below) to get a variable of the field.

UPDATE: Thanks to I was able to get this working! I have bolded the items that were the key. This is also a problem, because not all fields have an index, so ones that don't thrown an error, which seems to stop the script running. We tried to use Execute SQL with the DROP INDEX function, but it seemed to be needed for each field and each field requires a new Exectute SQL statement, which means over 500 statements. PS We are on FileMaker Pro 17 for Windows Here is what we have tried: We are open to plugins or other solutions that can help, or just some suggestions for how to do it via FileMaker Pro scripts. We have stumbled around for hours and are making no progress, so hoping someone can help! We are looking for help on how to iterate all the fields, see if it is indexed and drop the index if it is.

We are trying to access this table via ODBC but cannot due to the huge number of indexes. We have inherited a table with over 500 fields in it and almost all of them are indexed.