r> --- In Firebird-Java@y..., Marczisovszky Daniel <marczi@d...> wrote:

>> SA> How do I use quoted fields in Firebird?
>>
>> SA> in ISQL you can do that by: SQL> select * from "tblTemp"
>>
>> SA> How can you do that from inside java app?
>>
>> SA> ResultSet rs = st.executeQuery("select * from ???;");
>>
>> ResultSet rs = st.executeQuery("select * from tblTemp");

r> Sorry, but this is possibly wrong. if you have dialect 3 database,
r> you should use quotes.

r> ResultSet rs = st.executeQuery("select * from \"tblTemp\"");

r> Or you can use DatabaseMetaData.getIdentifierQuoteString() value.

I have a dialect 3 database. Although I don't specify it on
connecting, but I'm not using " at all. Which dialect does the driver
use when I connect to a database?

Best wishes,
daniel