I'm trying to add a simple extended query to a couple of standard reports. The query is:
SELECT STING_VAL FROM USER_DEF_FIELDS WHERE ROWID=:15586
When I run the report, I get the error "COUNT field incorrect or syntax error"
I've tried many things:
Tried this on two reports, VMORDFRM and VMORDFM1
When I remove the extended query, the error goes away.
I've tried running SQL Profiler to see what SQL Server sees, but I don't think this makes it to the server. Maybe an ODBC error?
I'm on Visual 9.0.8 SP4 and Gupta 7.0
