Re: 5.0 Engines with 4.1 tools

Since the 5.0 engine has features that are not supported by the tools if you want to use them you must use PREPARE, DECLARE, EXECUTE syntax. For example: you want the hex value for partnum in the systables supported in the 5.0 engine but not in the 4.x tools main define p_str char(50) define progvar record tabname like systables.tabname, hexnum char(20) end record let p_str = "select tabname, hex(partnum) ", "from systables ", "where tabid > 99 " prepare p_prep from p_str declare p_exec cursor for p_str open p_exec while true fetch p_exec into progvar.* if status = notfound then exit while end if ### Do Stuff end while end main