| Blank space insertion into a Database fiel [message #370590] |
Tue, 04 January 2000 03:26  |
Ajay Madan
Messages: 8
Registered: January 2000
|
Junior Member |
|
|
Hi !!
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@usa.net
|
|
|
|
| Re: Blank space insertion into a Database fiel [message #370594 is a reply to message #370590] |
Tue, 04 January 2000 06:53  |
hmg
Messages: 40
Registered: March 1999
|
Member |
|
|
Hi,
the same behaviour you told is with Oracle 8.0.5 and Forms 5.0. Try this workaround
PRE-INSERT Trigger of the database block:
:database_block.delete_flag := 'X';
POST-INSERT Trigger of the database block:
update yourtable
set delete_flag = chr(32)
where delete_flag = 'X';
Bye
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
