Navision 4 - Application Designer’s Guide

Indhold i Application Designer’s Guide:

PART 1 ARCHITECTURE 1

Chapter 1 Architecture and Installation 3

The Navision Client/Server Environment. 4
Installation 6

Chapter 2 The Server Options 13

The Different Server Options. 14

Chapter 3 The Navision Security Model 25

Security 26
Business Areas and Granules 32

PART 2 FUNDAMENTALS 37

Chapter 4 C/SIDE Fundamentals 39

The C/SIDE User Interface 40
What Is a C/SIDE Application? 43
The Physical and the Logical Database 45

Chapter 5 Designing a C/SIDE Application. 47

Introduction to C/SIDE Application Design 48

PART 3 TABLES 53

Chapter 6 Table Fundamentals 55

What Is a Table? 56
Viewing and Modifying Properties 62
Defining Keys 67
Identifiers, Data Types and Data Formats in the SQL Server Option for
Navision. 74
Saving tables and Viewing Sorted Data 80
Special Table Fields 83
Dividing the Database into Companies 91

Chapter 7 Customizing and Maintaining Tables. 93

Using Table and Field Triggers 94
Setting Relationships Between Tables 96
Changing Tables That Contain Data 102
Linked Objects. 103

Chapter 8 Special C/SIDE Tables. 109

What Is a Temporary Table?. 110
What Is a System Table? 112
What Is a Virtual Table? 117

PART 4 FORMS 137

Chapter 9 Form Fundamentals. 139

What Are Forms? 140
Creating Forms 142
Saving, Compiling and Running Forms. 150
Chapter 10 Designing Forms 151
Form and Control Properties 152
Types of Controls 155
Adding Controls 157
Selecting, Moving and Adjusting Controls 160
Tools for Customizing Controls 164
Setting Control Properties 165
Container Controls. 169
How to Use Controls in Applications 171
Chapter 11 Extending the Functionality of Your Forms 185
Main Forms and Subforms 186
Looking Up Values and Validating Entries 189
Drilling Down to the Underlying Transactions 193
Launching Another Form 195
Designing Menu Buttons 196
Form and Control Triggers 200
Form Types and Characteristics 203

PART 5 REPORTS 211

Chapter 12 Report Fundamentals 213

What Are Reports? 214
What Happens When a Report Runs? 218
The Report Designer 221
Saving, Compiling and Running Reports. 224

Chapter 13 Designing Reports 227

Report Properties 228
Designing a Simple Report 232
Designing a More Advanced Report 240

Chapter 14 Extending Report Functionality 245

Grouping and Totaling. 246
Triggers in Reports 253
Advanced Sample Reports 254
Creating a Simple Document. 269
Creating a Nonprinting Report. 275
Types of Report 279

PART 6 CODEUNITS. 281

Chapter 15 Codeunit Fundamentals 283

Chapter 16 Introducing the C/AL Language 299

What Can You Do with C/AL? 300
What Are Statements, Expressions, and Operators? 301
Introducing the Elements of C/AL Expressions 309
The C/AL Control Language 318
Chapter 17 Using C/AL 327
Overview 328
System-Defined Variables. 330
Handling Runtime Errors 331
The Essential C/AL Functions 332

Chapter 18 Debugging C/AL Code. 349

What Are Bugs? 350
The Microsoft Business Solutions–Navision Debugger. 357
The Code Coverage Tool 365

Chapter 19 Extending C/AL 367

What Is COM?. 368
Using COM Technologies in C/SIDE. 370
Using C/SIDE as an Automation Controller. 374
Receiving Events in C/SIDE 392
Using Custom Controls from C/SIDE 400
Acquiring Controls 408

PART 7 DATAPORTS 409

Chapter 20 Dataports 411

What Are Dataports? 412
Designing Dataports 417
Exporting Data. 423
Importing Data. 431

PART 8 XMLPORTS. 443

Chapter 21 XMLports 445

XMLport Fundamentals 446
Designing XMLports 448
XMLport Examples 451
Validating Data 456
XMLports and Business Notifications 458

PART 9 MENUSUITE OBJECTS 459

Chapter 22 MenuSuite Objects. 461

Menu Suite Fundamentals. 462
Customizing a Menu Suite. 463
Exporting a MenuSuite Object. 466
Upgrading Menu Suite Content 468

PART 10 MULTILANGUAGE FUNCTIONALITY 469

Chapter 23 Multilanguage Functionality 471

Multilanguage Functionality. 472
Developing Multilanguage-Enabled Applications 478
Learning the Code Base Language. 482
Number Ranges for Text Constants 485

PART 11 BEYOND THE BASICS 487

Chapter 24 SumIndexFields 489

SumIndexFields. 490
SIFT and the SQL Server Option for Navision 492
Chapter 25 Type Conversion 511
Type Conversion in Expressions. 512
Type Conversion Mechanisms 514

Chapter 26 Numbering in Navision 521

How Does Number Sorting Work? 522

Chapter 27 C/SIDE in Multiuser Environments. 525

Ensuring Data Integrity in a Multiuser Environment 526
Locking in Navision – a Comparison of the two Server Options 534
Chapter 28 Caption Class Functionality 539
Syntax 540
Function Code 546

Chapter 29 Supporting Record Level Security. 553

Record Level Security 554

Chapter 30 Performance. 567

The DBMS Cache 568
The Commit Cache 570
The Command Buffer 572
Keys, Queries and Performance 574
C/AL Database Functions and Performance on SQL Server 576
Configuration Parameters 577
Login Stored Procedure on the SQL Server Option 581
Bulk Inserts 583

PART 12 APPENDIXES 585

Appendix A C/SIDE Specifications 587

Specifications for the DBMS 588
Specifications for C/SIDE Application Objects 589

Appendix B Report Flow Charts 591

Report Flow Charts 592
Report.Run 593
DataItem.Run 594
Section.Run. 595
Header.Run 596
Footer.Run. 597
TransHeader.Run 598
TransFooter.Run 599
GroupHeader.Run 600
GroupFooter.Run. 601
Body.Run. 602
NewPage. 603
GetRecord 604

Appendix C Dataport Flow Charts 605

Dataport Flow charts 606
Dataport.Import/Export 607
DataItem.Export. 608
VariableRecord.Export 609
FixedRecord.Export. 610
DataItem.Import. 611
VariableRecord.Import. 612
FixedRecord.Import 613

Appendix D NDBCS – The Database Driver 615

NDBCS – the Database Driver 616
A Brief History of Performance Improvements 624

Kommentar

Du skal være logget ind før du kan se eller skrive kommentarer til de forskellige indlæg. Klik her for at logge ind, eller oprette en bruger.