From: | "Yudha Setiawan" <inas_husband(at)bonbon(dot)net> |
---|---|
To: | Daniel Michał <danielosch(at)o2(dot)pl> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: lock row in table |
Date: | 2003-08-28 10:42:50 |
Message-ID: | 1bb201c36d51$2728f500$ea00a8c0@yudha |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Of course I can lock record with syntax
"Begin;
select * from table1 where ID=12 for update;
update table1 set field1="New value" where ID=12;
commit;"
but I can not to inform other user that the record is edited?
MAIN TARGET:
How to get information that current record is edited? Which function can I use?
* as long as i know, the only message you could create is just
* raise notice 'ur_message'; or raise exception 'ur_error_message';
* and the only message that delphi could read is just raise exception.
* And if you wanna make your own message, perhaps you must using try and except
* and you could give your own message via ShowMessage('ur_message') or other
* Class object on delphi.
Please help me, Maybe someone have similar problem?
Greetings,
Daniel
Hope it Help, GOD Bless You and Bravo PostgreSQL.
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel | 2003-08-28 12:14:38 | Re: lock row in table |
Previous Message | Daniel Michał | 2003-08-28 08:23:58 | lock row in table |