problem with 'lookup on' and writing to a SQLserver table
Joe Boyle
joeboyle_adt@hotmail.com
Tue, 20 Apr 2004 17:03:39 +0100
<html><div style='background-color:'><P>I beleive that SQLserver puts a write block on the lookup on'ed row( this won't be released until another row is read); add syntax autocommit to the field and this should cause the row to be released once the read is done.</P>
<DIV class=RTE>
<P>Incidentally all, I am still looking for employment contact details, any agency names and numbers that handle PowerHouse work would be most gratefully recieved.</P>
<P>as I mentioned in an earlier email, I am now looking for work after a five year period on the Cognos ADT support desk.</P>
<P>Whilst at Cognos I worked with products PowerHouse, Axiant and PHWEB, on platforms <BR>such as Unix, Windows/NT, VMS and HP3000, with database/file systems such as Oracle, <BR>SQLserver, RDB, RMS, and 'the isams'.</P>
<P>Prior to Cognos I worked on VMS with PH and RMS for seven years, and for the three <BR>years prior to that I worked with Digital Cobol again with RMS on PDP-11's :-)</P>
<P>many thanks in advance for your help,<BR><BR> </P></DIV>
<DIV></DIV>>From: "brian_matthewsbrian matthews" <brian_matthews_bmw@hotmail.com>
<DIV></DIV>>To: powerh-l@lists.sowder.com
<DIV></DIV>>Subject: problem with 'lookup on' and writing to a SQLserver table
<DIV></DIV>>Date: Tue, 20 Apr 2004 15:06:23 +0000
<DIV></DIV>>
<DIV></DIV>>I have never used this list before so am not completely sure what to
<DIV></DIV>>expect so here goes : I am trying to write to a SQLserver table from
<DIV></DIV>>a field process procedure but the row is blocked if a 'lookup on' is
<DIV></DIV>>also present on the field, can anyone explain this, or offer a
<DIV></DIV>>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>>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>Stay in touch better and keep protected online with MSN’s NEW all-in-one Premium Services. <a href="http://g.msn.com/8HMAENUK/2743??PS=">Find out more here.</a> </html>