RE: Difference between insert by a function and per hand

Maybe a difference in the versions I'm using. Postgresql 7.1.2, ODBC
7.01.0005 (get at http://odbc.postgresql.org ) and MS Access 2K. If you can
I'd advise upgrading the postgresql parts of the setup. The only other thing
I can think of is Access getting confused about Primary Keys or similar. Do
you have single field primary keys?
- Stuart

> -----Original Message-----
> From: DI Hasenöhrl [SMTP:i(dot)hasenoehrl(at)aon(dot)at]
> Sent: Friday, June 22, 2001 10:17 AM
> To: Henshall, Stuart - WCP
> Subject: Re: Difference between insert by a function and per hand
>
> Hello Stuart,
> I see the data, but I can't update the tuples inserted by the function I
> can update only these tuples, which I inserted in datasheet view.
> My ODBC settings are:
> Driver:
> Disable Generic Optimizer: yes
> KSQO: yes
> Recognize Unique Indexes: yes
> all others: no
> Data Source:
> all: no
> Protocol: 7.X
>
> After enabling Row Versioning and relink, I can't see my data in datasheet
> view, each field contains #name?
> What' this?????
>
> Irina
>
> ----- Original Message -----
> From: Henshall, Stuart - WCP
> <mailto:SHenshall(at)westcountrypublications(dot)co(dot)uk>
> To: 'DI Hasenöhrl' <mailto:i(dot)hasenoehrl(at)aon(dot)at>
> Cc: 'pgsql-odbc(at)postgresql(dot)org' <mailto:'pgsql-odbc(at)postgresql(dot)org'>
>
> Sent: Friday, June 22, 2001 10:58 AM
> Subject: RE: Difference between insert by a function and per hand
>
> Hello Irina,
> I seem to be able to edit when viewing in datasheet. Are you able to
> see the data?(I was after shift+F9 to refresh the data). I have Row
> Versioning enabled and find that tends to help Access handle things.
> Also
> I'm using Access 2K which may not be identical. If you add row
> versioning
> you'll need to relink you're tables to get the xmin field. What are
> your
> ODBC settings?
> - Stuart
>
> > -----Original Message-----
> > From: DI Hasenöhrl [ SMTP:i(dot)hasenoehrl(at)aon(dot)at
> <mailto:SMTP:i(dot)hasenoehrl(at)aon(dot)at>]
> > Sent: Friday, June 22, 2001 9:37 AM
> > To: Henshall, Stuart - WCP
> > Subject: Re: Difference between insert by a function and per hand
> >
> > Hello Stuart,
> >
> > I access these rows in the tables datasheet view, because at this
> time I
> > make experiments but it should work.
> >
> > I think, that the tuples of the table are *marked* in a certain
> kind,
> > because tuples I inserted via datasheet I can update and tuples
> inserted
> > by function I can't update via datasheet, but I don't see a
> difference.
> >
> > Hope you can bring me on the right way ;-)
> >
> > Thanks
> > Irina
> >
> > ----- Original Message -----
> > From: Henshall, Stuart - WCP
> > < <mailto:SHenshall(at)westcountrypublications(dot)co(dot)uk>>
> > To: 'DI Hasenöhrl' < <mailto:i(dot)hasenoehrl(at)aon(dot)at>> ;
> > pgsql-odbc(at)postgresql(dot)org <mailto:pgsql-odbc(at)postgresql(dot)org> <
> <mailto:pgsql-odbc(at)postgresql(dot)org>>
> > Sent: Friday, June 22, 2001 10:10 AM
> > Subject: RE: Difference between insert by a function and per hand
> >
> > How are you trying to access these rows? If its via a form or
> > recordset it
> > may be necessary to requery.
> > - Stuart
> >
> > > -----Original Message-----
> > > From: DI Hasenöhrl [ SMTP:i(dot)hasenoehrl(at)aon(dot)at
> <mailto:SMTP:i(dot)hasenoehrl(at)aon(dot)at>
> > < <mailto:SMTP:i(dot)hasenoehrl(at)aon(dot)at>>]
> > > Sent: Thursday, June 21, 2001 10:00 AM
> > > To: pgsql-odbc(at)postgresql(dot)org <mailto:pgsql-odbc(at)postgresql(dot)org>
> < <mailto:pgsql-odbc(at)postgresql(dot)org>>
> > > Subject: Difference between insert by a function and per hand
> > >
> > > Hello all,
> > >
> > > I use postgresql 7.0.2 as backend, ODBC Driver 7.1.003 and
> > MsAccess97 as
> > > frontend.
> > > Now I have the following Problem and hope, someone can help me.
> > >
> > > I developed a function in plpgsql, which inserts rows in a table
> > *price*.
> > > This function is called from VBA-Code and everything seemed to
> be
> > OK, but
> > > then I realized, that I can't change these rows inserted by the
> > function.
> > > When I put in rows by the normal way as linked table, I can
> change
> > these
> > > rows. Where is the difference to insert rows by a function or
> per
> > hand.
> > >
> > > Has anyone an idea, please let me know.
> > >
> > > Thanks in advance
> > > Irina
> > >
> > > E-Mail: i(dot)hasenoehrl(at)aon(dot)at <mailto:i(dot)hasenoehrl(at)aon(dot)at> <
> <mailto:i(dot)hasenoehrl(at)aon(dot)at>> <
> > < <mailto:i(dot)hasenoehrl(at)aon(dot)at>>>
> >
> >
>
>