DB.GetTopN

SiMX Help‎ > ‎The Target Platform‎ > ‎Objects‎ > ‎DB Object‎ > ‎

Platform Objects

DB Object
DBCreator Object
DS (Data Source)
- alias
- CallFunction
- CallProcedure
- clsid
- Create
- csv_col_separator
- csv_include_column_names
- csv_positional
- csv_text_qualifier
- database
- Drop
- dsn
- Execute
- extension
- Format
- GetAsString
- GetCustomSelect
- GetFieldNames
- GetFROM
- GetRelation
- GetTableNames
- LoadFields
- password
- ReplaceTable
- schema
- SetCustomSelect
- SetDS
- SetFROM
- SetParam
- table
- TableExists
- user
- valid
TARGET Object
- target.array
  - Add
  - Allocate
  - Chop
  - Clone
  - Empty
  - Find
  - First
  - Get
  - GetArray
  - Insert
  - Join
  - Last
  - Remove
  - Set
  - SetArray
  - Sort
  - UBound
- target.ArrayFind
- target.ArrayInsert
- target.CloseAllDBConnections
- target.CreateObject
- target.Execute
- target.file
  - Copy
  - Delete
  - Exists
  - GetDate
  - GetExtension
  - GetExtensionByMIME
  - GetFileNames
  - GetMIME
  - GetName
  - GetSize
  - GetText
  - IsLocked
  - IsTextPDF
  - Move
  - Read
  - Rename
  - Replace
  - SetDate
  - Unzip
  - Write
  - Zip
- target.FormatDate
- target.FormatNumeric
- target.GetDateRange
- target.GetItem
- target.GetMessage
- target.GetProcessData
- target.GetProcesses
- target.GetProcessID
- target.GetProcessTime
- target.GetService
- target.GetStartPath
- target.GetUniqueString
- target.hash_table
  - Add
  - AddOnce
  - Clone
  - Count
  - Empty
  - Find
  - GetByIndex
  - GetByKey
  - Remove
  - UBound
- target.IIF
- target.InitDate
- target.InitNumeric
- target.IsEmpty
- target.IsNumeric
- target.IsRunning
- target.IsTrue
- target.KillProcess
- target.mail
  - Connect
  - Delete
  - Disconnect
  - GetMessage
  - GetMessages
  - Move
  - Send
  - SetAttachments
  - SetCC
  - SetFont
  - SetPickupFolder
  - SetSMTP
- target.map
  - Clone
  - Empty
  - Get
  - GetRadio
  - GetValue
  - IsEmpty
  - IsFull
  - IsTrue
  - Set
  - SetAll
  - SetRadio
  - SetValue
- target.Max
- target.Message
- target.Min
- target.progress
  - Increment
  - SetLimit
- target.Replace
- target.RunOnce
- target.SaveProject
- target.Sleep
- target.Sort
- target.SplitString
- target.strlib
  - Chop
  - Delete
  - Extract
  - Extract1
  - FilterIn
  - FilterOut
  - GetAddress
  - GetCityStateZip
  - GetEmail
  - GetName
  - GetPhone
  - GetSSN
  - GetWord
  - GetWords
  - InStr
  - IsAlphaNumeric
  - Mid
  - Pad
  - Replace
  - SetCaseSensitive
  - Split
  - Trim
- target.TimerGet
- target.TimerSet
- target.Update
- target.Validate
- target.weblink
  - CopyTo
  - Download
  - HTTPRequest
  - NSLookup
  - Respond
Value

Description

This will return the Top N value of the objects select statement.

Syntax

Function GetTopN

Parameters

none

Return value

The Top N value

See also

Platform Objects and Methods
DB.sort
DB.AppendFinish

	Search this site