help with locking using mssql

[Peter Bateman]

I would try declaring a cursor in PowerHouse with the
FOR UPDATE OF column. ...
build in. Most databases support the FOR UPDATE clause by putting
a write lock on the row.

Make sure your key columns are the cursor and the FOR UPDATE OF list.

The COMMIT UPDATE should release your locks.

Regards,
Peter






>G'day Viet
>
>Try using a T-SQL stored procedure for the update or at least in-line SQL.
>The "UPDATE tablename SET ..." in SQL Server will lock the table for
>update.
>
>Blue
>
>
>
>
>
>
>Hi , Could someone give me some help to convert the following quick
>procedure to the relational model using powerhouse and mssql. I need to
>convert the lock / unlock statements.
>
>Thank you.
>
>
>
>procedure internal xupdate
>
>    begin
>
>       if timetype_post of peabsence <> " "
>
>          then begin
>
>
>
>                 lock pycheckdock, ctaccr, peabsence, peaccr, peaccrtran
>
>                 do xupdate-accr
>
>               end
>
>          else  lock pycheckdock, peabsence
>
>
>
>       let timeqty_dock of peabsence =   &
>
>         timeqty_dock of peabsence + xdock_qty
>
>       let docked of peabsence = "Y"
>
>       put peabsence
>
>       let ssnumr of pycheckdock = ssnumr of peabsence
>
>       put pycheckdock  reset
>
>       unlock all
>
>    end
>
>
>
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe &lt;password&gt;" in message body to 
>powerh-l-request at 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.

_________________________________________________________________
Powerful Parental Controls Let your child discover the best the Internet has 
to offer.  
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSN® Premium right now and get the 
first two months FREE*.