Search Results for fieldbase

 

Pull

Takes three parameters, QueryName, FieldBase, FieldNames

 

Plus8Encode

Takes three parameters, FieldBase, Fields, IfLenFld

 

ResetFields

Takes two parameters, FieldBase, FieldNames

 

Set

Takes four parameters, FieldBase, Destination, Source, IfLenFld

 

SendEmail

Takes 10 parameters, FieldBase, From, To, Subject, Body, bMerge, AttachName, AttachPath, Slow, IfLenFld

 

PickFirstField

Takes three parameters, FieldBase, Destination, SourceFields

 

MergeRecords

Takes 5 parameters, FieldBase, GroupBy, MergeField, Delimiter, bKeepBlanks

 

MergeFields

Takes 4 parameters, FieldBase, Destination, SourceFields, Delimiter

 

Num

Takes 6 parameters, FieldBase, Destination, Function, Source, Value, IfLenFld

 

Parse

Takes seven parameters, FieldBase, Destination, Source, bAny, Delimiter, Item, IfLenFld

 

Offset

Takes 7 parameters, FieldBase, Destination, Source, OffsetVal, Operator, OpValue, IfLenFld

 

Text

Takes six parameters, FieldBase, Destination, Function, Source, Value, IfLenFld

 

Sort

Takes two parameters, FieldBase, SortFieldList

 

Value

Takes four parameters, FieldBase, Destination, Function, IfLenFld

 

WithGroup

Takes six parameters, FieldBase, GroupByField, Destination, Action, Source, IfLenFld

 

WithAll

Takes five parameters, FieldBase, Destination, Action, Source, IfLenFld

 

SetNew

Takes four parameters, FieldBase, FieldName, Source, IfLenFld

 

SetIf

Takes six parameters, FieldBase, Destination, Source, Left, Comparison, Right

 

SetFirst

Takes four parameters, FieldBase, Destination, Source, IfLenFld

 

SetIfAll

Takes a variable number of parameters, FieldBase, Destination, Source, Test1, Test2, [etc...]

 

SetLast

Takes four parameters, FieldBase, Destination, Source, IfLenFld

 

SetIfAny

Takes a variable number of parameters, FieldBase, Destination, Source, Test1, Test2, [etc...]

 

KeepIfSimilar

Takes 3 parameters, FieldBase, pOne, pTwo

 

EnsureFields

Takes two parameters, FieldBase, FieldNames

 

DeleteFields

Takes two parameters, FieldBase, FieldNameList

 

Lookup

Takes six parameters, FieldBase, Destination, Table, Alias, SourceField, IfLenFld

 

Group

Takes 7 parameters, FieldBase, GroupBy, GroupTotals, GrandTotals, Seperator, TotalPre, TotalPost

 

Format

Takes five parameters, FieldBase, FieldList, Mask, bBlanks2Zero, IfLenFld

 

Files

Takes 5 parameters, FieldBase, Destination, Action, Source, IfLenFld

 

TopQuery

Takes one parameter, FieldBase

 

[Pull] List of Fields from another Query

Takes three parameters, QueryName, FieldBase, FieldNames

 

ForeignWith

Takes a single parameter, a FieldBase

 

Lang$

Takes four parameters, FieldBase, Destination, Source, IfLenFld

 

WorkWith

Takes one parameter, FieldBase

 

TopWith

Takes one parameter, FieldBase

 

KeepIfAll

Takes a variable number of parameters, FieldBase, Test1, Test2, [etc..]

 

KeepIf

Takes 4 parameters, FieldBase, Left, Comparison, Right

 

KeepIfFound

Takes 3 parameters, FieldBase, Fields, SearchTerms

 

KeepIfAny

Takes a variable number of parameters, FieldBase, Test1, Test2, [etc...]

 

Images

Takes up to 6 parameters, FieldBase, FileName, Action, Val1, Val2, IfLenField

 

NameField

Takes three parameters, FieldBase, OldFieldName, NewFieldName

 

DeleteTableField

Takes two parameters, a FieldBase and FieldNamesList

 

Pivot

Takes two parameters, FieldBase, PivotField

 

Plus8Decode

Takes three parameters, FieldBase, Fields, IfLenFld

 

LTrimFields

Takes one parameter, FieldBaseToTrim

 

EnsureNavFields

Takes two parameters, FieldBase, FieldNamesList

 

KeepFields

Takes two parameters, FieldBase, FieldNamesList

 

ParseRecords

Takes two parameters, WorkFieldBase + FieldToParse, Delimiter

 

NewFields

Takes two parameters, FieldBase, FieldNames

 

LFillFields

Takes one parameter, a FieldBase

 

Math

Takes a variable number of parameters

 

Build

Takes a variable number of parameters

 

Using the Backtick `

Some Work Query command parameters can accept a source of either a Work Query Field name or a text literal. Text literals in these cases are prefixed with a backtick ` character.