how to force not to entry empty string to PK columns(nvarchar) by NAV Setup?

(0) Share

Report

Posted on by Community Member

Hi, all. i have a question.

Regarding as Customer table(for example) if you know, could you please tell me about how to force not to entry empty string in PK(No_) without Validation in NAV environment?

in my situation,

my customer always entry some data in Customer table, that Bill-to Customer No is empty string because of not inputting Bill-to Customer No.
they use No Series and manual Code both that's why No Series setup is manual [yes].

someday unfortunately they have one data that is empty String in Customer_No by their miss-operation or something like that.
after that they changed empty string to one code issued by No. Series.
they didn't notice anything at that time, but all customer data's Bill-to Customer No had changed the Code from empty string, completely every Customer data.

at the end of month, they spent so many hours for recovering some posted document and customer data...

they don't want to happen this situation again.
and they are hoping NAV Setup that they don't have one data that is empty String in Customer_No any more in case of that situation.

they don't want to change setup of No Series manual [No] also, they use both.
of course i know that each columns have table definition parameter [Not Blank] but it becomes effective only validation,
and i also know they can setup table definition using check constraint in SQL Server directly but i don't know influence to NAV environment...

they would like to setup NAV to force not to entry empty string...

they are using NAV2015R2/CU9. they have more than 80,000 customers data and increasing 300 customers every month. i have to take the action early.

if you knew some idea or clue or something, could you please help me about it?

Thanks Regards,
Taka Saito

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

mmv 11,471 on at

Like (1)

Report

Hi,

You may write a code to throw an error in the OnQueryClosePage trigger on the page if the field is blank.

Was this reply helpful? Yes No
Suggested answer

aavio 895 on at

Like (1)

Report

please test with NotBlank property on the primary key field set to yes.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanx Mahesh!

your solution is only action of the page... so i would like to set trigger or constraint like that on Table without validation via NAV...

Taka

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi aavio!

but i had already tested that property, it doesn't work without validation...anyway thanks.

Taka

Was this reply helpful? Yes No
mmv 11,471 on at

Like (1)

Report

Hi,

If it's in the table, it's pretty easy, you need to write a code to check the blank value in the OnInsert trigger or OnModify.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mahesh,

my understanding about OnInsert & OnModify on table, it works on Validation. the key point is without Validation. so do you have any idea for that? thanx!

Taka

Was this reply helpful? Yes No
Suggested answer

aavio 895 on at

Like (1)

Report

NotBlank property doesnt need any validation code.

Can you check the documentation in the screenshot.

Was this reply helpful? Yes No
mmv 11,471 on at

Like (1)

Report

Hi,

How you are inserting the records into the NAV tables?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi aavio,

i had already read that documentation before and tried it. but it doesn't work without validation. have you tried it before?

Taka

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mahesh,

we Japanese localization have data import tool, that is able to select on validation or without(skip) validation, that's why i can test whenever.

finally we hope the situation that we are not able to have empty string(Blank) in PK columns(nvarchar) like Customer No without validation, always, every time.

if you have some solution, please help me thanks.

Taka

Was this reply helpful? Yes No