The PB stops executing the next statement, and the update statement in the PB is displayed

In PB functions or events, SQL statements can be executed; The variables used in SQL statements should be colonized': 'The statement must use a semicolon'; 'The end. To execute a select statement with a return value, it is necessary to have an into statement and define a variable that receives the value, for example:

select userno,username into :ls_userno,:ls_username from t_user where userno='testuser';The syntax of the update and delete statements is the same as that of the SQL syntax, and the transaction needs to be committed after the execution

update employee set emp_name = :ls_namewhere = :emp_num using sqlca;if > 0 then commit using sqlca ;end if-elete from employee where = :

li_num ;

Do you want to track debugging, or do you want to ** function statements or the like, to put it bluntly, otherwise it won't help you, friend.

Pa and pb are both references, which are aliases for a variable that are of the same type as that variable and can be simply regarded as the same variable.

Just tested your ** above, please add:

prepare sqlsa from 'insert into information values (:split_arry[1],:split_arry[2],:

split_arry[3])';

execute sqlsa using :split_arry[1],:split_arry[2],:split_arry[3];

Changed to prepare sqlsa from'insert into information values (?';

execute sqlsa using : split_arry[1],:split_arry[2],:split_arry[3];

Perform a pass under PB9.

Here's the problem: insert into information (name, gender, ID number) values ('+string+'('+split_arry[1]+'),'+string+'('+split_arry[2]+'),'+int+'('+split_arry[3]+'))

It should be revised.

insert into information (name, gender, ID number) values ('+split_arry[1]+','+split_arry[2]+','+split_arry[3]+')

In the third one there is a 'wrong' sign,'。

Do you want to check it:

prepare sqlsa from 'insert into information values ('1','2','3')';

You first use a fixed variable to test it, if it is correct, it means that the problem is in these variables, if it is not correct, it is the problem of **.

messagebox("SQL statements",sqlsyntax)

Note: If the binding parameter of the Wangli database connection is set to enable, the display is incomplete. You can check the "Disable Bind" option on the Transactions tab.

But when the sleepy waiter searches for your update, it will show SQL statements and talk about it!

sqlcode is 0

If it's 0, I don't understand the following question too much.

Do you want to run the update modification statement in the table when the where condition is not met?

If sqlcode is equal to 0, the execution is successful.

In this case, you return 100, which means that there is no response line, that is, the where condition is not valid.

Another -1 indicates an update error.

There is also a parameter sqlnrows, which indicates the number of rows in the response. If it is equal to 0, there is also no response line.

dw_"jn2"DW 1 is a data window control that is placed on a window to display data, and JN2 is a data window, usually querying data from a database through SQL statements or stored procedures.

DW SQLCA is a transaction object, usually initialized at the beginning of the program, and is used to connect to the database, which means that the data is queried from the database to which SQLCA is connected.

dw_""This sentence clears the filter condition, that is, all the data queried out of the data window is displayed.

dw_"Device serial number ='"+sle_"'"), which sets the filter condition, that is, only the data that matches the filter condition is displayed in the query results.

The dw sentence is to let the data window go to the database to perform data retrieval.

The query looks right, but the filtering looks problematic after the query retrieve() ends.

filter() should be executed.

dw_"Device serial number ='"+sle_"'")dw_ )

But you're not right, isn't it?

This is filtered**, and the query (fuzzy query) is as follows:

string s

if sle_'' then

messagebox("Tips","Please enter what you are looking for")else

s=sle The content entered in the query box is assigned to s

dw_" like'%"+s+"%'") refers to the code of the content you are looking for, such as name, and then the s after it is what you entered in the query box.

dw to focus.

dw to connect to your database.

dw_end if

Device serial number ='"+sle_"'"The plus and quotation mark question of this sentence:

The part in the middle of and + is a character-type variable, so the filtered PB syntax stipulates that it is represented by two + good in quotation marks, which can actually be like this:'%"+sle_"%'

It's just a matter of its grammar, and it's only possible to explain what to say and how not to do.