Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: fiat2
  • Order by date
  1. fiat2

    Attempting to Transpose data in table.

    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...
  2. fiat2

    Attempting to Transpose data in table.

    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.
  3. fiat2

    Attempting to Transpose data in table.

    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...
  4. fiat2

    Can I create materialized view on a view?

    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.
  5. fiat2

    Can I create materialized view on a view?

    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..
  6. fiat2

    Can I create materialized view on a view?

    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...
  7. fiat2

    Can I create materialized view on a view?

    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...
  8. fiat2

    vb form appears differently compiled than when being developed

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

    vb form appears differently compiled than when being developed

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

    vb form appears differently compiled than when being developed

    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?
  11. fiat2

    IE is opening file in browser, no Open-Save dialog

    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...
  12. fiat2

    DataTable question/issue.

    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...
  13. fiat2

    DataTable question/issue.

    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...
  14. fiat2

    DataTable question/issue.

    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...
  15. fiat2

    DataTable question/issue.

    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()]...
  16. fiat2

    DataTable question/issue.

    good point on the Dispose method. You're right, I shortened the code snippet to ask the question...always a bad move. here is my Button click event: protected void btnDownload_Click(object sender, System.EventArgs e) { MessageBox.Text = ""; string result = "0"...
  17. fiat2

    DataTable question/issue.

    I have this app that is passing a dataset to an Excel writer. The database call in SourceData_Build() returns only about 10 rows of data but contains almost 200 columns. The app has no problem with Converting to Excel and saving a file on the webserver. The issue is that the Panel is never...
  18. fiat2

    Page Panel not being updated.

    I have a page that contains a Panel with a few controls and one that is inherited(btnDownload) from the Master page. When the btnDownload is clicked, the code is going off and building a Dataset. This Dataset is built on a view which contains 200+ columns with only a few rows of data. I'm...
  19. fiat2

    How to select records based on Date

    Well, it must be Christmas in April because Santa just brought me a gift. It worked and provided me the results I needed. Thanks for taking the time. Enjoy,
  20. fiat2

    How to select records based on Date

    I'm trying to select records that have workdates greater than 4/1/2009. workdate is of type Date is stamped with sysdate when inserted so it contains Date & Time How can I achieve this? SELECT * FROM tb_my_table WHERE to_char(workdate, 'MM/DD/YYYY') > ('4/1/2009')

Part and Inventory Search

Back
Top