At 14:15 16/12/2002 -0500, you wrote:

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

Dielect 3. The field exists in the database. I can see it with IBOConsole
etc. I can access it by number. I just can't access it by name.

Robert Munro

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