General information
Category:
Forms & Form designer
>I would like to include a paramaterised view within the forms DE and would like to know what the recommended way of doing this is. I can obviously declare a public variable in the DE in the before load tables method but this seems a bit clumsy. Is there a better alternative? I have looked in the FAQs and the MS support area but have had no joy.
You can in beforeopentable method of DE create cursor that will store your parameters. eg. create cursor myparameters ( field1 I, field2 C(5) etc... )
and insert into this cursor values of this parameters. In such way your parameters will be visible in all methods of your form.
Ofcourse your view definnition shuld respect such way of work eg.
create view .... wheres field1 = ?myparameters.field1 .. etc
Greetings
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only