How to use update extractor from data result view?
In the new version of the tool I cannot generate updates statement from tables that in the previous version worked ok. The problem is that the resulting statement does not include the table from the executed query but a default table name "MY_TABLE". Table from the query does have a pk.
Here is a short example:
-- Prepare test table
create table tmp_test2 (
a int,
b varchar2(50),
constraint test2_pk primary key (a)
);
insert into tmp_test2 values (1,'2');
-- executre statement
select * from tmp_test2;
-- returnint result from update extractor (ctrl + c)
UPDATE MY_TABLE SET A = 1, B = '2';
Please sign in to leave a comment.
Hello,
I have created the issue, please follow https://youtrack.jetbrains.com/issue/DBE-1571 for updates. Btw what Datasource type do you use? Thanks.
Thanks,
it's an Oracle datasource.
Hello,
Please check with the latest EAP from https://confluence.jetbrains.com/display/DBE/0xDBE+142.4861+Released . Before using data extractor please Synchronize the Datasource. Does it work or if there are eny errors with synchronization? Thanks.
It works without any issue :) thank you.
Thanks for the information!