Unable to select all the rows when creating a Database Schema.

[Rin]

Hi,
For some odd reason am not able to select all the rows when creating a Database Schema.

I have checked with our DBA and it’s not a permission issue. I can only select a singe row, the rest can not be selected.

I have added a screenshots to demonstrate the issue.

Not sure why?

Thanks.

Attachments:

You must be logged in to view attached files.

Topic

[John Mercogliano]

I would say it’s the dashes.  In sql you need to enclose a column name in brackets when there are special characters so the jdbc and/or the gui are probably having issues.

I’ve never had to do this, but you should be able to create a schema from sql and manually add the fields to the select statement with brackets.

I would tell you dba not to use dashes 😉

 

• This reply was modified 1 week, 3 days ago by John Mercogliano.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[Rin]

Thanks John.

[Rin]

This has done the trick.

Thank you.

[John Mercogliano]

Excellent glad that worked.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[Author]

Replies