If you specify field lists in a NEW SHARED query, the matching SHARED query definitions in external procedures only have to include the FIELDS or EXCEPT keyword as a minimum field list reference. The complete field list is optional in the SHARED query definitions, but required in the NEW SHARED query definition.

However, the AVM raises the ERROR condition when you run a procedure with a SHARED query if you:

  • Specify a field list in the SHARED query to match a NEW SHARED query that has no field list.
  • Do not specify a field list reference in the SHARED query to match a NEW SHARED query that has a field list.