Thank you Dawn,
 
That made it happy....and me too!!!!!
 
and BTW, Razzak...sorry, i thought i was on the high-tech list ;-)
 
tom
----- Original Message -----
From: Dawn Oakes
Sent: Wednesday, February 16, 2005 8:24 AM
Subject: [RBASE-L] - RE: invalid integer type--I'm missing something :-)

 
Tom
The choose statement treats the returned value as text.  So instead try this.
 
IF vidnumtxt = '[Esc]' THEN
    GOTO done
  ELSE

    SET VARIABLE  vidnum INTEGER = .vidnumtxt
  ENDIF



From: Thomas Eldred [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 16, 2005 8:26 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - invalid integer type--I'm missing something :-)

Good Morning all....
 
This should be simple...easy and low brain power, but so am i and this has me puzzled.
 
My user types a last name....R:Base then searches the list to find a count of like names.
 
If there is one, or none everything is fine and the program runs flawlessly.
 
If more than one, I have a list generated for the user to choose the correct person.
 
Using the code below, I get an "ERROR - Your value does not have the same type or scale as your variable vidnum (2178)"
 
The code continues to run and calls the expected form with the expected results. (edit using form where idnum = .vidnum)
 
IF vrows > 1 THEN
  CLS
  CHOOSE vidnumtxt FOR #VALUES +
  FOR (lookupname & (CTXT(rushnum)) & homeaddress),idnum +
  FROM peoplelist WHERE lookupname CONTAINS .vlastname   +
  CHKBOX 1 TITLE 'Choose a Donor' +
  CAPTION 'Select Name and Press Enter' +
  LINES 20 FORMATTED +
  OPTION LIST_FONT_COLOR BLACK|List_Back_Color YELLOW +
  |title_font_color BLACK|Title_Back_Color BLACK +
  |window_back_color YELLOW +
  |title_font_size 24 +
  |title_font_name times new roman +
  |window_caption +
  |Buttons_Show_Glyph ON +
  |Buttons_Back_Color YELLOW
  IF vidnumtxt = '[Esc]' THEN
    GOTO done
  ELSE
    SET VARIABLE  vidnum = .vidnumtxt
  ENDIF
ENDIF
 
All Fields having num in the name are integers,  lookupname is a computed column all others are text.
 
Any one see a problem here? I can't find my boo-boo.
 
Thank you
Tom Eldred
 
 
 

Reply via email to