Some questions (I have a few sites that have this as an open topic as well...) I meant to ask earlier, but couldn't figure out if I should Reply or Reply All (kidding!!)....
What was the driving force to move from D3 to UniData? How difficult was the move - was it all green screen with source code or more difficult? How did you actually DO the move - it's not like D3 files will copy at any high level to UniData! How long did it take to make the move (physically, once you worked out the kinks) Thanks -- I'm sure there are others here who would be interested in knowing more about your migration... David W. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Tuesday, March 14, 2006 7:44 PM To: [email protected] Subject: [U2] [UD] Triggers I've converted a client's system from D3 to UniData and everything mostly works fine. One of the last items I have to deal with are triggers. I've read the UniData documentation on triggers and am intimately familiar with D3 triggers, so it's no wonder I'm confused about UniData triggers. Questions: 1) Can I create both an update and delete trigger on a file using the same BASIC program or do I need to create two separate programs? In D3 there's an internal function that indicates if the action is an add or delete. This allows a single program to be used for both an update and a delete. 2) How can I tell if a record is being added or changed? 3) Where do the passed variables come from? SUBROUTINE U2.NAMES.BRIDGE.U (ExecStat, DictFlag, FileName, RecIdExpr, RecValue) What specifically is "RecIdExpr"? The record key being updated (documentation says it's the record to be updated)? Is FileName the file name or the "opened" file (file variable)? Do I have to set "DictFlag"? It seems UniData requires a trigger to be defined as either UPDATE or DELETE. Does this mean I have to create two BASIC programs; one for updating and one for deleting? Any assistance would be appreciated. :-) Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
