Thanks Roman. But see my earlier email, it means changing a lot of code. More than a
1000 classes worked on by 100 developers. I was researching on replacing the Access
database with Firebird. But encountered problems during conversion, as SQL2GDB
converted my password field to passwordcol. Hence the problems of quoted fields etc.


Thanks again.

--- rrokytskyy <rrokytskyy@...> wrote:

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