Integra for Notes Banner
  QuickReports Integra4Notes Integra Family of Products

Integra Script Library Documentation


Context:

Class Method (Function)

Library/Class:

FileExport Class



Function FileExport.GetNotesFieldText() As String

GetNotesFieldText (fd As Long, fstlp As Integer)

All data sent to Word is converted to type String. Integra applies following formatting rules:

Lotus Script
Data Type
Selected Field List Conversion
DATE (Variant)Date (D)Format(value,"dd.MMM.yyyy")
TIME (Variant)Time (T)Format(value,"hh:mm:ss")
NUMBERNumeric (N)"" & value
BOOLEAN (Integer)Logic (L)Depending on the data type of value

STRING: No Conversion
INTEGER: "False" (0) or "True" (any value other then 0)
OTHER: "False"
STRINGText (T)No conversion
VARIANTFormula (F)Any other data type is checked for being an array and converted to a single value string using following utilities function:

ArrayToString(value, multivalue separator)
valuerefers to the value as stored in export.record.fvalue(fd)

Note: if these conversion rules are not as desired, the profile developer can refer to Notes Formula (formula fields) or advanced Lotus Script to implement its own conversion formats.


Parameters:

    fd (Long)
      Index of the internal value representation of the Notes field or formula as defined in the Selected Field List, which is export.record.FValue()

      see also:
      export.record.structure.FName()
      export.record.structure.FType()
      export.record.structure.FMacr()
      export.record.structure.FNFX()
    fstlp (Integer)
      Internal parameter. Can be either True or False.

Return Value:

    String value presentation of the Notes field content as passed on with the parameter fd
 
QUICK LINKS
 
 

 

  © Shireburn Software Ltd. 2008 - 2024