> -------- Original Message -------- > Subject: RE: SLOCP: Prodding about > From: "Bruce Chitiea" <[email protected]> > Date: Mon, November 29, 2010 4:41 pm > To: "Dennis McGrath" <[email protected]> > > > Dennis: > > Thanks for eye aye. Follows now a trainee brute-force "I really don't > know what I'm doing" testing procedure with TV-8 8.0.24.31116. I'm > attacking what I see as the first-level anomalous results. > > I'm sure that text wrapping will do grave violence to my formatting: > > 1. Create a string map for vtest1: > > XX X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X - your > first string > 123456789|123456789|123456789|123456789|123456789|123456789|12 - > character count (62) > ..|.|.|.|.5.|.|.|.|.5.|.|.|.|.5.|.|.|.|.5.|.|.|.|.5.|.|.|.|.5. - > CHAR(32) occurrence > > 2. Truncate the map for vtest = (SGET(.vtest1,40,1)): > > XX X X X X X X X X X X X X X X X X X X X - truncated string > 123456789|123456789|123456789|123456789| - character count (40) > ..|.|.|.|.5.|.|.|.|.5.|.|.|.|.5.|.|.|.|. - CHAR(32) occurrence > > 3. Isolate the first test set with a "goto end" after the first "wri > '---..." and a "label end" just before the "return". > > 4. Run the routine several times and - ignoring the puzzling results of > the "-1" LAST OCCURRENCE parameter - see what happens: > > Param Result > 17 35 > 18 37 > 19 39 > 20 41 - shouldn't return a value, or should error > 21 42 - shouldn't return a value, or should error > 22 43 - shouldn't return a value, or should error ... > > ... since the last occurrence of CHAR(32) is #19. > > Do this often enough and the results for occurrences 20,21,22 vary in a > consistently inconsistent pattern right up to receiving an "Access > violation at address NNNNNNNN in module 'RBENGINE8.DLL'. Read of address > NNNNNNNN". > > 5. Change the "SGET" statement to (SGET(.vtest1,60,1)) and see what > happens: > > Param Result > 17 35 > 18 37 > 19 39 > 20 41 - which makes sense > 21 43 - which makes sense > 22 45 - which makes sense ... > > ... since the string is long enough to contain all these occurrences. > > 6. Changing the datatype of vtest to varchar produces results similar to > those of step #4. > > So it isn't just the -1 LAST OCCURRENCE parameter of your v7.6 that > produces funky results. Speaking of which, I'm getting "values" for the > -1 LAST OCCURRENCE ranging from '66' to '81372', whether the length of > the SGET is 40 or 60. Looks like junk, but I'm out of time for today. So > I'll leave it at this: > > Question: Does SGET happily digest strings of NOTE datatype? > Question: Why does SLOCP return "values" outside the boundary of the > string? > Question: Is INT the appropriate datatype for vtestint? Is that what > SLOCP is happy returning? > Question: Um...shouldn't -1 LAST OCCURRENCE return the position of the > last occurrence WITHIN the string? What's up with positions 20 plus of > CHAR(32)? > Question: Would clearing the value of vtestint between instances make > any difference? > > Ouch. My brain hurts. > > bruce chitiea > safesectors inc > > > -------- Original Message -------- > > Subject: RE: SLOCP: > > From: Dennis McGrath <[email protected]> > > Date: Mon, November 29, 2010 2:31 pm > > To: 'Bruce Chitiea' <[email protected]> > > > > > > All correct. This was designed this way to see if there were any barrier > > (correct terminology?) conditions which made a difference. One set has a > > space at position 40 and the other does not. > > > > You do have an eye for detail :) > > > > -----Original Message----- > > From: Bruce Chitiea [mailto:[email protected]] > > Sent: Monday, November 29, 2010 4:21 PM > > To: Dennis McGrath > > Subject: SLOCP: > > > > Dennis: > > > > Back after freezing/raining/snowing Thanksgiving at a Mojave Desert > > camp. Keyboard strange. > > > > To business! > > > > Haven't run yet. But first note. When expanded in R:Edit, the first > > string of Xs begins: > > > > 'XX X ...' > > > > No space between the first two Xs. Don't know if this has any bearing on > > your results. > > > > Second string of Xs all spaced. > > > > Back to you. > > > > Bruce > > > > > -------- Original Message -------- > > > Subject: RE: Kitchen-Sink Views: A "Select All Columns Except for > > > These"Capability? > > > From: Dennis McGrath <[email protected]> > > > Date: Wed, November 24, 2010 9:04 am > > > To: 'Bruce Chitiea' <[email protected]> > > > > > > > > > Bruce, > > > > > > Try this test of SLOCP with note variables > > > It seems to be buggy in my version > > > Testing for space gets weird results. > > > You should get no number > 40 especially with the -1 parameter, > > > because the string tested is 40 characters long. > > > > > > I get weird results. > > > I get different results each run. > > > > > > > > > Thanks > > > Dennis > > > > > > > > > clear all var > > > set var vTest1 NOTE= + > > > 'XX X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X' > > > set var vTest NOTE > > > set var vTest = (SGET(.vTest1,40,1)) > > > set var vSpc TEXT = (CHAR(32)) > > > > > > set var vTestInt INT = (SLOCP(.vTest,.vSpc,-1)) > > > wri .vTestInt > > > set var vTestInt INT = (SLOCP(.vTest,.vSpc,17)) > > > wri .vTestInt > > > set var vTestInt INT = (SLOCP(.vTest,.vSpc,18)) > > > wri .vTestInt > > > set var vTestInt INT = (SLOCP(.vTest,.vSpc,19)) > > > wri .vTestInt > > > set var vTestInt INT = (SLOCP(.vTest,.vSpc,20)) > > > wri .vTestInt > > > set var vTestInt INT = (SLOCP(.vTest,.vSpc,21)) > > > wri .vTestInt > > > set var vTestInt INT = (SLOCP(.vTest,.vSpc,22)) > > > wri .vTestInt > > > set var vTestInt INT = (SLOCP(.vTest,.vSpc,-1)) > > > wri .vTestInt > > > wri '-------------------------------' > > > set var vTest1 NOTE= + > > > 'X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X' > > > set var vTest NOTE > > > set var vTest = (SGET(.vTest1,40,1)) > > > set var vTestInt INT = (SLOCP(.vTest,.vSpc,-1)) > > > wri .vTestInt > > > set var vTestInt INT = (SLOCP(.vTest,.vSpc,17)) > > > wri .vTestInt > > > set var vTestInt INT = (SLOCP(.vTest,.vSpc,18)) > > > wri .vTestInt > > > set var vTestInt INT = (SLOCP(.vTest,.vSpc,19)) > > > wri .vTestInt > > > set var vTestInt INT = (SLOCP(.vTest,.vSpc,20)) > > > wri .vTestInt > > > set var vTestInt INT = (SLOCP(.vTest,.vSpc,21)) > > > wri .vTestInt > > > set var vTestInt INT = (SLOCP(.vTest,.vSpc,22)) > > > wri .vTestInt > > > set var vTestInt INT = (SLOCP(.vTest,.vSpc,-1)) > > > wri .vTestInt > > > > > > > > > return > > > > > > -----Original Message----- > > > From: Bruce Chitiea [mailto:[email protected]] > > > Sent: Monday, November 22, 2010 4:30 PM > > > To: Dennis McGrath > > > Subject: RE: Kitchen-Sink Views: A "Select All Columns Except for > > > These"Capability? > > > > > > Then, what else do you need? I'll suggest that, too. > > > > > > bruce
