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: *

  1. sandease

    Not catching error in FTP

    I am not catching the error when the FTP process fails in the following code. The CONET FTP object does not throw an exception. How can I code a boolean to catch the ftp failure? try { FTP objFTP = new CONET.FTPClass(); System.Object lngFTPConn = objFTP.FTPConnect(strHost,strUser,strPass)...
  2. sandease

    MSDAORA vs MSDAORA.1

    Thank you, you have helped immensely. I will take your advice and start using ADO,NET. I did find, after searching hidden files, that I have version 2.81.1117.0 MDAC on my PC. Thank you again!
  3. sandease

    MSDAORA vs MSDAORA.1

    Cassidy, Thanks again. First off we are using MSDAORA because we don't know any better. None of us have taken any .net classes and we are attempting to learn how to use it on our own, sharing with each other what we have learned. I'll read about OraOledb and attempt to use it in the app I'm...
  4. sandease

    MSDAORA vs MSDAORA.1

    Cassidy, Thanks for your help. What we are still wondering is why am I forced to use MSDAORA.1 as my provider instead of MSDAORA? We coded the same console app on three PC's. The other two programmers could connect to the database using provider=MSDAORA and if I used that I'd get an error...
  5. sandease

    MSDAORA vs MSDAORA.1

    I am in a group programming situation with two other programmers. Just received a new PC, WindowsXP pro sp2, installed Oracle 8i, C# & .Net to connect to Oracle databse. My connecton string is as follows: strConn = "Provider=MSDAORA.1;User ID=myID;Password=Mypwd;Data Source=address.of.server"...
  6. sandease

    MTD YTD, actual and forecast report using query

    Thank you, this is so much easier than I was trying to do.
  7. sandease

    MTD YTD, actual and forecast report using query

    I have a report that lists two types of numbers; actual and forecast. Let's say I'm printing the report during the month of March. I want Jan and Feb columns to show actual numbers and March through Dec to show forecast numbers. This report sums the columns based on job#. I have one query with...
  8. sandease

    What is BOL

    Please explain to me what 'BOL' is and where I can find it. I'd like to look up hash joins that were discussed in a thread from 02/03/2004 which I have inserted below. Thank you >can you explain what is a hash join >jymm (Programmer) Feb 3, 2003 >BOL has a very nice explanation of HASH joins...
  9. sandease

    grouping and summing

    jad, While you were working on the inclusion of the date problem, I took your first solution and worked with it. This is what I came up with. I ordered the returned items by descending date and then numbered the rows. Out of the numbered rows, I select row #1. This will give me one line per...
  10. sandease

    grouping and summing

    jad, You're solution highlights a problem I didn't contemplate...What happens when more than 1 product sums to maximum quantity. If I wanted to include tr_date in the selection criteria and use the most recent tr_date to select between the multiple Max quantities, where would I insert it? Thank...
  11. sandease

    grouping and summing

    jad....close, but not quite there. If the top quantity = 200 and the customer has more than one product that totals to 200, then all products with total quantity of 200 are returned.
  12. sandease

    grouping and summing

    My problem is that my transaction table can contain 1 or more lines for the same product for a customer. I need to make a subquery that will, by customer, sum the quantity for like products and then extract the all of the information for the product with the largest quantity so it can be used...

Part and Inventory Search

Back
Top