Title: [Suggestion] Warn when copying row id column? · Issue #1094 · sqlitebrowser/sqlitebrowser · GitHub
Open Graph Title: [Suggestion] Warn when copying row id column? · Issue #1094 · sqlitebrowser/sqlitebrowser
X Title: [Suggestion] Warn when copying row id column? · Issue #1094 · sqlitebrowser/sqlitebrowser
Description: Details for the issue I guess this should be more in a Wiki page than in the application, but its a weird issue, and users aren't going to find/look for it on the Wiki. Thought I'd mention it here first before creating a Wiki entry... Wh...
Open Graph Description: Details for the issue I guess this should be more in a Wiki page than in the application, but its a weird issue, and users aren't going to find/look for it on the Wiki. Thought I'd mention it here ...
X Description: Details for the issue I guess this should be more in a Wiki page than in the application, but its a weird issue, and users aren't going to find/look for it on the Wiki. Thought I'd mention ...
Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/1094
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[Suggestion] Warn when copying row id column?","articleBody":"### Details for the issue\r\n\r\n\u003c!--\r\n\r\nThanks for coming here to report an issue. :)\r\n\r\nPlease describe it in this section, fill out the correct check boxes\r\nbelow with an \"x\", then click the \"Submit new issue\" button at the bottom\r\n\r\n-->\r\n\r\nI guess this should be more in a Wiki page than in the application, but its a weird issue, and users aren't going to find/look for it on the Wiki. Thought I'd mention it here first before creating a Wiki entry...\r\n\r\nWhen copying rows of data (for duplication), it might be common practice to select the rows via using the number column (not necessarily the row_id column, which is usually hidden).\r\nHowever, when doing this, this copies the row_id column, which means you can't paste it into new cells (as the range is now mismatched - clipboard contains the hidden column which may or may not be what you've selected to paste into)\r\n\r\nIf you *do* select the rows using the same method as copying, DB4S obviously moans at each paste, as it can't paste the row_id column.\r\n\r\n\r\n\r\nIf you've pasted 100 records, you're in for a bad time clicking that dialog box! ;)\r\n\r\nIf you just paste into an empty cell, then the row_id is pasted, which isn't what you want, if the row_id column is hidden.\r\n\r\nThis is all database-dependant and 'depends on what the user clicks on', but I think if the row_id column is hidden (default) and the user has selected rows via the number column, then when they copy cells, DB4S should say, \"The row_id column has also been copied. This may cause issues if you attempt to paste it back into DB4S\" or some such warning.\r\n\r\nCopying the row_id might be useful/required, but not if you're wanting to paste it back into DB4S.\r\n \r\n### Useful extra information\r\n\r\n\u003c!-- The info below often helps, please fill it out if you're able to. :) -->\r\n\r\n#### I'm opening this issue because:\r\n\r\n- [ ] DB4S is crashing\r\n- [ ] DB4S has a bug\r\n- [x] DB4S needs a feature\r\n- [ ] DB4S has another problem\r\n\r\n#### I'm using DB4S on:\r\n\r\n- [x] Windows: ( _version:_ ___ )\r\n- [ ] Linux: ( _distro:_ ___ )\r\n- [ ] Mac OS: ( _version:_ ___ )\r\n- [ ] Other: ___\r\n\r\n#### I'm using DB4S version:\r\n\r\n- [ ] 3.10.0\r\n- [x] 3.9.200-beta*\r\n- [ ] 3.9.1\r\n- [ ] Other: ___\r\n\r\n#### I have also:\r\n\r\n- [ ] Tried out the latest nightly version: https://github.com/sqlitebrowser/sqlitebrowser#nightly-builds\r\n- [ ] Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20\r\n","author":{"url":"https://github.com/chrisjlocke","@type":"Person","name":"chrisjlocke"},"datePublished":"2017-08-21T11:27:39Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1094"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:1e4e0c72-f213-5059-68cc-1c963be22a1a |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | BED8:1D094D:19B5E:231B9:6AFD3B75 |
| html-safe-nonce | e2e12a53095cecda2ad697a7ddc9116d051b9bf9678bb652866d857e4b1db7c0 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCRUQ4OjFEMDk0RDoxOUI1RToyMzFCOTo2QUZEM0I3NSIsInZpc2l0b3JfaWQiOiI2Njk1MjA2OTMyMTkxMTk4MDY5IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0= |
| visitor-hmac | 5d33d14e4e329a7636bfa1d8f6b05914288c6c370102b2066a095d6b9eff925e |
| hovercard-subject-tag | issue:251630016 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlitebrowser/sqlitebrowser/1094/issue_layout |
| twitter:image | https://opengraph.githubassets.com/bbeb6ef19f893c151408aa30847111165519e739a1c1d354fa460404f378999a/sqlitebrowser/sqlitebrowser/issues/1094 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/bbeb6ef19f893c151408aa30847111165519e739a1c1d354fa460404f378999a/sqlitebrowser/sqlitebrowser/issues/1094 |
| og:image:alt | Details for the issue I guess this should be more in a Wiki page than in the application, but its a weird issue, and users aren't going to find/look for it on the Wiki. Thought I'd mention it here ... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | chrisjlocke |
| hostname | github.com |
| expected-hostname | github.com |
| None | bdbacc25b921224ff0befcb9e629560a1255be51aec9991d6e3f95b5e9151474 |
| turbo-cache-control | no-preview |
| go-import | github.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git |
| octolytics-dimension-user_id | 7454271 |
| octolytics-dimension-user_login | sqlitebrowser |
| octolytics-dimension-repository_id | 19416551 |
| octolytics-dimension-repository_nwo | sqlitebrowser/sqlitebrowser |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 19416551 |
| octolytics-dimension-repository_network_root_nwo | sqlitebrowser/sqlitebrowser |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 556dd37bb0aceffb25724e151b5d858b3265b40b |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width