employee_id field is Integer...
This works:
SELECT * from audits WHERE employee_id in (12,35)
This doesn't:
lcEmployeeString = '12,35'
SELECT *;
FROM audits Audits;
WHERE ALLTRIM(STR(Audits.employee_id)) IN (?lcEmployeeString)
I also tried this:
lcEmployeeString = "'12','35'"
lcEmployeeString = '12,35'
lcEmployeeString = "('12','35')"
Can I even do this in a remote view?
Thanks!
ICQ 10556 (ya), 254117