A text is a string of 0 to 250 characters. The length of a text is the number of characters in it. To find the amount of storage a text takes up, add one to the length and round up to the nearest four. Thus an 8-character text takes up 12 bytes (1 + 8 rounded up to the nearest 4).
I not sure but this hapen only when that text it's stored in database
Some questions that I had in my test. If someone could answer....
1 Witch posting routine read the journal table?
A: Post Batch
B: Post Line
C: Check Line
2 Witch posting routine write in to leger table ?
A: Post Batch
B: Post Line
C: Check Line
3 Look the following code:
1
Find(‘-‘)
Do
Delete();
While next <> 0
2
Find(‘-‘)
Do
Ok:=Delete();
While next <> 0
3
deleteAll();
What’s the difference ?
A: 1 is faster
B: 2 is faster
C: 3 is faster all are the same
4 In a report with 1 dataItem. Witch trigger is not executed if the dataset is empty ?
A onAftergetRecord
B onPostDataItem
C
D
5: In a function with a record as parameter. Can we know witch filters have been applies ?
A: NO
B: Yes, the recors contains all the information about the filter applied
C: Yes, the filters applied to a record are stored in a system variable.
D…
6: What is a typical instruction in a check line routine ?
A¨Validate()
B: Modify()
C
D
7: Look the following code in a post batch routine:
LOCKTABLE;
SETRANGE("Journal Template Name",'GENERAL');
SETRANGE("Journal Batch Name",'IMPORT');
IF FIND('+') THEN
NextLineNo := "Line No." + 10000
ELSE
NextLineNo := 10000;
If we post a journal of 20 lines. How many times the line “NextLineNo := "Line No." + 10000” will be executed ?
A. 1
B: 20
C: 40 100
8: In a dataport, you have to test the data before to import them. Where do you want to place your code ?
A: onbeforeimport
B: onaftergetrecord
C
D
9: Look the following code:
VarRecord.field1 := ‘xyz’;
VarRecord.modify();
When the change is submitted ?
A: a submit is implicitly called after the modify
B: when leaving the trigger
C: modify submit the transaction
10: How to implement optimistic concurrency (I dn’t remember the server type) ?
A: Set a maximum of filters. The server will lock the table (implicit) during the update
B: Set a maximum of filters and explicitly call the LOCKTABLE
C
D
11: If a customer want to be able to change the sorting order of a report without the intervention of a Navision developer, what do you do ?
A: Fill the requFilterHeading
B: Leave the requFilterHeading blank
C: Fill the property ???? Leave the property ??? blank
12. In a form create with the form wizard. Witch code is automatically generated ?
A: Validate(“No.”) in onaftergetrecord
B: SETRANGE(“No.”) in onaftergetrecord
C: FORM.Save() in onDeleterecord() ???? in onNewRecord
13: In a report, witch instruction do the same task as putting a field name in the totalField property ?
I think...........but I'm not sure :-k
1.c
2.b
3.I had the same question and really don't know..... C
4.a
5.c
6.Ithink that question was.. What is NOT typical.... and the answer is B
7.b
8.b
9.c
10.a
11.c .......the property named ReqFilterFields
12. had same question, and I chose A
13.a
hello, these are my answers of lorenjans's question.
i have also do this exam, and many questions are the same. unfortunately i have failed.
moreover, i think that the question number 3 of laurent is D. for the others laurent's question i think that vodoo answers are correct. i hope...:)
bye jpm
1 b
2 a
3 a
4
5 b
6 b
7 e
8 b
9 b
10 c
11 a
12 b
13
14 b
15 b
16 b
17 a
18 a
19
20 b or c
21 a
22 a
23 d
24
25 a
26
27
28 d
29 in 4.0 menu suite has not c/al
30 a
31 c
32 b
33
34 a
35 b
36
37 a
38 a
39
40 c
41 a
42 a
43 you can not change its value at runtime
44 d
45
46 a+c
Cust.Setcurrentkey('No.');
Cust.Setrange(Cust.Salesperson,'PS');
If Cust.Find('-') then
Repeat
Cust.CreditLimit(LCY) := 10000;
Until Cust.Next = 0;
Sec B:
Cust.Setcurrentkey('SalesPerson');
Cust.Setrange(Cust.Salesperson,'PS');
If Cust.Find('-') then
Repeat
Cust.CreditLimit(LCY) := 10000;
Until Cust.Next = 0;
Sec C:
Cust.Setrange(Cust.Salesperson,'PS');
If Cust.Find('-') then
Repeat
Cust.CreditLimit(LCY) := 10000;
Until Cust.Next = 0;
Ans:
A: Sec A is faster
B: Sec B is faster
C: Sec C is faster All took same time
hi again, Question 41 from Lorenjans: I think it's D. I tried to insert a Subform in a Subform. When you start the form, Navision brings you the following Error: You cannot open a subform in a subform.
Its important to fill the Propreties SubFormID twice.
hi guys,
someone knows what dimension are used when we post?
and what dimension are used when we insert a record in sales order?
these are lorenjan's questions that i have also found in my test.
2) u are make a data convertion from legacy system to new one
using dataport but but something accur thier is description filed contain 80 char and the new description filed can take 50 char only.
u told ur customer about this he told u its fine with first 50 char
know what is true way to do this data convertion ?
1) Change the new description filed properties to take 80 char
2) write code in the table triger to to reed the first 50 char
2) dataport will handle this situations u dont need to do any thing
4)u need to write code in data port to handle this situations
5) put the data in variable and then write code to read the first 50 char
sorry, yes for the question 2 the correct answer is B.
for question 3 i think that answer 4 is much generic,but you could be right...
really i don't know.
bye
jpm
Hello guys!
I agree with montoya except with the question "u are make a data convertion from legacy system to new one
using dataport but but something accur thier is description filed contain 80 char and the new description filed can take 50 char only.
u told ur customer about this he told u its fine with first 50 char
know what is true way to do this data convertion ? ". The answer should be "put the data in variable and then write code to read the first 50 char"
Could someone help me with the questions that I've posted after I did the exam?
Thanks guys.
Lorenjans-free
Hi, does anyone take the development 2 exam??
Can u tell me, how many questions, time limit?
Is it a multiple choice questions like in the development 1 or there are some essay or others?
also, can you please tell me how many percentage(number of exam) for each section (of all 10 sections).??
any tips or material sources that might be useful to be looked at before the exam???
thx
Microsoft Business Solutions Certified Professional–Navision 4.0 C/SIDE Solution Development Exam (VUE Exam # NA 40-222, Prometric Exam # MB7-222) Preparation Guide
Last Modified 4/7/2005
Posted 3/1/2005
This preparation guide includes information and tools to assist you in preparation for the exam. This exam was formerly known as Navision Development.
Target Audience
Microsoft Business Solutions partners wishing to become a Microsoft Business Solutions Certified Professional–Navision C/SIDE Solution Development should take this exam. Partners authorized for Microsoft Navision should take this exam.
Exam Specifics
Skills Being Measured:
This certification exam measures your ability to understand and articulate how to use the C/SIDE software development environment inside of Microsoft Navision 4.0.
Time Requirements & Questions:
120 minutes to complete the exam
100 questions with a passing rate of 80%
Exam Preparation Tools
In addition to your hands-on experience working with the product, we highly recommend using the following tools and training to help you prepare for this exam:
Navision Introduction (eCourse/Classroom/Courseware)
Navision 4.0 C/SIDE Introduction (eCourse/Classroom/Courseware/Exam)
Navision 4.0 C/SIDE Solution Development course (Classroom/Courseware)
For Classroom Training information/availability please check with your region.
For eCourse information please click here.
For Courseware information or to order please click here.
Supplemental Learning Resources:
Navision Application Developers’ Guide, Navision C/SIDE Reference Guide, and Basic Online Help within the Microsoft Navision product.
Additional Skills Recommended:
Advanced working knowledge of Navision C/SIDE software development functionality.
Exam Topics
C/AL Programming – 17%
Defining tables
Table and field properties
Creating tables
Defining keys
Setting relationships between tables
Special table fields
Table types and characteristics
Defining C/AL
Accessing C/AL
Simple datatypes
Identifiers and variables
Assignment statements
Expressions
Numeric expressions
Logical and related expressions
IF and EXIT statements
Compound statements and comments
Arrays
Repetitive statements
Other statements
Calling built-in functions
Using intrinsic C/AL functions
Creating C/AL functions
Solution Design – 24%
Defining master tables
Defining secondary tables
Main and subforms
Matrix forms
Complex datatypes
Multilanguage functionality
Microsoft SQL Server
C/AL Triggers
Solution Implementation – 24%
Posting
Integration
Reporting
Statistics
Dimensions
Interfaces
Deployment
Specific Programming Topics – 21%
DataItems
Triggers
Reports
Dataports
XMLports
Codeunits
Lookups
Advanced report features
Development Scenarios – 14%
Master table creation
Secondary table creation
Posting
Journals
Reports
Data import/export
This preparation guide is subject to change at any time without prior notice and at Microsoft Business Solutions' sole discretion. Please contact mbsuniv@microsoft.com with any certification or training related questions.
thx for the reply....
who has taken the exam??
could you post your score and date(taking the exam) here??
i just want to know how close (if fail) and statistics of the failure....
questions from laurent:
1.C
2.B
3.D?? could anyone correct this??
4.A
5.B?? I choose B, because you can use VAR.GETFILTERS function
6.A
7.A?? because there is NO NEXT, I assume the code would be run once only
8.OnAfterImportRecord.
9.C.
10. no idea
11. ReqFilterFields
12. no idea
13. A?? not sure, just guessing
guys, do u know if there is other thread in this forum that also talking about development2 exam?? or mabybe other website ? could you give me the link ??
thx...
Regarding to solution development , chapter 4 : Navision NTR Usage. it said "if the version tag says NAVW13.10.01.25, the "NAV" is the product (Navision Attain), "W1" indicates that it is a world wide object, "3" is the major release, ".10" is the minor release, ".01" is the maintenance release (service pack), and the ".25" is the unreleased (but published) hotfix number."
hello,
yes, it's a service pack.
someone can answer lorenjans-free's questions about Dimension (posting and sales order record insert)? questions are the 45 and 46.
bye,
jpm
Comments
I not sure but this hapen only when that text it's stored in database
1 Witch posting routine read the journal table?
A: Post Batch
B: Post Line
C: Check Line
2 Witch posting routine write in to leger table ?
A: Post Batch
B: Post Line
C: Check Line
3 Look the following code:
1
Find(‘-‘)
Do
Delete();
While next <> 0
2
Find(‘-‘)
Do
Ok:=Delete();
While next <> 0
3
deleteAll();
What’s the difference ?
A: 1 is faster
B: 2 is faster
C: 3 is faster
all are the same
4 In a report with 1 dataItem. Witch trigger is not executed if the dataset is empty ?
A onAftergetRecord
B onPostDataItem
C
D
5: In a function with a record as parameter. Can we know witch filters have been applies ?
A: NO
B: Yes, the recors contains all the information about the filter applied
C: Yes, the filters applied to a record are stored in a system variable.
D…
6: What is a typical instruction in a check line routine ?
A¨Validate()
B: Modify()
C
D
7: Look the following code in a post batch routine:
LOCKTABLE;
SETRANGE("Journal Template Name",'GENERAL');
SETRANGE("Journal Batch Name",'IMPORT');
IF FIND('+') THEN
NextLineNo := "Line No." + 10000
ELSE
NextLineNo := 10000;
If we post a journal of 20 lines. How many times the line “NextLineNo := "Line No." + 10000” will be executed ?
A. 1
B: 20
C: 40
100
8: In a dataport, you have to test the data before to import them. Where do you want to place your code ?
A: onbeforeimport
B: onaftergetrecord
C
D
9: Look the following code:
VarRecord.field1 := ‘xyz’;
VarRecord.modify();
When the change is submitted ?
A: a submit is implicitly called after the modify
B: when leaving the trigger
C: modify submit the transaction
10: How to implement optimistic concurrency (I dn’t remember the server type) ?
A: Set a maximum of filters. The server will lock the table (implicit) during the update
B: Set a maximum of filters and explicitly call the LOCKTABLE
C
D
11: If a customer want to be able to change the sorting order of a report without the intervention of a Navision developer, what do you do ?
A: Fill the requFilterHeading
B: Leave the requFilterHeading blank
C: Fill the property ????
Leave the property ??? blank
12. In a form create with the form wizard. Witch code is automatically generated ?
A: Validate(“No.”) in onaftergetrecord
B: SETRANGE(“No.”) in onaftergetrecord
C: FORM.Save() in onDeleterecord()
???? in onNewRecord
13: In a report, witch instruction do the same task as putting a field name in the totalField property ?
A: CreateTotal
B: FlowFiels
C: Sum
???
1.c
2.b
3.I had the same question and really don't know..... C
4.a
5.c
6.Ithink that question was.. What is NOT typical.... and the answer is B
7.b
8.b
9.c
10.a
11.c .......the property named ReqFilterFields
12. had same question, and I chose A
13.a
i have also do this exam, and many questions are the same. unfortunately i have failed.
moreover, i think that the question number 3 of laurent is D. for the others laurent's question i think that vodoo answers are correct. i hope...:)
bye jpm
1 b
2 a
3 a
4
5 b
6 b
7 e
8 b
9 b
10 c
11 a
12 b
13
14 b
15 b
16 b
17 a
18 a
19
20 b or c
21 a
22 a
23 d
24
25 a
26
27
28 d
29 in 4.0 menu suite has not c/al
30 a
31 c
32 b
33
34 a
35 b
36
37 a
38 a
39
40 c
41 a
42 a
43 you can not change its value at runtime
44 d
45
46 a+c
thanks montoya for the answers, but I think the question number 41 can be the answer c). Does someone help us?
Thanks.
SeeYa to all
Now I've some Questions about the Answers of 2 Questions from Laurent:
Q3: Are they all the same? I think C (3 is faster) is right!!!!
Q12: When I create a Form with the Wizzard, no Code is written automaticlly. I tried Card-Type Form AND Tabular-Type Form.
I know, when i use the Report Designer Wizzard and I sort my Report, the some Code will be written.....
thanks a lot
curdin
Cust.Setcurrentkey('No.');
Cust.Setrange(Cust.Salesperson,'PS');
If Cust.Find('-') then
Repeat
Cust.CreditLimit(LCY) := 10000;
Until Cust.Next = 0;
Sec B:
Cust.Setcurrentkey('SalesPerson');
Cust.Setrange(Cust.Salesperson,'PS');
If Cust.Find('-') then
Repeat
Cust.CreditLimit(LCY) := 10000;
Until Cust.Next = 0;
Sec C:
Cust.Setrange(Cust.Salesperson,'PS');
If Cust.Find('-') then
Repeat
Cust.CreditLimit(LCY) := 10000;
Until Cust.Next = 0;
Ans:
A: Sec A is faster
B: Sec B is faster
C: Sec C is faster
All took same time
Can anybody guess which one is write.
Its important to fill the Propreties SubFormID twice.
grz, curdin
Question from sankarganesh:
Think B is the fastest, because of the SetCurrentKey!
curdin
Lorenjans-free
someone knows what dimension are used when we post?
and what dimension are used when we insert a record in sales order?
these are lorenjan's questions that i have also found in my test.
bye
jpm
1) A client make a mailing with microsoft word combinated with MBS, We use for this.
a)ODBC
b)C/ODBC
c)C/Front
d)Automation Microsfot Word
Depends, If a report can have unlimited items the answer is unlimited but if the question is for one dataitem the answer is 10.
All people says 2, but why not is the 5
i think that answers of nando_sg's questions are:
1) d
2) a
3) 4
bye,
jpm
2) a? are you sure?
3) 4) why not 5?
Gracias montoya
for question 3 i think that answer 4 is much generic,but you could be right...
really i don't know.
bye
jpm
I agree with montoya except with the question "u are make a data convertion from legacy system to new one
using dataport but but something accur thier is description filed contain 80 char and the new description filed can take 50 char only.
u told ur customer about this he told u its fine with first 50 char
know what is true way to do this data convertion ? ". The answer should be "put the data in variable and then write code to read the first 50 char"
Could someone help me with the questions that I've posted after I did the exam?
Thanks guys.
Lorenjans-free
Can u tell me, how many questions, time limit?
Is it a multiple choice questions like in the development 1 or there are some essay or others?
also, can you please tell me how many percentage(number of exam) for each section (of all 10 sections).??
any tips or material sources that might be useful to be looked at before the exam???
thx
Last Modified 4/7/2005
Posted 3/1/2005
This preparation guide includes information and tools to assist you in preparation for the exam. This exam was formerly known as Navision Development.
Target Audience
Microsoft Business Solutions partners wishing to become a Microsoft Business Solutions Certified Professional–Navision C/SIDE Solution Development should take this exam. Partners authorized for Microsoft Navision should take this exam.
Exam Specifics
Skills Being Measured:
This certification exam measures your ability to understand and articulate how to use the C/SIDE software development environment inside of Microsoft Navision 4.0.
Time Requirements & Questions:
120 minutes to complete the exam
100 questions with a passing rate of 80%
Exam Preparation Tools
In addition to your hands-on experience working with the product, we highly recommend using the following tools and training to help you prepare for this exam:
Navision Introduction (eCourse/Classroom/Courseware)
Navision 4.0 C/SIDE Introduction (eCourse/Classroom/Courseware/Exam)
Navision 4.0 C/SIDE Solution Development course (Classroom/Courseware)
For Classroom Training information/availability please check with your region.
For eCourse information please click here.
For Courseware information or to order please click here.
Supplemental Learning Resources:
Navision Application Developers’ Guide, Navision C/SIDE Reference Guide, and Basic Online Help within the Microsoft Navision product.
Additional Skills Recommended:
Advanced working knowledge of Navision C/SIDE software development functionality.
Exam Topics
C/AL Programming – 17%
Defining tables
Table and field properties
Creating tables
Defining keys
Setting relationships between tables
Special table fields
Table types and characteristics
Defining C/AL
Accessing C/AL
Simple datatypes
Identifiers and variables
Assignment statements
Expressions
Numeric expressions
Logical and related expressions
IF and EXIT statements
Compound statements and comments
Arrays
Repetitive statements
Other statements
Calling built-in functions
Using intrinsic C/AL functions
Creating C/AL functions
Solution Design – 24%
Defining master tables
Defining secondary tables
Main and subforms
Matrix forms
Complex datatypes
Multilanguage functionality
Microsoft SQL Server
C/AL Triggers
Solution Implementation – 24%
Posting
Integration
Reporting
Statistics
Dimensions
Interfaces
Deployment
Specific Programming Topics – 21%
DataItems
Triggers
Reports
Dataports
XMLports
Codeunits
Lookups
Advanced report features
Development Scenarios – 14%
Master table creation
Secondary table creation
Posting
Journals
Reports
Data import/export
This preparation guide is subject to change at any time without prior notice and at Microsoft Business Solutions' sole discretion. Please contact mbsuniv@microsoft.com with any certification or training related questions.
who has taken the exam??
could you post your score and date(taking the exam) here??
i just want to know how close (if fail) and statistics of the failure....
I pass my exam.
I'm sure that the 3 question es 5 because the answer 4 isn't a option in my exam.
Thank's for all
1.C
2.B
3.D?? could anyone correct this??
4.A
5.B?? I choose B, because you can use VAR.GETFILTERS function
6.A
7.A?? because there is NO NEXT, I assume the code would be run once only
8.OnAfterImportRecord.
9.C.
10. no idea
11. ReqFilterFields
12. no idea
13. A?? not sure, just guessing
cmiiw
Thank's
1.NAVW13.00.03 -> What does the 03 means?
A: Worldwide Hotfix -> I choose this
B: Wordwide Service Pack
C: something Local
don't know
Thx
curdin
thx...
So I think this one should be B. Any ideas?
yes, it's a service pack.
someone can answer lorenjans-free's questions about Dimension (posting and sales order record insert)? questions are the 45 and 46.
bye,
jpm
but what is the functional area with more master tables? any idea?
thanks, bye jpm