Search Results for tablename

 

Detach

Takes 3 parameters, ParentTableName, ChildTableName, and a boolean expression (optional)

 

DetachWithDelete

Takes 4 parameters, TableName, Relation, OtherTableName, and a boolean expression (optional)

 

New

Takes two parameters, TableName, IfLenFld

 

AppendTable

Takes one parameter, TableName

 

Attach

Takes 3 parameters, ParentTableName, ChildTableName, IfLenFld

 

Delete

Takes two parameters, TableName and a boolean expression

 

Update

A database command which takes two parameters, TableName, IfLenFld

 

UpdateOrNew

A database command which takes two parameters, TableName, IfLenFld

 

UpdateOrNewWithAttach

A database command which takes four parameters, TableName, Relation, OtherTableName, IfLenFld

 

NewWithAttach

Takes 4 parameters, TableName, Relation, OtherTableName, IfLenFld

 

Search

Takes three parameters, TableName, SearchTerms, SearchInFields

 

UnloadTableFiles

Takes one parameter, TableName

 

[L] Lookup (DB Field Attribute)

Parameter is the database path that is to be looked up in the form of TableName|Alias|FieldName where it may be a specific fixed path or you may use {} to replace one or more of the path components where the value inside the {} is a field name in the current record.

 

Exists$

Takes two parameters, DBTableName, DBTableRecordAlias

 

LoadTableFields

Takes one parameter, TableName

 

LoadRecord

Takes two parameters, TableName, RecordAlias

 

LoadTable

Takes one parameter, TableName

 

LoadTableFiles

Takes one parameter, TableName

 

PWHash

Takes three parameters, TableName, Alias, Password

 

[A] Copy Attached Value

Parameter must first specify only looking at Parents ( PARENT ) or only looking at Children ( CHILD ). The remainder of the parameter should be the table and field name you are after in the form of TableName.FieldName.

 

[+] Sum of Field of Attached Child Records

Parameter is the table and field name that you want to sum in the form of TableName.FieldName. The specified Table must be a Child of the calling Record.

 

Parents

Takes three parameters, ChildTableName, ParentTableName, Mode

 

FieldDef$

Takes a single parameter, in the format of TableName.FieldName#Deff where Deff is one of: Label, Attr, Note, or DevNote

 

Children

Takes two parameters, ChildTableName, Mode

 

LastAlias$

Takes one parameter, TableName

 

FirstAlias$

Takes one parameter, TableName

 

Get

Takes one parameter, a TableName

 

[L] Lookup (Top Query)

Parameter is the database path that is to be looked up in the form of TableName|Alias|FieldName where it may be a specific fixed path or you may use {} to replace one or more of the path components where the value inside the {} is a field name in the current record.

 

 

EnsureFields

Takes two parameters, FieldBase, FieldNames

 

Text

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

 

GetFieldDefs

Has no parameters.

 

CopyTable

Takes two parameters, destinationTable, sourceTable

 

MakeValidTable$

Takes one parameter, Source

 

 

GoTo

Takes one parameter, a Label