Views from SQl

[mdr]

I have some views in my SQL database, but when i try to connect to them in the tables dialogue box, i can only see catalogue tables on the right, nothing on the left.

Is there any way that i can get to see the views?

Help says that i should retrieve tables, but i cant find a way to do this.

Thanks in advance for any help.

 

[esselinj]

Go to Impromptu Options and remove the tick on the General tab before the line: Retrieve database tables when editing catalog tables. This will provide you with a button in the Tables dialog box. Once you push this button you can select what content of the database you can see (tables, views, synonyms).

Cheers

Jack