Just add a new field to the table called LOCKED_BY_USER or something and
when a user wants to lock a record you just update the table so it is
filled in with their user id. Other instances of the program should
check that field and not allow the user to touch the record if it is not
null. Of course once the original user is done they need to update the
table again and null out the field...

-steve

Doru Constantin wrote:

>
> It don't have to be without lock, but since in mysql it is so simple, I'm
> looking for similar to do things in firebird.
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> [mailto:firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>] On Behalf Of Kjell Rilbe
> Sent: 31 iulie 2008 11:41
> To: firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> Subject: Re: [firebird-support] get_lock / release_lock
>
> Doru Constantin wrote:
>
> > So, you say that I can modify for 30 minutes a document and then I
> try to
> > see if I can commit the changes?
> > I need to know that I can comit the changes before I begin to modify the
> > doc. It is like pessimistic locking but without any record lock.
>
> Why does it have to be without a record lock?
>
> Kjell
> --
> --------------------------------------
> Kjell Rilbe
> DataDIA AB
> E-post: kjell@... <mailto:kjell%40datadia.se>
> Telefon: 08-761 06 55
> Mobil: 0733-44 24 64
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org <http://www.firebirdsql.org> and
> click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
> <http://www.ibphoenix.com>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>