Search results for query: *

Hi, I have the wonderful task of modifying an SAP program. The screen has a tab control and a customer (custom) tab labeled 'Art Prod'. When I click the Art Prod tab there is nothing in that tab. However, there is another screen that does have two command buttons. I have stepped through code...

Hi, I am like a new born baby to ABAP so please help and bare with me. When using a hotspot on the grid to go to another form/program, is there a way to get back to the ALV when clicking the SAP green back button while in the form/program that you went to from the hotspot? If you could...

Hi again everyone, This is kind of the second part to my chr(10) issue. I have a process that attempts to INSERT but when throws an exception (DUP_VAL_ON_INDEX) I need to detect that a related child record(s) exists. If a child record exists then I have to delete the child record(s) but first...

Hi, I am trying to figure out the syntax for a linefeed in the UNIX environment for PL/SQL. I tried the following as a test but the result is not what I want. What I am actually doing is building a variable with a message. In this message I need to move to another line sometimes. I appreciate...

Hi All, This one is going to be lengthy but it is necessary to have you fully understand my problem. I have a table with a debit/credit (C/D)indicator and an amount, along with other key fields. I am trying to have a query give back as few records as possible where the the C/D records are...

Hi, Does anyone know of an easy way to hide columns in a databound datagrid (Windows form). I programmatically have created the dataadapter, connection, and dataset. How can I programmatically hide the first two columns. In addition, if the columns are hidden, will I still be able to populate...

Hi, I have been struggling with this problem for a week now. I have a login table that has a relationship of one to many with a look up table. I want the data grid to be bound to the look up table (tblDoctorType). This table only has AutoID, UserID and DoctorType fields. Lets say that the...

Is there a way to do a global replace on a files content in a directory? For example, I want to change ‘exports1’ to ‘exports’ in all files with an extension of ‘ksh’ (*.ksh). Thank you for all your help www.besware.com Tom

Hi I have a query in a report that I am analyzing and do not know what (+) does. I would think it means all records from the given table (b.vendor_cd) but I am not sure. I appreciate your input. where a.plant = c.plant and a.component = c.item and...

Hi All, Is there a way to create an empty file from with in PL/SQL? I want to create an empty file from with in PL/SQL if child records are found in a table. Then when PL/SQL returns to the UNIX script I will check for the existance of that file and if it exists I will send an email. I know...

Hi, I am having a problem with a group by query that sums up a field that is defined as NUMBER(10,2). The result that comes back is dropping off the 2 place holder on the right side of the decimal. Is there a way to sum and show both digits? select journal_type, dr_cr_ind, sum(post_amt) from...

Hi All, I have a table with year, quarter, item, and four different dollar fields. I am trying to build a query that will display records that have year, quarter and the first 8 out of 16 positions of the item field that match but only if at least one of the dollar fields are different...

Hi again everyone, This is a take off from my other issue with CRW - thread222-1177001 which now has a solution thanks to everyone here at Tek-Tips. I now have a fix to the CRW issue but I wanted to be able to have the installer execute the JET35SP3.EXE file during the install instead of the...

Hi all, I just want to say thank you very much for getting me this far. I have completed all aspects of my code changes from DAO to ADO. Unfortunately, my crystal reports are causing an error when I try to print or preview them on the screen. It works fine on my developement machine but on a...

Hi Everyone, I have tried to resolve two errors that have been reported with my application, with no success. The other error with the same application was error 713 (please refer to another post that I made and tried the suggestions without success). Post thread222-1155350 My application...

Hi, I set SQL up and followed the instructions to set up an NETSDK name and I have the checkbox checked to start the service everytime windows starts. Now my problem: Everytime Windows starts the SQL Server icon in the system tray has a empty white circle instead of the white circle with a...

Hi, I set SQL up and followed the instructions to set up an NETSDK name and I have the checkbox checked to start the service everytime windows starts. Now my problem: Everytime Windows starts the SQL Server icon in the system tray has a empty white circle instead of the white circle with a...

Hi Everyone, Posted this in the Oracle group but I think it should have went here! I have this problem when I run a form in debug but not in client/server mode. I am in form builder 6.0 and when I execute the debug mode I get a the following message quickly, "Cannot load Function Body...

Hi Everyone, I have this problem when I run a form in debug but not in client/server mode. I am in form builder 6.0 and when I execute the debug mode I get a the following message quickly, "Cannot load Function Body GET_ERROR_MESSAGE (unresolved ref to <Unknown Program Unit>). Load...

Hi Everyone, I get the following error when my InitializeDatabase subroutine executes. Error 713 (Class not registered. Looking for object with CLSID:{00000010-0000-0010-8000-00AA006D2EA4}) The code in this subroutine is: On Error GoTo InitializeDatabase_error Set gDB =...