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.' The best I have so far is: st = 'SELECT FILE @ID BY.DSND @ID' st<-1> = 'LIST ONLY FILE SAMPLE 1' exec st capturing cap maxId = trim(cap<4>) Any other ideas? Cheers, Stuart _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
