When using the Table Configuation wizard in VS2008 and VS2005 Select and Insert commands are created but Update commands are not created. Anyone know if this is a bug or by design?

TIA

 I believe it's by design.  I can't say that I've run across it but I don't use the wizard either.

Thanks for the response Mirheil,

 It appears that the Providers are simply interfaces into ODBC? Not sure but I'm wondering if you can send a short snippet of what one of your Update statements look like...standard SQL update statements don't seem to work. One caveat is that parameters are specified with a '?' symbol rather than the standard '@' symbol. First time working with Pervasive Provider but they seem to have strayed for what has been normal for MSSQL/ORACLE/et. el. databases when it comes to implementing their Provider.

Linton

Okay, after further reading, looks like this could be a bug:

"PsqlCommandBuilder Object: Gets the automatically generated PsqlCommand object required to perform updates on the database when an application calls Update on the PsqlDataAdapter." -- Pervasive ADO.NET provider docs.

Key words are "automatically generated" as I would expect from an ADO.NET Provider. Looks like any communication with support costs $250US. Anyone know if this fee is waived for bugs?

TIA,

Linton

Actually the provider follows the standards for ADO.NET.  PSQL does use the ? instead of @ but it has always done that.

A typical update statement with parametes would be :

UPDATE table SET field = ? WHERE field2 = somevalue

You can open a ticket. It'll cost $250 USD but will be refunded if it's a defect.  

Thanks for you quick response. I've opened a support ticket because I'm still having trouble getting the Insert and Update commands to be generated by the provider when used with the Pervasive Provider: I've tested MSSQL, Oracle, ODBC providers and they work as expected, only the Pervasive provider (when used with the wizard) does not create these...hopefully I will not be charged :-)

 I'll post any information I find out from support here...stay tuned...

Linton

I'm curious.  I'm going to try it too.  What error do you get?  Also, does it happen with all tables?