How to block a filled field

DarkHorse

Hello, I'd like to know how I cant block a filled field; I mean, I have a field on a table, and I want that that field let me fill it only one time, after that it should not let fill it again. What code have I to put?.
Many thanks in advance.

nunomaia

If I have understood the question.
You can use Validation Trigger.

Timo_Lässer

One possible solution could be

YourField - OnValidate()
IF xRec.YourField <> '' THEN
  ERROR('You are not allowed to change the value of %1', FIELDCAPTION(YourField));

DarkHorse

Fantastic!!!, it works. Thank you both for the help.

Marky

Timo Lässer wrote:

One possible solution could be

YourField - OnValidate()
IF xRec.YourField <> '' THEN
  ERROR('You are not allowed to change the value of %1', FIELDCAPTION(YourField));

Hi,
Would it be possible to allow some selected user to edit the value ?

Savatage

if userid = 'whomever'
then
end
else
..lockdown code..

I don't hard coding a specific user id tho - so I would use permissions or a boolean set on the user table.

Here's just one you can modify to fit your needs
http://www.mibuso.com/forum/viewtopic.php?t=2323

Marky

Savatage wrote:

if userid = 'whomever'
then
end
else
..lockdown code..

I don't hard coding a specific user id tho - so I would use permissions or a boolean set on the user table.

Here's just one you can modify to fit your needs
http://www.mibuso.com/forum/viewtopic.php?t=2323

Hi dear thank you for u quick reply.
Since i new in coding in navision i am having difficulty,
I have tried the following

on form open

defined a variables name as "groups" data type "Records" Subtype as user

Code:

Groups.SETRANGE(Groups."Role ID",'Super');
IF (Groups.FIND('-') )THEN BEGIN
CurrForm."Model".visible := false;
CurrForm."Model".editable := false;
END;

Thank you for your help.

Could you advice some common code reading metrial

Regards
Mark

Savatage

The only reading material other that taking courses is the Application Designers Guide on the product CD &
http://www.geocities.com/powerofthenigh ... ALProg.pdf

Marky

Savatage wrote:

The only reading material other that taking courses is the Application Designers Guide on the product CD &
http://www.geocities.com/powerofthenigh ... ALProg.pdf

Thank you for the link i will read it and hope it will helpe me,
Ps: was my above coding right?

Regards
Mark