S
sparkane
The following query
SELECT qsGROUP.fGroupID, qsGROUP.fGroupName, qsGROUP.fGroupDesc
FROM qsGROUP
WHERE (((qsGROUP.fGroupParameters)=
"NAME_ENTITY_TYPE = 17;INTERSECT(0);fNameEntityType = 17;1;3;0;"));
doesn't want to work for me. The string is the problem, but I don't
know why. This exact string exists in the table and field I'm
searching, but the sql command always produces an empty recordset,
programmatically and through Access' sql builder. I have an "=" in the
where clause, so I'd expect that it isn't running afoul of pattern
matching. Would the fact that fGroupParameters is a Memo field has
something to do with it? Any assistance is greatly appreciated.
sparky
SELECT qsGROUP.fGroupID, qsGROUP.fGroupName, qsGROUP.fGroupDesc
FROM qsGROUP
WHERE (((qsGROUP.fGroupParameters)=
"NAME_ENTITY_TYPE = 17;INTERSECT(0);fNameEntityType = 17;1;3;0;"));
doesn't want to work for me. The string is the problem, but I don't
know why. This exact string exists in the table and field I'm
searching, but the sql command always produces an empty recordset,
programmatically and through Access' sql builder. I have an "=" in the
where clause, so I'd expect that it isn't running afoul of pattern
matching. Would the fact that fGroupParameters is a Memo field has
something to do with it? Any assistance is greatly appreciated.
sparky