A condition query data with parameter window, pb code through the variable assignment to query data window parameters to achieve conditions but I now want to query out again at the same time the data window without conditions (all of the data), how should pb code should be implemented? Is simultaneously with and without parameters query

CodePudding user response:

The simplest is to use the setsqlselect function

CodePudding user response:

With filter setfilter

CodePudding user response:

When the data window object defined parameters form such as: col_name like: arg_name
Need all data script form such as: dw_1. Retrieve (" % ")

CodePudding user response:

Built two Grid one with no arguments, a band parameter
Retrieve ()
Retrieve (1, 2,... )

CodePudding user response:

Filter filter is not a good way, large data quantity, efficiency will be very bad, are generally setsql, 1/f, like or matching parameters, such as the original two parameters,

Where x=: and y=a: b

Plus two sign parameters where (=1: flag1 or x=: a) and (1=: flag2 or y=: b) which parameters need to enable, respectively set up corresponding sign parameter is 1, set the value corresponding to a or b, this approach similar to the third floor