Deriving parameters for stored proc not supported

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Posts: 165
Joined: Thu 03 Jul 2008 23:55

Deriving parameters for stored proc not supported

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?

Devart Team
Posts: 8033
Joined: Thu 14 Aug 2008 12:44

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.

Post Reply