--- 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");

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

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

Or you can use DatabaseMetaData.getIdentifierQuoteString() value.

Best regards,
Roman Rokytskyy