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

 

NewWithAttach

Takes 4 parameters, TableName, Relation, OtherTableName, IfLenFld

 

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

 

Parents

Takes three parameters, ChildTableName, ParentTableName, Mode

 

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

 

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.

 

LoadTableFiles

Takes one parameter, TableName

 

[+] 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.

 

Children

Takes two parameters, ChildTableName, Mode

 

FirstAlias$

Takes one parameter, TableName

 

LastAlias$

Takes one parameter, 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.

 

Get

Takes one parameter, a TableName

 

FieldDef$

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

 

EnsureFields

Takes two parameters, FieldBase, FieldNames

 

 

Text

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

 

GetFieldDefs

Has no parameters.

 

GoTo

Takes one parameter, a Label

 

MakeValidTable$

Takes one parameter, Source

 

 

CopyTable

Takes two parameters, destinationTable, sourceTable