Embedded SQLs – PB Docs 2022

When you build and deploy a PowerServer project, the embedded
SQL statements will be placed into the CS file under the PowerServer
C# solution > “AppModels” project > [appname] > “ESql” folder
according to their types, for example, Delete, Insert, Select,
SelectBlob, Update, UpdateBlob etc.

The statement will be kept exactly the same as before in the CS
file; and each statement will be assigned with a variable name, for
example, sqlHandle_01_E7015B54 in the example below.

At runtime, the variable name, sqlHandle_01_E7015B54, will be
sent from the client to PowerServer, then the corresponding statement
will be executed at the server and the execution result will be
returned to the client.

If there is no sqlHandle_01_E7015B54 in the C# solution, you may
see this error. You will have to full build and redeploy the
PowerServer project to resolve this error.