Start a new topic

Dragging table into the SQL window

[This topic is migrated from our old forums. The original author name has been removed]

Tried dragging a table (ett_RefDesk) into the SQL editor from the Connections tree, selected SELECT for 'Scripting Type'. This is what ended up in the SQL commander: SELECT regionID, deskCode, deskDescr, creDate FROM {color:#ff0000}*nullnull*{color}{color:#000000}e{color}tt_RefDesk

[This reply is migrated from our old forums.]

Re: Dragging table into the SQL window
Alex, Should have mentioned that the null string issue is not fixed in 9.0.3. Only the drag and drop configuration to either launch the scripting feature or insert object name and drop in editor. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Dragging table into the SQL window
Roger It is blank (I mentioned it in Dec 4, 2012 8:08 AM post) Thanks
[This reply is migrated from our old forums.]

Re: Dragging table into the SQL window
Alex, Show Null As can now be set to an empty string in 9.1.3. http://www.dbvis.com/download/ Regards Roger