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.
Peter,
that works ! I never thought of suing ExecuteSQL().
Thanks
planteg wrote:
I never thought of suing ExecuteSQL().
Me neither. „What is a nice repetition like you doing in a field like this?“
Huzzah -- I'm glad you got it to work.
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.