Re: [RBASE-L] - General Question about Views & SQL Databases

2018-04-25 Thread 'James Bentley' via RBASE-L
Paul, The super view idea is a conditional yes. It all depends on tables and views involved. One key idea to remember is that the order of selection is VERY important. The selection of tble actions should proceed from the most restricted selection (seleccts the smallest number of records) to the

[RBASE-L] - General Question about Views & SQL Databases

2018-04-25 Thread Paul C. Buckley
Good afternoon, I’m using the latest version of R:BASE X Enterprise. I’ve got multiple SQL tables from a SQL database sattached. I’m creating multiple views from a combination of attached SQL tables and R:BASE tables. Each is a view linking the previous view and another table/view or 2. The