Filter a DataGrid.

[zaxos]

this isnt a question, if anyone want to filter a datagrid her's what i did.
Filter button code:

Code: Select all

on mouseUp
   lock screen
   send dbConnect to me -- Populates the DataGrid with data
   put the dgData of group "DataGrid" into theDataB --  Puts the data of the DataGrid into a variable
   put the dgIndexes of group "DataGrid" into theIndexes -- Puts the Indexes of the DataGrid into a variable
   repeat for each item theIndex in theIndexes
      if theDataB[theIndex]["People"] contains field "filter" or theDataB[theIndex]["Country"] contains field "Filter" then -- If Array "People" or "Country" contains any of the text in field "filter" then it populates the DataGrid with this data
         put theDataB[theIndex]["People"] after theDataC[theIndex]["People"]
         put theDataB[theIndex]["Country"] after theDataC[theIndex]["Country"]
      end if
   end repeat
   set the dgData of group "DataGrid" to theDataC
   unlock screen
end mouseUp

Refresh button code:

Code: Select all

send dbConnect to me

[sritcp]

Hi zaxos:

Code: Select all

if theDataB[theIndex]["People"] or theDataB[theIndex]["Country"] contains field "Filter" then

is only testing the second condition, not the first (it won't return a compilation error, so it will blindside you).

You really mean

Code: Select all

if theDataB[theIndex]["People"] contains field "Filter" or theDataB[theIndex]["Country"] contains field "Filter" then

Regards,
Sri.

[dunbarx]

Yes.

What Sri said.

Each snippet of a boolean must resolve independently. Be sure you understand this. In a button script:

Code: Select all

on mouseUp
   put "true" into xxx
   if xxx then answer "Valid"
end mouseUp

If you comment out the first line, you get nothing. This is because the engine actually does try to evaluate "if xxx", and sees it as shorthand for "if xxx is true". This is common parlance, and should also be made familiar to you.

So in your line of code, there is no error, because the evaluation is as follows:

Code: Select all

if theDataB[theIndex]["People"] is "true" or theDataB[theIndex]["Country"] contains field "Filter" then

But this is not what you wanted, correct? You wanted what Sri expanded for you.

Craig Newman

[zaxos]

Thank you for you corrections guys! I didn't even know there was a mistake until now, never needed to filter the first field... i will update my code and the original post