-
Cursor Adaptor best practices
Hi,
I have a scenario where I am using two virtualtables.
One is a straight select, the other I created using a where clause that references the first.
I did this to mimic a parent - child relationship.
Create virtualTable v_customers....select * from customers
Create virtualTable v_locations....select * from locations where custid = {v_customers.custid}
I make sure to use v_customers first, then use v_locations.
My question - if in fact this is not a poor design on my part - where do I set up the cursor adaptor for v_locations?
Do I do it in the init of the app or load of the page?
I seem to be doing something wrong as sometimes the cursoradaptor works and sometimes it does not.
Whats the best way to accomplish this?
Thanks.
Herb
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Bookmarks