I've found a workaround by myself. (-: Only upper-case columns are visible this way. Thank you. Kind Regards / C ????????? Dmitry Bezhenar
________________________________ From: Bezhenar, Dmitry Sent: Tuesday, January 30, 2007 8:57 PM To: 'arslist@ARSLIST.ORG' Subject: Error while creating a view form (ORA-00904) Hello List, I've set up a connection between ORACLE and MS SQL server using tg4msql. Now I'm trying to create a view form directly on the MS SQL table ([EMAIL PROTECTED]) After clicking on the "LOAD" button it shows me the list of fields and I choose the unique identifier. When I click the "CREATE" button it shows me the following error - Failure during SQL operation to the database : ORA-00904: "ROLEID": invalid identifier (ARERR 552). After switching on the sql logging I found an SQL statement, which fires this error - CREATE VIEW T3294 (C1) AS SELECT RoleID FROM [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> I tried to input the same statement using SQL'plus - it really fires Oracle error - ORA-00904: "ROLEID": invalid identifier At the same time if I type RoleID in quotes it works - SELECT "RoleID" FROM [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Anybody knows a workaround for this. Thank you. PS: I need this view form in order to be able to modify data in MS SQL tables. PPS: Our environment: ARS 6.3.16 on Oracle 9.2.0.7 on MS Windows 2003 + MS SQL 2000 (8.0.818) Kind Regards / C ????????? Dmitry Bezhenar _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
