Subject RE: [ib-support] IB and locks
Author akahanek@qgir.cz
You can exec "dummy" update

UPDATE MYTABLE SET MYCOLUMN = MYCOLUMN WHERE ....

Then the the desired row is locked until you commit or rollback. Side
efect is, that update triggers are fired in such case (sometimes it is
not desireable).

Ales

> -----Original Message-----
> From: Duilio Foschi [mailto:dedalus@...]
> Sent: Tuesday, February 19, 2002 2:38 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] IB and locks
>
>
> I was accustomed to lock records in PDX/DBF, but I am told
> that this is no
> more necessary with IB.
>
> How does IB manages the users access to table rows ?
>
> Is there any tech info to read about this subject ?
>
> Thank you
>
> Duilio Foschi
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Tiny Wireless Camera under $80!
> Order Now! FREE VCR Commander!
> Click Here - Only 1 Day Left!
> http://us.click.yahoo.com/nuyOHD/7.PDAA/yigFAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/