Deriving parameters for stored proc not supported

JORGEMAL · Post by **JORGEMAL** » Fri 05 Sep 2008 23:07

I just purchased PostgreSQLDirect.NET and tried it with a FormView in Visual Studio 2005.
* I run the wizard to choose a datasource and select New Data Source
* I click on the pgDatabase icon to select a PostgreSQL database and press the OK button
* I select my data connection and click Next
* In the Configure the Select Statement window I choose some fields and click on the advanced button to generate Insert, Update and Delete statements.
* I test the query and it displays the correct data.
* At the end of the Wizard the following error message is displayed:

"Deriving parameters for stored procedures is not supported with the Corelab,PostgreSQL provider."

What is this message about?
Does it have to do with the SQL commands automatically generated for Insert, Update and Delete?

Shalex · Post by **Shalex** » Mon 08 Sep 2008 10:18

We have reproduced this problem. We recommend you to use the workaround: to create PgSqlDataSource separately (not by Data Source Configuration Wizard in the FormView component) and then add it to FormView Data Source. In this case automatic generation for Insert, Update and Delete commands works fine.