Carlos,
If I understand you correctly, youve 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:
select Column1, Column2, LongColumnName
from Table1
where etc
.
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.
_____
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Carlos Valente
Sent: Sunday, April 29, 2007 9:19 PM
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] Isql dont "see" the tables, its only show
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.
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???
_____
MSN Messenger: converse com os seus amigos online. Instale grátis.
<http://g.msn.com/8HMBBR/2749??PS=47575> Clique aqui.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
