Oracle Forms 2.3 question on insert feature (data entry)
Date: 11 Jan 1994 14:59:17 -0500
Message-ID: <2gv0el$os0_at_access.digex.net>
This might be a dumb question, but here goes: A user is trying to insert
commas in name fields, to clean up the data. For example,
"Mr. John and Lorena Bobbit" might need to be changed to
"Mr. John, and Lorena Bobbit". When the "," after John is added, you
have to erase all the characters after the "t" in Bobbit to allow
any character to be inserted. This is because we are in block mode on
an IBM 4381 under VM/CMS. Is there any parameter in SQL*Forms 2.3 that
can be tweeked to fix this? The user has hundreds of records to add
commas too, so any subtraction of necessary key strokes would be
greatly appreciated. What it boils down to is querying up the name field
with trailing nulls. Now, it is possible that the data contains trailing
blanks, due to it coming from an Oracle system, but I still think that
Mr. Oracle should be smart enough to know what to do. Thanx for any
advice.