I think I have found the problem. SQLInform copies to Windows clipboard in CF_UNICODETEXT format. When I manually copy from the SQLInform window by selecting with mouse and pressing ctrl-C, the text is copied to the clipboard in CF_TEXT format. Perhaps there could be an option in SQLInform to copy using CF_TEXT by default? I have a workaround so it's not terribly important. Thank you for looking into it!
Hi @guido, thanks for trying, I really do appreciate it. Unfortunately it appears that the utf button performs identically to the existing Copy SQL 2 Clipboard button and the rtf button does not place usable text on the clipboard at all (it does not result in a paste option being available in Access). I used the Nirsoft InsideClipboard utility at https://www.nirsoft.net/utils/inside_clipboard.html to compare the results of all three copy to clipboard operations (the original Copy SQL 2 Clipboard button, the utf button, and the rtf button) plus simply copying the text from SQLInform results box using ctrl-C, and copying from Notepad using ctrl-C:
1. Using the original Copy SQL 2 Clipboard button (results in UTF in the clipboard):
2. Using the utf button (identical result to clicking the original Copy SQL 2 Clipboard button - still results in UTF in the clipboard):
3. Using the rtf button:
4. Copying directly from SQLInform results window using ctrl-C (this places a lot of things on the clipboard but works with a simple ctrl-V to paste into Access SQL window)
5. Copying from Notepad using ctrl-C (also works with a simple ctrl-V to paste into Access SQL window)
@admin Hello Guido, the new copy button works well for MS Access. Rather than confuse other users perhaps the preferred copy method could be implemented as a general setting rather than as an extra button? Just a thought. It seems to work well and thank you very much for your work on this issue!
