Seemingly very simple thing - commenting tables

[datanibbler]

Hi,

it seemed to be the simplest thing: Adding a comment rgd. a specific table to the load script so that later, when hovering above that table in the table_viewer, the comment will be visible. I am using the following syntax:

COMMENT TABLE [table_name] WITH '[my_text]';

It also works with that syntax for one table. For some inexplicable reason, though, when I copied this exact command under the Load_statement for another table (only changing the name of the table), it does not.

Can anybody advise me on any pitfalls this command has?

Thanks a lot!

Best regards,

DataNibbler

[Anonymous]

Hi DataNibbler,

It works fine for me for two or three table. I have tested as well.

Please test below in sample qvw file:

Test:
LOAD * Inline [
Year, Dept, PatientCount
1011,  CARDIOLOGY, 1000
1011,  SURGERY,  2000
1011,  ORTHO,  2500
1012,  CARDIOLOGY, 1000
1012,  ORTHO,  3000
1013,  CARDIOLOGY, 4000
1013,  SURGERY,  5000
1013,  ORTHO,  6000
];

COMMENT Table Test with 'This is only for testing purpose';

Test2:
LOAD * Inline [
Year1, Dept1, PatientCount1
1011,  CARDIOLOGY, 1000
1011,  SURGERY,  2000
1011,  ORTHO,  2500
1012,  CARDIOLOGY, 1000
1012,  ORTHO,  3000
1013,  CARDIOLOGY, 4000
1013,  SURGERY,  5000
1013,  ORTHO,  6000
];

COMMENT Table Test2 with 'This is only for testing purpose';

Reload and check both the table will show comments while hovering.

Best,

Skumar

[datanibbler]

Hi Skumar,

no, unfortunately it still doesn't work in my case - it's inexplicable to me because I have really copied the exact same statement.

In the case of one table (where I have a perfect key), the comment appears in the table-viewer (it is underneath the Load statement in the script (closed with a semicolon) and it uses the name I have given to the table).

In the case of the second table where I have a perfect key, I have again written (or pasted) the statement underneath the Load statement (properly closed) and inserted the name I have given to the table - and that one doesn't appear in the table-viewer.

Can anybody else think of any reason there might be for this strange behaviour?

Thanks a lot!

Best regards,

DataNibbler