Re: [Firebird-net-provider] Isql dont "see" the tables, its only show

[Jason W. <ja...@br...>]

Carlos,

=20

If I understand you correctly, you=92ve imported data that created =
tables and
columns in mixed case (ie Table1, Column1, etc) or all lowercase. =
Depending
on the dialect of your database, you may need to enclose table and =
column
names in quotes in your queries. See if this works in your c# =
application:

=20

select =93Column1=94, =93Column2=94, =93LongColumnName=94

    from =93Table1=94

    where etc=85.

=20

I had a similar situation where I created a mixed case column on =
accident
and had to add quotes around the column name for the queries to work.

=20

  _____ =20

From: fir...@li...
[mailto:fir...@li...] On Behalf =
Of
Carlos Valente
Sent: Sunday, April 29, 2007 9:19 PM
To: fir...@li...
Subject: [Firebird-net-provider] Isql dont "see" the tables, its only =
show

=20

=20

i import a .mdb file  with IBEasy for my Bd, but de Isql not select this
tables (tables Unknow) its apper in show tables command, but not in =
command
select, in c# is the same, but in de IBeasy and flame Robin both read =
the
tables fields and register.

=20

i have one table if your name  is in upper case its readble. I change =
the
tables name for uppercase and it's work.

but the same ocurs with the fields (column unknow) i need change all my
field names too for uppercase before import this?????

uai flamerobim and Ibeasy can see all it and edit???




  _____ =20

MSN Messenger: converse com os seus amigos online. Instale gr=E1tis.
<http://g.msn.com/8HMBBR/2749??PS=3D47575>  Clique aqui.=20