In PB8, database is SQL Server 2000, call a stored procedure code:
DECLARE update_data6 PROCEDURE FOR
Insert_voucheritem @ summary2=: ll_summary2, @ account=: ll_account
Using the SQLCA.
The EXECUTE update_data6;
Messagebox (" 6 ", string (sqlca. Sqlerrtext))
IF the SQLCA. SQLCode=1 THEN
MessageBox (" prompt ", "cannot be stored procedure execution server insert_voucheritem set up accounting vouchers, please try again later." )
Return
END the IF
The CLOSE update_data6;
Of these two parameters are of type string, when assignment for similar 'abcdefgdddd' character run normally, but the assignment for similar 'to the opposition character will not be able to run normally, through a messagebox (" 6 ", string (sqlca. Sqlerrtext))
Capture the message is: the SQLSTATE=37000 string 'on the opposition before has not closed quotes. Strangely, the assignment of two Chinese characters and the normal operation, do not know what reason be? Please help to see.

CodePudding user response:

Whether know or don't understand, trouble you analysis analysis, thank you!

CodePudding user response:

Try it in the query analyzer

CodePudding user response:

What is your stored procedure code?

CodePudding user response:

Store the code of process:
CREATE PROCEDURE insert_voucheritem @ summary2 varchar (30), @ account char (13) AS


- use transaction control data update
The BEGIN TRANSACTION
.

If @ @ error<> 0
The rollback transaction
Commit the transaction
The select 0
GO

CodePudding user response:

Perform no problem in the query analyzer