----- Original Message -----
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
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