Re: *** HELP !!!

Juraj Buma wrote: > Hi everybody! > > I'm using Informix-4GL version 7.20.UD7 on Linux and my problem is: > > SELECT db1:table.string[2, 4] > FROM db1:table > ... > > UNION > > SELECT db2:table.string[2, 4] > FROM db2:table > ... > > and during compilation folowing error occured in the first SELECT: > > db1:table.string[2, 4] > |_______________^ > | > | A grammatical error has been found on line 112, character 29. > | The construct is not understandable in its context. > | See error number -4373. > > What's wrong? Cannot select a part of string when using database name > prefix? > Please help !!! > > Juraj I am not that familiar with Informix 4GL compiler. If the compiler should allow you the select statement (I do not see why not) then you may find that the error is in a few line before where the compiler is indicating. Informix compiler has never been very accurate about the error line number on which the -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other RDBMS such as Oracle. Hydra 4GL Compiler Compile once, run everywhere Phoenix Windows GUI. Chimera Java GUI The only GUI you will ever need... Arachne Web Technology For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------