Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data edit screen where only certain records are displaye
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00016392
Message ID:
00016439
Views:
28
>I want to create an edit screen where only records meeting a certain criteria is displayed; for example, a claim number equal to a number entered by the user. How do I prompt the user for the claim number? Once they enter the claim number, how do I create the dataset? I started by experimenting with a view, am I on the correct path?
>
>Thanks!

1) Create a view with a filter claimno = ?p_claimno
2) Set NODATAONLOAD to .t. (cursor property)
3) On lost lostfocus of the control do the following :-
a) p_claimno = uservalue
b) =REQUERY('viewname')
c) thisform.refresh()
System Analyst
Nabil B. Ghrayyeb
nabilg@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform