Hi net gurus,
I am working on Developer/2000 forms (version 4.5) that access
Oracle's (previously Digital's) RDB database. The environment
is Windows 95, and I am using Oracle's ODBC driver for RDB.
I am wondering if someone could help me out with the following
questions I have:
- How can I store spaces in character fields? The problem I am
running into is every time a character field (like varchar2(5))
is left blank, it stores NULLs in the database which is not desirable
in our environment. Is there anyway to get around this? Ideally,
I would like to default to spaces for these fields.
- We have found that Developer/2000 queries leave transactions
open in RDB. So, we are doing explicit transaction starts and commits
in PRE- and POST-QUERY triggers. But this is making the refreshes
slower because of their row level nature. Oracle's online documentation
talks about POST-FETCH trigger, but I have been told by their support
people that it doesn't exist. Is there any other way to start
and commit transactions before/after all the records are fetched?
I will greatly appreciate any help!
Thanks,
Rajeev
Received on Tue Jun 03 1997 - 00:00:00 CDT
