Data Entry and Editing

AddRow (Entry as String, Locator as String) As Long

DeleteCurRow () as Long

GetCellFieldNo () As Long

GetCellText () as String

PutCellText (NewText as String) As Long

GetEntry () as String

PutEntry (Entry as String) As String

GetLocator () as String

PutLocator (NewLocator as String) As String

GetLabel () As Long

PutLabel (Label as Long) As Long

GetSortOrder () As siSortOrders

GroupOnRecNos (RecNos as String) As Boolean

Current Row Status

CurRowRecNo () As Long

CurRowCreator () As String

CurRowEditor () As String

CurRowDateCreated () As String

CurRowDateEdited () As String

Find

FindHeading (HeadingIndex as Integer, FindText as String) as Long

FindNextHeading () as Long

GetFindHeadingOffset () As Long

FindEntry (FindText as String)

FindNextEntry () as Long

GetFindEntryOffset () As Long

FindLocator (FindText as String) as Long

FindNextLocator () as Long

GetFindLocatorOffset () As Long

Navigation

FirstRow () As Long (returns record number)

LastRow () As Long

PreviousRow () As Long

NextRow () As Long

FirstCell () As Long

LastCell () As Long

NextCell () As Long

PreviousCell () As Long

GotoRecord (RecordNumber As Long) as Boolean

GetFirstRowRecNo () As Long

GetLastRowRecNo () As Long

Index

Backup (Path as String) As String (returns path or null)

GenerateIndex () As String

IndexRows Collection

CommitRowChanges (UndoCaption as String) As Boolean

LoadIndexRows () As Boolean

Connection to SKY

RequestConnection () as Boolean

CloseConnection () as Boolean

Word Embed

SetConfigForWordEmbed () As Boolean

Built-in SKY Index Functions

ExecuteSKYIndexCommand (Command as SKYIndexCommands) as Long

Sky Styled Text Functions

InString (StyledText As String, Text As String, Optional Compare As Integer = 1) As Integer (same as InStr)

InStringRev (StyledText As String, Text As String, Optional Compare As Integer = 1) As Integer (same as InStrRev)

InsertStr (StyledText As String, Offset As Integer, Text As String) As String

SplitStr (ByVal StyledText As String, ByVal Delimiter As String) As String() (same as Split)

Stuff (StyledText As String, Offset As Integer, DeleteCount As Integer, InsertText As String, Optional Style As TextStyle) As String

LeftStr (StyledText as String, Count as Long) As String

MidStr (StyledText As String, Offset As Integer, Optional Length As Integer = -1) As String (same as Mid)

RightStr (StyledText as String, Count as Long) As String

LenStr (StyledText as String) As String

PlainStr (StyledText as String) As String

TrimStr (StyledText as String) As String

LTrimStr (StyledText as String) As String

RTrimStr (StyledText as String) As String

RemoveLeadingPunctuationStr (StyledText as String, Optional Punctuation as String) As String

RemoveTrailingPunctuationStr (StyledText as String, Optional Punctuation as String) As String

Grid View (Sort/Filter/Group)

SetSortOrder (SortOrder As siSortOrders, MaintainGroup as Boolean) As Boolean

SetFilter (Settings as String) As Boolean

ClearFilter () As Boolean