Yep On 1 Apr 2003, at 11:20, Dennis McGrath wrote:
> Ben, > > Did you RStyle before codelocking? > > Dennis McGrath > > --- Ben Petersen <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > Very stuck here. > > > > This is from a view definition: > > > > from tCompany t1, + > > gl_Accounts t2, + > > gl_GroupNames t3, + > > gl_Budget t4 + > > Whe (t1.AccountSet = t2.AccountSet) and +> > (t2.AcctType = 'e' or > > t2.AcctType = 'i') and + > > (t2.AcctGroup = t3.AcctGroup) and + > > (t2.AcctRef = t4.AcctRef) > > > > Without codelocking this works correctly (returns 80 records total). > > Codelocked, only AcctTypes of "i" are returned, ignoring "e"s, (21 > > records > > total). > > > > This is under Rbw 6.5+, Windows NT Server (also Win98) > > > > I've tried changing the order, using "IN" rather then "OR", and > > limiting the > > literals to just "e" (no records returned), shifting the offending > > code up / down > > .. > > > > TIA, > > > > Ben Petersen > > >
