Recent content by fiat2

Great! Thanks for the information. Both appear to solve my requirement. After a quick query, it does appear that the Case statement is returning the data more efficiently. Santa, Thanks for introducing me to In-Line Views (hanging my head in shame for not knowing...) Again, thanks for the...

Great! Thanks for the information. After a quick query, it does appear that the Case statement is returning the data more efficiently. Santa, Thanks for introducing me to In-Line Views (hanging my head in shame for not knowing...) Again, thanks for the quick replies. Enjoy.

Using Oracle 9i. I have a table that stores the records in the following fashion: prodID | sample | attribute | value ----------------------------------- 1445a | 1 | Thickness | 13.9 1445a | 2 | Thickness | 14 1445a | 3 | Thickness | 13.8 1445a | 1 | Drop | 0...

As you can probably see, my knowledge of materialized views is limited. I just did some research on Refresh types... I'm gonna go back and work on this solution for a while and either post more questions or explain what I did. Thanks again for your assistance.

Here is what I'm thinking now... Create the materialized view logs on the tables that I want the data from.... Then create a materialized view on these tables with a more complex query then usual..

Thanks for pointing out my obvious mistake...and more importantly, not doing so in an obnoxious manner. I greatly appreciate that. After your post, I attempted to create the MV on the reporting database and receive the following error: ora-23413: table "" does not have a materialized view log...

using Oracle 9. I'm trying to create a materialized view on a view but keep getting the following error. The view does exist. I'm under the assumption that creating a materialized view on a view is done the same way as on a table. ora-00942: table or view does not exist. CREATE...

I greatly appreciate the information you have provided considering my lack of information that I can provide.

I should have been more informative...this question was poised to me by a colleague of mine..seriously.

When the .dll is being developed in Visual Studio, a vb form from that .dll appears one way, (textbox size, label placement, etc.) than when compiled and hosted in an application. Any suggestions as to what may cause this?

using IE 6.0. I have an app that produces a URL on the .aspx page. When this user clicks on the URL, IE attempts to open the Excel in the browser. Does not provide a Open-Save dialog. I've gone into File Types, (Under Folder Options) and set the options to the same as my computer, but still...

jbenson001-- Well, that depends. If the report that the user is running will only be ran once a week. One minute is really not that big of a deal. The number of rows is not the issue. I'm only returning, on average, 10. The number of columns cannot be changed. This report will report on data...

Below is the view that is providing the data for the report. When executing the query with the parameters that is being passed in, it executes in about 1 minute. CREATE OR REPLACE FORCE VIEW CIDDEV.VW_RDE_ZEUS_LDS ( FACILITY, PROTOCOLID, MOLOTID, MONOMER_LOTID, MIX_DATE...

That is a slight problem...the last function that is being called is the Dispose() in the Report.Master. All goes well for this function, even when called with the larger DataSet. There does seem to be a timing issue, because, regardless of dataset, if I step through the Dispose() function and...

Thanks again for the reply...and simplifying my code. The only problem: If I change myDataset2.Tables.Add(SourceData_Build2()); to myDataset2.Tables.Add(SourceData_Build()); The same results occur, the loading panel never gets turned off. The second code snippet [SourceData_Build()]...