Is is possible to filter records from the Temp Record var

pawanp

Suppose i have temp variable of item records(ItemTemp) with some records.
And i want to filter variable item records(Items) with temp variable(ItemTemp).
How to do that?? Please help me with the code. Thanks

rmpatel22

You can filter it with same commands SETFILTER and SETRANGE

pawanp

Can u help me out with the code. As the parameter for SETFILTER function is Field and value.

rmpatel22

ItemTemp - Temporary Record variable for Item table
Items - Record variable for Item table

If ItemTemp having filter on "No." field then,

Items.SETFILTER("No.",ItemTemp.GETFILTER("No."));

pawanp

ItemTemp is not having any filter. Its only having few records.
I want to apply filter to Item Variable based on few records on Itemtemp variable.

rmpatel22

Why you want to do this? What is your exact requirement?

Instead of this you can do process like,

IF ItemTemp.FIND('-') THEN REPEAT BEGIN (Sorry, before I written GET instaed of FIND, now corrected it)
IF Items.GET(ItemTemp."No.") THEN BEGIN
//You can write your code here for Items record
END;
END UNTIL ItemTemp.NEXT = 0;

kine

rmpatel22 wrote:

Why you want to do this? What is your exact requirement?

Instead of this you can do process like,

IF ItemTemp.GET('-') THEN REPEAT BEGIN
IF Items.GET(ItemTemp."No.") THEN BEGIN
//You can write your code here for Items record
END;
END UNTIL ItemTemp.NEXT = 0;

What is "GET('-')"? You mean "FIND('-')"? ;-)

lvanvugt

A small note on this:
you can perform any action you can on a table also on a temp table (based on a temporary record variable)