Dave I'm assuming vtdict is a table name. Try using &vtdict instead of .vtdict in your choose command.
Buddy -----Original Message----- From: David Ebert [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 8:11 AM To: [EMAIL PROTECTED] Subject: Syntax check please The following returns a syntax error for a reason that seems to be eluding me. Any insight is appreciated. I have a feeling I'm going to owe the kitty for this one (but it's worth it). tia Dave (this mail client won't let me reset the following to a system font. I'm attaching the file in case this comes up as unreadable). --vbutton value set by form ISSUES SET VAR vbutton INTEGER --set variable for dictionary lookup value SET VAR vtdict TEXT SET VAR vtdict = NULL --set variable to hold CHOOSE values SET VAR vtlist TEXT SET VAR vtlist = NULL SELECT dict INTO vtdict + INDICATOR vtindicat FROM diyissues + WHERE diyiid = .vbutton CHOOSE vtlist FROM #VALUES FOR tdesc, nval + FROM .vtdict + ORDER BY tdesc AT CENTER CENTER CHKBOX + TITLE 'Select all that apply' + CAPTION 'Press Enter to Finish' RETURN
