Hi Listers,
Please look into the following issue.
I created the following table in oracle (Manually).
CREATE TABLE MIGRATE_DATE ('EMP_LAN_ID' char(10), 'FIRST_NAME' char(10),
DATE_HIRED DATE);
Then i created view for the above table using the following SQL Syntax.
CREATE OR REPLACE FORCE VIEW MIGREATE_DATE_VIEW ("ROW_NUM", "EMP_LAN_ID",
"FIRST_NAME", "DATE_HIRED") as
SELECT ROW_NUM, FIRST_NAME, EMP_LAN_ID, DATE_HIRED
FROM
MIGREATE_DATE;
It created the view in the oracle db,
Now i am trying to create VIEW form using Developer Studio for the above
mentioned view, But when i create, it is showing only character and integer
fields (Except DATE Fields in the view form) in the VIEW form selection
(Developer Studio).
But if i try to put DATE Fields as character, then it is showing DATE_HIRED
as character field in the VIEW form (Developer Studio).
Please suggest me to achieve the above problem to create date fields in the
VIEW form using Developer Studio.
Best Regards,
Krishna B
--
View this message in context:
http://old.nabble.com/Create-Date-components-using-VIEW-Forms-tp26261651p26261651.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
