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]
> 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>
> 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>]
> > Sent: Thursday, June 21, 2001 10:00 AM
> > To: 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>>
>
>