firebird-net-provider

[Firebird-net-provider] uppercase names for tables?

[Wotan v. K. <von...@we...>]

Hello,
I'm a c# & firebird newbie. I tried to use:
 
..
custDA.SelectCommand = new FbCommand("SELECT * FROM Persons", conn,
txn);
custDA.Fill(personDS);
....
 
-> error:
Dynamic SQL Error
SQL error code = -204
Table unknown
PERSONS
At line 1, column 15.
 
 
 
The Name of the Table is "Persons".
 
Do I have to use uppercase names for tables?
 
 
Best regards,
 
Wotan von Klass
Germany
 

Re: [Firebird-net-provider] uppercase names for tables?

[Carlos G. A. <car...@te...>]

Hello:


> custDA.SelectCommand = new FbCommand("SELECT * FROM Persons", conn, txn);
> The Name of the Table is “Persons”.

How you have created the table??, If you have created the table using

CREATE TABLE "Persons" (
	....
);

Yo need to use:

custDA.SelectCommand = new FbCommand("SELECT * FROM \"Persons\"", conn, 
txn);



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.