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 >
