Обсуждение: 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.hasenoehrl@aon.at
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.hasenoehrl@aon.at] > Sent: Thursday, June 21, 2001 10:00 AM > To: pgsql-odbc@postgresql.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.hasenoehrl@aon.at <mailto:i.hasenoehrl@aon.at>
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.hasenoehrl@aon.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@westcountrypublications.co.uk>
> To: 'DI Hasenöhrl' <mailto:i.hasenoehrl@aon.at> ;
> pgsql-odbc@postgresql.org <mailto:pgsql-odbc@postgresql.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.hasenoehrl@aon.at
> <mailto:SMTP:i.hasenoehrl@aon.at>]
> > Sent: Thursday, June 21, 2001 10:00 AM
> > To: pgsql-odbc@postgresql.org <mailto:pgsql-odbc@postgresql.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.hasenoehrl@aon.at <mailto:i.hasenoehrl@aon.at> <
> <mailto:i.hasenoehrl@aon.at>>
>
>
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.hasenoehrl@aon.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@westcountrypublications.co.uk> > To: 'DI Hasenöhrl' <mailto:i.hasenoehrl@aon.at> > Cc: 'pgsql-odbc@postgresql.org' <mailto:'pgsql-odbc@postgresql.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.hasenoehrl@aon.at > <mailto:SMTP:i.hasenoehrl@aon.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@westcountrypublications.co.uk>> > > To: 'DI Hasenöhrl' < <mailto:i.hasenoehrl@aon.at>> ; > > pgsql-odbc@postgresql.org <mailto:pgsql-odbc@postgresql.org> < > <mailto:pgsql-odbc@postgresql.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.hasenoehrl@aon.at > <mailto:SMTP:i.hasenoehrl@aon.at> > > < <mailto:SMTP:i.hasenoehrl@aon.at>>] > > > Sent: Thursday, June 21, 2001 10:00 AM > > > To: pgsql-odbc@postgresql.org <mailto:pgsql-odbc@postgresql.org> > < <mailto:pgsql-odbc@postgresql.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.hasenoehrl@aon.at <mailto:i.hasenoehrl@aon.at> < > <mailto:i.hasenoehrl@aon.at>> < > > < <mailto:i.hasenoehrl@aon.at>>> > > > > > >