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

basic questions with odbc and visual basic.

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: basic questions with odbc and visual basic.
Date: 2004-09-27 18:10:07
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3412A74C2@Herge.rcsinc.local (view raw or flat)
Thread:
Lists: pgsql-odbc
Hello,

I have some basic questions regarding visual basic and odbc.  So far,
I've been having problems getting Visual Basic/Access to write data back
to my database via odbc.  Normally I use Delphi for this type of thing,
but some of our clients are insisting on vb 6.0 access.

The biggest problem I have is that updating data from a VB app always
fails...the problem is that at update time ADO builds a where clause
containing every field in the table, not just the primary key.
Invariably, this causes the update to not to work.  If I have some type
of integer primary key for my table is there some way of forcing the
driver row resolution to write queries in the form of 

update t set [] where f = k?

instead of 

update t set [] where f1 = a, f2 = b, f3 = c [...] for all the fields in
t?


Merlin




Responses

pgsql-odbc by date

Next:From: Merlin MoncureDate: 2004-09-27 18:43:44
Subject: Re: basic questions with odbc and visual basic.
Previous:From: Gary DoadesDate: 2004-09-27 17:26:41
Subject: Re: odbc with PostgreSQL 8.0 & Delphi

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