Databases
StackOverflow2013
Postsdbo
POchanging schema at run time delphi 5/ crystal 8.5
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POchanging schema at run time delphi 5/ crystal 8.5
    text
    copied!<p>Ive got a database right now with one username that the front (delphi 5) end connects to. we call reports using the following:</p> <pre><code>with tcrpe.create(self) do try report_name := 'CrystalLotRecapSummary.rpt'; if fileexists(dmposting.tws_drive+'\tws\special\'+report_name) then ReportName := dmposting.tws_drive+'\tws\special\'+Report_Name else ReportName := dmposting.tws_drive+'\tws\reports\harvest\'+Report_Name; WindowButtonBar.PrintSetupBtn := true; Paramfields.retrieve; ParamFields[0].Value := cmbCropYear.text; // IN OLD REPORT ParamFields[1].Value := 'ALL'; ParamFields[2].Value := real_to_str(unitfactor,0); // IN OLD REPORT ParamFields[3].Value := cmbUnit.text; // IN OLD REPORT ConnectMethod := useConnect; Connect.Retrieve; Connect.Password := 'PASSWORD'; Output := toWindow; Execute; finally CloseJob; end; end; // PRINT SUMMARY BY WAREHOUSE </code></pre> <p>This works just fine. the problem is that we are now about to have 2 schemas (sysdba and sysdba2).</p> <p>right now the crystal reports query looks like:</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 "SYSDBA"."LOT_RECAP" LOT_RECAP WHERE LOT_RECAP."GROWING_YEAR" = 2009 AND LOT_RECAP."COMMODITY_ID" = 'RICE' AND LOT_RECAP."STORAGE_ONLY" = 'FALSE' ORDER BY LOT_RECAP."LOT_ID" ASC </code></pre> <p>I need to figure out some way to have the report to decide if the userid is sysdba then the table is sysdba.lot_recap, and if the userid is sysdba2 then the table name is sysdba2.lot_recap. BTW, Ive got to do this for about 300 reports. Any help would be greatly appreciated. If i didnt provide enough info please let me know</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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