I've searched the forums and couldn't find anything about this. Is there a way to search for text in datagrid as in basic list field (using find "something" in field "someField")?
Thanks....
Finding specific text in dataGrid
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller
Re: Finding specific text in dataGrid
You'll find useful infos on :
http://lists.runrev.com/pipermail/use-l ... 60402.html
But you have to consider the issue :
-if the data are coming from a SQL DB... then it's easier to do the search through a SQL query
-or a more simple solution : put the content of the datagrid into a variable, and then use functions like Offset, WordOffset, ItemOffset on this variable.
-third solution : put the content of the datagrid into a simple text field, and then use the command Find
[see the dictionnary]
http://lists.runrev.com/pipermail/use-l ... 60402.html
But you have to consider the issue :
-if the data are coming from a SQL DB... then it's easier to do the search through a SQL query
-or a more simple solution : put the content of the datagrid into a variable, and then use functions like Offset, WordOffset, ItemOffset on this variable.
Code: Select all
put the dgText of group "myDatagrid" into theData
put ItemOffset ("text i'm looking for", theData) into ab
if ab = 0 then
answer "Not found"
else
answer "Found"
end if
[see the dictionnary]