cancel
Showing results for 
Search instead for 
Did you mean: 

Not getting the records from Access database

Former Member
0 Kudos

Hi All,

Iam creating a universe based on Access database. I am able to view the data from all the tables except one table. When i try to view the data there is one error message "Syntax error in from clause, State: 37000". Everything is ok at database side. What does this error means?

Please help me on this.

Thanks.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hey here,

It's really fiddly creating them - you have to associate each object with the "table" using the tables button in designer.

Thank You!!

Sent from iPhone

Former Member
0 Kudos

Hi BOCP,

Thanks for your reply. I have resolved my issue. Actually my issue was, I have a table "Date" in universe which was created in Access database, when i tried to view the Date Table values in Universe i was getting that Syntax error in From clause message. I came to know that Date is a keyword or predefined table in WebI & it wont accept that word as a user defined Table. So i renamed that table in Access and Universe. Now my issue was solved.

Thanks,

Swati.

Former Member
0 Kudos

Good work Swathi.

In general, we will get that error coz of what I posted.

Thank You!!

Sent from iPhone