Can anyone adwise on a good article and/or sample application/database with this triggers so I can get started. I understand the concept but I have not yet done actual programming with it. I cant find it the samples databases fir 6.5++ or on the Edge! Have I just missed it or is it not there?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of A. Razzak Memon Sent: den 22 november 2002 05:28 To: [EMAIL PROTECTED] Subject: Re: Auto Number - Razzak's Reply At 10:37 AM 11/19/2002 -0500, Steve Johnson wrote: >I am sure there is a better way to control autonumber more >effectively. And I want to minimize the additional keystrokes >needed on a repetitive basis to prevent instances of an >unwanted incremented autonumber column. Suggestions? Steve, Ask and you shall receive. No worries, mate! Using The Glorious R:BASE 2000 (ver 6.5++), In-Line Patch-3, Build:1.854xRT03 and higher, you can take advantage of the NEW feature of "AFTER TRIGGERS" to update the column after the actual INSERT has occurred. Then, use the simple scenario as following: SET VAR vMaxNo INTEGER = 0 SELECT (MAX(ColumnName)+1) INTO vMaxNo INDIC IvMaxNo FROM TableName UPDATE TableName SET ColumnName = .vMaxNo WHERE COUNT = INSERT Background: The current triggers are All "BEFORE" triggers in that they run just before the actual INSERT, UPDATE, or DELETE and give you the ability to abort the action. The new triggers are "AFTER" triggers in that they run just after the action. The new triggers can be created by the create table command or by the alter table command. When you use the alter table command you must define the insert triggers in the same command. The same goes for update and delete. Do not use one alter table command to add the "BEFORE" insert trigger and then another alter table to add the "AFTER" trigger. Do them both in the same command. When you drop a trigger, you do not specify the "BEFORE" or "AFTER" trigger. The drop of the insert trigger, for example, drops both parts of they are there. LIST TRIGGERS and UNLOAD command has also been updated to include these changes. Should you need further assistance or step-by-step instructions, feel free to contact me privately at mailto:[EMAIL PROTECTED] If you would like to test the latest and greatest in-line patch-3 beta, send your request to: mailto:[EMAIL PROTECTED] Enjoy the benefits of staying CURRENT! Very Best Regards, Razzak. ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
