I just started writing a data entry application using Paradox 5.0 for
Windows because the place where I volunteer has standardized on that for
a DB package. I have some experience in Access and VB, and am having
problems trying to do some things that are simple in Access. For
example, Access lets you build a query field using a function, either
custom or supplied (like IIF). Say I want a QBE field to contain
either the contents of table field A or table field B depending on the
contents of table field C. In Access I could write
IIF(FieldC="Something",FieldA, FieldB). I can't find anything in my
Paradox documentation that describes how to do this, and trying to put
the function in a query column doesn't work, either, with or without a
CALC. Can this be done in Paradox? Thanks for any help.
peter.reader@nwcs.org
* SLMR 2.1a * "Good Morning" is an opinion, not a greeting.
--- WILDMAIL!/WC v4.12
---------------
* Origin: NWCS Online (1:105/362.0)
|