M
From: Ajay Madan <ajay_madanNOajSPAM_at_usa.net.invalid>
Date: Tue, 04 Jan 2000 01:38:29 -0800
Message-ID: <0062c5dd.abb070f3_at_usw-ex0109-066.remarq.com>
Hi !!
[Quoted] My application is on Oracle8i with Forms6.0. I have a Database Block which is based on the base Table which has a Delete Flag field with declaration - VARCHAR2(1) NOT NULL. This field is not displayed on the canvas. My application requires that I initialize this field with a single Blank space and then insert into the database. But whether directly or thru another variable I am not able to initialize and insert this value into the database. The table or the form variable does not accept this value at all. But In SQL. I am able to insert the record into the Database by giving a ' ' as value for the delete flag field. But I am not able to do the same using forms.
Date: Tue, 04 Jan 2000 01:38:29 -0800
Message-ID: <0062c5dd.abb070f3_at_usw-ex0109-066.remarq.com>
Hi !!
[Quoted] My application is on Oracle8i with Forms6.0. I have a Database Block which is based on the base Table which has a Delete Flag field with declaration - VARCHAR2(1) NOT NULL. This field is not displayed on the canvas. My application requires that I initialize this field with a single Blank space and then insert into the database. But whether directly or thru another variable I am not able to initialize and insert this value into the database. The table or the form variable does not accept this value at all. But In SQL. I am able to insert the record into the Database by giving a ' ' as value for the delete flag field. But I am not able to do the same using forms.
Can you help me out with this? How do I initialize this field with a single blank space?
Thanks and Regards,
Ajay
ajay_madan_at_usa.net
- Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful