You could try: SELECT FILE READLIST IDS ELSE ABORT MAX.ID = MAXIMUM(IDS)
rex On Fri, May 27, 2011 at 6:40 AM, Wols Lists <antli...@youngman.org.uk> wrote: > On 27/05/11 07:03, Boydell, Stuart wrote: >> Just wondering if anyone has a neat trick for picking up the highest ID from >> a file. Where the file ID is an integer. >> >> With UVSQL I would SELECT MAX(@ID) FROM TABLE; - however, the program I need >> to do this within has the file (table) open and if I try to execute it >> returns the error 'Non-SQL re-entrant query calls are not allowed.' _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users