Be certain the offending variables are declared ('Typed') in the
onBeforeStart EEP first before they are used in any expression.
SET VAR vVarName DataType = Null {or some initial value if required}
----- Original Message -----
From: "Dave McCann" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, February 15, 2012 10:30 PM
Subject: [RBASE-L] - form variables changing type
: I've encountered a strange problem, several times over the last several
: months while working with forms (RB9.1/32) mostly with a couple of some
: complex forms where some of my variables will suddenly change type --
: from INTEGER to BIT or TEXT to BITNOTE, etc. A few cases, I've been
: unable to change their type back as I get an error indicating the
: database COLUMN type doesn't match the expression, etc. Have been able
: to recover a backup of the form since I keep ongoing revisions, but its
: no fun losing the latest changes doing that.
:
: The one thing in common seems to be the variable expressions all lookup
: data in another table based on a variable value in the form.
:
: I'm perplexed, may be some flaw in my form or process and a rather
: annoying problem.
:
: Anybody seen this or have any ideas on what could be causing this for me?
:
: --
: Dave McCann
: Classic Micro Systems
:
:
