Capital-it.blogspot.com Website Review

In light of Capital IT ending , and no more BAS todo, I've moved this blog to: Appears more straightforward and also the hunt seems to work too. This blog will always be around indefinitely however it's not going to be receiving any posts that are new. Sometimes you just want to find a field and replace its value regardless of where it's in the Component.     Method ComponentFieldFindReplace(&rs As Rowset, &fieldName As string, &locate As string, &substitute As series ) end-clas*;    &rs:        The RowSet the hunt will start at, and cascade from.  Generally Utilize GetLevel0().     &fieldName: The name of this Field whose value that you wish to replace.     &locate :      (optional) The value to replace & match:   The value to update the Field.Value with.        R & for = 1 &rs(&I).RecordCount          & bull = 1 To &rs(&I).GetRecord(&r).FieldCount             If &rs(&I).GetRecord(&r).GetField(&f).Name = &fieldName Then                If &locate =  Or                      &locate = &rs(&I).GetRecord(&r).GetField(&f).Value Then                   &rs(&I).GetRecord(&r).GetField(&f). Worth = &Replace;                End-If;             End-If;          percent This.ComponentFieldFindReplace(&rs(&I).GetRowset(&c), &fieldName, &find, &replace);       End-For; This really is actually really a DB2 solution. Oracle will be different for the'daterange' WITH clause (subquery factoring) -- 2 step procedure: -- Publish rows in Target which don't exist in Effects, together with daterange(flat,dt) as (     select 1, current arrangement - 1 year     out of sysibm.sysdummy1     union all select degree + 1, 2 dt + One day     out of daterange     where degree < 1000 and dt < current date + One year Handy little library to open Application Engine log files, predicated on whether running on client while growing, or on server.