MS SQL Server blocked.

[Peter Bateman]

Brian:

  An autocommit on the lookup statement should work. I think the lookup is 
done
  in the UPDATE transaction but I am not sure. DBAUDIT=FULL on the run of 
QUICK
  should tell you. You must have a unique key if your want to update an MS 
SQL Server row.
  This key can defined in MS SQL Server and I also believe it can be stated 
on the FILE or
  CURSOR associated with the table.

Regards,
Peter Bateman


>From: "chuck.reinke" <chuck.reinke@sbcglobal.net>
>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: Mon, 19 Apr 2004 21:07:02 -0700
>
>I'm a little surprised to hear about this problem, but I haven't ever 
>worked
>with SQLserver.
>
>However, Lookups are done be default with a read/write transaction just
>after Input procedure time, and therefore I would think the transaction
>should be committed by Process procedure time. You may have some 
>non-default
>stuff on your File statements. Or the File statement for the lookup is the
>same as the one you are trying to update in the Process procedure. 
>Reference
>files are by default opened for read only, which could cause a problem. I
>the files are the same, try using an alias and some other file type for 
>your
>update.
>
>Finally, if you think there may be some bug, try doing a commit at the 
>start
>of your Process procedure.
>
>Chuck
>----- Original Message -----
>From: "brian_matthewsbrian matthews" <brian_matthews_bmw@hotmail.com>
>To: <powerh-l@lists.sowder.com>
>Sent: Tuesday, April 20, 2004 8:06 AM
>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.
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>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.

_________________________________________________________________
Add photos to your messages with MSN Premium. Get 2 months FREE*  
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines