The pessimistic lock of ADO may not be supplied properly by the driver vendor. One way to do it, is to do a dummy update
statement of the records you would like to lock. This will keep anyone else from being able to update them until you commit.

Jason

kevtey wrote:

> hie im new in firebird. i would like to know how can i impliment
> record locking in firebird? can anyone pls enlighten me pls...
>
> currently im accessing the firebird from vb using connectionstring and
> recordset. i try using pesimistic lock but its not working...should i
> use adodb connection begintrac?
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

--
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.