Hi,
This is probably
really easy but I am having a hard time figuring it out. I would like to
have multiple text values entered in one dialog box with the text values
separated by commas. The variable from the dialog box would then be used in the
IN clause of a SELECT statement. The statement works fine with one value
but not more than one. To use more than one text value in the IN clause,
the text values must have single quotes around each value.
Thanks
Example:
DIALOG 'Enter year(s) wanted separated by commas.
example: 05 '=45 vyears=10 vendkey 1
CAPTION 'Month-end Year(s)' AT CENTER CENTER
SELECT SUM(quantity) INTO vtotal FROM table WHERE year IN (.vyears)
Ted Wolfley
Database/Internet Programmer
The Ogden Group of Rochester
phone:
(585) 321 1060 x23
fax: (585) 321 0043
[EMAIL PROTECTED]
