Flow filter inventory problem

haja12_aams

Hi all,


Im trying to track the inventory details of all our 8 showrooms through NODBC. Item Variant table has Location Filter am taking inventory details using sql statement pred SetFlowFilter, 'Item_Variant','Location_Filter','S002', so i have to run 8 quries like this, it takes long time coz of network speed i would like to make single quries to get all the showrooms inventory. Any one know?

Thank you in advance

ara3n

I would use CFRONT if you are using native db. otherwise if you are on sql use sql native driver.