Search results for query: *

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

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

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

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

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

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

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.

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

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

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