HI ....I tried to explain the code a little better. I just moved my 7.6 app to a new Win 7 computer and now some blocks of code run differently. I am using Ver 7.6.11.31014, it is different then my old computer, I updated versions to get a new license to install this on the new computer.
This block of code use to work in Vista, if the Browse command failed the SQLCODE would be 100 and the Pause command would work. Now using Win7, no changes in the code.... the SQLCODE = 0 and I go to the bottom block of code at the bottom of the page ** , then it skips the IF SQLCODE = 100, because it is 0 I have no earthly clue what to look for, Thanks Marc BROWSE USING aptnext + WHERE (cust1 = .vcust1 OR cust2 = .vcust1 OR cust3 = .vcust1 + OR cust4 = .vcust1) AND aptdate > .#DATE -- the code below ** pops up here and I do not know where it comes from? IF SQLCODE = 100 THEN PAUSE 1 USING 'Needs to make an Apt' CAPTION 'No APts set' ENDIF RETURN ** this pops up after the Browse command above SET VAR #NOW DATETIME = NULL SET VAR Vcap1 TEXT = NULL SET VAR RBTI_FORM_FORMNAME TEXT = NULL return
