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
Ben,
Have you tried the same scenario using the CURRENT version of R:BASE 6.5++ (Build: 1.864xRT03) or higher?
6.5+ (the version you are using) was released in December 2000, over two (2) years ago and there have been hundreds ENHANCEMENTS and BUG-FIXES since that version.
If you can reliably replicate ANY boo-boo(s) in the CURRENT version of R:BASE, we'll be happy to address the issue.
If this issue is important to you or your lovely client(s), I recommend creating
a sample for the R:DCC (The Dream Team) using the CURRENT version so
that we can resolve the problem.
At this point, you can choose to either waste time or take care of business ... the choice is obviously yours!
Very Best Regards,
Razzak.
