Eli,
What I had to do was add a zTemp field, set it to " and then as I build
my qualification, I would call the zTemp field whenever I nneded a
double quote (")
Roger
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Eli Schilling
Sent: Thursday, April 05, 2007 12:24 PM
To: [email protected]
Subject: HELP - Building EXTERNAL table qual using table loop
So I need to build an EXTERNAL qualification using a table loop. When
the user opens a form there is a hidden table that looks to another form
to determine associations. The table loop builds a list of these
associates into a qualification (i.e. ['Manager*' = $col_MgrName$ OR
'Manager* = $col_MgrName$...] etc) and sets a field with this value.
The EXTRNAL qual on the table then grabs this field. The problem is I
can't get double quotes around the column value. So I end up with
'Manager*' = Steve Smith...and of course without the double quotes the
qualification fails.
Can someone tell me what I'm missing?
I have tried:
"'Manager*' = " + $col_MgrName
"'Manager*' = " + """ + $col_MgrName + """
"'Manager*' = " + """"" + $col_MgrName + """""
Thanks in advance!
Eli
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
