pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sbragion Denis <infotecn@tin.it>
To: David Hartwig <daveh@insightdist.com>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Odbc and Visual Basic
Date: Mon, 27 Apr 1998 18:22:18 +0200
Message-ID: <3.0.5.32.19980427182218.008412d0@MBox.InfoTecna.com> (raw)
In-Reply-To: <354476A4.B6E6D1F9@insightdist.com>
References: <3.0.5.32.19980427102627.008acaa0@MBox.InfoTecna.com>

Hello,

At 08.14 27/04/98 -0400, David Hartwig wrote:
>Here is an excerpt from the soon to be published ODBC FAQ.
>
>How do I get my application to recognize primary keys?
>
>SQLPrimaryKeys() is implemented in the driver.   As of the driver's
release, however,
...

Unfortunately VB 5.0 seems to ignore the SQLPrimaryKey() call and insists
looking for a unique index. It was the first thing I tried when I saw the
announce for the support of that call. I also know that the concept of
Primary Key is different from the concept of Unique Index (though on most
database system, including PostgreSQL, the Primary Key concept is
implemented using unique indexes), and using the SQLPrimaryKey() call would
be The Right Way To Do Things (tm), but as long as Microsoft doesn't
understand it... I don't know what would have happened if the ODBC
interface specification have come from someone else than Microsoft itself... 

Thanks anyway !

	Dr. Sbragion Denis
	InfoTecna
	Tel, Fax: +39 39 2324054
	URL: http://space.tin.it/internet/dsbragio



view thread (8+ messages)  latest in thread

Message-ID: <3.0.5.32.19980427182218.008412d0@MBox.InfoTecna.com>
Permalink:  ../3.0.5.32.19980427182218.008412d0@MBox.InfoTecna.com/
Also on:    postgresql.org/message-id/3.0.5.32.19980427182218.008412d0@MBox.InfoTecna.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: infotecn@tin.it, daveh@insightdist.com
  Subject: Re: [INTERFACES] Odbc and Visual Basic
  In-Reply-To: <3.0.5.32.19980427182218.008412d0@MBox.InfoTecna.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox