All Episodes

December 6, 2018
We review each of the Design Functions in FileMaker Advanced 17. We also discuss DatabaseNames     A list of the names of all files open on the computer. FieldBounds     The location, in points, of each field boundary and the field’s rotation in degrees. FieldComment     The specified field’s comment. FieldIDs     A list of all field IDs in fileName and layoutName. FieldNames     A list of the names of all fields on layoutName in fileName. FieldRepetitions     The number and orientation of repetitions of a repeating field as formatted on a layout. FieldStyle     The field formatting applied to fieldName on layoutName in fileName. FieldType     Information about fieldName. GetNextSerialValue     The next serial number of fieldName in fileName. LayoutIDs     A list of all layout IDs in fileName. LayoutNames     A list of the names of all layouts in fileName. LayoutObjectNames     A list of the names of all named objects on layoutName in fileName. RelationInfo     A list of four values for each relationship directly related to tableName. ScriptIDs     A list of all script IDs in fileName. ScriptNames     A list of the names of all scripts in fileName. TableIDs     A list of all table IDs in fileName. TableNames     A list of all table occurrences in the relationships graph for fileName. ValueListIDs     A list of all value list IDs in fileName. ValueListItems     A list of the values in a value list. ValueListNames     A list of the names of all value lists in fileName. WindowNames     A list of the names of windows that are currently open.   https://www.databuzz.com.au/using-executesql-to-query-the-virtual-schemasystem-tables/ https://mightydata.com/sql-reserved-words-in-filemaker/
Mark as Played

Advertise With Us

Popular Podcasts

CrimeLess: Hillbilly Heist

CrimeLess: Hillbilly Heist

It’s 1996 in rural North Carolina, and an oddball crew makes history when they pull off America’s third largest cash heist. But it’s all downhill from there. Join host Johnny Knoxville as he unspools a wild and woolly tale about a group of regular ‘ol folks who risked it all for a chance at a better life. CrimeLess: Hillbilly Heist answers the question: what would you do with 17.3 million dollars? The answer includes diamond rings, mansions, velvet Elvis paintings, plus a run for the border, murder-for-hire-plots, and FBI busts.

Crime Junkie

Crime Junkie

Does hearing about a true crime case always leave you scouring the internet for the truth behind the story? Dive into your next mystery with Crime Junkie. Every Monday, join your host Ashley Flowers as she unravels all the details of infamous and underreported true crime cases with her best friend Brit Prawat. From cold cases to missing persons and heroes in our community who seek justice, Crime Junkie is your destination for theories and stories you won’t hear anywhere else. Whether you're a seasoned true crime enthusiast or new to the genre, you'll find yourself on the edge of your seat awaiting a new episode every Monday. If you can never get enough true crime... Congratulations, you’ve found your people. Follow to join a community of Crime Junkies! Crime Junkie is presented by audiochuck Media Company.

Stuff You Should Know

Stuff You Should Know

If you've ever wanted to know about champagne, satanism, the Stonewall Uprising, chaos theory, LSD, El Nino, true crime and Rosa Parks, then look no further. Josh and Chuck have you covered.

Music, radio and podcasts, all free. Listen online or download the iHeart App.

Connect

© 2025 iHeartMedia, Inc.