Larry You can quote the tfilename
Set var VQ = (CVAL(‘QUOTES’)) SET VAR vRunSel = (‘RUN SELECT USING’ & .vq + .tFileName + .vq & ‘ConvertProgram IN TableName WHERE RowID =’ & .vq + .vRowID + .vq))) &vrunsel From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Friday, December 04, 2009 8:30 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: RUN SELECT with parameter << Try this I’m assuming vRowID is integer SET VAR vRunSel = (‘RUN SELECT USING’ & .tFileName & ‘ConvertProgram IN TableName WHERE RowID =’ & (CTXT(.vRowID))) >> No, I think this would be worse since tFileName can have spaces in it and wouldn't be quoted. And RowID is text in my case. I tried it with all literals and no variables and got the same results -- it runs without the USING clause, but not with it. -- Larry
