Toad World® Forums

Problem with Insert Export


#1

Tried to export to an insert statement to the clipboard from the sql grid today.

Table looks like this

CREATE TABLE almt_extension
(extension_id NUMBER(38,0),
name VARCHAR2(255 BYTE) NOT NULL,
type NUMBER(38,0) NOT NULL,
value_int NUMBER(38,0),
value_float FLOAT(126),
value_date DATE,
value_string VARCHAR2(510 BYTE),
value_hours NUMBER(14,4),
value_currency_id NUMBER(38,0),
value_currency NUMBER(20,10),
value_bobref_type NUMBER(38,0),
value_bobref NUMBER(38,0),
parent_id NUMBER(38,0) NOT NULL)

Generated sql looks like this:

INSERT INTO almt_extension
VALUES(,'travelPl,1,NU,NU,NU,'TA001,NU,NU,NU,NU,NU,-1885);

It truncated all the fields, all these values are too short. The “NU” s should be NULL.

Georges Bernanos


#2

Hi Joethejet,

Thanks for your feedback, this problem had been fixed in story “SQLNAV-1792” , pls wait the next upcoming beta program .

Regards,

Alan


#3

Joe, this is also addressed in the new beta.