SELECT SPACKINGLISTITEMS.*, ; > FROM VSO3!SPACKINGLISTITEMS ; > WHERE SPACKINGLISTITEMS.IPID = ?VP_IPID>
SELECT SPACKINGLISTITEMS.*, ; FROM VSO3!SPACKINGLISTITEMS ; WHERE SPACKINGLISTITEMS.IPID BETWEEN ?VP_IPID_1 AND ?VP_IPID_2Before USEing the view:
m.vp_ipid_1 = 0 m.vp_ipid_2 = 2147483647 lnParameter = INPUTBOX('Enter ID value','Parameter value') IF !EMPTY(lnParameter) IF TYPE('lnParameter') = 'N' STORE lnParameter to m.vp_ipid_1,m.vp_ipid_2 ENDIF ENDIF