I need to & lt; 00 the FROM TB @ company & gt; The choice of parameter setting company here, because there is a formal company & lt; TB0100 & gt; A company is to test & lt; TB0200 & gt; , can choose 01 and 02 first when querying data query data once, but I now written as wrong, also tried & lt; TB '00' @ company & gt; Or & lt; TB '+ + @ company' 00 & gt; Also prompt error, strives for the great god solution,

The SELECT TABE01, TABE02 FROM TB @ company 00

CodePudding user response:

Are you used in the SQL or PB code in use, all make it dynamic execution string SQL statements to go,

CodePudding user response:

The SET @ MY_SQL='SELECT TABE01, TABE02 FROM TB' + + '00' @ company
Execute (@ MY_SQL)
If (@ @ Error & lt;> 0) goto one rror

CodePudding user response:

Hello, I tried failed