Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
Slight over-enthusiasm |
Tue, Mar 6 2007 8:41 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
I'm following Ole's advice on the Triggers. For the update one I've added two columns (_ID and _Name). When I go to save I get the prompt shown in the attachment. Not sure why. I do get the following trigger created CREATE TRIGGER "RemoveTrailingBlanksU" BEFORE UPDATE OF "_ID","_Name" ON "Accounts" BEGIN SET NEWROW._ID = RTRIM(NEWROW._ID); SET NEWROW._NAME = RTRIM(NEWROW._NAME); END Roy Lambert Attachments: xx.jpg |
Tue, Mar 6 2007 12:38 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I'm following Ole's advice on the Triggers. For the update one I've added two columns (_ID and _Name). When I go to save I get the prompt shown in the attachment. >> It's not resetting the modified flag when you add the column. I'll make sure this is fixed. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Friday, May 3, 2024 at 08:07 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |