Procedures and Triggers

Can someone point me to an example of a procedure, trigger, and
instructions on how to use them in NexusDB?

Thanks

Mark,

<< Can someone point me to an example of a procedure, trigger, and
instructions on how to use them in NexusDB? >>

As a start, you should check the following topics in the NexusDB V2 SQL
Reference:

- Stored Procedures and Functions
- CREATE PROCEDURE statement
- CREATE FUNCTION statement
- CREATE TRIGGER statement

Ole

"Mark Clark" <mcmahling@mac.com> wrote in message news:434d3c0c@wic040d....
> Can someone point me to an example of a procedure, trigger, and
> instructions on how to use them in NexusDB?
>
> Thanks

You can go to the online help at
http://www.nexusdb.com/onlinemanualv...nce/index.html

Here is an example stored procedure:

DROP ROUTINE IF EXISTS "GENERALGLCODES";
create PROCEDURE GENERALGLCODES
(
out code1 VARCHAR(15), // can be in or out
out code2 VARCHAR(15),
out code3 VARCHAR(15),
out RESULT SMALLINT
)
READS SQL DATA // if altering tables then use MODIFIES SQL DATA to give
write access
AS
BEGIN
set code1 = '';
set code2 = '';
set code3 = '';
set Result = 0;
set code1 = (Select CODE from glcodes where gTYPE = 'abc'); //gTYPE has
unique values
set code2 = (Select CODE from glcodes where gTYPE = 'def');
set code3 = (Select CODE from glcodes where gTYPE = 'ghi');
if ((code1 = '') or (code2 = '') or (code3 = '')) then
set Result = -1;
end if;
END

To use it within EM SQL you will need something like:
declare
myCode1 varchar(10),
myCode2 varchar(10),
myCode3 varchar(10),
myResult integer; // or smallint
CALL GENERALGLCODES(myCode1, myCode2, myCode3, myResult);
//variables now holding data returned from calling the stored procedure.
select myCode1 from #dummy; //to show the value

Regards,
William.