Re: How to put validation/code in perform file using isql ?

Jonathan Leffler wrote: > On Thu, 3 Sep 1998 n_kolekar@hotmail.com wrote: > > Hey Folks, Is there a way to put code in instruction section of the > > perform file generated by isql? We are doing input using the perform > > screen using ISQL. So we want to validate the data in minimal before it > > goes into the database. Example: My valid date range is from 80 to 99. > > So if the user enters any other dates, I want him to re-enter the date. > > And I want this to be done using ISQL only (not 4gl). > > You can create a custom version of Perform with the cperf script, and you > can add validation functions which can be called in the instructions > section of the form. You could put in your Perform screen: f001 = tabname.date_fld, include = (80 to 99); Or did you mean that the valid dates are '1/1/80' to '12/31/99' (using MDY2/ format) ? I don't know if INCLUDE handles dates, but you could try include = ('1/1/80' to '12/31/99') Sorry, I don't have I-SQL, so I can't test this (life's gotten so tough). I'd be curious to know whether it works, though. June -- june_t@hotmail.com Lost in the wilds of Palo Alto, living on M&M's