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 Rhinorhino 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. keith818

    Calling DTS from ASP.NET

    I have written a function to call a DTS package from a c# DLL. The function looks as follows: public bool RunBulkInsert() { DTS.Package2Class dtsBulkInsert; object objPersistStgOfHost = null; UCOMIConnectionPointContainer cpcCnnctPtCont; UCOMIConnectionPoint cpConnectionPoint...
  2. keith818

    Changing the tab length on a richtext box

    I want to change the number of characters a tab moves the cursor on a rich text box. Does anyone know how this can be done? Cheers for you help, Keith
  3. keith818

    Component Licences

    I am writing a .NET component in c# and I want to set-up a licence so that it works fully in the development environment but requires a licence file if its being distributed in an application. Could anyone tell me how to do this or where I could find a resource that explains how this can be...
  4. keith818

    rounding

    There are several different options depeding on what you want to do. Probably the best option, if you a novice, would be to simply copy and paste the code into the form you wish to call the function from. If your feeling brave you could try putting into a module or class file and making it...
  5. keith818

    rounding

    This function should do the trick. Just call it with the number you wish to round down and the number of values after the decimal place you wish. Private Function RoundDown(dblNum As Double, intPlacesAfterDecimal As Integer) As Double RoundDown = CDbl(Left(CStr(dblNum)...
  6. keith818

    Problem Accessing Stored Oracle Procedure

    Instead of using the ODBC driver I used the native oracle driver and it worked! Cheers for all the help. Keith
  7. keith818

    Problem Accessing Stored Oracle Procedure

    I can call both those procedures form another SQL statement they work fine, I only have the problem when I try to import the stored procedure into Crystal Reports. I am using the Windows 2000 ODBC driver v8.01.76.00 and am calling a 7.32 Oracle Database.
  8. keith818

    Problem Accessing Stored Oracle Procedure

    Again, thanks or your help. Unfortunatly that still hasnt fixed the problem. The first way dosent work because your not allowed to call another stored procedure from the orginating procedure. When I tried the second option I still got the same error. I think it must also prevent you from...
  9. keith818

    Problem Accessing Stored Oracle Procedure

    Thanks for your help, unfortunatly I dont think that'll work as the insert dosent use a cursor, but just inserts directly into the Database. The INSERT is in the main body of the procedure in a for loop and is as follows: INSERT INTO AGED_DEBTS VALUES (EVENT_SEQ, DEBT_REF, SYSDATE -...
  10. keith818

    Problem Accessing Stored Oracle Procedure

    I have created a stored procedure in Oracle that contains an ‘INSERT’ statement in it which inserts values to a table which are then returned by a cursor variable to Crystal Reports using a ‘OPEN [cursor] FOR’ statement. The problem is that when I try to add this procedure to the report I get...

Part and Inventory Search

Back
Top