Jim,

Have you tried     (INT(.VCONDID))

Rich

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of J. Andrus
Sent: Friday, June 08, 2001 5:17 PM
To: RBase
Subject: Variables In Forms


RBWin 2000, Ver 6.5+

        Column CONID was initially a text column.  Form FCONT had a variable
field
VCONID where I intended to determine the next alpha-numeric ID available
in
an entry EEP.  I would then set CONID = .VCONID after incrementing
VCONID
        I later decided to make column CONID integer and revised TCONT
accordingly.
Now, in the EEP I am unable to set VCONID = (.VCONID + 1) because VCONID
continues to be defined as text when I enter the form even if I set it
to
integer prior to entering the form.  Also, in the EEP, if I set VCONID
INTEGER (changing it from TEXT as the form is entered) I then get the
error
message "Your value does not have the same type or scale as your
variable
(2178)".
        In the Form Designer Variable Object Properties in the section labeled
Variable Name how does one delete a variable shown there so it can be
redefined as a different data type based on the revised data type for
the
column?  I am unable to find anything in the User Reference section on
Forms
that tells he how to delete or modify a variable shown in the Variable
Name
pane of the Variable Object Properties.

Jim



Reply via email to