Search results for query: *

I am trying to find all the records for a column that does not have all capital letters, ABCDEFGHIJKLMNOPQRSTUVWXYZ. I tried the following: Select widget_column from widget_table where widget_column not like '%ABCDEFGHIJKLMNOPQRSTUVWXYZ%' However I still got records back that had all capital...

I am working on an exception handler and I want it to do two things, but I have only be able to get to it to do one of the two tasks. I want the exception handler to call a stored procedure to update a Product ERROR table. Then I would like to use the raise_application_error procedure. If I...

I want to call a stored procedure in my exception handler. However when I have an error that triggers the exception handler it doesn't seem to trigger the stored procedure. Is it possible to do this? Is there something I am doing wrong? I do however get a message from the...

Ok, I have completely confused myself. I need to return data from a database from a select statement. How do I do this? Is this done in a package, function, stored procedure? It is a simple query that would return several rows. For example select product_id, product_name, product_price...

Hello, I need some help returning values from a procedure. All I want is to return results from a select statement. Many rows would be returned. I had read that bulk collect into was a good way to do this but I am not sure how to return the values. Can someone help? CREATE OR REPLACE...

Hello, I have a subprocedure that changes the background for all text objects on a form. Currently I have it set up like this: public sub chngcolor() with form1 .txtbox1.backcolor = thewhitecolor .txtbox2.backcolor = the whitecolor etc... end with What I would like to do is make this more...

Hello Group, I am having problems using a toolbar and an imagelist. My image list contains bmp images that I created from paint. When I use the images for the buttons on the toolbar the images are small. How can I adjust the size of the image buttons? Thanks.

Ok I am sure there is probably a function out there for this but I haven't found it. How do I get today's current date using Perl? I would like to get it in two different forms: MMDDYYYY and DD-MON-YY All I have found so far are refrences to a module called Date:Calc but that seems to be for...

Ok I am a rookie to be Perl so take it easy on me. :) I want to open multiple files that are located in a directory, extract information from them and do some checking with the numbers in the files. I am stuck and have not found good examples to help me out. This is what I have to this point...

Hello, I have an xml document that has one too many end tags in over 500 documents. I want to eliminate one of the end tags and thought I would use it with a substitution line. However I have been unsuccesful. example of text: </body> </prod_batch> </prod_batch> I wrote: perl -pi -e...

I am having problems creating a MS Excel file from my Visual Basic Application. I keep getting an error when I try to assign a name to a worksheet. The error says ojbect doesn't support this propert or mehtodIM006. Here is the snippett of code I have to this point: Dim objXL As...

I have a Crystal Report that customers would like to see broken out into individual worksheets for each distinct product. Currently I have a report that lists all the current products, the number of products varies through time. The reports lists the product name, location of product, date...

I am trying to determine how I can find numbers in a string. For example if I had the string: Trying to figure out how to do this in less than 123 steps. Help please. I would like to return 123 to a variable. Can Someone help?

I have a 6.0 VB application that sends information out to an Excel Workbook. I have been able to automate the process as long as I know the number or worksheets I need. However now I need to learn how to use the VB OLE Automation to create X amount of worksheets. Each time the report is ran...

When I was using the Package & Deployment Wizard for my VB Application I get an error that says: These files are needed for this package but cannot be found. Click Browse to locate the file(s) or OK to proceed without the file(s). Missing Files: Crystal I have tried to proceed without the...

I have a report that has 4 subreports. I can get it to run on my machine but not on any other users. After picking it apart I learned that if I removed all the subreports it runs on their machine. I am thinking that this is a missing DLL file or another supporting file. Anyone know what...

I am having problems with a few of my combo boxes on a SSTab. I have two tabs. General Information, and Comments. The General Information is displayed first and has combo boxes on it. They are loaded when the form is loaded. The Comments section has some text boxes on it. When I click on...

I have been using RDO in my VB 6 application to query the database. I would like to learn how to bind these statements. Does anyone have any information on binding and how to do that in RDO statements? I am using VB 6, and Oracle 8i. For example if I have this I want to know how to bind it...

Is there a way to improve the speed of populating a combo box? I have a combo box that is populated from a resultset but it has 1750 choices and it takes a long time to populate. Any suggestions?

I am working with an Oracle 8i database. After executing a sql statement and having a recordset of multiple records, up to thousands I want to display the information to a form. The method that I came up with was to write code so I build and populate the html form at the same time the Next or...