X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 8C015D1B8A9 for ; Thu, 28 Aug 2003 10:48:14 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 94391-10 for ; Thu, 28 Aug 2003 07:47:45 -0300 (ADT) Received: from snickers.hotpop.com (snickers.hotpop.com [204.57.55.49]) by svr1.postgresql.org (Postfix) with ESMTP id 43155D1D888 for ; Thu, 28 Aug 2003 07:47:42 -0300 (ADT) Received: from bonbon.net (kubrick.hotpop.com [204.57.55.16]) by snickers.hotpop.com (Postfix) with SMTP id 761C37A8FC for ; Thu, 28 Aug 2003 10:47:32 +0000 (UTC) Received: from yudha (unknown [61.5.113.115]) by smtp-3.hotpop.com (Postfix) with SMTP id F2CB86AABEF; Thu, 28 Aug 2003 10:47:23 +0000 (UTC) Message-ID: <1bb201c36d51$2728f500$ea00a8c0@yudha> From: "Yudha Setiawan" To: =?iso-8859-2?Q?Daniel_Micha=B3?= Cc: References: <002301c36d3d$baf7f1f0$2601a8c0@gliwice.helion.com.pl> Subject: Re: lock row in table Date: Thu, 28 Aug 2003 17:42:50 +0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_1BAF_01C36D8B.CD4CCCB0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-HotPOP: ----------------------------------------------- Sent By HotPOP.com FREE Email Get your FREE POP email at www.HotPOP.com ----------------------------------------------- X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.0 tagged_above=0.0 required=5.0 tests=HTML_40_50, HTML_FONT_FACE_ODD, REFERENCES X-Spam-Level: * X-Archive-Number: 200308/340 X-Sequence-Number: 14956 This is a multi-part message in MIME format. ------=_NextPart_000_1BAF_01C36D8B.CD4CCCB0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable Of course I can lock record with syntax=20 "Begin;=20 select * from table1 where ID=3D12 for update;=20 update table1 set field1=3D"New value" where ID=3D12;=20 commit;" but I can not to inform other user that the record is edited? =20=20=20 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=20 * raise notice 'ur_message'; or raise exception 'ur_error_message'; * and the only message that delphi could read is just raise exception.=20 * 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 ot= her=20 * Class object on delphi. =20=20=20 Please help me, Maybe someone have similar problem?=20 Greetings, Daniel =20=20=20 Hope it Help, GOD Bless You and Bravo PostgreSQL. ------=_NextPart_000_1BAF_01C36D8B.CD4CCCB0 Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable
 
Of course I can lock record with syntax= =20
"Begin;
      &nbs= p; select=20 * from table1 where ID=3D12 for update; 
        update table1 se= t=20 field1=3D"New value" where ID=3D12; 
commit;"
but I can not to inform other user that = the=20 record is edited?
 
MAIN TARGET:
How to get information that current reco= rd is=20 edited? Which function can I use?
 
* as long as i know, the only message = you could=20 create is just
* raise notice 'ur_message'; or=20 raise exception 'ur_error_message';
* and the only message that delphi cou= ld read=20 is just raise exception.
 
* And if you wanna make your own messa= ge,=20 perhaps you must using try and except
* and you could give your own message via=20 ShowMessage('ur_message') or other
* Class object on delphi.
 
 
Please help me, Maybe someone have simil= ar=20 problem?
Greetings,
Daniel
 
Hope it Help, GOD Bless You and Bravo= =20 PostgreSQL.
------=_NextPart_000_1BAF_01C36D8B.CD4CCCB0--