System Control Tags

September 01, 2006, 12:41:18 pm
by administrator

/*CONTROL TAG BLOCK=MYTAG*/
Multi-line control tag creation

Replies: 3    Views: 557    Started by: administrator

September 04, 2006, 05:19:48 pm
by administrator

AAA {TagConstantPrefixSecurity=X}

Replies: 0    Views: 269    Started by: administrator

September 04, 2006, 05:20:23 pm
by administrator

AAA{TagFieldName}

Replies: 0    Views: 308    Started by: administrator

September 04, 2006, 05:21:01 pm
by administrator

AllowDelete
Allows data to be removed from a database

Replies: 0    Views: 248    Started by: administrator

September 04, 2006, 05:22:05 pm
by administrator

AllowInsert
Allows data to be written directly back to the dbs

Replies: 0    Views: 241    Started by: administrator

September 04, 2006, 05:22:56 pm
by administrator

AllowUpdate
Allow for data to be written back to the database

Replies: 0    Views: 270    Started by: administrator

September 04, 2006, 05:23:42 pm
by administrator

Control Tag Resolution
Order of Control Tag Resolution

Replies: 0    Views: 332    Started by: administrator

September 04, 2006, 05:25:21 pm
by administrator

Delayed control tag resolution
How to suspend resolution of control tags

Replies: 0    Views: 554    Started by: administrator

September 01, 2006, 12:44:08 pm
by administrator

