Re: Can't select USER.

There is *no* *aberration* in the behaviour of 7.30.UC1 that would surprise me. It has *major* "undocumented features" (have you tried pressing ESCAPE yet?)-: Upgrade to a later release or revert to 7.20.UD7 (or later). From: Kevin Golding <kgolding@webcom.com.au> > >I am trying to select the USER into a 4gl program, as in (example taken >from Informix 4GL reference manual) .... >function get_user() > define uid like sysusers.username > select USER into uid from systables > where tabname = "systables" > return uid >end function > >But the select statement falls over with the error ... >4GL run-time error number -9971 >Cannot determine the return types of a query or return types are >inconsistent. > >The code used to run on ver. 4.13.UD3 of the 4GL RDS, but now that we >have upgraded to 7.30.UC1, it no longer runs. >Has anybody else experienced the same problem? >Does anybody have a workaround? > >I am running 4GL RDS 7.30.UC1 with Dynamic Server 2000 9.20 on RedHat >6.2 > >Thanks >Kevin > _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.