get(lasterror)? (if not 0, etc)
Why not create a self-join by name, then check on the count of related records and either increment or add a new record?
There is a function FilterValues() that might help along with getting all the current "increments" into a List. Store the list of values, test a new possible against the list with FilterValues(), if there's not a match, use the value and add it to the list. If there is a match, try the next increment.
You might even use PatternCount() on the list to see how many "ford-falcon-" have been used, assuming you have the increments correct.
Then there's the ExecuteSQL to narrow list of what's used based on the "ford-falcon".
Lots of lovely possibilities.
This is what I was looking for mostly. It is simple. I just never had a use for somehting like this yet. 0 for scripts, 401 for finds, 1408 & 1409 for ExecuteSQL.
Selecting the increment direcly from the table where the model = "Ford Falcon" using ExecuteSQL seems like the quickest way. If that fails and returns an error then add the name to the table.