Hi,
the title says it all. Is there some way to search, via a script, in a specific repetition of field, other than setting another field to that specification repetition ?
I hate repeating fields .
Thanks
Hi,
the title says it all. Is there some way to search, via a script, in a specific repetition of field, other than setting another field to that specification repetition ?
I hate repeating fields .
Thanks
Off the top of my head you could use SQL to retrieve a list of matching primary keys; something like:
ExecuteSQL ( "SELECT \"primaryKey\" FROM \"table\" WHERE \"repeatingfield\"[x] = ?" ; Char ( 9 ) ; Char ( 13 ) ; "search term" )
Where x is the repetition you're searching in.
Off the top of my head you could use SQL to retrieve a list of matching primary keys; something like:
ExecuteSQL ( "SELECT \"primaryKey\" FROM \"table\" WHERE \"repeatingfield\"[x] = ?" ; Char ( 9 ) ; Char ( 13 ) ; "search term" )
Where x is the repetition you're searching in.