Column Name with #

[rick.duarte]

I'm trying to execute a query to a table that have columns with '#' on name but it don't return any value.

Here is the describe of the table:

Code: Select all

Column Name                    Null?    Type            
------------------------------ -------- ----------------
SESSIONID                      NOT NULL NUMBER
ENTRYID                        NOT NULL NUMBER
STATEMENT                      NOT NULL NUMBER
TIMESTAMP#                     NOT NULL DATE
USERID                                  VARCHAR2(30)
USERHOST                                VARCHAR2(128)
TERMINAL                                VARCHAR2(255)
ACTION#                        NOT NULL NUMBER

Here is the linq that I'm using:

Code: Select all

DateTime d1 = new DateTime(2010, 11, 1);
DateTime d2 = new DateTime(2008, 11, 2);

var ret = from log in ctxSiebel.AuditHistoricos
          where (log.Action == 101 || log.Action == 102)
          && log.Timestamp >= d1
          && log.Timestamp = :p__linq__0)) AND ("Extent1"."TIMESTAMP#" < :p__linq__1)

I created a test table with columns without the char '#' and everything works fine.
Do you have some workaround for this?

Best regards,

Henrique

[AndreyR]

I have sent you a test project (it works correctly with your table structure at my machine).
Unfortunately, I've got a delivery failure report.
Could you please provide us an e-mail address to send you the sample to?

[rick.duarte]

I updated my profile.
Please, send a message to m.henrique at x2sistemas.com
Thanks!

[AndreyR]

I've sent the project to another address.