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

[chuck.reinke]

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.