I don't know why it worked once with the specified character set, but if
you supply a case sensitive identifier that isn't (I think) all upper case,
you have to refer to it forevermore with quotes. I'm not sure about if it
starts out all upper case anyway.

david jencks

On 2002.04.17 16:13:27 -0400 sanjayamatya wrote:
> During conversion from Access to GDB (using sql2gdb) used the
> following option:
>
> Name map method: Use quotes (dialect 3 only)
>
> After conversion, the SQL string I can use is:
>
> This worked: select * from "Employee" //1
> This did not work: select * from Employee (note the table name
> provided is case sensisitive and is supplied exactly as in table) //2
>
> Aren't //1 and //2 both supposed to work. If //1 is the only way,
> does it mean all SQL strings in app have to be changed?
>
> Strange enought, one time during conversion I provided the option:
> character set = ISO8859_1 (in sql2gdb) and //2 did work. But next
> time I tried, the same thing didn't work????
>
> Pls advise.
>
>
>
> 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/
>
>
>
>
>