Toad World® Forums

Data Export Wizard - SQL - still including timestamp data type fields


#1

Reported on previous versions:
Select a table that includes a timestamp field.
Right-click the results, choose Export…
Pick SQL Script as the option.
Attachment

The wizard shows the timestamp data type field as selected, but that field cannot be part of an insert SQL Script. It is impossible to insert data into timestamp fields, so I have to waste time looking for the timestamp field in the list of columns and then clearing the Include checkbox.

The field shouldn’t even be displayed. Failing that it shouldn’t be included by default.

DataExportWizardTimestamp.jpeg


#2

Hi Darren,
I didn’t find the CR for some reason, so I’ve reated a new one - 107524

thanks for the post.