next »

[Michael L.]

I was trying to debug a call to a CRC function we use to validate data and was trying to see what my integer was in hexadecimal prior to being passed to the C function, and to my surprise, my program would not compile due to HEX() function being undefined?

Was this function removed from Genero/BDL?

If it has been removed/deprecated, is there a list of all the 4GL functions that have been deprecated?

I am using to Genero 2.11.03 on AIX 5.3.3

Oh, BTW, good job on setting up this forum!  This has been long overdue!

-Michael Laporte
Versaterm Inc.

[Sebastien F.]

Michael,

I think HEX() has never been a 4gl function, it's an Informix SQL function:

main
   define h varchar(20)
   database test1
   select hex(123) into h from systables where tabid = 1
   display h
end main

Following line does not compile with Informix 4gl 7.32:

   let h = hex(123)

Are you sure that this function was not implemented as a C extension by yourself?

A list of de-supported functions can be found here:

https://4js.com/techdocs/genero/fgl/devel/DocRoot/User/BuiltInFunctions.html#DESUPLIST

Seb

[Michael L.]

You're right, sorry for the mix up!   

My book had this function under the title of Built-in Functions and I automatically assumed 4GL functions, but reading further I can see that it was referring to "... functions that can be used in Informix's SQL.".  My bad  :( .

Thanks also for the link!

-Michael Laporte
Versaterm Inc.

[Scott N.]

There is a dec2hex 4GL function available either in the binary package from IIUG (http://www.iiug.org/software/index_I4GL.html) or as part of the Gt toolkit on SourceFourJs (http://code.google.com/p/sourcefourjs/).

--
Scott Newton