Search results for query: *

Hey Guys, It's me again. I have been trying to figure out why one computer out of four that I've tried my application return an oracle error ora-06502. The error occurs when the program gets to the Execute command of the stored procedure. Can someone list me possibilities of why this would...

Hey Guys, I am trying to call a stored procedure with ADO command object as well as connection. I have the stored procedure return a reference cursor, and the way I call my stored procedure is: set objRS = datCMD1.execute The application gives me an error saying wrong type or number of...

Hey guys, I have in a VB application two text boxes that the user can enter a range that they would want to query off of the server. The user can have the option of inputing as much of the range information they know when creating their ranges. I am wondering is there anyway I can use LIKE...

Hey Guys, I am writing an application that will write to an Excel spreadsheet from Visual Basic and I want it to save and close without Excel prompting. How would I go about doing that? Many thanks, -Diran

Hey guys and gals, I was wondering does my stored procedure have to have a PUBLIC synonym for the users of my application to be able to call the stored procedure from VB? If I have a LOCAL synonym created what all do I have to do in VB? Appreciate any help. Thanks, -Diran

Hey guys, I got a quick question. How would I be able to pass an ADO recordset to an Oracle Stored procedure as a paramter? I appreciate any help and info given. Thank you, -Diran

Hey guys, I have a question. I have a multiline textbox on my form and what I want to do is should the user enter data inside the textbox, I want the program to be able to parse each line from the textbox and put said line into an SQL insert statement. How could I accomplish this? Would be...

Hello guys, I have a question for you all. I have a recordset that contains two fields fields: 'Parent_Value' and 'Child_Value'. a sample of the data contained inside would be as follows. ... sport tennis sport hockey sport basketball sport baseball hobby carpentry hobby...

Hey guys, I was wondering how would one pass a collection to an Oracle PL/SQL stored procedure using ADO and provide = ORAOLEDB? I would very much appreciate this information, as I can not figure out how. Thanks, -Diran

Hello guys, How would I pass in an array to a stored procedure? The PL\SQL package is as follows: package test_varray is TYPE t_InputFields IS VARRAY(4) OF VARCHAR2(5); PROCEDURE Test_Array(p_InputFields IN t_InputFields, P_Field1 IN OUT VARCHAR2...

Hey guys, I have created a user define type in VB that is defined as follows: Type ErrorInfo Code As Integer Message As String Location As String End Type Now in a Function I have written I wanna create a variable that uses the defined type as a parameter to the stored...

Hey guys, I searched the forums and found a sort of related thread about running a PL/SQL script from VB, but I am kind of confused on that. It seems that the PL/SQL script has to be located on the oracle database? I have the pl/sql script as a separate file on the computer's hard drive...

Hey Guys, I am programming an application that will be creating an output file in Excel. I am programming a Function to print a header for this Excel file, and I was wondering what steps are involved to changes the justification of a merged cell (ie: I want to have my merged cell be center...

Hey guys, I am using an File System Object for reading/writing Input/Output files for my application, and I was wondering how would I make it so that if the program has read 100 lines and hasn't encountered a specific string (ie. "NEXT FILE") to exit out of the program? Appreciate the help...

Hey guys How would I make it so that I can populate a table I make on the machine that I will have a key (used for ID of each record) associated with each record in the recordset? Right now I am creating my recordset as follows: Dim rsDataSFAF as Object Set rsDataSFAF = New ADODB.Recordset...

Hey guys, I have a form with 4 different combo boxes fed in data from the same recordset. I have implemented the code to check if there is a duplicate item selected, but what I want to do is upon duplicate item force the combo box to autoselect the first item, which is a blank line. The...

Hey guys, I was wondering if it was at all possible to merge cells from Visual basic to an excel file? I know how to create an Excel object/book/sheet and manitpulate data into rows and columns, but was wondering if it was possible to merge cells, so that I can create a function that sets up a...

Hello all, It has been a little whiles since I've posted here. Been doing fine. I am looking for some help and guidance. In my application I have a PageFrame that has two similar buttons on them (OK, Cancel). I want to be able to use the hotkey alt+O whenever I am on either page and have...

Hi Guys, I want to do the following. Open up a file using a FileSystemObject and look through the file and check to see if a specific string either ADD or CHG is in the file. If they are set a flag to true, otherwhise set the flag to false. Thanks, -Diran

Hey Guys, I have a question. I have made an ActiveX Dll and inside of it makes a call to an Executable that may or maynot be stored in the same path on install. My question to you is this. How would I be able to in my code have the Executable's path be whatever the calling program's common...