on 02-11-2008 9:40 AM
Hi All,
Can we fetch the value of the fields from a view directly as we fetch from a database table in teh script?
Or is there any other way to be follwoed?
Pl help me out...
Regards,
Priya
Done
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
the same way as we do in case of table.
infact in case of view also data is fetched from the table itself in the background.
regards
vijay
reward points if helpful
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey Vijay,
Thanks for the help but i have done the same as i fetched from a table..
suppose i have a field from view V_024-TELFX , I have written the code in teh script as
&V_024-TELFX&. But still even though there is the value in the view, itis not at all getting fetched in the script...
What can i dofurther? pl reply..
Regards,
Priya
Hi
Selection conditions that are used as a filter can be defined for a view.
Specifying these conditions under the Selection conditions tab when creating a view in the dictionary would have an effect which is similar to specifying a where clause when writing a select query to restrict data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.