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

Ok, I figured it out with the help of all of you. Sorry Dagon, I did not see your last suggestion until I come up with what is below. The code below is inside of my first cursor LOOP. The initial unit test appears to have passed. Thanks again. -- build message with all records that are...

I guess I am so not in the loop with PL/SQL and I have results that I have to produce, I am trying to anything and getting nowhere. :( Then let me ask you this. This is the format that I have in my script. DECLARE ... variables declared here ... Initial main input CURSOR here ... several...

Ok, now I am really confused. I have a table OTHER_JOURNAL (not a cursor) that I want to read in PL/SQL code. I am trying to not do a loop type thing. At most it will return 4 records based on my WHERE clause. I would have to do define all fields of my table like this... DECLARE TYPE...

Hi, I am not following your code! DECLARE TYPE NumTab IS TABLE OF emp.empno%TYPE; TYPE NameTab IS TABLE OF emp.ename%TYPE; enums NumTab; -- no need to initialize names NameTab; BEGIN ... EXCEPTION WHEN DUP_VAL_ON_INDEX THEN SELECT empno, ename BULK COLLECT INTO enums, names FROM...

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

You all are great! :) So I am going to attempt to use the following code and see what happens. I guess I am being lazy because I am using VI (I do not prefer) and I am use to stepping through code to watch line by line and I cannot in this environment. gv_msg_build := 'CANNOT DELETE THE OCD...

Cool that worked for my test. So is it safe to say that this will work in the PL/SQL code. gv_hdr_build1 := 'FOUND DUPLICATE OCD RECORD(S) WITH RELATED OJ RECORD(S) ' ||chr(12) Man, you do not know how much I appreciate this information. Thank you for all your help www.besware.com Tom

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

SORRY! I forgot to mention that in a real situation the OCD_TRANS_NO will not be in the WHERE clause because I will not know what records are out of balance. Thanks again. Thank you for all your help www.besware.com Tom

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 again, I have tried this bunch of code and it does not error out. However, it has no effect. My first two columns are not hidden and the LoginID field name still displays in the grid column header. Can anyone recommend a good book that will help an idiot like me understand .NET Windows...

I really appreciate all the support. However, I cannot get this to work. I am so disappointed in .NET. I had no problems programming in VB6. Even the help file information does not make sense to me. Microsoft must have gotten antirely different crew to write the help file. It is not...

That is what I am tinkering with now but have had no luck yet. :( Thank you for all your help www.besware.com Tom

I do not see a AutoGenerateColumn property available. Man, I thought VB would be getting easier but this .NET is a step backwards. Thank you for all your help www.besware.com Tom

I am using VB.NET 2003 My code that works with the one of the datagrids looks like this. Private Sub CreateDataGrid() Dim strSQL As String strSQL = "SELECT ID, LoginID, Diagnosis FROM tblDiagnosis " strSQL = strSQL & "WHERE LoginID = " & gUserID_Number...

I will jump in but by far--I am know expert. Can you do a simple SQL command getting the max ID number. Since it is most likely indexed it should be a fast retrieval. Select max(ID) into myLastID from myTable Have your procedure some how return myLastID. Thank you for all your help...

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

It appears as though I have answered my own question with the following code/event usage. But now I would like to hide column 1 and column 2 (AutoID and LoginID) as long as it does not disrupt the new code listed below. Can someone please tell me how to hide specific columns in a datagrid? In...