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

This is a multi-part message in MIME format. --------------3BBDDBBD36A908754150C1E9 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit You can download all the ISQL manuals (in .pdf format) from the informix site at http://www.informix.com/answers/oldsite/answers/english/isql72.htm) Try this: database stores7@online_hp1 screen size 24 by 80 { order_num [f000 ] order_date [f001 ] customer_num [f002 ] ship_instruct [f003 ] backlog [a] po_num [f004 ] ship_date [f005 ] ship_weight [f006 ] ship_charge [f007 ] paid_date [f008 ] } tables orders attributes f000 = orders.order_num; f001 = orders.order_date, format = "mm-dd-yyyy", default = today, comments = "Enter the order date with format mm-dd-yyyy."; f002 = orders.customer_num; f003 = orders.ship_instruct; a = orders.backlog; f004 = orders.po_num; f005 = orders.ship_date; f006 = orders.ship_weight; f007 = orders.ship_charge; f008 = orders.paid_date; instructions after editadd editupdate of orders.order_date if (f001 < (today - 365) or f001 > (today + 365)) then begin comments bell reverse "Wrong date" let f001 = today nextfield = f001 end 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). > > Thanks in advance > > Niranjan Kolekar > IBM,Austin --------------3BBDDBBD36A908754150C1E9 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Manuel Andres Daponte Santiago Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Manuel Andres Daponte Santiago n: Daponte Santiago;Manuel Andres org: GM Group adr: MSC #54, Montehiedra Town Center;;9410 Los Romeros Ave.;San Juan;PR;00926;USA email;internet: mdaponte@prtc.net title: Systems Consultant tel;work: +1 (787) 7514343 tel;home: +1 (787) 2921107 note: ICQ 12214968 x-mozilla-cpt: ;0 x-mozilla-html: FALSE version: 2.1 end: vcard --------------3BBDDBBD36A908754150C1E9--