Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized View
Message
From
18/09/2001 07:58:46
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
18/09/2001 07:41:10
Carla Silva
Http - Produtos Informaticos, Lda.
Odivelas, Portugal
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00557699
Message ID:
00557704
Views:
11
>Hi to all,
>
>I created one Parameterized view (distrito.nome =?pv_filtro1), that I use to insert and to modify registers in a table base, the user indicates the register that he intends to modify, and is made requery. As I can make requery without use the filter to visualize all the existing registers in the table.
>
>
>Thanks,

Estimada Carla,

First of all, allow me let me point out that "registro" translates to "record" in English.

If your view parameter is of type character, you can leave it blank, and be sure to SET EXACT OFF. For integer or date types, you would have to: a) use two parameters, to indicate a range, b) specify a range that is wide enough (for instance, mydate >= {^1900-01-01} and mydate <= {2100-01-01}).

HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform