Comments by stevenandler (Top 10 by date)

Hi George

I added the Element.Update(), but I still get multiple strip lines showing up for certain elements. Can you recommend a good text source which explains the MS Chart component in detail, how it works, clear explanation of all of its properties and and some examples? It has been very frustrating getting any organized documentation about MS Chart even from Microsoft.

Thank you for your honest input. If you can suggest a couple of good C# books for me to read, I would really appreciate it.

I set the Dock to Fill. The only problem I have now is there are some labels and text boxes at the top of the form and the datagridview is now superimposed on these items. Can you tell me what other property I can set which will protect the top part of the form from being covered by ther datgridview?

Changing VALIDATED didn't help snd thre are no @ in my Oracle stored procedure.

I added Debug to my stored procedure:

CREATE OR REPLACE PROCEDURE VALIDATE_PATIENT_NEW
(
VALIDATED OUT int,
LAST_NAME IN VARCHAR2 DEFAULT NULL,
FIRST_NAME IN VARCHAR2 DEFAULT NULL,
DOB date DEFAULT NULL,
PAT_NUMBER OUT int,
FACILITY_KEY OUT CHAR
)
AS
BEGIN
/* SELECT * */
BEGIN

FOR REC IN ( SELECT
FACILITY_KEY,
PAT_NUMBER FROM OGEN.GEN_M_PATIENT_MAST
WHERE UPPER(VALIDATE_PATIENT_NEW.LAST_NAME) = LAST_NAME
AND UPPER(VALIDATE_PATIENT_NEW.FIRST_NAME) = FIRST_NAME
AND VALIDATE_PATIENT_NEW.DOB = BIRTH_DATE
)
LOOP
VALIDATE_PATIENT_NEW.FACILITY_KEY := REC.FACILITY_KEY;
VALIDATE_PATIENT_NEW.PAT_NUMBER := REC.PAT_NUMBER;
END LOOP;
END;
VALIDATED := SQL%ROWCOUNT;
RETURN;
END;

When my program hits the second BEGIN, execution jumps to END; I suspect a logic error since my stored produre compiles with out any errors.