Index

A

• Active Directory groups
  • about / Checking Active Directory groups
  • checking / How to do it...
  • working / How it works..., See also
• AddCustomer function / How it works...
• AddElement function / There's more...
• AddTable function / How it works...
• ADO
  • about / Using ADO to access outside data
  • using, to access outside data / How to do it...
  • working / How it works...
• advanced filtering
  • about / Using advanced filtering
  • advanced filteringusing / How to do it...
  • advanced filteringworking / How it works...
  • advanced filteringways / There's more...
• array
  • creating / Creating an array, How to do it...
  • working / How it works...
  • ARRAYLEN / There's more...
  • address creating, Format Address used / Creating an address using the format address codeunit

B

• backup plan
  • setting up / How to do it...
  • working / How it works...
• basic SQL query
  • creating / Creating a basic SQL query
  • working / How it works...
  • types / Other Types of SQL queries
• basic SQL query, types
  • data, adding / Other Types of SQL queries
  • data, editing / Other Types of SQL queries
  • data, deleting / Other Types of SQL queries
• breakpoints
  • setting / How to do it...
  • working / How it works...

C

• CALCDATE() function
  • working / There's more...CALCDATE() functionworking
  • units, using / There's more...CALCDATE() functionworking
• CALCFIELDS command / Determining the value of a FlowField
• CALCSUMS function / There's more...
• CalculateData function / How to do it...
• Caption property / Introduction
• CASE statement
  • multiple conditions, testing / Using a CASE statement to test multiple conditionsIF statementmultiple conditions, checking, How to do it...
  • working / How it works..., There's more...
• CHANGECOMPANY command / How it works...
• check mark, displaying on report
  • steps / How to do it...
  • working / How it works...
• CheckUserID function / How it works...
• class
  • FileIOPermission / How it works...
• CLEAR command / How it works...
• ClearPDFCreator function / How to do it..., How it works...
• Client Monitor
  • working / Introduction, How it works...
  • about / Using Client Monitor to diagnose problems
  • using, for problem diagnosis / How to do it...
• Code Coverage
  • about / Using Code Coverage
  • using / How to do it...
  • working / How it works...
  • use / There's more...
  • running, from code / Running Code Coverage from code
• CODECOVERAGELOG function / Running Code Coverage from code
• code repetition
  • loop, using / Repeating code using a loop
  • loop using, steps / How to do it...
  • loop used, working / How it works...
• ColumnHeader method / How it works...
• Common Dialog Management / How it works...
• communicator_OnSignin method / How it works...
• company-based menu suites
  • assigning / Assigning menu suites based on company, How to do it...
  • working / How it works...
• ContentArea / How it works...
• CopyHere function / How it works...
• CREATE command / How it works...
• CreateExcelBook function / How it works...
• CreateFile method / How it works...
• CREATE function / How it works...
• CreateMessage function / Sending an HTML formatted e-mail
• CreateWatermark function / How it works...
• CurrForm.UPDATE command / How it works...
• CurrReport.SHOWOUTPUT command / How it works...
• custom filters
  • adding, to request form / Adding custom filters to the request form, How to do it...
• custom NAS handler
  • about / Creating a custom NAS handler
  • creating / How to do it...
  • working / How it works...
• Custom Zoom menu button / There's more...

D

• data
  • dataretrieving, from another company / Retrieving data from another company
  • fields, totalling / Grouping data to display totals, How to do it...
  • sending, through FTP / Sending data through FTP, Getting ready
• data, retrieving
  • data, retrievingsteps / How to do it...
  • data, retrievingfrom another company, steps / How to do it...
  • data, retrievingworking / How it works...
• data, sending, through FTP
  • steps / How to do it...
  • working / How it works..., There's more...
• database
  • single record, retrieving from / Retrieving a single record from the database, How to do it...
  • GET command, working / How it works...
• data export
  • Excel buffer, using / Exporting data using the Excel buffer, How to do it...
• DataItemTableView property / How it works...
• DataPerCompany property / How it works...
• dataports
  • properties, setting / Introduction
  • creating / How to do it...
  • working / How it works...
  • Output Streams, using / There's more...
• data types
  • about / Introduction
• data validation
  • about / Validating data, There's more...
  • starting with / Getting ready
  • steps / How to do it...
  • working / How it works...
• date
  • details, determining / Determining the day, month, and year from a given date, How it works...
  • depreciation, calculating / Determining depreciation, See alsodatedepreciation, calculating
• DateFilter-Calc / Creating filters using other variable types
• date formulas
  • date, calculating / Using date formulas to calculate dates
  • CALCDATE() function, working / How it works...
• deadlocking
  • determining / How to do it...
  • sp_who command, working / How it works...
  • finding, ways / Another way to find deadlocks
• debugger
  • using / Using the debugger, How to do it...
  • working / How it works...
  • about / There's more...
  • limitations / There's more...
• DecomposeRowID() function / Linking records with strings
• default filter columns
  • changing / Changing default filter columns, How to do it...
  • working / How it works...
• DeleteSubKey function / There's more...
• Dialog / How it works...
• distinguishedName property / How it works...
• DOWNLOAD command / There's more...

E

• editable field
  • adding to non-editable form / Adding an editable field to a non-editable form, How to do it...
  • working / How it works...
