Received: from email04.aon.at (WARSL401PIP7.highway.telekom.at [195.3.96.115]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5PAQUa42330 for ; Mon, 25 Jun 2001 06:26:30 -0400 (EDT) (envelope-from i.hasenoehrl@aon.at) Received: (qmail 293446 invoked from network); 25 Jun 2001 10:26:17 -0000 Received: from n654p020.adsl.highway.telekom.at (HELO irina) ([62.47.25.180]) (envelope-sender ) by qmail4.highway.telekom.at (qmail-ldap-1.03) with SMTP for ; 25 Jun 2001 10:26:17 -0000 Message-ID: <005901c0fd61$51c69e00$01011eac@irina> From: =?iso-8859-1?Q?DI_Hasen=F6hrl?= To: "Richard Huxton" Cc: , References: <003201c0fb35$956d9880$1001a8c0@archonet.com> Subject: Re: [SQL] Difference between insert a tuple in a table by function and by datasheet Date: Mon, 25 Jun 2001 12:26:38 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0056_01C0FD72.14F3E080" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200106/99 X-Sequence-Number: 655 This is a multi-part message in MIME format. ------=_NextPart_000_0056_01C0FD72.14F3E080 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thank you for your information! ----- Original Message -----=20 From: Richard Huxton=20 To: cslucki@cyberworkers.com ; pgsql-sql@postgresql.org=20 Sent: Friday, June 22, 2001 6:08 PM Subject: Re: [SQL] Difference between insert a tuple in a table by functi= on and by datasheet From: "Cyril Slucki" > this is my 2nd attempt to get some links for my problem. > I don't know whether my question is so stupid or difficult or I'm in = the > wrong list. Please let me know. You might try the pgsql-odbc or pgsql-interfaces lists - it's also worth checking the archives for similar issues. I think the reason you've had no success here is we're all waiting for someone with an answer to pipe up. I put it in the pgsql-odbc list too > I have the following situation: ( I use MsAccess97 as frontend, ODBC > 7.1.0003) > I insert tuples in a table with a plpgsql-function, called in a form = via > VBA-code. It works fine, but I can't update these tuples in datasheet view. > ERROR: an other user has changed in the meantime.....but I'm the only. > When I insert tuples via datasheet view, I can update these tuples, b= ut > only these. > > I can't see a difference between the tuples inserted by the function = and > datasheet, but it looks like, that the tuples are *marked*. > > Please, give me some information to solve my problem. Well - I can think out loud FWIW. Access thinks something has changed the values, so there are a couple of things you can try: 1. Are you experiencing any timezone/clock-related problems elsewhere? no 2. If you insert tuples then quit and restart Access can you edit them at that time? no 3. Can you edit all tuples from psql? yes 4. If you write a pass-through query to update tuples does that work? yes 5. If you write a function to update tuples does that work? yes If it's any use here are the ODBC settings I use: Database, Server, User Name, Password - set as required Port: 5432 On the Advanced Options (Driver) dialogue... Disable Genetic Optimiser: Y KSQO: Y Recognize Unique Indexes: Y Use Declare/Fetch: N CommLog: N ReadOnly: N Parse Statements: N Cancel as FreeStmt: N Unknown Sizes: Maximum Text as LongVarChar: Y Unknowns as LongVarChar: N Bools as Char: Y Cache size: 100 Max Varchar: 1024 Max LongVarChar: 8190 Systable prefix: pg_; Connect Settings: (blank) Advanced Options (Postgresql) dialogue Protocol: 7.X,6.4 all other items unticked/blank. I use the same settings Now, I have located the problem, but I can't solve it. In my function, I make the following calculation: ............... update KalkPreislisten_float8 SET kp_ep =3D rkontingent.k_ep::float8= -- this works correct but I have to calculate with a numeric type too (rwaehrung.w_euro is nume= ric(9,5)) .................... update KalkPreislisten_float8 SET kp_ep =3D rkontingent.k_ep::float8 *rw= aehrung.w_euro::float8 -- this doesn't work I discovered, that a calculation float * float causes, that I can't updat= e tuples in datasheet view. float * integer works correct What I'm doing wrong????? Please, let me know, how to realize calculations with type: float * float Thanks in advance Irina ------=_NextPart_000_0056_01C0FD72.14F3E080 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Thank you for your=20 information!
----- Original Message -----
Fro= m:=20 Richard Huxt= on=20
To: cslucki@cyberworkers.com ; pgsql-sql@postgresql.org
Sent: Friday, June 22, 2001 6:08 P= M
Subject: Re: [SQL] Difference betw= een=20 insert a tuple in a table by function and by datasheet

From: "Cyril Slucki" <cslucki@cyberworkers.com>=

>  =20 this is my 2nd attempt to get some links for my problem.
> &nb= sp; I=20 don't know whether my question is so stupid or difficult or I'm in the>=20 wrong list. Please let me know.

You might try the pgsql-odbc or=20 pgsql-interfaces lists - it's also worth
checking the archives for sim= ilar=20 issues. I think the reason you've had no
success here is we're all wai= ting=20 for someone with an answer to pipe up.
I put it in the pgsql-od= bc list=20 too

>   I have the following situation: ( I use MsAcces= s97=20 as frontend, ODBC
> 7.1.0003)
>   I insert tuples i= n a=20 table with a plpgsql-function, called in a form via
> VBA-code. It = works=20 fine, but I can't update these tuples in datasheet
view.
> ERROR= : an=20 other user has changed in the meantime.....but I'm the=20 only.
>   When I insert tuples via datasheet view, I can= =20 update these tuples, but
> only these.
>
>   = I=20 can't see a difference between the tuples inserted by the function and>=20 datasheet, but it looks like, that the tuples are=20 *marked*.
>
>   Please, give me some information to= =20 solve my problem.

Well - I can think out loud FWIW.

Access= =20 thinks something has changed the values, so there are a couple of
thin= gs=20 you can try:

1. Are you experiencing any timezone/clock-related=20 problems elsewhere?
no
2. If you insert tuples then quit= and=20 restart Access can you edit them at
that time?
no
3. Can you edit all tuples from= =20 psql?
yes
4. If you write a pass-through q= uery to=20 update tuples does that work?
yes
5. If you write a function to up= date=20 tuples does that work?
yes

If it's any use here are the= ODBC=20 settings I use:

Database, Server, User Name, Password - set as=20 required
Port: 5432

On the Advanced Options (Driver)=20 dialogue...
Disable Genetic Optimiser: Y
KSQO: Y
Recognize Uniqu= e=20 Indexes: Y
Use Declare/Fetch: N
CommLog: N
ReadOnly: N
Parse= =20 Statements: N
Cancel as FreeStmt: N
Unknown Sizes: Maximum
Text = as=20 LongVarChar: Y
Unknowns as LongVarChar: N
Bools as Char: Y
Cache= =20 size: 100
Max Varchar: 1024
Max LongVarChar: 8190
Systable prefi= x:=20 pg_;
Connect Settings: (blank)

Advanced Options (Postgresql)=20 dialogue
Protocol: 7.X,6.4
all other items unticked/blank.
I use the same=20 settings
 
Now, I have located the = problem,=20 but I can't solve it.
In my function, I make t= he=20 following calculation:
    ...............
    updat= e=20 KalkPreislisten_float8 SET  kp_ep =3D=20 rkontingent.k_ep::float8        -- thi= s=20 works correct
 
but I have to calculate = with a=20 numeric type too (rwaehrung.w_euro is numeric(9,5))
....................
update KalkPreislisten_float8 SET  kp_ep =3D=20 rkontingent.k_ep::float8 *rwaehrung.w_euro::float= 8=20         -- this doesn't=20 work
 
I discovered, that a calculation float= *=20 float causes, that I can't update tuples in datasheet=20 view.
float * integer works=20 correct
 
What I'm doing wrong?????
Please, let me know, how to realize=20 calculations with type: float * float
 
Thanks in advance
Irina

 
------=_NextPart_000_0056_01C0FD72.14F3E080--