I have a view in a VFE application using dynamic view parameters. Executing the view with 'GAMINC' as the parameter returns 300 records. But executing the query from the view, using SQLEXEC, with the same parameter returns 3,956 records, which is what I would expect. This is the code from the SQLEXEC approach. The actual query code was just copied from the view code with the where clause added.

h1 = 4
TEXT TO csql NOSHOW PRETEXT 7
SELECT inv.inp_Vendor, 
      inv.inp_Long_Item_Name, 
      inv.inp_Long_Item_Number, 
      prc.own_Owner_Code, 
      prc.inp_Short_Item_Number, 
      prc.prl_Price_List_Code, 
      prc.pri_term, 
      prc.pri_Current_Price, 
      itm.vit_Sku, 
      brk.vpb_Vendor_Unit_Price, 
      ity.ity_Inventory_Type_Name
   FROM dbo.tblInventoryPrice prc 
      JOIN dbo.tblInventoryPrimary inv 
         ON prc.inp_Short_Item_Number = inv.inp_Short_Item_Number 
      JOIN dbo.tblVendorItem itm 
         ON inv.inp_Short_Item_Number + inv.inp_Vendor = itm.inp_Short_Item_Number + itm.ven_Vendor_Name 
      JOIN dbo.tblVendorItemPriceBreak brk 
         ON itm.vit_Sku + itm.ven_Vendor_Name = brk.vit_Sku + brk.ven_Vendor_Name 
      JOIN dbo.tblInventoryType ity 
         ON inv.ity_Inventory_Type_Code = ity.ity_Inventory_Type_Code 
   WHERE inv.inp_vendor = 'GAMINC'
ENDTEXT 
?SQLEXEC(h1,csql,'results')

Can anyone suggest where I should start looking to resolve this?

TIA,