Re: Generate data in Forms

Hi, try to use select field2||field1[5,7], it will work, but only if the values in field1 have the same length. If not than you need to use SPL for that. julia QueriX 4GL / Mehdi wrote: > Dirk Emmermacher wrote: > > > Hello list! > > I've got oonly a small problem. I try to get data from 2 fields in > > another field. > > Field 1 contains the value "0101001" > > Field 2 contains the value "0811" > > I want to get data from fiels 2 and the last three characters from field > > 1. The data in field should > > have the value "0811001". > > > > I'm using isql on a 4.00.UH2 standard engine. > > > > Is there a chance to get these data?? > > > > Thanx in advance. > > > > Dirk Emmermacher > > Lowersaxony gymnastics federation > > Easy in 4GL, I am not sure about isql, it is only a query tool. > -- > Compliments of QueriX > -------------------------------------------------------------------------------------------------- > > QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other > RDBMS such as Oracle. > > Hydra 4GL Compiler (Compatible with I4GL) Compile once, run everywhere > Phoenix Windows GUI. (Front End to 4GL) > Chimera Java GUI The only GUI you will ever need... (Front End to 4GL) > Arachne Web Technology (Front End to 4GL on the Web & HTML Report Generator) > > ESQL/C Compiler > > For more details visit: http://www.querix.com/ > ---------------------------------------------------------------------------------------------------