At 15:41 16/12/2002 -0000, you wrote:

>What version of JDBC driver do you use?

RC1a

>--- 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/
>
>
>
>

--
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