Toad World® Forums

Quick question about Object Explorer

Quick question about Object Explorer

RE: Quick question about Object Explorer

Alex, I want to revisit this as well, the behavior of the object explorer click
on the order of the fields I understand, however it will not reset back to the
original order in the Detail View of the columns, meaning the code is not
re-acting in the same manner…

IMHO, these two features OE and DeTViewer should mirror each other in action.
Meaning click one for Ascending, click two for descending, click three for
declared order in the detail view of a table or view.

Note: I am now bringing this to toad-SS discussion.

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image002.jpeg

Alex, I want to revisit this as well, the behavior of the object explorer click
on the order of the fields I understand, however it will not reset back to the
original order in the Detail View of the columns, meaning the code is not
re-acting in the same manner…

IMHO, these two features OE and DeTViewer should mirror each other in action.
Meaning click one for Ascending, click two for descending, click three for
declared order in the detail view of a table or view.

Note: I am now bringing this to toad-SS discussion.

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image006.png

Alex, I want to revisit this as well, the behavior of the object explorer click
on the order of the fields I understand, however it will not reset back to the
original order in the Detail View of the columns, meaning the code is not
re-acting in the same manner…

IMHO, these two features OE and DeTViewer should mirror each other in action.
Meaning click one for Ascending, click two for descending, click three for
declared order in the detail view of a table or view.

Note: I am now bringing this to toad-SS discussion.

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image004.png

Alex, I want to revisit this as well, the behavior of the object explorer click
on the order of the fields I understand, however it will not reset back to the
original order in the Detail View of the columns, meaning the code is not
re-acting in the same manner…

IMHO, these two features OE and DeTViewer should mirror each other in action.
Meaning click one for Ascending, click two for descending, click three for
declared order in the detail view of a table or view.

Note: I am now bringing this to toad-SS discussion.

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

Alex, I want to revisit this as well, the behavior of the object explorer click
on the order of the fields I understand, however it will not reset back to the
original order in the Detail View of the columns, meaning the code is not
re-acting in the same manner…

IMHO, these two features OE and DeTViewer should mirror each other in action.
Meaning click one for Ascending, click two for descending, click three for
declared order in the detail view of a table or view.

Note: I am now bringing this to toad-SS discussion.

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image005.png

Alex, I want to revisit this as well, the behavior of the object explorer click
on the order of the fields I understand, however it will not reset back to the
original order in the Detail View of the columns, meaning the code is not
re-acting in the same manner…

IMHO, these two features OE and DeTViewer should mirror each other in action.
Meaning click one for Ascending, click two for descending, click three for
declared order in the detail view of a table or view.

Note: I am now bringing this to toad-SS discussion.

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image003.png

Alex, I want to revisit this as well, the behavior of the object explorer click
on the order of the fields I understand, however it will not reset back to the
original order in the Detail View of the columns, meaning the code is not
re-acting in the same manner…

IMHO, these two features OE and DeTViewer should mirror each other in action.
Meaning click one for Ascending, click two for descending, click three for
declared order in the detail view of a table or view.

Note: I am now bringing this to toad-SS discussion.

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image001.gif

Agreed. I’ve created CR84357.

BTW, I see the same behavior in 5.0

regards,

Alexander Maximov
image003.png

Agreed. I’ve created CR84357.

BTW, I see the same behavior in 5.0

regards,

Alexander Maximov
image001.gif

Agreed. I’ve created CR84357.

BTW, I see the same behavior in 5.0

regards,

Alexander Maximov

Agreed. I’ve created CR84357.

BTW, I see the same behavior in 5.0

regards,

Alexander Maximov
image004.png

Agreed. I’ve created CR84357.

BTW, I see the same behavior in 5.0

regards,

Alexander Maximov
image002.jpeg

Agreed. I’ve created CR84357.

BTW, I see the same behavior in 5.0

regards,

Alexander Maximov
image006.png

Agreed. I’ve created CR84357.

BTW, I see the same behavior in 5.0

regards,

Alexander Maximov
image005.png

Thanks, Where I am now uses View quite extensively, so if the table underneath
is updated then none of the objects that rely on the view are effected, meaning
HankTblV00, HankTblV01, could be referenced in the view as just HankTbl.

Very slick use of view, probably the best use I ever run across. Will go into
more detail if needed, but the column name need here is an absolute.

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image006.png

Thanks, Where I am now uses View quite extensively, so if the table underneath
is updated then none of the objects that rely on the view are effected, meaning
HankTblV00, HankTblV01, could be referenced in the view as just HankTbl.

Very slick use of view, probably the best use I ever run across. Will go into
more detail if needed, but the column name need here is an absolute.

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image001.gif

Thanks, Where I am now uses View quite extensively, so if the table underneath
is updated then none of the objects that rely on the view are effected, meaning
HankTblV00, HankTblV01, could be referenced in the view as just HankTbl.

Very slick use of view, probably the best use I ever run across. Will go into
more detail if needed, but the column name need here is an absolute.

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image003.png

Thanks, Where I am now uses View quite extensively, so if the table underneath
is updated then none of the objects that rely on the view are effected, meaning
HankTblV00, HankTblV01, could be referenced in the view as just HankTbl.

Very slick use of view, probably the best use I ever run across. Will go into
more detail if needed, but the column name need here is an absolute.

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image002.jpeg