Re: Informix and JDBC

Posted in 1998

Chris Dornsife — Thu, 17 Dec 1998 10:56:35 -0800 — source: Informix-list mailing list archive (1991-1998)

>The statement >SELECT MAX(research_material.paper_id) FROM research_material I am just guessing, try this.... Your driver cannot find paper_id because it returned from an function as an expression so you should provide an alias like: SELECT MAX(research_material.paper_id) max_paper_id FROM research_material then extract the value from max_paper_id. I hope this works for you.