Oracle Table Adapter Querry Wizard Error


G

Guest

I am trying to generate a new DataTable in Visual Studio 2005 using the .Net
provided Oracle Client.

Here is the querry I am trying to use:

SELECT A.OWNER, A.CONSTRAINT_NAME, A.CONSTRAINT_TYPE, A.TABLE_NAME,
A.INDEX_NAME, B.TABLE_OWNER, B.COLUMN_NAME
FROM SYS.DBA_CONSTRAINTS A INNER JOIN SYS.DBA_IND_COLUMNS B ON
A.INDEX_NAME = B.INDEX_NAME
WHERE (A.CONSTRAINT_TYPE = 'P') AND (A.OWNER = 'RYAN')

Everything works fine in the Query Builder, however, when I choose finish in
the Table Adapter Configuration Wizzard I get the following error:

Syntax Error: Expecting ',' or 'WHERE' (etc.) after table alias.

Everything looks right. How do I fix this?

Ryan M. Hager
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top