Hi, No, I am sure that I can get this message from Delphi. Check it on web site www.microolap.com For example when I try to put a non-unique value in a primary key I get message from database that I get conflict with primary key :-) of course I use raise ... except ... but everything work perfectly... error handling works correctly :-)
so I am waiting for an answer for my question how check that the rekord is currently edited, Greetings, Daniel > > >*********** REPLY SEPARATOR *********** > >On 2003-08-28 at 17:42 Yudha Setiawan wrote: > >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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster