Browse Data Copy function doesn't actually copy Date/Time to Clipboard

[techie31]

Details for the issue

What did you do?

Open Browse Data on table with field of DATE type that contains valid date information.
Hit Control-A to highlight all records
Right-click and choose Copy or Copy with Headers

What did you expect to see?

When pasted anywhere, I expected to see the Date information from each record

What did you see instead?

Nothing, it inserted tabs to separate the field, but no actual field data.

Useful extra information

DB4S v3.13.1 [built for x86_64-little_endian-llp64] on Windows 10 Version 2009 (winnt/10.0.19045) [x86_64]
using SQLite Version 3.46.1
and Qt 5.15.2

[chrisjlocke]

with field of DATE type

Sqlite doesn't have a date type. Only text, integer, numeric and blob.

[itdept936]

So, I get that. Not really the point of the bug report. Just referencing the terminology used by the program itself:

If I select one or select all, either way, when I Copy, then Paste the selected data, it does not include the characters displayed on the screen that represent a Date and Time to the user:

In addition, if I simply select ANY ONE CELL that holds THIS TYPE OF DATA (whatever we want to call it) and Copy/Paste, nothing is pasted.

(As a side note, but entirely different issue, if I click on the cell, as if to edit it, a ZERO (0) is displayed, not the data that is actually there.)

[chrisjlocke]

Not really the point of the bug report

Apologies. I thought as its not a valid data type, DB4S may be getting confused on how to copy the data or how to paste it.

However, I've tried to replicate your data, and it seems to copy OK for me.
Have you pasted it into Notepad to see what is copied?

I don't think there's much difference between the two, but have you tried the nightly version? You don't have to install it - just download the zip, extract it, and run the .exe.

[itdept936]

However, I've tried to replicate your data, and it seems to copy OK for me. Have you pasted it into Notepad to see what is copied?

I have tried to Copy/Paste right into Notepad and other programs, but without luck

I don't think there's much difference between the two, but have you tried the nightly version? You don't have to install it - just download the zip, extract it, and run the .exe.

I will try the nightly and let you know how it goes... thx!

Edit - I ran the latest Nightly build and every test so far seems to be working correctly!!

I will post again if I find other copy/paste problems after further testing. Thanks for your help!