Parameter Query

M

Mudassir Iqbal

SELECT mcs_shopsetup.Shop_code
FROM mcs_shopsetup
WHERE NOT EXISTS
(SELECT Mcs_form.shop_code FROM Mcs_form
WHERE Mcs_form.shop_code = Mcs_shopsetup.shop_code and
Mcs_form.area_code = Mcs_shopsetup.Shop_area and
Mcs_form.lct_code = Mcs_shopsetup.Shop_location
AND Mcs_form.cal_code =65 and mcs_form.area_code=1 and
mcs_form.lct_code=1) and
(mcs_shopsetup.Shop_area=1 and
mcs_shopsetup.Shop_location=1);

I want to replace all the numeric values with the
variable, so that I can pass the values from the VB
Application.. I m using Crystal report as the Reporting
tool.

So is there any way to pass the values from the VB to the
subquery as we can send the filter criteria from the vb
direc tto the main query.

Mudassir Iqbal
 
Top