problem with 'lookup on' and writing to a SQLserver table
Joe Boyle
joeboyle_adt@hotmail.com
Fri, 23 Apr 2004 13:16:56 +0100
<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>