----- Original Message ----- From: "Dan Champion" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 18, 2002 4:20 AM Subject: Re: program failure since upgrade
> Ok, > I have used the code that was posted (copied below to save looking > back) It still does not skip to that field. It is getting at least to the > recalc variables as the "succsessfully inserted data" does show on the form. > The thing I wonder about is. The variable invbin1 is the SAME as the > field name. Mabye the trouble is that it thinks I am trying to skip to a > variable rather than the field. It is strange that the same skip to > command works earlier in the program. > Any other ideas? The skip may be the same, but there is a difference in how you set the variable. It works when you explicitly say SET V invbin1 INTEGER = and not when you say SET V invbin1 = Could that be the trouble? > > Thanks. > > > $COMMAND > updates > -- test the variables > -- insert the data to the matlist table > -- > IF invqty = 0 THEN > SET V invstatus TEXT = "Retry" > ELSE > SET ERROR V inverror > -- insert data > INSERT INTO matlist jobnum, mldate, qty, partnum, discript, + > price, product, margin, emp_mult + > VALUES (.invjobnum, .invmldate, .invqty, .invpartnum, .invdescript, + > .invprice, .invproduct, .invmargin, .invempmult) > IF inverror = 1 THEN > SET V invstatus TEXT = "Unsuccessful Insert" > ELSE > SET V invstatus TEXT = "Successfully inserted Data" > ENDIF > ENDIF > SET V invqty REAL = NULL > SET V invpartnum TEXT = NULL > SET V invdescript TEXT = NULL > SET V invprice CURRENCY = 0 > SET V invproduct TEXT = NULL > SET V invbin1 = NULL > RECALC VARIABLES > SKIP TO invbin1 > RETURN > > > > Dan Champion > P.O. Box 223 > Grandville, MI. 49428-0223 > www.championsolutions.net > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
