[RBASE-L] - Multi-line Input Box

[Mike Casey]

Hello all,

I am trying to create a form that allows a user to enter information into a 
multi-line input box.  I have the database column as a varchar(50).  If I 
create the input box as a Variable Edit, it works fine but I lose my multi-line 
capabilities.  If I try either a Variable Memo or a Variable Rich Edit, I am 
able to get my multi-line, but the form does not work.  It puts a -0- in each 
box and the system does not recognize when I enter text in it.  How do I get a 
multi-line input box to go into a varchar(50) column?

Here is my form EEP;
SET VAR v_gv_GlobalVariable TEXT = NULL
SET VAR v_gv_Description TEXT = NULL
SET VAR v_gv_Locations TEXT = NULL
RECALC VARIABLES
RETURN

Here is my Submit button EEP;
-- Validate Data Before Inserting a New Row
-- Validate there is Variable name
IF v_gv_globalvariable IS NULL THEN
  PAUSE 2 USING ' You must enter a variable name!' +
  CAPTION ' Customer Data' ICON stop +
  OPTION THEMENAME Razzmatazz +
  |MESSAGE_FONT_NAME Verdana +
  |MESSAGE_FONT_COLOR RED +
  |MESSAGE_FONT_SIZE 10 +
  |MESSAGE_FONT_BOLD ON
  PROPERTY txtglobalvariable set_focus 'TRUE'
  RETURN
ENDIF
-- Validate there is at least one location
IF v_gv_locations IS NULL THEN
  PAUSE 2 USING ' Missing at least one location!' +
  CAPTION ' Customer Data' ICON stop +
  OPTION THEMENAME Razzmatazz +
  |MESSAGE_FONT_NAME Verdana +
  |MESSAGE_FONT_COLOR RED +
  |MESSAGE_FONT_SIZE 10 +
  |MESSAGE_FONT_BOLD ON
  PROPERTY txtlocation set_focus 'TRUE'
  RETURN
ENDIF

LABEL insertrow
-- Get the current date
SET VAR v_gv_CreatedDate DATETIME = .#now
-- Set the UserName
SET VAR v_gv_CreatedBy INTEGER = '728'
-- Set the Active State
SET VAR v_gv_Active INTEGER = 1
-- Insert New Row
INSERT INTO dbo.gv_Variables +
(gvName,gvDescription,gvLocations,gvCreatedDate, +
fk_gvCreatedBy,gvVariableActive) +
VALUES +
.v_gv_GlobalVariable,.v_gv_Description,.v_gv_Locations,.v_gv_CreatedDate, +
.v_gv_CreatedBy,.v_gv_Active

-- Let the User Know
PAUSE 2 USING 'New Record Submitted Successfully!' +
CAPTION ' Customer Data' +
ICON confirm +
BUTTON 'Press any key to continue ...' +
OPTION BACK_COLOR WHITE +
|MESSAGE_COLOR WHITE +
|MESSAGE_FONT_NAME VERDANA +
|MESSAGE_FONT_SIZE 10 +
|MESSAGE_FONT_COLOR GREEN +
|MESSAGE_FONT_BOLD OFF +
|BUTTON_COLOR WHITE +
|BUTTON_FONT_COLOR GREEN +
|THEMENAME Razzmatazz

-- Reset all variables to NULL
SET VAR v_gv_globalvariable TEXT = NULL
SET VAR v_gv_description TEXT = NULL
SET VAR v_gv_locations TEXT = NULL

RECALC VARIABLES

PROPERTY txtglobalvariable set_focus 'TRUE'
RETURN

Thanks for any assistance,

Michael Casey