Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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


pgsql-odbc by date

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

pgsql-general by date

Next:From: Joshua D. DrakeDate: 2004-05-11 22:47:23
Subject: Re: Shared memory segment error
Previous:From: Alexander CohenDate: 2004-05-11 22:34:38
Subject: Shared memory segment error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group