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