Recent content by matchew

they just want to add auditing in their system

grrrrrr I think its impossible for me to upgrade client using 10.1C already

I am using 10.1C sorry about not mentioning earlier

Rob can you give me some link reference for the archiving the audit table? so that I can have a kick start for studying the intermediate dumping of record form audit trail

Cringer some links to the thread are 404 not found zzZzzZzz

Yes that is what I am scared of the table/area of audit trail that will grow in unimaginable size but I am wondering if can I archive programmatically? I just wanted to minimize the space of the audit as much as possible because the program that I am auditing is teller program where there is a...

Hi developers, I enable the audit trail of progress to my database now I want to have a House Keeping Window for this table I want to delete some records within a given date range of the user. Now I tried to delete one record this my code Find First _aud-audit-data No-Lock No-error. if...

Thanks Guys I already Solved my problem about this query few days ago and I forgot to update my thread thanks a Lot to you guys and I have a similar solution as LarryD posted Thank You Very Much ^_^

that is my problem when using a index so it makes it even slower I tried to use an index again but progress still doing a whole-index scan

I am using that statement for the static query of my browse but I think I will try this statement instead OPEN QUERY {&browse-name} FOR EACH ttMemAppCodes, EACH MemberInf WHERE MemberInf.lNAME + " " + MemInf.FName BEGINS SELF:SCREEN-VALUE AND NOT memInfo.memStatus =...

Ok thank cringer I will take note of your advices

for this table I think its over 30,000 records I tried caching them in main block but I think my users won't like it because it take like 15-30 secs to cached them bu I think I will Try your suggestion but any other suggestion?

The Index that I used was the "name" contains the ff. I just want to search for their full names fname lname memstatus ow yes I use that kind of method instead of creating new field for full name for the reason that if a user want to type first the firstname or the middlename that will be a 3...

Good Day, I am having a trouble with displaying the results of my open query statement to the browse. Legend Program Name: memberName.w Open Query: OPEN QUERY {&browse-name} FOR EACH MemberInf WHERE MemberInf.lNAME + " " + MemInf.FName BEGINS SELF:SCREEN-VALUE...