Re: [firebird-support] Re: Using events with php
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 'changes_for_fred' rather than seeing 'changes_for' and then having to ask the database who it was intended for ... which is what the second example does. You need to know the full name of each of the event you are looking for. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) * To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com * Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Re: Using events with php
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 than my intent. --- Daniel On 2015-08-26 03:20, r...@graficalc.nl [firebird-support] wrote: 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 the trigger add a recently changed field so you can retrieve the recently changed records. See for an explanation here: Is it possible to use arguments with firebird events : POST_EVENT 'event_name' + string args? [1] [1] Is it possible to use arguments with firebird events : P... [1] I've a trigger that detects a change on a field PHONE_EXT and POSTs an EVENT. I would like to post the Phone_ID with the event in order to use this ID in... View on stackoverflow.com [1] Preview by Yahoo Links: -- [1] http://stackoverflow.com/a/4338354/1037511 [2] http://www.firebirdsql.org [3] http://www.ibphoenix.com/resources/documents/ [4] https://groups.yahoo.com/neo/groups/firebird-support/info;_ylc=X3oDMTJldjB0bXVzBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTQ0MDU4NDQyMA-- [5] https://groups.yahoo.com/neo/groups/firebird-support/members/all;_ylc=X3oDMTJmOWZiZWh1BF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZtYnJzBHN0aW1lAzE0NDA1ODQ0MjA- [6] https://groups.yahoo.com/neo;_ylc=X3oDMTJkbmpnMG8yBF9TAzk3NDc2NTkwBGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxNDQwNTg0NDIx [7] https://info.yahoo.com/privacy/us/yahoo/groups/details.html [8] https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] FB 2.5 Lock conflict on no wait transaction
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 Firebird 2.5 server thas was working fine since several months ago on a Windows 2008 Server. We use gfix with -list option but it seems not to be any transaction pending. The gfix -commit all command has no efect. The only way to unlock the database is restarting the firebird service. There have not been changes on harware neither software in the server. Any help will be aprreciated. Regards, Hernando.
Re: [firebird-support] Re: Using events with php
---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 parameters through an event-name. You'll need to register the exact event-name at the client side and that would need to include the ID you want to extract, which defeats the whole purpose. Here are two topics discussing such wanted feature but you can see clearly it doesn't exist. http://tracker.firebirdsql.org/browse/CORE-642 http://tracker.firebirdsql.org/browse/CORE-642 http://tracker.firebirdsql.org/browse/CORE-1981 http://tracker.firebirdsql.org/browse/CORE-1981 So, like you are going to do, you need to transfer the data another way. A temporary table with changed IDs would be a way to go. A changed-field (and maybe changed_date field) in the same table as the trigger is on would be another.
[firebird-support] Re: Using events with php
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 the trigger add a recently changed field so you can retrieve the recently changed records. See for an explanation here: Is it possible to use arguments with firebird events : POST_EVENT 'event_name' + string args? http://stackoverflow.com/a/4338354/1037511 http://stackoverflow.com/a/4338354/1037511 Is it possible to use arguments with firebird events : P... http://stackoverflow.com/a/4338354/1037511 I've a trigger that detects a change on a field PHONE_EXT and POSTs an EVENT. I would like to post the Phone_ID with the event in order to use this ID in... View on stackoverflow.com http://stackoverflow.com/a/4338354/1037511 Preview by Yahoo
Re: [firebird-support] 2.5 architecture
Re: [firebird-support] FB 2.5 Lock conflict on no wait transaction
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. concurrent transaction number is 3590088 It repeats the same changing only the transaction number. This is happening with different databases in different servers. Regards, Hernando
Re: [firebird-support] SQL for TCC
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. - 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 screen -- - Robert Martin Development Manager Ph 03 377-0495 fax 03 377-0496 email r...@chreos.com Wild Software Ltd www.chreos.com Please forward all support queries to supp...@chreos.com so we may respond to your query as quickly as possible. No virus found in this message. Checked by AVG - www.avg.com http://www.avg.com Version: 2015.0.6125 / Virus Database: 4409/10518 - Release Date: 08/26/15
[firebird-support] SQL for TCC
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 screen -- - Robert Martin Development Manager Ph 03 377-0495 fax03 377-0496 email r...@chreos.com Wild Software Ltd www.chreos.com Please forward all support queries to supp...@chreos.com so we may respond to your query as quickly as possible.