A field in the table of contents is user input formula, such as: YJL * JZ (freight rate * weight), the formula of the user shall have the right to modify its calculation method, use SQL statements to parameters in the formula of the field (YJL or JZ) assigned to specify variables, and calculation results are obtained,
Ask everybody to help, how to implement with PB or SQL statements.

CodePudding user response:

YJL, you need to let the program know what this thing is, in general use CRT

CodePudding user response:

YJL * JZ into characters, find * on the left and right, respectively to the variable calculation

CodePudding user response:

Thanks to post, but how the parameters in the formula for assignment, what kind of statement, can you again

CodePudding user response:

Dynamic SQL, direct execution "SELECT" + "YJL * JZ" (my guess is that the user should fill in 2.5 * 1.005 only class)
May require the FROM (depending on the different databases)
Let the database do for you