Skip to Content
Former Member
Jul 28, 2010 at 06:46 AM

Query not working


Dear Experts,

I am trying to execute a query provided in 'How to define and use user-defined fields' doc under How to guides for SBO 8.8 but it is giving me error "incorrect syntax near...."

The Sample query i m trying to execute, which is for adding 20 in the posting date of current active sales document (not stored in database), is : Select $[$10.0.Date] + 20

This query will be used in Due date to automatically retrieve a date which 20 days forward from the posting date.

When I am executing the above query it is give me error: SQL native client "incorrect syntax near '+' and user-defined value could be created.

Please help resolving this issue. I am using SAP Business one 8.8 SP0 PL09