how to filter two fields

Vazid_490

Record.SETRANGE(Field [,FromValue] [,ToValue])// this is the setrange functon syntax

ZIPCGRec.SETRANGE("Post Code",ZIPCGRec."From Zip",ZIPCGRec."To Zip");//this is my form syntax
here post code is a field not in ZIPCGRec table....is my code is correct or wrong

RockWithNAV

ZIPCGRec.SETFILTER("Post Code",'%1|%2',ZIPCGRec."From Zip",ZIPCGRec."To Zip")

It will take just two filters.

Vazid_490

Thank you,
but it print only table first value.this code is didn't filter

vaprog

Vazid_490 wrote: »

ZIPCGRec.SETRANGE("Post Code",ZIPCGRec."From Zip",ZIPCGRec."To Zip");//this is my form syntax
here post code is a field not in ZIPCGRec table....is my code is correct or wrong

If "Post Code" is not a field in the ZIPCGRec table you'll get a compilation error.

It is somewhat suspicious that you use values from the same table/record as filter parameters on which you set the filter.

Vazid_490 wrote: »

but it print only table first value.this code is didn't filter

How did you retrieve the records?

Vazid_490 wrote:

how to filter two fields

in your code you're setting a filter on one filed using two filter parameters. Is that what you need or do you need the opposite: finding the record with "From Zip" <= "Post Code" <= "To Zip"?

archer89

hi, please describe in detail what you need, what you want to do. please describe the meanings of the variables post code, from-zip, to-zip.