I am working on Baan Vb with Sp12. I have to write constraints in PCF module of manufacturing but I am not able to successfully execute the select statements in it. Please let me know the functionality that can be executed in the constraints...what all functions..statements...etc. can be used in it. For using SQL without "!" what should be the SP updation on Baan Vb? Also, please suggest good documentation for it.

Thanks in advance

in Baan IV, for lines in constraints that are 4GL commands (like the select statement), you need to use the "!" symbol so the constraint knows it is a 4GL command.

For example:
!on case variable
! case 1:
variable = 1
! break
!endcase