Re: [firebird-support] Re: Using events with php

2015-08-26 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 26/08/15 19:48, dmil...@amfes.com [firebird-support] wrote: You're correct - but I'm trying to follow an example I saw. I think what you are missing perhaps is that the added ID on the example is allowing the client to only monitor events for a particular ID. So the client asks to see

Re: [firebird-support] Re: Using events with php

2015-08-26 Thread dmil...@amfes.com [firebird-support]
You're correct - but I'm trying to follow an example I saw. It would appear my string construct in my trigger isn't doing what I want. I think I'll make a temporary table with a varchar field and insert the string into that - theoretically that will show me if my construct is something other

Re: [firebird-support] FB 2.5 Lock conflict on no wait transaction

2015-08-26 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Hernado, You are the third person during several days with this question. Can you please post the full error text? Otherwise it is not possible to provide any help. Regards, Alexey Hi to all, From several days ago we are having trouble with Lock conflict on no wait transaction on a

Re: [firebird-support] Re: Using events with php

2015-08-26 Thread r...@graficalc.nl [firebird-support]
---In firebird-support@yahoogroups.com, dmiller@... wrote : You're correct - but I'm trying to follow an example I saw. You are probably trying to follow an example of somebody who like this feature implemented in Firebird events. But it just doesn't exist (yet). There is no way to give

[firebird-support] Re: Using events with php

2015-08-26 Thread r...@graficalc.nl [firebird-support]
Am I correct in understanding that you want to pass arguments with your event? As far as I know this is not possible. If you send a RAW:1234 event you need to register in PHP to receive RAW:1234 event. You can't listen for RAW:* event (like wildcards). You can send a generic RAW event and in

Re: [firebird-support] 2.5 architecture

2015-08-26 Thread Daniel Rail dan...@accra.ca [firebird-support]

Re: [firebird-support] FB 2.5 Lock conflict on no wait transaction

2015-08-26 Thread duque.herna...@yahoo.com [firebird-support]
Hi Alexey, Thank you for posting. The full error text is : lock conflict on no wait transaction. deadlock. update conflicts with concurrent update. concurrent transaction number is 36094733 lock conflict on no wait transaction. deadlock. update conflicts with concurrent update.

Re: [firebird-support] SQL for TCC

2015-08-26 Thread Robert martin r...@chreos.com [firebird-support]
Sorry set the SQL to the wrong 'support' email. Please ignore. Thanks Rob On 27/08/2015 12:07 p.m., Robert martin r...@chreos.com [firebird-support] wrote: UPDATE CsItem SET YeRef = 7051 WHERE ItemRef IN (688421, 688413, 688405, 688438, 688446) To run the above - On any ONE machine. -

[firebird-support] SQL for TCC

2015-08-26 Thread Robert martin r...@chreos.com [firebird-support]
UPDATE CsItem SET YeRef = 7051 WHERE ItemRef IN (688421, 688413, 688405, 688438, 688446) To run the above - On any ONE machine. - Go to Maintenance Advanced SQL Entry - Cut and paste the SQL into the 'SQL String to be processed' box - Click Process - The SQL has run so you can now close the