Validating or converting a column value in edittable?? (OpenInsight Specific)
At 09 OCT 1998 11:01:10AM G. Estey wrote:
I have a column in an edittable that I need to be uppercase
only. How can I do this. In a edit control there is a checkbox, but in the edittable there is none for a specified column.
At 09 OCT 1998 02:44PM Greg James wrote:
If nothing else, you could create a stored procedure and use it in the input validation of the edittable control.
For example:
/*
compile subroutine CONVERT_CASE(charstr TYPE, charstr VALUE, charstr BRANCH, charstr NEWVAL)
declare function get_property
*find out if focus is in the column that you want to be uppercase
cell=get_property(ctrlentid,'SELPOS')
column=cell
if column eq 'the column you want' then
convert @lower.case to @upper.case in valuenewval=valueend else
don't convert the caseend
*/
Then use CONVERT_CASE in for the input validation for the edittable.
Something like this might do what you want.
return
At 09 OCT 1998 04:32PM Blaise(Revelation) wrote:
See if this article works for you.
Good luckā¦
Blaise