Search results for query: *

Hi I'm trying to populate a payment field. I have a list of all 12 months, and the report is based on a date range. The report is based on fiscal year, April 1 - March 31. If the payment is within the date range and is not zero, I want the number value to show, either negative or positive...

Hello I'm trying to put the PageNumber function in a formula, and it's coming back "Page 3.00 of 4.00". I've tried the Round function but doesn't seem to be working. Is there something else I should try? Here's the function: If {V_CRYSTAL_EL_RENEWAL_NOTICE.OPTOUT} = 'NO' THEN 'Page '...

Hi I would like a column heading to read: April - 2005 Where the year is dependant on the parameter entered. I'm using the following formula: If month({?StartDate}) in 4 to 12 then 'April - ' & Year({?StartDate}) Else If month({?StartDate}) in 1 to 3 then 'April - ' &...

Hi I'm creating a report that lists payments for a fiscal year (April 1 - March 31). I have a column for each month. I'm not using a cross tab query, as the report will be exported into an excel spreadsheet. The user inputs start and end date parameters. Say the user enters the date range...

Hi I would like to send a string of numbers to a PL/SQL procedure from VB6. The string of numbers represents unique IDs concatenated together. The string can only be 2000 characters, approximately the unique IDs of 200 records. If the string is 3000, I'd like to send the first 2000 along...

Hi I'm getting a runtime error 429 on the following code. Private Sub cmdPrintGrid_Click() gridPending.PrintData False, True End Sub I'm printing the information from an SSUltraGrid. This started after I created an exe using Wise Installer, and it worked fine before that! I...

Hi I'm having some issues running a procedure in PL/SQL from VB6.0. I've added in a HAVING clause to help with performace, and in PL/SQL it works fine, but when I call it from VB, I get an ORA-06512 error "Not a GROUP BY expression". Here's the procedure: SELECT COUNT (*) INTO...

Hello I'm trying to run a query checks for existing rows in a 'queue' table (Batch_Reassign). If a row is already in the Batch_Reassign table, don't return it in subsequent queries. Here's the code, when I run it without any records in the Batch_Reassign table, nothing is returned. When...

Hey I was wondering if there's an easy way to number the rows in a grid. I'm using SSultragrid, and would just like to have a number next to each row. Seems simple enough, but can't find a "number" property to turn on for the grid... Thanks for any suggestions.

Hello I'd like to loop through selected rows in an ultragrid and get the value of one cell. I'm having difficulty figuring out how to do this, as well as finding ANY documentation on how to do it. I've tried so many scenarios, but here's some of the code: Dim rowCount As Integer Dim i As...

Hey Does anybody know where to find information, sample code for ultragrids? I'd like to be able to count selected rows and pass a specific field (ID) from a row. Thanks for any info.

Hey I'm using a string to pass multiple values from VB6 to PL/SQL. I want to delete certain rows from a table, based on IDs from the string. I'm not sure how to set up the loop so it knows when to stop. Here's what I have so far. PROCEDURE P_REMOVE_RECORDS (in_ID IN VARCHAR2) AS...

Hi I'm wondering if anyone knows if there is a limit to the number of parameters I can send from VB6 (using adParamInput) to a stored procedure in PL/SQL. I'm trying to send 11 input parameters into the stored proc. When I do this, the procedure doesn't work. When I commented out 2, it...

Hi I'm trying to pass an array to a stored procedure in PL/SQL. I'm having an issue with the following sub, when I'm in the loop, I can read the value of the COArray (by hovering over it), but when I try to pass it to the module, the subscript is out range. Any ideas? Here's the sub...

Hey This seems like a silly question, but here it is: I'm trying to populate a textbox in a VB 6 app with an output parameter from a stored procedure and I'm not sure how to set the value or where to set it. I call the procedure from a module and can debug.print the result fine... do I set...

I have created a VB 6 app where users select certain parameters and I run a stored proc to give them a number of how many records meet their parameters. I have been trying get the output value (a number) to return from a stored procedure in PL/SQL. Here is the code I'm using to call the...

Hey I'm having issues returning a value from a PL/SQL stored procedure. I'm passing info from a vb6 front end, but not able to get the result, getting the ByRef argument type mismatch error. Here's the code: Private Sub cmdTestCount_Click() Call...

Hi there. I'm using a PL/SQL back end (and VB.Net front end) to develop an application that will take accounts from one employee (the Source) and reassign them to one or more than one other employees (the Destination). It's when the accounts are reassigned to more than one employee that I'm...

Hi there. I'm using a PL/SQL back end (and VB.Net front end) to develop an application that will take accounts from one employee (the Source) and reassign them to one or more than one other employees (the Destination). It's when the accounts are reassigned to more than one employee that I'm...

Hi I'm using WP10 (and not used to it!). I'd like to print 2 pages of my document per sheet of paper. Can't find an easy way to do this in WP Help, or the "I Hate Word Perfect - But this book makes it easy!" reference book I have. Thanks for any suggestions.