At 03:31 PM 16-12-02 +0000, you wrote:

>The following:
>lastExport = dbConn.createStatement().executeQuery(
> "select \"PacketID\" from \"FiBRE$PacketsTransferred\"");
>lastExport.next();
>previousExportID = new Long(lastExport.getLong("PacketID"));
>
>Gives me the error 'Column Unknown PACKETID'. It used to work when the
>colum was called PACKETID, but now I have made it mixed case, and edited
>all the code in my program appropriately. I also tried:

When you changed it, did you do it with a statement like this:

alter table aTable alter column PACKETID to "PacketID";

i.e. if you didn't double-quote the identifier in the redeclaration, it
won't have changed anything.

Helen