Re: Forms 3 & long varchar2 fields

bamon_at_ocvaxc.cc.oberlin.edu (Jennifer R. Amon) writes:

>I'm using a long field in a SQL*Forms v3 form to correspond to a
>VARCHAR2 field in the database that is more than 255 characters in
>length. Should I anticipate any problems with this?

I do not know. Try and see!

>Now, is there a way to have that field display with an editor, without
>waiting until the user visits the field? In other words I'd like the
>editor to always appear for that field.

Yes. Write a field level trigger - ON-NEW-FIELD-INSTANCE - containing edit_field;
You can also add parameters to the edit_field, to set position, length and no-of-lines. See the SQL*Forms Reference Guide.

-- 
* Carsten Kristensen		      E-mail: ckr_at_ocsbrg.no 	*
* Offshore Computer Services AS       Tel   : +47 55 99 88 70	*
* Bergen, Norway		      Fax   : +47 55 99 88 84	*
* select std_disclaimer from opinions_not_shared_by_employer;   *