SqlDbx Forum

SqlDbx

You are not logged in.

#1 2014-09-04 05:59:53

Alex_N
Member

Script View Column-Name Issue

Hi,
i discovered an issue with Scripting View´s.

When i create a View and i use a different Column-Header in the Create-Statement this is not recognized by the Script-Create Function.


Original:

CREATE OR REPLACE VIEW v_tandem_test
(CCCC, DDDD) AS
SELECT 1234 AS AA , 4567 as BB FROM DUAL;


Script-Result:

DROP VIEW WMS.V_TANDEM_TEST;

CREATE OR REPLACE VIEW WMS.V_TANDEM_TEST
AS SELECT 1234 AS AA , 4567 as BB FROM DUAL;

--> By a select the result in the Grid is correct. (Header: CCCC / DDDD)
Also the Script SELECT:

SELECT
    CCCC
    , DDDD
FROM WMS.V_TANDEM_TEST

Offline

#2 2014-09-17 04:04:03

Alex_N
Member

Re: Script View Column-Name Issue

Hi,
requires you more information?

Offline

#3 2014-09-17 20:15:09

sqldbxhelp
Administrator

Re: Script View Column-Name Issue

This will be addressed in the next release

Offline

Board footer

Powered by FluxBB