If the base table isn’t easy to extract from the TO name then your naming convention needs work
> On 3 Feb 2018, at 16:21, Holger Herbst <[email protected]> wrote: > > Hi Christian, > > yes, it works, this somehow opens the box of pandora and just wrecked my > other weekend plans :-) > > > many thanks > Holger > > >> Am 02.02.2018 um 14:19 schrieb Christian Schmitz >> <[email protected]>: >> >> >>> Am 02.02.2018 um 14:02 schrieb Holger Herbst <[email protected]>: >>> >>> Hi Christian, >>> >>> I thought this would give a list of BaseTables of this file only. >> >> Sorry, no. This only queries with SQL and passes file name to FileMaker. >> So you can search in another open database. Works as intended. >> >> >>> Is there any opportunity, perhaps with another trailing parameter, to get >>> only the BaseTables of a specific file? >>> >> >> e.g. this will do >> >> MBS( "FM.ExecuteFileSQL"; “yyy"; "SELECT BaseTableName FROM FILEMAKER_TABLES >> where BaseFileName = ? "; 9; 13; “xxx”) >> >> >> Sincerely >> Christian >> >> -- >> Read our blog about news on our plugins: >> >> http://www.mbsplugins.de/ >> >> >> _______________________________________________ >> Mbsfmplugin_monkeybreadsoftware.info mailing list >> [email protected] >> https://ml01.ispgateway.de/mailman/listinfo/mbsfmplugin_monkeybreadsoftware.info > > Mit freundlichen Grüßen > Holger Herbst > -- > Dipl.-Ing. > Holger Herbst > digitalanswers > communications consulting gmbh > Am Steinweg 8 > 30952 Ronnenberg > Germany > Tel.: +49 5108 91364-0 > Mobil: +49 170 29 55 876 > > > > > > _______________________________________________ > Mbsfmplugin_monkeybreadsoftware.info mailing list > [email protected] > https://ml01.ispgateway.de/mailman/listinfo/mbsfmplugin_monkeybreadsoftware.info _______________________________________________ Mbsfmplugin_monkeybreadsoftware.info mailing list [email protected] https://ml01.ispgateway.de/mailman/listinfo/mbsfmplugin_monkeybreadsoftware.info
