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 3 months, 2 weeks 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

[Rin]

Hi John,

Some is odd again!
I am unable to select all the column names in one of the table but can on the other?
Please refer to my screenshots to see the difference.

 

Attachments:

You must be logged in to view attached files.

[John Mercogliano]

Rin,

Nothing looks out of place here.  I would recommend to resync the database schema to make sure nothing has changed.  Then try and create a schema using sql with some of the columns that won’t select using brackets. I’ve never had an issue like this so just reaching at this point.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[Rin]

It didn’t make any difference.

[Author]

Replies