From: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
To: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>
Cc: Delain Huggins <Windows/ADMIN/HugginsD@mpsllc.com>
Subject: win98 odbc problem?
Date: Fri, 23 Apr 1999 15:37:07 -0400
Message-ID: <01BE8D9F.28F1BC00.jt-kirkpatrick@mpsllc.com> (raw)
I have two databases, oidetail and dispnotes:
Create table oidetail (
Autoinv int4 not null,
Partnum char(6) not null check (partnum<>' '),
Ounitprc float4 default 0,
Ounitcost float4 default 0,
Ordqty int2 default 1,
Taxrate float4 default 0,
Vnum int4,
Reqdt date,
Orddt date,
Oqnum varchar(20),
Shipdt date,
About varchar(30),
Potcorechg int2,
Oldrtrn bool default 1,
Oldrtrndt date
Constraint ssmsoidetail foreign key (autoinv) references ssms);
6,561,792 bytes and 75,362 rows.
Create table dispnotes (
Autoinv int4 not null,
Dispnote varchar(255),
Dttm datetime not null default text 'now',
Noteby char(8) not null default 'current_user'
Constraint dispnotespk primary key (autoinv, dttm),
Constraint ssmsdispnotes foreign key (autoinv) references ssms);
23,347,200 bytes and 96,601 rows => A MUCH LARGER TABLE!!!
I have connected each table via a form to a main form in access97 using the
postgres odbc driver. You access the sub-forms using buttons on the main
one, linking by autoinv. In each sub-form I need to add records, using the
same autoinv. Taking the larger table through its form, it works great, no
problems. Just opening the form not only shows me all records but also
gives me a blank record at the end to type into. But I am having problems
with the smaller table! I have re-created its form by MAKING A COPY OF THE
LARGER ONE THAT WORKS, and then changing its record source and fields -
leaving all the form properties the exact same. This form for the smaller
table will not let me add records! It presents existing records just fine,
but it doesn't present me with a blank row like the other form. Because I
have made a copy of the working form, and left its settings the same, I am
assuming it is not an access97 problem, but maybe an odbc or postgres
issue. Another point, in the form for the smaller table, it won't let me
edit records either, no matter that I have set the "allow edits" property
to yes. It returns a message (not an error message from postgres, but a
"ding" with a message in the status bar) saying that this recordset is not
editable.
Have any thoughts??
Thanks. JT
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, Windows/ADMIN/HugginsD@mpsllc.com
Subject: Re: win98 odbc problem?
In-Reply-To: <01BE8D9F.28F1BC00.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