Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.


Welcome, Guest
Guest Settings
Help

Thread: events.gdb TEST_EVENT stored procedure code


This question is answered.


Permlink Replies: 5 - Last Post: Nov 2, 2015 2:42 PM Last Post By: ioan ghip
ioan ghip

Posts: 40
Registered: 3/16/00
events.gdb TEST_EVENT stored procedure code  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 28, 2015 1:29 PM
I don't have interbase installed on my machine, can someone who does please post the TEST_EVENT stored procedure code?

Thanks,
-ioan
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: events.gdb TEST_EVENT stored procedure code
Correct
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 28, 2015 1:38 PM   in response to: ioan ghip in response to: ioan ghip
ioan ghip wrote:
I don't have interbase installed on my machine, can someone who does please post the TEST_EVENT stored procedure code?

Thanks,
-ioan

CREATE PROCEDURE EVENTDEMO
(
EVENT VARCHAR(40)
)
AS
begin
post_event :event;
end

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
ioan ghip

Posts: 40
Registered: 3/16/00
Re: events.gdb TEST_EVENT stored procedure code  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 28, 2015 1:55 PM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
Thanks Jeff for the quick answer.

One more problem I have:

I register 5 events:

fax_confirmation
onramp_confirmation
email_confirmation
activate_f2f
deactivate_f2f

... but the application doesn't receive the 1st and 4th event (fax_confirmation, activate_f2f). I wonder what's the reason. If I change from "fax_confirmation" to "fax_confirmation_" works fine. Same for the "activate_f2f", only "activate_f2f_" works.

EDIT: BTW, all those events work fine on one machine with 100% same data structure and used to work fine on my development machine... so I'm trying to figure out what did I change that messed up the events (I use firebird).

Edited by: ioan ghip on Oct 28, 2015 1:55 PM

Edited by: ioan ghip on Oct 28, 2015 1:58 PM
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: events.gdb TEST_EVENT stored procedure code [Edit]  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 30, 2015 10:03 AM   in response to: ioan ghip in response to: ioan ghip
ioan ghip wrote:
Thanks Jeff for the quick answer.

One more problem I have:

I register 5 events:

fax_confirmation
onramp_confirmation
email_confirmation
activate_f2f
deactivate_f2f

... but the application doesn't receive the 1st and 4th event (fax_confirmation, activate_f2f). I wonder what's the reason. If I change from "fax_confirmation" to "fax_confirmation_" works fine. Same for the "activate_f2f", only "activate_f2f_" works.

EDIT: BTW, all those events work fine on one machine with 100% same data structure and used to work fine on my development machine... so I'm trying to figure out what did I change that messed up the events (I use firebird).

Edited by: ioan ghip on Oct 28, 2015 1:55 PM

Edited by: ioan ghip on Oct 28, 2015 1:58 PM

Unfortunately I do not know what is going on with you. The pattern of your
problem doesn't match any of the issues that have been fixed over the past few
years.

The two main bugs were problems with events that started with the same letter
(this was fixed back in the XE/XE2 time frame) and a problem that the documented
structures for events were actually wrong. This had no impact on 32 bit
applications as the documented structure and the real structure had the same
byte size, but a problem under 64 bit app where the two were not that same # of
bytes. This was fixed in either XE7 or XE8.

What you are describing doesn't match either of the criteria. I haven't seen it
and your case is intermittent (works on some machine not on others). Events
have been stable for decades but perhaps the FB people tried to make
improvements in it so check the client you are using on both machine and make
sure they are the same and that the server version is the same.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Elton Barbosa

Posts: 9
Registered: 7/19/00
Re: events.gdb TEST_EVENT stored procedure code [Edit]  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 31, 2015 5:37 AM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
Maybe if OP could create a simple test case it would help.

Jeff Overcash (TeamB) wrote:
ioan ghip wrote:
Thanks Jeff for the quick answer.

One more problem I have:

I register 5 events:

fax_confirmation
onramp_confirmation
email_confirmation
activate_f2f
deactivate_f2f

... but the application doesn't receive the 1st and 4th event (fax_confirmation, activate_f2f). I wonder what's the reason. If I change from "fax_confirmation" to "fax_confirmation_" works fine. Same for the "activate_f2f", only "activate_f2f_" works.

EDIT: BTW, all those events work fine on one machine with 100% same data structure and used to work fine on my development machine... so I'm trying to figure out what did I change that messed up the events (I use firebird).

Edited by: ioan ghip on Oct 28, 2015 1:55 PM

Edited by: ioan ghip on Oct 28, 2015 1:58 PM

Unfortunately I do not know what is going on with you. The pattern of your
problem doesn't match any of the issues that have been fixed over the past few
years.

The two main bugs were problems with events that started with the same letter
(this was fixed back in the XE/XE2 time frame) and a problem that the documented
structures for events were actually wrong. This had no impact on 32 bit
applications as the documented structure and the real structure had the same
byte size, but a problem under 64 bit app where the two were not that same # of
bytes. This was fixed in either XE7 or XE8.

What you are describing doesn't match either of the criteria. I haven't seen it
and your case is intermittent (works on some machine not on others). Events
have been stable for decades but perhaps the FB people tried to make
improvements in it so check the client you are using on both machine and make
sure they are the same and that the server version is the same.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
ioan ghip

Posts: 40
Registered: 3/16/00
Re: events.gdb TEST_EVENT stored procedure code [Edit]  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 2, 2015 2:42 PM   in response to: Elton Barbosa in response to: Elton Barbosa
Elton Barbosa wrote:
Maybe if OP could create a simple test case it would help.


Here is my setup:

Windows Server 2012 64bits
Firebird 2.5.4 64 bits
Delphi XE5

I created a test.fdb on d:\ with the following structure:

SET SQL DIALECT 3;
 
CREATE DATABASE 'localhost:d:\test.fdb'
PAGE_SIZE 4096
DEFAULT CHARACTER SET NONE;
 
/*  External Function declarations */
 
DECLARE EXTERNAL FUNCTION RDB$GET_CONTEXT
VARCHAR(80) CHARACTER SET NONE, VARCHAR(80) CHARACTER SET NONE
RETURNS VARCHAR(255) CHARACTER SET NONE FREE_IT
ENTRY_POINT 'get_context' MODULE_NAME 'system_module';
 
 
DECLARE EXTERNAL FUNCTION RDB$SET_CONTEXT
VARCHAR(80) CHARACTER SET NONE, VARCHAR(80) CHARACTER SET NONE, VARCHAR(255) CHARACTER SET NONE
RETURNS INTEGER BY VALUE 
ENTRY_POINT 'set_context' MODULE_NAME 'system_module';
 
 
 
COMMIT WORK;
SET AUTODDL OFF;
SET TERM ^ ;
 
/* Stored procedures */
 
CREATE PROCEDURE "EVENTDEMO" 
(
  "AN_EVENT" VARCHAR(40)
)
AS
BEGIN EXIT; END ^
 
 
ALTER PROCEDURE "EVENTDEMO" 
(
  "AN_EVENT" VARCHAR(40)
)
AS
begin
  POST_EVENT :AN_EVENT;
end
 ^
 
SET TERM ; ^
COMMIT WORK;
SET AUTODDL ON;
 
/* Grant Roles for this database */
 
 
/* Role: "RDB$ADMIN", Owner: SYSDBA */
 
CREATE ROLE "RDB$ADMIN";
 
/* Grant permissions for this database */
 


For testing the events I use the IBXEvents compiled for 32 bits, the only modification is the path to the database.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02