VB.NET, Oracle View and you
Posted on 2004-11-24
Ok.. I'm here.. at work on the Wednesday before Thanksgiving.. so the brain isn't working too well and I don't have access to an Oracle database.. so if someone can help me, I promise to save some turkey tomorrow for them.
I've written a VB.NET program to open a Crystal Report. I manipulate the RecordSelectionFormula to select the record that I want based on a simple query on a single table.
Next, I wrote a view which selects from 6 or so tables to populate the "real" report.. for example
CREATE OR REPLACE VIEW VIEW_A AS
A.KEY = B.KEY
Now I want to use the RecordSelectionFormula to limit the result to a single record (A.KEY = 'value')
1. Will this filter be done on the Server or the Client? If on the client, is there a more efficient way to do this selection?
2. How do I specify the A.KEY value? Is it view.tablespace.fieldname? VIEW_A.TABLE_A.KEY??
Thanks in advance for any help offered!