Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>create a view to union both tables and select by a new column "userid":</p> <pre><code>create view LOT_RECAP_ALL as select 'sysdba' userid, l.* from sysdba.lot_recap l union all select 'sysdba2' userid, l.* from sysdba2.lot_recap l ; </code></pre> <p>And now modify your select to select from LOT_RECAP_ALL and add LOT_RECAP."USERID" = 'sysdba' (or sysdba2):</p> <pre><code>SELECT LOT_RECAP."GROWING_YEAR", LOT_RECAP."GREEN", LOT_RECAP."ADJUSTED", LOT_RECAP."SHIPPED", LOT_RECAP."WAREHOUSE_ID", LOT_RECAP."REMAINING", LOT_RECAP."LOT_ID", LOT_RECAP."FINISH_DRYING", LOT_RECAP."NAME", LOT_RECAP."STATUS", LOT_RECAP."COMMODITY_ID", LOT_RECAP."VARIETY_ID", LOT_RECAP."PRODUCER_ID", LOT_RECAP."LR_AVMOISTURE", LOT_RECAP."PROJECTED", LOT_RECAP."NOTE", LOT_RECAP."MASTER_ID", LOT_RECAP."VARIETY_TYPE", LOT_RECAP."CROP", LOT_RECAP."STORAGE_ONLY" FROM "LOT_RECAP_ALL" LOT_RECAP WHERE LOT_RECAP."GROWING_YEAR" = 2009 AND LOT_RECAP."COMMODITY_ID" = 'RICE' AND LOT_RECAP."STORAGE_ONLY" = 'FALSE' AND LOT_RECAP."USERID" = 'sysdba' -- or sysdba2 ORDER BY LOT_RECAP."LOT_ID" ASC </code></pre> <p>Depending on your connecting user you might need to add</p> <pre><code>grant select on LOT_RECAP_ALL to sysdba; </code></pre> <p>or</p> <pre><code>grant select on LOT_RECAP_ALL to sysdba2; </code></pre> <p>And maybe you also need to add select grants on sysdba(2).lot_recap to the view owner. Can't tell this from here, depends on your schemas' access privileges.</p>
    singulars
    1. This table or related slice is empty.
    1. POchanging schema at run time delphi 5/ crystal 8.5
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USGWu
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COtheres a sysdba.lot_recap_all, and a sysdba2.lot_recap all. when the user looks at the report with the login as sysdba i want them to see the report populated with data frm sysdba.lot_recap_all, and if they log in as sysdba2 i want them to see the report with data populated with data from sysda2.lot_recap_all. The only way i've found so far is to go in and create 2 different reports, and thats what im trying to avoid. If i do that i have to go in and edit all 300 reports manually, and then i have to go manually insert a statement to redesign where the report points to based on the login,
      singulars
      1. PO
      1. USTidmore
    2. CObecause the select statement that i showed you looks for the fully quakified table, theres not a way to look at just 'LOT_RECAP_ALL' i dont want sydba to have access to sysdba2 and vice versa, i want to force crystal to pull from either sysdba or sysdba2 based on my logins with out having to go in and do them manually
      singulars
      1. PO
      1. USTidmore
    3. COWell, the simplest solution would be to remove the schema qualifier from the select. If you can't change the select statement with the fully qualified table, I see no way to trick oracle into using a different table. Is LOT_RECAP a view or a table? If it's a view, you can still use my approach: rename it, use my view which selects from the renamed originals, do the grants and query with userid=USER. Or there is some way in crystal, but that I don't know of.
      singulars
      1. PO
      1. USGWu
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload