Always hold the following statement:
String cuno
The select Max (customer acc_no) into: cuno from customer;
If isnull (cuno) or len (cuno)=0 then
Sle_1. Text='CM000001'
The else
='CM' sle_1. Text + string (long (right (string (long (cuno, 5) (right) + 1 + 100000), 5)), '00000')
End the if
PB is the following problems

CodePudding user response:

The select Max (customer acc_no) from the customer
The statements in the database, run it and see how long it takes

CodePudding user response:

PB9, SQL Server2012, test your code, no problem, you can perform,

CodePudding user response:

In addition, about the link database code to test, please don't direct execution, needs to be compiled into a program, testing of the program, sometimes links database code, run directly, is easy to report errors,