Submit your data to the server, in PB insert into table (rcpt_no, patient_id) values (ls_no, : ls_id) using the sqlca. Always prompt insert NULL, in fact, ls_no ls_id can output value; And if the sqlca. Sqlcode<> 0 indicates the database connection is not successful?

CodePudding user response:

Insert into table (rcpt_no, patient_id) values (ls_no, : ls_id) using the sqlca.

Grammar that's right.
Must be ls_no, ls_id has a problem. Or type does not match.

If the sqlca. Sqlcode & lt;> 0 then
Messagebox (" prompted!" , "insert failed!" )
Return
End

The sqlca. Sqlcode & lt;> 0 indicates the SQL statement execution is not successful.

CodePudding user response:

Insert into table (rcpt_no, patient_id) values (ls_no, : ls_id) using the sqlca.

-- -- --

Does this sentence right
1, you first test ls_no ls_id whether does have value, using messagebox (', ') returns a see will know that
2, the sqlca sqlcode & lt;> 0
SQL statement execution is not successful.
Add the following statement test why wrong
Insert into table (rcpt_no, patient_id) values (ls_no, : ls_id) using the sqlca.
IF the SQLCA. SQLCode=1 THEN

MessageBox (" SQL error ", the SQLCA SQLErrText)

END the IF
3, the enclosed SQLCODE error description
The Value a fancy
0 Success
100 Fetched row not found
- 1 Error; The statement failed. Use SQLErrText or SQLDBCode to obtain the detail.

CodePudding user response:

 insert into table (rcpt_no, patient_id) values (ls_no, : ls_id) using the sqlca. 

-- -- -- 

Does this sentence right 
1, you first test ls_no ls_id whether does have value, using messagebox (', ') returns a see will know that 
2, the sqlca sqlcode & lt;> 0 
SQL statement execution is not successful. 
Add the following statement test why wrong 
Insert into table (rcpt_no, patient_id) values (ls_no, : ls_id) using the sqlca. 
IF the SQLCA. SQLCode=1 THEN 

MessageBox (" SQL error ", the SQLCA SQLErrText) 

END the IF 
3, the enclosed SQLCODE error description 
The Value a fancy 
0 Success 
100 Fetched row not found 
- 1 Error; The statement failed. Use SQLErrText or SQLDBCode to obtain the detail. 

CodePudding user response:

If you have a table named table then I suggest you change a,

CodePudding user response:

Ha ha, support the LS
Before you insert into messagebox value, have the values quoted the SQL text

CodePudding user response:

Why don't knot posted in time

CodePudding user response:

Just want to ask for, do not want to pay!