How can you...
Wishman
Member Posts: 36
Hi all,
I have some questions. Any help will be appreciated!!
1)How can you call a report in the middle of a transaction?
2)I want to import data 1000 from a file, my internal variable type is integer. If textmode(true), how many bytes does it takes place? And what if textmode(false), how many bytes does it takes place? and why?
3)What kind of tables include one to one relationship?And how can I name the table?
Thanks a lot.
I have some questions. Any help will be appreciated!!
1)How can you call a report in the middle of a transaction?
2)I want to import data 1000 from a file, my internal variable type is integer. If textmode(true), how many bytes does it takes place? And what if textmode(false), how many bytes does it takes place? and why?
3)What kind of tables include one to one relationship?And how can I name the table?
Thanks a lot.
0
Comments
-
1) In the system error message file, you can find the following:
2) The File.READ topic in the C/SIDE Online Reference contains the following:fin.etx wrote:Report.RunModal() is allowed in write transactions only if 'RequestForm = FALSE'. For example, 'Report.RunModal(...,FALSE)' is allowed.
So, when TEXTMODE is TRUE, a read from the file will read all characters from the current file position until the next carriage return/linefeed. The system will then attempt to evaluate the text string (see the EVALUATE function) into your integer variable. This could result in an error if the text contains non-integer data.If TEXTMODE (File) is set to TRUE, the system reads a line of text from the file, evaluates it and sets the variable equal to the result.
If TEXTMODE is set to FALSE, the system determines the number of bytes to read based on the size of the variable.
When TEXTMODE is FALSE, the read will read the next 4 bytes from the file (a C/AL Integer is 32 bits), and store them directly into the integer variable.
3) I'm sorry, but I don't fully understand your third question. Can you provide a little more detail?0 -
Thanks for the answers, you mean when textmode is true, it is then 8 bytes. 1000 is 4 bytes and 1 byte is added when it is text, and is rounded to 8 bytes. True?
And for the other question, for example;
The Item Vendor table is subsidiary table, there is 1(Vendor) to n(Item) relation. My question is if there is one to one relation?? What is the table type, and how can you name the table?0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 324 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions