syntax errors

aylin_sk

When I execute this script, I got 2 errors at end of the script "myConnection" like: - ; expected - Invalid expression term ')' Please help me correcting these syntax errors.. String insertCmd = "insert into PATIENTS (PATIENT_NUMBER, PATIENT_NAME, PATIENT_LASTNAME, PATIENT_SEX, PATIENT_TREATSTARTDATE)" + " values(:p_patient_number, :p_patient_name, :p_patient_lastname, :p_patient_sex, :p_patient_treatstartdate)", myConnection);

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

aylin_sk22y ago
Ok thanks..It worked already...
alijabari22y ago
first of all when you insert string or date values they must be placed inside qutation marks (' '). for example: string cmd = " insert into test(id,name) values(" + variable_id +",'" + variable_name +"')"; the variable that contains the id must be inside single quats like: " ' " + variable_id + " ' " the second thing is that you should but the variables out side the string not inside it as you did. see the example i provided. the last thing, i didn't understand what is ( ", myConnection); ) there is no open bracket for this one.