From: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
To: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>
To: 'pgsql-sql@hub.org' <pgsql-sql@hub.org>
Cc: Delain Huggins <Windows/ADMIN/HugginsD@mpsllc.com>
Subject: why i couldn't insert. . .
Date: Thu, 29 Apr 1999 14:52:40 -0400
Message-ID: <01BE924F.EEFA3800.jt-kirkpatrick@mpsllc.com> (raw)
some of you last week and earlier this week may recall my problem of not
being able to insert into certain postgres tables (connecting through
access97 odbc). plug your ears now. . . -- YIPPIE! it finally works!
thanks for all your help! i thought i'd post this message in case others
would benefit. . .
1) i was using forms that drew info from a query in access97, linked to
postgres tables.
2) i couldn't insert into the recordset!
3) 1st solution, the primary table i was inserting into (the query had a
few tables linked) did NOT have a primary key or otherwise unique index --
access97 must have that to edit or insert into the recordset! i re-made
the table to include a primary key.
4) well, now i could open the table directly in access97 and insert
records, but not through the query! what a pain. . . more brainracking and
postgres mailing list postings. . .
5) ah hah, somehow that stupid paper clip help guy in access97 helped me
(of course at first directed by an honorable member of this mailing list)
find the answer inside access97 help. Even though you don't use the field
in your form, the primary key of the table being inserted into MUST be
present in the underlying query. a simple drag and drop and all things are
sunny (even though it has been raining here in Chattanooga TN usa for days.
. .).
hey, i'd do a better job if they asked me to document this stuff for an
odbc driver manual, but in the meantime, i hope this will help others as
many more have helped me!
jt kirkpatrick
(look herouth, no null character! -- i just turned off WORD as my email
editor. ah but soon i'll be solely in kde on linux. . .)
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: jt-kirkpatrick@mpsllc.com, pgsql-interfaces@hub.org, pgsql-sql@hub.org, Windows/ADMIN/HugginsD@mpsllc.com
Subject: Re: why i couldn't insert. . .
In-Reply-To: <01BE924F.EEFA3800.jt-kirkpatrick@mpsllc.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