Hi Marco,
I need to process a query using an IN expression in the WHERE clause. The code would be something like this:
DeclareVariable('agnt', otString);
Declare Variable('cty', otString); -- obviously otString in not correct here
SQL.Add('SELECT * FROM CLIENT WHERE AGENT_CODE = :agnt AND COUNTY_CODE IN
cty)');
SetVariable('agnt', '1A');
SetVariable('cty', '08,12'); -- How do you set a value list here?
The problem is for the variable cty. Can I do this and if so, how? Obviously otString is not appropriate here since this needs to be a list, not a single string. I could hard code the county codes into the statement but would prefer not to do it.
Thanks
I need to process a query using an IN expression in the WHERE clause. The code would be something like this:
DeclareVariable('agnt', otString);
Declare Variable('cty', otString); -- obviously otString in not correct here
SQL.Add('SELECT * FROM CLIENT WHERE AGENT_CODE = :agnt AND COUNTY_CODE IN
cty)');SetVariable('agnt', '1A');
SetVariable('cty', '08,12'); -- How do you set a value list here?
The problem is for the variable cty. Can I do this and if so, how? Obviously otString is not appropriate here since this needs to be a list, not a single string. I could hard code the county codes into the statement but would prefer not to do it.
Thanks
