problem with 'lookup on' and writing to a SQLserver table

[Peter Bateman]

Good point Gavin. I have done something similiar to what Brian is doing.
I was reserving products from inventory for an order that I was building. 
and yes
I had to put in code to backout if the order was modified or cancelled.
Regards,
Peter


>From: "Lloyd, Gavin" <gavin.lloyd@fmglobal.com>
>To: "brian_matthewsbrian matthews" <brian_matthews_bmw@hotmail.com>,   
><powerh-l@lists.sowder.com>
>Subject: RE: problem with 'lookup on' and writing to a SQLserver table
>Date: Wed, 21 Apr 2004 12:57:38 +0100
>
>The autocommit would release the lock but what worries me is doing the
>write in the process procedure.  If you are updating a record based on
>the logic in the screen then you cannot guarantee the update will be
>completed until the update procedure.  So if this doesn't get done will
>the SQLserver table be out of synch?
>
>If the updates are related you may be able to change the lookup file to
>secondary and your field changes to the process procedure and the update
>should sort itself out.  If it's all procedure code you may be able to
>use a designer file.
>
>If I have misunderstood then I can only apologise in advance but I had 5
>minutes and thought I would try and help for a change but as usual MY
>suggestion sounds a lot more complicated than the original question.
>
>Regards,
>Gavin.
>
>
>-----Original Message-----
>From: powerh-l-admin@lists.sowder.com
>[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of
>brian_matthewsbrian matthews
>Sent: 20 April 2004 16:06
>To: powerh-l@lists.sowder.com
>Subject: problem with 'lookup on' and writing to a SQLserver table
>
>
>I have never used this list before so am not completely sure what to
>expect
>so here goes : I am trying to write to a SQLserver table from a field
>process procedure but the row is blocked if a 'lookup on' is also
>present on
>the field, can anyone explain this, or offer a wokaround ?
>
>P.S we are from RMS and trying out SQLserver
>
>_________________________________________________________________
>Express yourself with cool new emoticons
>http://www.msn.co.uk/specials/myemo
>
>
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>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.

_________________________________________________________________
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines