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
