Re: displaying substring in a form, can I ??

al-jouhar <adel@q8petroleum.com.kw> writes: >I can't displat substring in a form >f01=table.column[2,10]; >instructions >screen record screen-rcd [4] (table.column) >giving me error no -2950 >or, >screen record scr_rcd [4] (table.column[2,10]) >giving me error no -2018 Using 4GL, you could use FORMONLY in the perform screen, and do the subscripting in the 4GL file. Using sperform, your best bet is probably creating a VIEW that selects the substring and then refer to the view in the perform file. See View in the Guide to SQL manuals or let me know if you need details on either of these approaches. ======================================================================= Dennis J. Pimple dennisp@informix.com Opinions expressed Senior Consultant -------------------- are mine, and do not Informix Software Inc Voice: 303-850-0210 necessarily reflect Denver Colorado USA Fax: 303-779-4025 those of my employer.