Kbase P109012: The .NET OdbcCommandBuilder class does not generate the correct INSERT, DELETE and UPDATE statements
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/05/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.0x
OpenEdge 10.1x
MERANT 3.60 32-BIT Progress SQL-92
DataDirect 4.1 32-Bit Progress SQL92 9.1D
DataDirect 4.10 32-Bit Progress SQL92 9.1E
DataDirect 4.20 32-Bit OpenEdge SQL92 10.0B
Progress OpenEdge 10.1B driver
SYMPTOM(s):
The .NET OdbcCommandBuilder class does not generate the correct INSERT, DELETE and UPDATE statements
The OdbcCommandBuilder's generated statements only include columns that are part of a unique index
Using the ODBC.NET data provider
Using C#.NET 2003
Using C#.NET 2005
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
Use the OdbcCommand class instead to define the correct INSERT, DELETE and UPDATE statements.