Skip site navigation (1) Skip section navigation (2)

RE: Difference between insert by a function and per hand

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: 'DI Hasenöhrl' <i(dot)hasenoehrl(at)aon(dot)at>
Cc: "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: RE: Difference between insert by a function and per hand
Date: 2001-06-22 09:31:44
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F745F9@MAIL_EXCHANGE (view raw or flat)
Thread:
Lists: pgsql-odbc
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>>>
> 	> 
> 	> 
> 	
> 

pgsql-odbc by date

Next:From: Henshall, Stuart - WCPDate: 2001-06-22 10:12:10
Subject: RE: RE: Difference between insert by a function and per hand
Previous:From: Henshall, Stuart - WCPDate: 2001-06-22 08:58:16
Subject: RE: Difference between insert by a function and per hand

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group