Table Definition in Side Menu

I created the following table via the following script in SQLPro Studio:

CREATE TABLE MOLMAN.AA (
    JOB               NVARCHAR2(8)  NOT NULL,
    RUN               NVARCHAR2(2)  NOT NULL,
    SAMPLE_NAME       NVARCHAR2(8)  NOT NULL,
    SAMPLE_POSITION   NVARCHAR2(1),
    METHOD_TYPE       NVARCHAR2(8)  NOT NULL,
    DATA_FILE         NVARCHAR2(16) NOT NULL,
    INJ_VOL           NUMBER(*,0),
    ACQ_TIME          NVARCHAR2(32) NOT NULL
);

The attached image shows the column definitions are doubled in size in the side menu, but when I  run Script as -> Create To it shows the correct definitions:

9replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • I downloaded v2020.08 (Build 110632) just to see if that took care of the issue and it did not.

    I dropped the table and used the script generated by the Script as -> Create To  command to re-create table AA and got the same result where the side menu shows a doubling of the nvarchar2 definitions.

    If I change some of the fields to VARCHAR2 the definitions are correct in the side menu.  It just seems to be NVARCHAR2 fields.

    Obviously this is not 

    Like
    • Chris Wolcott hey Chris. Sorry, I completely missed your post! This will be an easy fix - I'll get it sorted for the next build. FYI I will be shutting this forum down soon as I'm finding it very difficult to track issues/requests here. Please use https://github.com/hankinsoft/SQLPro/issues for future items. Sorry about that!

      Like
  • Not a problem.  I have book marked the GitHub issues and will post any issues there.

    Like
    • Chris Wolcott fixed for the next build (should be available early next week).

      Like
    • Kyle Hankinson are you using the App Store version of the app? This has been updated.

      Like
  • I typically download from your site.

    Like
  • We are all good

    Like 1
Like Follow
  • Status Answered
  • 13 days agoLast active
  • 9Replies
  • 24Views
  • 2 Following