{/##/##}
Suppress a field given a specific code path

Replies: 1    Views: 394    Started by: administrator

September 01, 2006, 12:45:12 pm
by administrator

{999}
Hide a table, field or join from the Vision user

Replies: 0    Views: 292    Started by: administrator

September 01, 2006, 12:46:49 pm
by administrator

{AccessStart}{AccessEnd}
Microsoft Access Control Tag Switches/Platform Control Tag

Replies: 1    Views: 370    Started by: administrator

September 01, 2006, 12:48:18 pm
by administrator

{AlchemyJoinBracket}
Special Join Bracket logic to assist Microsoft Access databases handling of mid tables without sql errors

Replies: 1    Views: 413    Started by: administrator

September 01, 2006, 12:50:00 pm
by administrator

{AlchemyOverrideGroupByClauseStart}{AlchemyOverrideGroupByClauseEnd}
Override the SQL output in the GROUP BY clause

Replies: 1    Views: 435    Started by: administrator

September 01, 2006, 12:55:06 pm
by administrator

{AlchemyOverrideOutputClauseStart} {AlchemyOverrideOutputClauseEnd}
Override SQL name field in SQL Output

Replies: 2    Views: 454    Started by: administrator

September 01, 2006, 12:58:11 pm
by administrator

{AlchemyOverrideWhereClauseStart} {AlchemyOverrideWhereClauseEnd}
Override the SQL field name in the WHERE clause

Replies: 1    Views: 415    Started by: administrator

September 01, 2006, 12:59:26 pm
by administrator

{AlchInvNode}
Invisible Table Fields

Replies: 0    Views: 283    Started by: administrator

September 01, 2006, 01:00:44 pm
by administrator

{BtrieveStart}{BtrieveEnd}
Btrieve Control Tag Switches / Platform Control Tag

Replies: 0    Views: 245    Started by: administrator

September 01, 2006, 01:01:22 pm
by administrator

{CurrentTreePath}
Allows flexibility when creating User Defined Output fields

Replies: 0    Views: 257    Started by: administrator

September 01, 2006, 01:05:50 pm
by administrator

{FilterKey#CodePath(D)}
Retrieve Original Value

Replies: 2    Views: 472    Started by: administrator

September 01, 2006, 01:10:50 pm
by administrator

{FilterKey1##}{FilterKey2##}
To/From Filter Values

Replies: 3    Views: 493    Started by: administrator

September 01, 2006, 01:11:34 pm
by administrator

{FilterKey1#WildCardSearch#}
Wild Card Search

Replies: 0    Views: 256    Started by: administrator

September 01, 2006, 02:43:02 pm
by administrator

{FilterKey1/##/##/##(!)}
Suppress FilterKey search error messages

Replies: 0    Views: 278    Started by: administrator

September 01, 2006, 02:44:38 pm
by administrator

{FilterKey1/../}
Enhancement to Filter Control Tags to allow access to filter index

Replies: 0    Views: 308    Started by: administrator

September 01, 2006, 02:46:29 pm
by administrator

{FilterKey1CheckValue} {FilterKey2CheckValue}
Check Filter Values

Replies: 0    Views: 274    Started by: administrator

September 01, 2006, 02:47:14 pm
by administrator

{FilterKey1ConnectionDatabase}
A system control tag that can be used to return the current database

Replies: 0    Views: 278    Started by: administrator

September 01, 2006, 02:48:01 pm
by administrator

{FilterKey1ConnectionDataDirectory}
Data Directory of DSN

Replies: 0    Views: 250    Started by: administrator

September 01, 2006, 02:48:52 pm
by administrator

{FilterKey1ConnectionDriveName}
The ODBC driver DLL name used in the connection

Replies: 0    Views: 254    Started by: administrator

September 01, 2006, 02:49:34 pm
by administrator

{FilterKey1ConnectionIndex}
Connection details

Replies: 0    Views: 237    Started by: administrator

September 01, 2006, 02:50:20 pm
by administrator

{FilterKey1ConnectionPlatform}
A system control tag that can be used to return the current database platform

Replies: 0    Views: 263    Started by: administrator

September 01, 2006, 02:51:47 pm
by administrator

{FilterKey1LookupCodePath……….}
Control Tag For Codepath Details in Lookups

Replies: 0    Views: 253    Started by: administrator

September 01, 2006, 02:52:26 pm
by administrator

{FilterKey1LookupFieldDesc}
System Control Tag for Lookups

Replies: 0    Views: 264    Started by: administrator

September 01, 2006, 02:53:41 pm
by administrator

{FilterKey1LookupP1} to {FilterKey1LookupP9}
Lookup referencing Parameters

Replies: 1    Views: 379    Started by: administrator

September 01, 2006, 02:55:39 pm
by administrator

{FilterKey1Module#####}
Module Details

Replies: 1    Views: 401    Started by: administrator

September 01, 2006, 02:59:18 pm
by administrator

{FilterKey1PeriodCalCurrentPPP}
Period Calculation

Replies: 0    Views: 276    Started by: administrator

September 01, 2006, 03:02:31 pm
by administrator

{FilterKey1PeriodCalCurrentYYYY}
Always picks up the current year as defined in your serduct

Replies: 0    Views: 271    Started by: administrator

September 01, 2006, 05:30:20 pm
by administrator

{FilterKey1PeriodCalCurrentYYYY}
Always picks up the current year as defined in your serduct

Replies: 0    Views: 243    Started by: administrator

September 01, 2006, 02:57:14 pm
by administrator

{FilterKey1PeriodCalCurrent}
Period Calculation

Replies: 0    Views: 320    Started by: administrator

September 01, 2006, 03:05:29 pm
by administrator

{FilterKey1PeriodCalFirstPeriod}
Period Calculation

Replies: 0    Views: 245    Started by: administrator

September 01, 2006, 03:06:58 pm
by administrator

{FilterKey1PeriodCalIsRelative}
Period Calculation

Replies: 0    Views: 265    Started by: administrator

September 01, 2006, 03:07:28 pm
by administrator

{FilterKey1PeriodCalMax}
Period Calculation

Replies: 0    Views: 241    Started by: administrator

September 01, 2006, 03:08:46 pm
by administrator

{FilterKey1PeriodCalOffset2}
Period Calculation

Replies: 0    Views: 237    Started by: administrator

September 01, 2006, 03:08:12 pm
by administrator

{FilterKey1PeriodCalOffset}
Period Calculation

Replies: 0    Views: 255    Started by: administrator

September 01, 2006, 03:10:23 pm
by administrator

{FilterKey1PeriodCalPeriodFromPPPBalance}
Period Calculation

Replies: 0    Views: 245    Started by: administrator

September 01, 2006, 03:09:48 pm
by administrator

{FilterKey1PeriodCalPeriodFromPPP}
Period Calculation

Replies: 0    Views: 266    Started by: administrator

September 01, 2006, 03:11:04 pm
by administrator

{FilterKey1PeriodCalPeriodFromYYYY}
Period Calculation

Replies: 0    Views: 286    Started by: administrator

September 01, 2006, 03:09:21 pm
by administrator

{FilterKey1PeriodCalPeriodFrom}
Period Calculation

Replies: 0    Views: 251    Started by: administrator

September 01, 2006, 03:12:49 pm
by administrator

{FilterKey1PeriodCalPeriodToPPP}
Period Calculation

Replies: 0    Views: 241    Started by: administrator

September 01, 2006, 03:13:32 pm
by administrator

{FilterKey1PeriodCalPeriodToYYYY}
Period Calculation

Replies: 0    Views: 255    Started by: administrator

September 01, 2006, 03:11:37 pm
by administrator

{FilterKey1PeriodCalPeriodTo}
Period Calculation

Replies: 0    Views: 264    Started by: administrator

September 01, 2006, 03:15:07 pm
by administrator

{FilterKey1PeriodCalTypeGroup}
Period Calculation

Replies: 0    Views: 270    Started by: administrator

September 01, 2006, 03:14:27 pm
by administrator

{FilterKey1PeriodCalType}
Period Calculation

Replies: 0    Views: 249    Started by: administrator

September 01, 2006, 03:17:07 pm
by administrator

{FilterKey1ProductAuthorProductRegistration99}
Serduct Author and Registration for modules 1 to 99

Replies: 0    Views: 278    Started by: administrator

September 01, 2006, 03:16:03 pm
by administrator

{FilterKey1ProductAuthorProductRegistration}
Serduct Author and Registration

Replies: 0    Views: 276    Started by: administrator

September 01, 2006, 03:17:38 pm
by administrator

{FilterKey1ProductCode}
Serduct Internal Code

Replies: 0    Views: 289    Started by: administrator

September 01, 2006, 03:18:37 pm
by administrator

{FilterKey1ProductDemoMode}
Determines if the serduct has been serialised

Replies: 1    Views: 400    Started by: administrator

September 01, 2006, 03:19:48 pm
by administrator

{FilterKey1ProductDescription}
Serduct Description Serduct Description

Replies: 1    Views: 369    Started by: administrator

September 01, 2006, 03:27:08 pm
by administrator

{FilterKey1ProductVersion}
Serduct Version

Replies: 0    Views: 272    Started by: administrator

September 01, 2006, 03:28:36 pm
by administrator

{FilterKey1QModeAdhocDrillDetRpt}
Used to detect the current report type

Replies: 1    Views: 366    Started by: administrator

September 01, 2006, 03:32:01 pm
by administrator

{FilterKey1QModeAdhocDrillSumRpt}
Used to detect the current report type

Replies: 3    Views: 443    Started by: administrator

September 01, 2006, 03:33:18 pm
by administrator

{FilterKey1QModeDatLink}
Defines the Data Link query mode type

Replies: 1    Views: 372    Started by: administrator

September 01, 2006, 03:35:18 pm
by administrator

{FilterKey1QModeDetRpt}
Defines the Detailed Report Query Mode

Replies: 2    Views: 436    Started by: administrator

September 01, 2006, 03:41:43 pm
by administrator

{FilterKey1QModeSumLink}
Defines the Summary Link Query Mode

Replies: 2    Views: 419    Started by: administrator

September 01, 2006, 03:43:51 pm
by administrator

{FilterKey1QModeSumRpt}
Defines the Summary Report Query Mode

Replies: 2    Views: 447    Started by: administrator

September 01, 2006, 03:37:42 pm
by administrator

{FilterKey1QModes|DetRpt|AdhocDrillDetRpt}
Defines multiple modes for a table or field

Replies: 2    Views: 429    Started by: administrator

September 01, 2006, 03:44:25 pm
by administrator

{FilterKey1SecurityViewActiveColumnCount}
Security View

Replies: 0    Views: 283    Started by: administrator

September 01, 2006, 03:45:04 pm
by administrator

{FilterKey1SecurityViewBitMask00} ... {FilterKey1SecurityViewBitMask00}
Bit Mask Security View

Replies: 0    Views: 268    Started by: administrator

September 01, 2006, 03:47:08 pm
by administrator

{FilterKey1SqlErrorDesc}
Description returned from the SQL error returned

Replies: 1    Views: 387    Started by: administrator

September 01, 2006, 03:50:56 pm
by administrator

{FilterKey1SqlErrorNo}
Used to detect if error message was generated

Replies: 4    Views: 605    Started by: administrator

September 01, 2006, 03:51:38 pm
by administrator

{FilterKey1SystemApplicationId}
Application ID e.g. Vision Setup is 1

Replies: 0    Views: 303    Started by: administrator

September 01, 2006, 03:52:39 pm
by administrator

{FilterKey1SystemIsLasata}
Are we connected to the Lasata network

Replies: 0    Views: 278    Started by: administrator

September 01, 2006, 03:53:19 pm
by administrator

{FilterKey1SystemIsTerminalServer}
Detect if environment is Terminal Server/Citrix

Replies: 0    Views: 297    Started by: administrator

September 01, 2006, 04:02:37 pm
by administrator

{FilterKey1SystemModeDemo}
When not Serialised so in Demo mode

Replies: 0    Views: 285    Started by: administrator

September 01, 2006, 04:03:13 pm
by administrator

{FilterKey1SystemModeDeveloper}
Determine if serialisation allows developer mode

Replies: 0    Views: 259    Started by: administrator

September 01, 2006, 04:15:15 pm
by administrator

{FilterKey1SystemSerialLicenseeNo}
Uniform Licensee No as appears on logon window

Replies: 0    Views: 299    Started by: administrator

September 01, 2006, 04:14:29 pm
by administrator

{FilterKey1SystemSerialLicensee}
Uniform Licensee name as appears on logon window

Replies: 0    Views: 303    Started by: administrator

September 01, 2006, 04:15:43 pm
by administrator

{FilterKey1SystemSilentRunning}
Silent Running Mode e.g. unattended installation

Replies: 0    Views: 288    Started by: administrator

September 01, 2006, 04:16:35 pm
by administrator

{FilterKey1TableAccess:######}
User Profile Table Access Details

Replies: 1    Views: 366    Started by: administrator

September 01, 2006, 04:17:29 pm
by administrator

{FilterKey1TableAlias:###}
This tag will return the alias (ie the {id1} ) assigned to the given table

Replies: 0    Views: 260    Started by: administrator

September 01, 2006, 04:18:12 pm
by administrator

{FilterKey1TableCodeInt}
Lookup only control tag

Replies: 0    Views: 267    Started by: administrator

September 01, 2006, 04:18:38 pm
by administrator

{FilterKey1TableCodeUser}
Lookup only control tag

Replies: 0    Views: 275    Started by: administrator

September 01, 2006, 04:19:08 pm
by administrator

{FilterKey1TableDesc}
Lookup only control tag

Replies: 0    Views: 283    Started by: administrator

September 01, 2006, 04:20:57 pm
by administrator

{FilterKey1TableID:###}
This tag will return the Table ID assigned to the given table codepath

Replies: 1    Views: 387    Started by: administrator

September 01, 2006, 04:21:53 pm
by administrator

{FilterKey1TableIsChild}
Detect if a field or join is in a child table

Replies: 0    Views: 249    Started by: administrator

September 01, 2006, 04:22:38 pm
by administrator

{FilterKey1TableIsRoot}
Detect whether a field or join is in the root table

Replies: 0    Views: 259    Started by: administrator

September 01, 2006, 04:23:18 pm
by administrator

{FilterKey1TableName}
Table name

Replies: 0    Views: 267    Started by: administrator

September 01, 2006, 04:24:29 pm
by administrator

{FilterKey1TaskGet#####[[...]]}
Retrieve Task Details - General Format

Replies: 0    Views: 291    Started by: administrator

September 01, 2006, 04:27:25 pm
by administrator

{FilterKey1TaskGetFound[[...]]}
Retrieve Parameter details

Replies: 1    Views: 406    Started by: administrator

September 01, 2006, 04:29:57 pm
by administrator

{FilterKey1TaskGetLastUpdated[[...]]}
Retrieve Date/Time Details for when a task was last updated

Replies: 0    Views: 285    Started by: administrator

September 01, 2006, 04:30:44 pm
by administrator

{FilterKey1TaskGetTimeTaken[[...]]}
Retrieve execution details

Replies: 0    Views: 269    Started by: administrator

September 01, 2006, 04:33:15 pm
by administrator

{FilterKey1TaskGetUpdatedBy[[...]]}
Retrieve User Code Details for when a task was last updated

Replies: 1    Views: 352    Started by: administrator

September 01, 2006, 04:34:29 pm
by administrator

{FilterKey1TaskLastUpdated}
Retrieve date/time details

Replies: 0    Views: 264    Started by: administrator

September 01, 2006, 04:35:08 pm
by administrator

{FilterKey1TaskTimeTaken}
Retrieve Execution Details

Replies: 0    Views: 253    Started by: administrator

September 01, 2006, 04:36:14 pm
by administrator

{FilterKey1TaskUpdatedBy}
Task updated by

Replies: 0    Views: 270    Started by: administrator

September 01, 2006, 04:41:35 pm
by administrator

{FilterKey1VbScriptResult}
Used for passing a resulting value from VbScript to SQL

Replies: 0    Views: 275    Started by: administrator

September 01, 2006, 04:43:01 pm
by administrator

{FilterOnly}
Fixed Lookup element

Replies: 0    Views: 270    Started by: administrator

September 01, 2006, 01:02:28 pm
by administrator

{Filter} {FilterId}
Control Tags associated with Join Lookup Fields

Replies: 0    Views: 265    Started by: administrator

September 01, 2006, 04:43:50 pm
by administrator

{FoxProStart}{FoxProEnd}
Microsoft Foxpro Control Tag Switches/Platform Control Tag

Replies: 0    Views: 278    Started by: administrator

September 01, 2006, 04:45:27 pm
by administrator

{fromcode} {focode}
SQL Lookup From/To Values

Replies: 1    Views: 369    Started by: administrator

September 01, 2006, 04:50:21 pm
by administrator

{FuncSum 2|3|1=AAA|2=BBB|3=CCC|FuncSumEnd}
Multiple Field Columns

Replies: 0    Views: 244    Started by: administrator

September 01, 2006, 04:49:46 pm
by administrator

{FuncSum {FilterKey1.../Period}|{FilterKey2.../Period}#|#|#|#|#|FuncSumEnd}
Summing multiple fields

Replies: 0    Views: 274    Started by: administrator