problem with 'lookup on' and writing to a SQLserver table
brian_matthewsbrian matthews
brian_matthews_bmw@hotmail.com
Fri, 23 Apr 2004 13:01:56 +0000
This is a multi-part message in MIME format.
------=_NextPart_000_6bf0_6317_212
Content-Type: text/plain; format=flowed
no - I hav'nt given up guys - just taking it all in. We have another team
looking at Oracle, and we like the single TX method here - can you blame us
?
can't thank you all enough !
>From: "Joe Boyle" <joeboyle_adt@hotmail.com>
>To: shediac92@hotmail.com, powerh-l@lists.sowder.com
>Subject: RE: problem with 'lookup on' and writing to a SQLserver table
>Date: Fri, 23 Apr 2004 13:16:56 +0100
>
_________________________________________________________________
Find a cheaper internet access deal - choose one to suit you.
http://www.msn.co.uk/internetaccess
------=_NextPart_000_6bf0_6317_212
Content-Type: message/rfc822
X-Message-Info: yilqo4+6kc6lb8pCaxjgPm5MjxQl90sN
Received: from sowder.com ([69.93.28.243]) by mc4-f25.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824);
Fri, 23 Apr 2004 05:23:07 -0700
Received: from sowder.com (localhost [127.0.0.1])
by sowder.com (8.12.3/8.12.3/Debian-6.6) with ESMTP id i3NCMuv3021761;
Fri, 23 Apr 2004 07:22:57 -0500
Received: from hotmail.com (bay13-f9.bay13.hotmail.com [64.4.31.9])
by sowder.com (8.12.3/8.12.3/Debian-6.6) with ESMTP id i3NCHAv3021490
for <powerh-l@lists.sowder.com>; Fri, 23 Apr 2004 07:17:12 -0500
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
Fri, 23 Apr 2004 05:16:57 -0700
Received: from 212.85.12.211 by by13fd.bay13.hotmail.msn.com with HTTP;
Fri, 23 Apr 2004 12:16:56 GMT
X-Originating-IP: [212.85.12.211]
X-Originating-Email: [joeboyle_adt@hotmail.com]
X-Sender: joeboyle_adt@hotmail.com
From: "Joe Boyle" <joeboyle_adt@hotmail.com>
To: shediac92@hotmail.com, powerh-l@lists.sowder.com
Subject: RE: problem with 'lookup on' and writing to a SQLserver table
Mime-Version: 1.0
Content-Type: text/html
Message-ID: <BAY13-F9xAEVJsZwpnP000077df@hotmail.com>
X-OriginalArrivalTime: 23 Apr 2004 12:16:57.0077 (UTC) FILETIME=[DF0E4250:01C4292C]
Sender: powerh-l-admin@lists.sowder.com
Errors-To: powerh-l-admin@lists.sowder.com
X-BeenThere: powerh-l@lists.sowder.com
X-Mailman-Version: 2.0.11
Precedence: bulk
List-Help: <mailto:powerh-l-request@lists.sowder.com?subject=help>
List-Post: <mailto:powerh-l@lists.sowder.com>
List-Subscribe: <http://lists.sowder.com/mailman/listinfo/powerh-l>,
<mailto:powerh-l-request@lists.sowder.com?subject=subscribe>
List-Id: Cognos PowerHouse 4GL <powerh-l.lists.sowder.com>
List-Unsubscribe: <http://lists.sowder.com/mailman/listinfo/powerh-l>,
<mailto:powerh-l-request@lists.sowder.com?subject=unsubscribe>
List-Archive: <http://lists.sowder.com/pipermail/powerh-l/>
Date: Fri, 23 Apr 2004 13:16:56 +0100
Return-Path: powerh-l-admin@lists.sowder.com
<html><div style='background-color:'><DIV class=RTE>
<P>why not set a flag in the field process proc which conditionally decides if the row is written in the preupdte or postupdate proc; this way you don't need a backout proc, and the update TX gets rolled back as a unit if there is a problem - you still need the autocommit with the 'lookup on' - and the designer TX mentioned in an earlier email should have been a 'read write' TX.</P>
<P>P.S. I suspect Brian might have given up ?<BR><BR><BR></P></DIV>
<DIV></DIV>>From: "Peter Bateman" <shediac92@hotmail.com>
<DIV></DIV>>To: powerh-l@lists.sowder.com
<DIV></DIV>>Subject: RE: problem with 'lookup on' and writing to a SQLserver table
<DIV></DIV>>Date: Thu, 22 Apr 2004 12:24:37 -0300
<DIV></DIV>>
<DIV></DIV>>Good point Gavin. I have done something similiar to what Brian is
<DIV></DIV>>doing.
<DIV></DIV>>I was reserving products from inventory for an order that I was
<DIV></DIV>>building. and yes
<DIV></DIV>>I had to put in code to backout if the order was modified or
<DIV></DIV>>cancelled.
<DIV></DIV>>Regards,
<DIV></DIV>>Peter
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>>From: "Lloyd, Gavin" <gavin.lloyd@fmglobal.com>
<DIV></DIV>>>To: "brian_matthewsbrian matthews"
<DIV></DIV>>><brian_matthews_bmw@hotmail.com>, <powerh-l@lists.sowder.com>
<DIV></DIV>>>Subject: RE: problem with 'lookup on' and writing to a SQLserver
<DIV></DIV>>>table
<DIV></DIV>>>Date: Wed, 21 Apr 2004 12:57:38 +0100
<DIV></DIV>>>
<DIV></DIV>>>The autocommit would release the lock but what worries me is doing
<DIV></DIV>>>the
<DIV></DIV>>>write in the process procedure. If you are updating a record based
<DIV></DIV>>>on
<DIV></DIV>>>the logic in the screen then you cannot guarantee the update will
<DIV></DIV>>>be
<DIV></DIV>>>completed until the update procedure. So if this doesn't get done
<DIV></DIV>>>will
<DIV></DIV>>>the SQLserver table be out of synch?
<DIV></DIV>>>
<DIV></DIV>>>If the updates are related you may be able to change the lookup
<DIV></DIV>>>file to
<DIV></DIV>>>secondary and your field changes to the process procedure and the
<DIV></DIV>>>update
<DIV></DIV>>>should sort itself out. If it's all procedure code you may be able
<DIV></DIV>>>to
<DIV></DIV>>>use a designer file.
<DIV></DIV>>>
<DIV></DIV>>>If I have misunderstood then I can only apologise in advance but I
<DIV></DIV>>>had 5
<DIV></DIV>>>minutes and thought I would try and help for a change but as usual
<DIV></DIV>>>MY
<DIV></DIV>>>suggestion sounds a lot more complicated than the original
<DIV></DIV>>>question.
<DIV></DIV>>>
<DIV></DIV>>>Regards,
<DIV></DIV>>>Gavin.
<DIV></DIV>>>
<DIV></DIV>>>
<DIV></DIV>>>-----Original Message-----
<DIV></DIV>>>From: powerh-l-admin@lists.sowder.com
<DIV></DIV>>>[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of
<DIV></DIV>>>brian_matthewsbrian matthews
<DIV></DIV>>>Sent: 20 April 2004 16:06
<DIV></DIV>>>To: powerh-l@lists.sowder.com
<DIV></DIV>>>Subject: problem with 'lookup on' and writing to a SQLserver table
<DIV></DIV>>>
<DIV></DIV>>>
<DIV></DIV>>>I have never used this list before so am not completely sure what
<DIV></DIV>>>to
<DIV></DIV>>>expect
<DIV></DIV>>>so here goes : I am trying to write to a SQLserver table from a
<DIV></DIV>>>field
<DIV></DIV>>>process procedure but the row is blocked if a 'lookup on' is also
<DIV></DIV>>>present on
<DIV></DIV>>>the field, can anyone explain this, or offer a wokaround ?
<DIV></DIV>>>
<DIV></DIV>>>P.S we are from RMS and trying out SQLserver
<DIV></DIV>>>
<DIV></DIV>>>_________________________________________________________________
<DIV></DIV>>>Express yourself with cool new emoticons
<DIV></DIV>>>http://www.msn.co.uk/specials/myemo
<DIV></DIV>>>
<DIV></DIV>>>
<DIV></DIV>>>
<DIV></DIV>>>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
<DIV></DIV>>>Mailing list: powerh-l@lists.sowder.com
<DIV></DIV>>>Subscribe: "subscribe" in message body to
<DIV></DIV>>>powerh-l-request@lists.sowder.com
<DIV></DIV>>>Unsubscribe: "unsubscribe <password>" in message body to
<DIV></DIV>>>powerh-l-request@lists.sowder.com
<DIV></DIV>>>http://lists.sowder.com/mailman/listinfo/powerh-l
<DIV></DIV>>>This list is closed, thus to post to the list you must be a
<DIV></DIV>>>subscriber.
<DIV></DIV>>
<DIV></DIV>>_________________________________________________________________
<DIV></DIV>>http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
<DIV></DIV>>
<DIV></DIV>>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
<DIV></DIV>>Mailing list: powerh-l@lists.sowder.com
<DIV></DIV>>Subscribe: "subscribe" in message body to
<DIV></DIV>>powerh-l-request@lists.sowder.com
<DIV></DIV>>Unsubscribe: "unsubscribe <password>" in message body to
<DIV></DIV>>powerh-l-request@lists.sowder.com
<DIV></DIV>>http://lists.sowder.com/mailman/listinfo/powerh-l
<DIV></DIV>>This list is closed, thus to post to the list you must be a
<DIV></DIV>>subscriber.
<DIV></DIV></div><br clear=all><hr>Have more fun with your phone - download ringtones, logos, screensavers, games & more. <a href="http://g.msn.com/8HMBENUK/2728??PS=">Click here to begin!</a> </html>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
------=_NextPart_000_6bf0_6317_212--