Help in Retrieve and Filter syntax for Multiple Database/Columns

[marvin2010]

Can someone please give me a format of a filter string that will have access to multiple database and tables?

I am to access 2 database and several tables to come up with a single report. I need to filter out some columns as the program needs to be able to allow the user to select if he wishes to include all or just a specific category (say, city).

I will have retrieval arguments. So my dw_retrieve will be dw_retrieve(arg1, arg2,...).

Can someone show me the correct format with example on how to go about this?

thanks...

 

[mbalent]

The filter is applied to the datawindow object, regardless of the source of the data. Generally filtering is done:

integer li_rc
long ll_rows
string ls_filter, ls_city

ls_city = ....//however you get the value

ls_filter = "city = '" + ls_city + "'"

li_rc = dw_retrieve.setfilter(ls_filter)
ll_rows = dw_retrieve.filter()// apply the filter
// to remove the filter
dw_retrieve.setfilter('')
dw_retrieve.filter()

Matt


"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

 

[marvin2010]

Thanks a lot, Matt !!!

 

[marvin2010]

Hi Matt,

A follow-up question re this...

In the format you gave,

"ls_filter = "city = '" + ls_city + "'"

is it possible to get the first three characters of the ls_city and that all records matching that will be filtered out?

Thanks!

 

[mbalent]

You would set the filterstring like this:

"ls_filter = "city LIKE '" + Left(ls_city,3) + "%'"

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

 

[marvin2010]

Thanks, Matt !!!

Appreciate it...