Also, what dialect is the database 1 or 3? If I remember correctly only 3
uses mixed case.

Rick

----- Original Message -----

> What version of JDBC driver do you use?
>
> Thanks!
> Roman Rokytskyy
>
> --- In Firebird-Java@yahoogroups.com, "Robert (Jamie) Munro" <rjmunro-
> egroups@i...> 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:
> >
> > previousExportID = new Long(lastExport.getLong("\"PacketID\""));
> >
> > Which gave the error 'Column Unknown "PACKETID"'. Why is it being
> forced
> > upper case? Is there a way to access lower case stuff by name? I
> have
> > uninstalled Interserver, so I don't know what that did. I know I
> can use
> > getLong(1), and I will do that temporarily, but I prefer to use
> names to
> > make it clear which field I mean.
> >
> > Robert Munro
> > --
> > Robert (Jamie) Munro - IT department
> > Viva Network - Helping 'children at risk'
> > by linking & enhancing the Christian Response
> > http://www.viva.org/
> > PO Box 633, Oxford, England, OX2 0XZ
> > Tel : +44 1865 320131 Switchboard : +44 1865 320 100
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>