--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:

>
> kevtey wrote:
> >>>hie im new in firebird. i would like to know how can i impliment
> >>>record locking in firebird?
>
> The short answer is don't use it. You don't need it, and it will
> only cause you trouble. If you'd like a longer and more pertinent
> answer, please explain what you're trying to do.
>
>
> Regards
>
>
> Ann
>

i have an application written using visual basic 6.0 . Im using ADO to
update the field..basically i assign a value to the field in client
side first b4 posting the data to the server.
eg. rs("field").value = txtvalue
rs.update

the reason i needed a lock is this to do this.
1. User 1 press edit -> Record in db is lock for editing,updating and
deleting.
2. User 1 key in all the information and press save button. lock is
release

currently i face the problem is
while user 1 still updating the record the 2nd user already delete
that particular record.

i tried to use "select * from table where id='zzz' with lock" when
user1 press edit button.but the error happen! user 2 cant able to read
the particular record that is being update by user1

is there a way to cater this problem? currently im using zstylegroup
provider.

im not sure if the way im doing it is correct or wrong. if you want i
can post up my coding here.