We just upgraded to MS Sql, when using crystal and access to evaluate text fields such as Credit hold and User Defined Fields, it does not work.
Example: SELECT OEORDHDR_SQL.hold_fg, OEORDHDR_SQL.ord_no
FROM OEORDHDR_SQL
WHERE (((OEORDHDR_SQL.hold_fg)<>"H"))
WITH OWNERACCESS OPTION;
This returns no records.
Thanks,
Bob Zaback
Example: SELECT OEORDHDR_SQL.hold_fg, OEORDHDR_SQL.ord_no
FROM OEORDHDR_SQL
WHERE (((OEORDHDR_SQL.hold_fg)<>"H"))
WITH OWNERACCESS OPTION;
This returns no records.
Thanks,
Bob Zaback