>Every now and then I perform SQL Selects within an event method. The trouble is that by using
>the table name I am not pointing in the same place as the registry. I have had no luck when
>performing the SQL Selects against a view.
>
>Any suggestions?
>
>Tom Weymann
>thwsdo@rit.edu
Tom,
Could you provide me with your exact steps? Because I am having no problems at all. But I don't make SQL selects against views.
I prefer to make views of views, so their definition get saved within the DBC. I suspect that your problem might come out of the aliasing of the view (you know "lv_something" that gets used as "v_something") . Also don't forget to prefix the view with its DBC container name.
José