Microsoft Dynamics NAV (Archived)

Boolean SetRange doesn't work for Job Queue

(0) Share

Report

Posted on by Community Member

Hello Members,

I run into an issue where I have to setup a job queue with the following scenario.

- I created own table and the field type boolean is not part of the primary keys

- I created a code unit which filters as follows: NEWTABLE.SETRANGE("Boolean FIELD", FALSE) , that the only filter

- IF NEWTABLE.FIND('-') THEN BEGIN END;

- NOTE: The NEWTABLE includes record with boolean field true and false

- When I run the code unit, it is going through the loop (eg. finding the record)

- BUT when i try the same code unti via Job Queue, its not going through the loop.

Any idea?

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

sorenk on at

Like (0)

Report

Can you show a little more of your code. I would use a findset instead of a find('-'), but there should be no difference between the execution locally and in the Job Queue.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Here is what I have in code unit.....

CLEAR(ShipmentImportData);

ShipmentImportData.SETRANGE("Is Sales Order Updated",FALSE);

IF ShipmentImportData.FIND('-') THEN BEGIN

REPEAT

//updating Sales order table

UNTIL ShipmentImportData.NEXT = 0;

END;

when I run code unit from development environment, it found records and went through the loop and updating the SO but when I run the same code unit via Job Queue, it not finding any records.

Its strange, Instead of SETRANGE, when I use the following filter: ShipmentImportData.SETFILTER("Is Sales Order Updated",'<>%1',TRUE);it went through the loop and updated the SO.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (1)

Report

It is bit strange but i am not sure why would it behave that way. Try to use RESET function before apply any filters and try again.

Was this reply helpful? Yes No
Suggested answer

sorenk on at

Like (1)

Report

I would simplify the code a little by writing it as this.

CLEAR((ShipmentImportData);

ShipmentImportData.SETRANGE("Is Sales Order Updated",FALSE);

IF ShipmentImportData.FINDSET THEN

REPEAT

//updating Sales order table

UNTIL ShipmentImportData.NEXT = 0;

Use FINDSET instead of FIND('+')

No need for the BEGIN END; unless you have other code not mentioned.

I would also use RESET instead of CLEAR unless you have a specific reason for using CLEAR.

Waldo has created a good "How do I" Video on use of NAS that might help you too. I am assuming here that you are running a 3 tier architecture.

www.youtube.com/watch

There is no difference between using SETRANGE and SETFILTER to my knowledge out side that they work slightly different. In this example they should provide the same result.

Let me know if this answer helps you.

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

As suresh said it is bit strange thing to happen. Try the code with

Reset, FINDFIRST

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you very much Suresh. I changed it to reset but didn't work. I know its strange but works.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you very much Soren for the suggestions and video. Yes, I am using 3 tier architecture.

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

Like (0)

Report

Hi,

Is your issue resolved? If not, could you share the screen print of the code?

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

Like (0)

Report

Hi,

One more suggestion, after changing the code, did you restart the NAV session and restarted the Job Scheduler?

Was this reply helpful? Yes No
Alchmeist 10 on at

Like (0)

Report

Type code in this format-:

NewTable.reset

NewTable.setrange(BoolField,False);

if NewTable.findset then begin

repeat

..........Write the valid conditions..........

until NewTable.next =0;

end;

This will help you.

Was this reply helpful? Yes No