Re: Help : -1214 Error in 4GL

melogranor@flashnet.it wrote: > > Billy Wheeler wrote: > > > > Help! In a 4GL program we receive an error -1214 "Value exceeds limit of > > SMALLINT precision" in a statement like : > > SELECT * INTO record.* FROM table > > on table with NO SMALLINT columns ! > > It may be that your program record contains a SMALLINT. Could we have a code > fragment, table layouts and variable definitions? > > The record is defined "LIKE table.*" > It seems to be a memory error ... Never happened ? Yes. If you altered the table without re-compiling the modules where the LIKE keyword is used. Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+