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

Re: basic questions with odbc and visual basic.

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: basic questions with odbc and visual basic.
Date: 2004-09-28 15:26:46
Message-ID: 20040928152646.39966.qmail@web20824.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Do you have driver option "Row Versioning" set to
true?  I'm vague on the details, but I suspect that
may help.

--- Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>
wrote:

> > For manipulating the data -- Access works pretty
> good as long as
> Access
> > can know which record(s) to update (primary keys
> or OIDs -- that sort
> of
> > thing).
>  
> 
> Looking deeper it seems all my problems are really
> boiling down to one
> problem: the where clause used to update the edited
> record back to the
> server.  Both access and vb generate a where clause
> that includes every
> field in the table instead of the p-key.  For
> various sundry reasons
> such as improper handling of null values, etc. this
> where clause gets
> busted.  This problem is aggravated by the fact that
> all my domains get
> treated as text types, although this is correctable
> by using a view
> which I was planning to use anyways (aside: I make
> heavy use of
> domains).  This busted where clause trips up vb and
> access in different
> ways.  This may be a case where I may want to
> explore hacking the odbc
> driver to get it to do what I want, depending on who
> is building the
> clause.  My guess is the ado driver is building it
> so I'm basically
> hosed.  It's really queer to me that they use the
> p-key to pull the data
> out and the entire record to write the data
> back...what's the point of
> the p-key anyways?
> 
> The odbc driver is supposed to have a property
> exposed to the ado
> wrapper that allows you to constrain the write-back
> where clause to
> different things, but apparently this does not work
> in pgsql-odbc.  
> 
> I tried the ole db driver and got nowhere, couldn't
> even get a basic
> connection.  Hopefully I can get this corrected and
> work with this
> driver a little bit.  I have about two weeks to
> figure out the best way
> to proceed.  So far, I'm really unimpressed with the
> ado architecture,
> this being my first real experience with it (as
> compared to ado.net,
> which is a dream to work with).
> 
> Merlin
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map
> settings
> 



		
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail

In response to

pgsql-odbc by date

Next:From: Merlin MoncureDate: 2004-09-28 16:06:17
Subject: Re: basic questions with odbc and visual basic.
Previous:From: Merlin MoncureDate: 2004-09-28 14:41:31
Subject: Re: basic questions with odbc and visual basic.

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