Hi,
How can I use parameters in an SQL Server prepared statement?
I tried
Database.Connection conn = Database.Connection("BOPSO");
Database.PreparedStatement stmt = conn.prepareStatement("SELECT * FROM MyTable WHERE Id = @Id");
stmt.bindParam("Id", 1, Database.DataType.Int);
but that gives me "FlexScript exception: Bind variable/parameter 'Id' not found". When I replace @Id by :Id I get "FlexScript exception: API client not set" instead.
I figured it out myself shortly after posting this. The message
FlexScript exception: API client not set
means that the connection to the database is closed, I forgot to conn.connect();
The parameters should be specified with a colon, so not @Id but :Id
6 People are following this question.
© 1993- FlexSim Software Products, Inc. All Rights Reserved.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
