WhoIsGregg

Beautiful! Works perfectly. Thanks!

While building a FMP->MySQL PHP script, I've discovered that my FM database has some incorrectly formatted numbers. As I am inserting to a DECIMAL(30,2) field, MySQL is choking on double decimal point input, "2..25" or "0..15" I want to identify and correct all of the screwed up data, but can't figure out how to isolate them. I tried to do a find for the following values and the all turned up "no records found:" .. ".." ==.. =.. *..* .. What find criteria should I be using to find these screwed up records?

Same problem, no solution. Has anyone got ODBC working on the Mac?

My script is bloated with the unnecessary "go to related records" because I figured they would be necessary once I figured out how to loop through the other related records, btw. <added>and my actual script didn't use "select contents" on every insert... lol</added>

Hello! I have a file with three tables: First Names | Middle Initials | Last Names I am trying to output every combination of one field from each table. Specifically, formatted like so: <record> <first>John</first> <middle>A.</middle> <last>Doe</last> </record> I believe this should be done using the null relationship (X) between each table. Then, using a script that loops through each record set and inserts the result into a global field in the first table. I've also thought about using counters and a layout with two portals to do the looping. I can successfully loop throught the first names and could setup a script for each name then eliminate duplicates, but I'd rather learn the right way to do it. Does anyone have nested loop scripting experience they can share with me? Here's how I loop through the first names: