Passing parameters
Passing parameters
I need open report from .net passing Sql query and value parameters. I'm working with SQLite database.
report.Load("C:\\temp\\FastReport\\Clientes.frx");
// do it after loading the report, before running it find the table by its alias
TableDataSource table = report.GetDataSource("EPALI_CLIENTE") as TableDataSource;
report.SetParameterValue("parNombre", "MARSHALLS");
table.SelectCommand = "SELECT CLTE_CLIENTE, CLTE_NOMBRE FROM EPALI_CLIENTE WHERE CLTE_NOMBRE = :parNombre ";
report.Show();
When execute report.Show return SQLiteException:
Insufficient parameters supplied to the command
What is the problem?? Is it necessary to create the parameter in the report?
Thank you
I need open report from .net passing Sql query and value parameters. I'm working with SQLite database.
report.Load("C:\\temp\\FastReport\\Clientes.frx");
// do it after loading the report, before running it find the table by its alias
TableDataSource table = report.GetDataSource("EPALI_CLIENTE") as TableDataSource;
report.SetParameterValue("parNombre", "MARSHALLS");
table.SelectCommand = "SELECT CLTE_CLIENTE, CLTE_NOMBRE FROM EPALI_CLIENTE WHERE CLTE_NOMBRE = :parNombre ";
report.Show();
When execute report.Show return SQLiteException:
Insufficient parameters supplied to the command
What is the problem?? Is it necessary to create the parameter in the report?
Thank you