TIP: Click on subject to list as thread! ANSI
echo: paradox
to: ALL
from: PETER READER
date: 1995-04-29 14:55:00
subject: Adding procs to queries

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)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.