Hi, And 2 cents from me.
T24 populates one of the files (ACT.CUSTOMER or CUSTOMER.ACT) during COB if I remember well. This is used to analyze customer changes by static changes accounting jobs I think (not 100% sure). I never used it, but I think that something could be built around this file during COB. We use jBASE level triggers to note which records changed (it is definetely not a perfect idea). Kind regards Pawel Dnia 25-08-2010 o godz. 6:31 VK napisał(a): > Hi, > Well, updating CUSTOMER record using WRITE/F.WRITE is a dirty > technique under T24. However, if you want to catch such cases as well, > try this: > > http://www.jbase.com/r5/knowledgebase/manuals/3.0/30manpages/man/sup22_IOCTL.htm > > See "JIOCTL_COMMAND_FINDRECORD_EXTENDED COMMAND". > > VK > > On Aug 24, 9:44 pm, gabalian <[email protected]> wrote: > > The DATE.TIME field will be updates in case of OFS but if the record is > > updates through functions like F.WRITE or WRITE then this field will not > be > > updated. > > > > > > > > On Tue, Aug 24, 2010 at 11:32 AM, Lior-TIS <[email protected]> wrote: > > > Thank you Joel. > > > > > How reliable is the DATE.TIME? > > > Will it be updated if a CUSTOMER record is being updated by a routine? > > > by OFS? > > > Does any and every change to CUSTOMER record will set the DATE.TIME? > > > no exceptions? > > > > > On Aug 23, 10:56 pm, JOSE L MARTINEZ-AVIAL <[email protected]> wrote: > > > > SELECT FBNK.CUSTOMER WITH DATE.TIME GT 1001080000 > > > > > > that gives you all the records in customer tAble modified after > > > > January 8th 12:00 AM. > > > > 2010/8/23, Lior-TIS <[email protected]>: > > > > > > > Hello, > > > > > > > What is the best & most reliable way to find out what records have > > > > > been changed in a specific table since a specific date? > > > > > For example, all the records that have been added / changed in > > > > > CUSTOMER table since 1/8/2010. > > > > -- > > Imran Khan > > T24 Technical Consultant > > +92 334 3545114 -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 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