• editable lookup forms
  • preventing / Preventing editable lookup forms
  • working / How it works...
  • Lookup mode / There's more...
• Editable property / Getting ready
• ELSE statement / How it works...
• EVALUATE() function
  • working / How it works...
  • about / There's more...

F

• fields
  • referencing / Referencing dynamic tables and fields, How to do it...
  • working / How it works..., There's more...
• filter
  • creating, variable types, used / Creating filters using other variable types
• FilterRecord function / How it works...
• FIND command
  • FIND commanddata, retrieving / Retrieving data using FIND
  • FIND commandworking / How it works...
• FlowField
  • FlowFieldworking / How it works...
  • FlowFieldusing / There's more...
  • FlowFieldvalue, determining / Determining the value of a FlowField
• FOR loop
  • using / There's more...
• function
  • creating / Creating a function
  • creating, steps / How to do it...
  • working / How it works...
  • local private function, creating / Creating local or private functions

I

• IF statement
  • condition, checking / Checking for conditions using an IF statement, How to do it...
  • working / How it works..., There's more...
  • multiple conditions, checking / Testing multiple conditions, Using a CASE statement to test multiple conditionsIF statementmultiple conditions, checking
• InitValue property / Populating date fields when a document is created
• INSERT command / Calling code when performing a transaction

K

• key
  • working / How it works...

M

• MARK function / How it works...
• method
  • InsertLogEntry() / Logging changes and events
  • MakeReminder() / Calculating reminder terms using date formulas

N

• .NET add-in
  • displaying, on page / Displaying a .NET add-in on a page, How to do it...
  • working / How it works...
• NAV
  • data validation / There's more...
• NoSeriesManagement / Incrementing a number series

O

• Object Designer
  • code, creating / How to do it...Progress Bardisplaying
• OnRun trigger / How to do it..., How to do it...
• OptionString / How it works...
• OptionString property / How it works...
• option variable
  • about / How to do it...option variableabout
  • creating / How to do it...option variableabout
  • working / How it works...
  • using, in documents / Using Options in documents

P

• parameters by reference
  • passing / Passing parameters by reference
  • passing, steps / How to do it...
  • working / How it works...
  • hangeCustomerNameRef function / How it works...
• Progress Bar
  • displaying / How to do it...Progress Bardisplaying
  • displaying, steps / How to do it...Progress Bardisplaying
  • working / How it works..., There's more...
  • reports, processing / Processing only reports
• property
  • propertyCalcFormula / How it works...

R

• records
  • viewing / Introduction
  • storing / Introduction
  • recordsmarking / How to do it...
  • recordsworking / How it works...
  • recordsmerging / Merging records
• records, merging
  • records, mergingstarting with / Getting ready
  • records, mergingsteps / How to do it...
  • records, mergingworking / How it works...
• recursion
  • about / Using recursion
  • using / How to do it...
  • working / How it works..., There's more...
• REPEAT..UNTIL loop
  • using / Using a REPEAT..UNTIL loop
• RESET function / How it works...
• ReverseEntry function / How it works...
• RoleTailored client / There's more...
• rollback routine
  • rollback routinewriting, steps / How to do it...
  • rollback routineworking / How it works...

S

• SIFT
  • SIFTabout / There's more...
• string
  • converting, into another data type / How to do it...stringconverting, into another data type
  • EVALUATE() function, working / How it works...
  • contents, manipulating / Manipulating string contents
• string contents
  • manipulating / How to do it...
  • working / How it works...
  • records, linking with / Linking records with strings
• STRLEN() function / How it works...
• SumIndex field
  • SumIndex fieldabout / Creating a SumIndex field
  • SumIndex fieldcreating, steps / How to do it...
  • SumIndex fieldworking / How it works...
  • SumIndex fieldneed for / There's more...
• system time
  • retrieving / Retrieving the system date and time
  • TODAY keyword / How it works...
  • CURRENTDATETIME, advantage / Logging changes and events

T

• table
  • about / How to do it...tableabout
  • creating / How to do it...tableabout
  • working / How it works...
  • key, adding to / Adding a key to a table
  • tableFlowField, adding / Adding a FlowField to a table
• TableNo property / There's more...
• temporary
  • temporaryworking / How it works...
• Temporary property / How to do it...
• temporary tables
  • temporary tablesdata, storing / Using temporary tables to store data, How to do it...
  • temporary tablesrecords, storing / Storing records to process
• transactions
  • creating, by data altering / Creating transactions to alter data, How to do it...
  • working / How it works...
  • code, calling / Calling code when performing a transaction
  • errors, catching / Catching errors when performing a transaction

V

• VALIDATE command / How it works...
• value
  • predefined date formats / Introduction, There's more...
  • converting, into formatted string / Converting a value to a formatted string, How to do it...
  • FORMAT function, working / How it works...
  • valueremoving / Clearing filters, keys, and values, How to do it...

W

• WaitUntilFileExists function / How to do it..., How it works...
• WHILE loop
  • using / Using a WHILE loop
• work date
  • about / Retrieving the work date
  • retrieving / How to do it...
  • working / How it works...
  • WORKDATE keyword, using / There's more...work dateWORKDATE keyword, using
  • date fields, populating / Populating date fields when a document is created