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.
public static string sqlHandle_01_E7015B54 = "DELETE FROM Sales.Customer WHERE PersonID =? ";
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.
