Hi
I Have access query result where i see expected result in MS access itself but when I copy and paste same result, I see extra double quote in result. how do I fix this issue ? Please see attached.
This is how I see query result in my MS Access query result
<tbody>
</tbody>
When I copy and paste same result into any Text Editor (eg. Notepad), I see one extra double quote than I should be.
"catalog sql object ""_SYS_AFL"".""EML_MODEL_CONFIGURATION"": DELETE;"
"catalog sql object ""_SYS_AFL"".""EML_MODEL_CONFIGURATION"": INSERT;"
"catalog sql object ""_SYS_AFL"".""EML_MODEL_CONFIGURATION"": SELECT;"
"catalog sql object ""_SYS_AFL"".""EML_MODEL_CONFIGURATION"": UPDATE;"
"catalog sql object ""_SYS_AFL"".""FUNCTION_EXECUTION_COUNTS_CONTROL"": DELETE;"
"catalog sql object ""_SYS_AFL"".""FUNCTION_EXECUTION_COUNTS_CONTROL"": INSERT;"
"catalog sql object ""_SYS_AFL"".""FUNCTION_EXECUTION_COUNTS_CONTROL"": SELECT;"
"catalog sql object ""_SYS_AFL"".""FUNCTION_EXECUTION_COUNTS_CONTROL"": UPDATE;"
"catalog sql object ""_SYS_AFL"".""PLUGIN_ERRORS"": DELETE;"
"catalog sql object ""_SYS_AFL"".""PLUGIN_ERRORS"": INSERT;"
"catalog sql object ""_SYS_AFL"".""PLUGIN_ERRORS"": SELECT;"
"catalog sql object ""_SYS_AFL"".""PLUGIN_ERRORS"": UPDATE;"
"catalog sql object ""_SYS_TASK"".""CURRENT_VERSIONS_"": SELECT;"
"catalog sql object ""_SYS_XB"".""MESSAGING_DESTINATIONS"": SELECT;"
"catalog sql object ""_SYS_XB"".""MESSAGING_SUBSCRIPTIONS"": SELECT;"
"catalog sql object ""SYS"".""EXPLAIN_PLAN_TABLE"": DELETE;"
"catalog sql object ""SYS"".""EXPLAIN_PLAN_TABLE"": SELECT;"
"catalog sql object ""SYS"".""FULL_SYSTEM_INFO_DUMPS"": SELECT;"
I Have access query result where i see expected result in MS access itself but when I copy and paste same result, I see extra double quote in result. how do I fix this issue ? Please see attached.
This is how I see query result in my MS Access query result
Catalog_Table_View |
---|
Statement |
catalog sql object "_SYS_AFL"."EML_MODEL_CONFIGURATION": DELETE; |
catalog sql object "_SYS_AFL"."EML_MODEL_CONFIGURATION": INSERT; |
catalog sql object "_SYS_AFL"."EML_MODEL_CONFIGURATION": SELECT; |
catalog sql object "_SYS_AFL"."EML_MODEL_CONFIGURATION": UPDATE; |
catalog sql object "_SYS_AFL"."FUNCTION_EXECUTION_COUNTS_CONTROL": DELETE; |
catalog sql object "_SYS_AFL"."FUNCTION_EXECUTION_COUNTS_CONTROL": INSERT; |
catalog sql object "_SYS_AFL"."FUNCTION_EXECUTION_COUNTS_CONTROL": SELECT; |
catalog sql object "_SYS_AFL"."FUNCTION_EXECUTION_COUNTS_CONTROL": UPDATE; |
catalog sql object "_SYS_AFL"."PLUGIN_ERRORS": DELETE; |
catalog sql object "_SYS_AFL"."PLUGIN_ERRORS": INSERT; |
catalog sql object "_SYS_AFL"."PLUGIN_ERRORS": SELECT; |
catalog sql object "_SYS_AFL"."PLUGIN_ERRORS": UPDATE; |
catalog sql object "_SYS_TASK"."CURRENT_VERSIONS_": SELECT; |
catalog sql object "_SYS_XB"."MESSAGING_DESTINATIONS": SELECT; |
catalog sql object "_SYS_XB"."MESSAGING_SUBSCRIPTIONS": SELECT; |
catalog sql object "SYS"."EXPLAIN_PLAN_TABLE": DELETE; |
<tbody>
</tbody>
When I copy and paste same result into any Text Editor (eg. Notepad), I see one extra double quote than I should be.
Example Query giving this result:
SELECT Unique_Privileges.*, "catalog sql object """ & Trim([SCHEMA_NAME]) & """.""" & Trim([OBJECT_NAME]) & """: " & Trim([PRIVILEGE]) & ";" AS Statement
FROM Unique_Privileges WHERE (((Unique_Privileges.OBJECT_TYPE)="TABLE" Or (Unique_Privileges.OBJECT_TYPE)="VIEW"));
"catalog sql object ""_SYS_AFL"".""EML_MODEL_CONFIGURATION"": DELETE;"
"catalog sql object ""_SYS_AFL"".""EML_MODEL_CONFIGURATION"": INSERT;"
"catalog sql object ""_SYS_AFL"".""EML_MODEL_CONFIGURATION"": SELECT;"
"catalog sql object ""_SYS_AFL"".""EML_MODEL_CONFIGURATION"": UPDATE;"
"catalog sql object ""_SYS_AFL"".""FUNCTION_EXECUTION_COUNTS_CONTROL"": DELETE;"
"catalog sql object ""_SYS_AFL"".""FUNCTION_EXECUTION_COUNTS_CONTROL"": INSERT;"
"catalog sql object ""_SYS_AFL"".""FUNCTION_EXECUTION_COUNTS_CONTROL"": SELECT;"
"catalog sql object ""_SYS_AFL"".""FUNCTION_EXECUTION_COUNTS_CONTROL"": UPDATE;"
"catalog sql object ""_SYS_AFL"".""PLUGIN_ERRORS"": DELETE;"
"catalog sql object ""_SYS_AFL"".""PLUGIN_ERRORS"": INSERT;"
"catalog sql object ""_SYS_AFL"".""PLUGIN_ERRORS"": SELECT;"
"catalog sql object ""_SYS_AFL"".""PLUGIN_ERRORS"": UPDATE;"
"catalog sql object ""_SYS_TASK"".""CURRENT_VERSIONS_"": SELECT;"
"catalog sql object ""_SYS_XB"".""MESSAGING_DESTINATIONS"": SELECT;"
"catalog sql object ""_SYS_XB"".""MESSAGING_SUBSCRIPTIONS"": SELECT;"
"catalog sql object ""SYS"".""EXPLAIN_PLAN_TABLE"": DELETE;"
"catalog sql object ""SYS"".""EXPLAIN_PLAN_TABLE"": SELECT;"
"catalog sql object ""SYS"".""FULL_SYSTEM_INFO_DUMPS"": SELECT;"