Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
V6s5 - How to make Parameterized Views return all record
Message
From
19/03/2004 08:03:30
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00886996
Message ID:
00887841
Views:
12
This message has been marked as a message which has helped to the initial question of the thread.
>Hi Dorin
>
>>Could you post some sample code?
>
>
SELECT SPACKINGLISTITEMS.*, ;
>	FROM VSO3!SPACKINGLISTITEMS ;
>	WHERE SPACKINGLISTITEMS.IPID = ?VP_IPID
>
>Sorry for replying late as I was out of town. Thanks for your interest. I am open to ideas, but also see Cetin's reply to the same query.

If parameters are numeric, then you can do something like this
View code:
SELECT SPACKINGLISTITEMS.*, ;
	FROM VSO3!SPACKINGLISTITEMS ;
	WHERE SPACKINGLISTITEMS.IPID BETWEEN ?VP_IPID_1 AND ?VP_IPID_2
Before 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 
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform