Subject Re: [Firebird-Java] Re: How do I use quoted fields?
Author Sanjay Amatya
It's interclient. I am not sure which dialect it uses when connecting to datbase.

--- Marczisovszky Daniel <marczi@...> wrote:
> 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
>
>
>
> 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/
>
>


__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/