Delphi / Object Pascal · Database exception

dbExpress ParameterNotSet Error

What does dbExpress ParameterNotSet Error mean in Delphi / Object Pascal?

Returned when a TDBXCommand is executed but one or more of its parameters haven't had a value assigned before execution.

dbExpress ParameterNotSet ErrorDelphi (VCL) · Delphi (FireMonkey) · Delphi (dbExpress)

Condition

Returned when a TDBXCommand is executed but one or more of its parameters haven't had a value assigned before execution.

Fix

Set every parameter the prepared command declares before calling Execute, checking for parameters added by the SQL text that the code building the parameter list didn't account for, particularly after a query or stored procedure signature changes.

Related database exception