ISqlExpressionGenerator

Overview

Location

Required Methods

AddTime

 

method AddTime(date: String; value: String; interval: String): String

 

String AddTime(String date, String value, String interval)

 

Function AddTime(date As String, value As String, interval As String) As String

Parameters:

  • date:
  • value:
  • interval:

Date

 

method Date: String

 

String Date()

 

Function Date() As String

DatePart

 

method DatePart(date: String; interval: String): String

 

String DatePart(String date, String interval)

 

Function DatePart(date As String, interval As String) As String

Parameters:

  • date:
  • interval:

DateTime

 

method DateTime: String

 

String DateTime()

 

Function DateTime() As String

FormatDate

 

method FormatDate(date: String): String

 

String FormatDate(String date)

 

Function FormatDate(date As String) As String

Parameters:

  • date:

FormatDateTime

 

method FormatDateTime(date: String): String

 

String FormatDateTime(String date)

 

Function FormatDateTime(date As String) As String

Parameters:

  • date:

Length

 

method Length(value: String): String

 

String Length(String value)

 

Function Length(value As String) As String

Parameters:

  • value:

LowerCase

 

method LowerCase(value: String): String

 

String LowerCase(String value)

 

Function LowerCase(value As String) As String

Parameters:

  • value:

Modulo

 

method Modulo(divident: String; divisor: String): String

 

String Modulo(String divident, String divisor)

 

Function Modulo(divident As String, divisor As String) As String

Parameters:

  • divident:
  • divisor:

NoLock

 

method NoLock: String

 

String NoLock()

 

Function NoLock() As String

Substring

 

method Substring(value: String; index: String; count: String): String

 

String Substring(String value, String index, String count)

 

Function Substring(value As String, index As String, count As String) As String

Parameters:

  • value:
  • index:
  • count:

Time

 

method Time: String

 

String Time()

 

Function Time() As String

Trim

 

method Trim(value: String; trimChar: String): String

 

String Trim(String value, String trimChar)

 

Function Trim(value As String, trimChar As String) As String

Parameters:

  • value:
  • trimChar:

TrimLeft

 

method TrimLeft(value: String; trimChar: String): String

 

String TrimLeft(String value, String trimChar)

 

Function TrimLeft(value As String, trimChar As String) As String

Parameters:

  • value:
  • trimChar:

TrimRight

 

method TrimRight(value: String; trimChar: String): String

 

String TrimRight(String value, String trimChar)

 

Function TrimRight(value As String, trimChar As String) As String

Parameters:

  • value:
  • trimChar:

UpperCase

 

method UpperCase(value: String): String

 

String UpperCase(String value)

 

Function UpperCase(value As String) As String

Parameters:

  • value: