Trigger deffinitions as well as indexes are stored in the ]I file. What does LIST-TRIGGER primaryfile show? My guess is the trigger is no longer there.
Dan Ell jBASE Technical Engineer 813-498-2544 | 866-582-8447 [email protected] | www.jbase.com 1050 Calle Amanecer, Suite A , San Clemente, CA , 92673 From: [email protected] <[email protected]> On Behalf Of Tom J Sent: Thursday, March 7, 2019 5:26 PM To: jBASE <[email protected]> Subject: Triggers and Indexes We are using jBASE 5.6 on Linux Centos 7.6. We recently experienced a system freeze forcing a console stop, then boot. A file was damaged beyond repair as a result of this system freeze and had to be restored from a prior backup. All indexes on this file were deleted. We also removed the file]I. The indexes were then recreated. We have a primary file with a trigger that updates this (secondary) file. Some of the attributes on this secondary file are indexed. Prior to the system freeze the indexes on the secondary file would update properly after the trigger on the primary file updated the secondary file attributes. After the system freeze this does NOT happen. Updating an indexed field on the secondary file automatically correctly updates the corresponding index. Updating the secondary file with the primary file trigger does update the secondary file properly but the corresponding index on the secondary file is NOT updated. How do we get the indexes updating automatically after the primary file trigger updates the secondary file? Any advice and suggestions are greatly appreciated. TIA. -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected]<mailto:[email protected]> To unsubscribe, send email to [email protected]<mailto:[email protected]> For more options, visit this group at http://groups.google.com/group/jBASE?hl=en<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgroups.google.com%2Fgroup%2FjBASE%3Fhl%3Den&data=02%7C01%7Cdane%40jbase.com%7C7564f6e84c934bdc8dc608d6a34defa7%7Cbfd62fcabd384e07a0785e9943d1f9c0%7C0%7C0%7C636875952464580307&sdata=AciKTP1arJNHm%2Fddq%2BjAG0XOzZROSppTrfAN%2BTL6WsM%3D&reserved=0> --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Foptout&data=02%7C01%7Cdane%40jbase.com%7C7564f6e84c934bdc8dc608d6a34defa7%7Cbfd62fcabd384e07a0785e9943d1f9c0%7C0%7C0%7C636875952464590312&sdata=OKXxtXindZEpmRHZSVzSysVsOLSFPOQg2nQJOYh%2BJR8%3D&reserved=0>. -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
