Updating a ADO RecordSet with INNER JOIN...

From: "Thomas LeBlanc" <thomasatiem(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Updating a ADO RecordSet with INNER JOIN...
Date: 2004-05-11 22:36:16
Message-ID: BAY17-F27SkkE7jndRG0003917b@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-odbc

We can not update fields in an ADO recordset using the PostgreSQL ODBC
driver in Visual Basic 6.0.

The same code works against Access and SQL Server. We are INNER JOIN ing 3
tables. We are able to update a single table ADO recordset without a
problem.

Are there any ODBC driver switches that might turn on/off being able to
update a multi table join?

The error message says:
Provider does not support the property.

Thanks,
Thomas

_________________________________________________________________
Best Restaurant Giveaway Ever! Vote for your favorites for a chance to win
$1 million! http://local.msn.com/special/giveaway.asp

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2004-05-11 22:47:23 Re: Shared memory segment error
Previous Message Alexander Cohen 2004-05-11 22:34:38 Shared memory segment error

Browse pgsql-odbc by date

  From Date Subject
Next Message Peter Eisentraut 2004-05-11 23:31:37 Re: Fwd: Bug#247306: odbc-postgresql: SIGSEGV with long inputs (> 10000 bytes)
Previous Message Jeff Eckermann 2004-05-11 13:54:45 Re: where can i find documentation of odbc api