is it passible to validate field value through Navision web service before insert or update

vinceliu666

Hi All:

Navision provide web service that you could call it for insert , update ... etc. The filed value will be validated when you call web service Create / Update function. But I just want to validate field value before call Create / Update function for checking filed value legally .

Is it passible to validate field value through Navision web service before insert or update? Does anyone has ideal to do it ?

Tony_NCD

Just copy the validation from where it currently exist, create something similar in the web service and utilize it before the create/update function in the web service. This, of course, means it will be inefficient since it's having to do the same thing twice but it does what you're asking. You can get around the inefficiency but you have to ask yourself how often it happens and whether it's worth it with a little more programming.

vinceliu666

Tony_NCD wrote: »

Just copy the validation from where it currently exist, create something similar in the web service and utilize it before the create/update function in the web service. This, of course, means it will be inefficient since it's having to do the same thing twice but it does what you're asking. You can get around the inefficiency but you have to ask yourself how often it happens and whether it's worth it with a little more programming.

Thanks for your feedback , My Issue is that if I run record.insert, the record will be inserted. But I just want to validate data only, not insert record. If I run the record.insert , I must delete the record after insert . But the autoasign no for example Sales Order No will be add one.

irasoelbaks

vinceliu666 wrote: »

Tony_NCD wrote: »

Just copy the validation from where it currently exist, create something similar in the web service and utilize it before the create/update function in the web service. This, of course, means it will be inefficient since it's having to do the same thing twice but it does what you're asking. You can get around the inefficiency but you have to ask yourself how often it happens and whether it's worth it with a little more programming.

Thanks for your feedback , My Issue is that if I run record.insert, the record will be inserted. But I just want to validate data only, not insert record. If I run the record.insert , I must delete the record after insert . But the autoasign no for example Sales Order No will be add one.

Another option is to make a Record Variable: Temporary. By using Temp Tables you can do all CRUD operations without committing anything to your Physical table.

foo_bar

you can validate the field in the OnInsert trigger

Tony_NCD

Just copy the validation from where it currently exist, create something similar in the web service and utilize it before the create/update function in the web service. This, of course, means it will be inefficient since it's having to do the same thing twice but it does what you're asking. You can get around the inefficiency but you have to ask yourself how often it happens and whether it's worth it with a little more programming.

irasoelbaks

If you want to validate the field on certain criteria, value or pattern just write a function and publish it as a Soap Service for example and test the value with your own logic. After validation perform a Rec.Insert(TRUE) or Rec.Modify(TRUE) for example.

vinceliu666

Tony_NCD wrote: »

Just copy the validation from where it currently exist, create something similar in the web service and utilize it before the create/update function in the web service. This, of course, means it will be inefficient since it's having to do the same thing twice but it does what you're asking. You can get around the inefficiency but you have to ask yourself how often it happens and whether it's worth it with a little more programming.

Thanks for your feedback , My Issue is that if I run record.insert, the record will be inserted. But I just want to validate data only, not insert record. If I run the record.insert , I must delete the record after insert . But the autoasign no for example Sales Order No will be add one.

Wisa123

There is no simulate OnInsert, OnModify, OnValidate triggers without actually calling them first.
The only way around that would be to implement your own AL function that does the wished validation for you - without actually inserting - which honestly sounds like a nightmare to code and maintain for complex scenarios.

irasoelbaks

vinceliu666 wrote: »

Tony_NCD wrote: »

Just copy the validation from where it currently exist, create something similar in the web service and utilize it before the create/update function in the web service. This, of course, means it will be inefficient since it's having to do the same thing twice but it does what you're asking. You can get around the inefficiency but you have to ask yourself how often it happens and whether it's worth it with a little more programming.

Thanks for your feedback , My Issue is that if I run record.insert, the record will be inserted. But I just want to validate data only, not insert record. If I run the record.insert , I must delete the record after insert . But the autoasign no for example Sales Order No will be add one.

Another option is to make a Record Variable: Temporary. By using Temp Tables you can do all CRUD operations without committing anything to your Physical table.

vinceliu666

irasoelbaks:

It seems work. I thought your suggestion is the best solution. I could validate field value and not really insert or update the record in physical table. thanks for your answer.