Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

SyntaxColoring.SetShowFieldAndTableIDs

Set whether to show field and table IDs.

Component Version macOS Windows Linux Server iOS SDK
SyntaxColoring 7.4 ✅ Yes ❌ No ❌ No ❌ No ❌ No
MBS( "SyntaxColoring.SetShowFieldAndTableIDs"; Value )   More

Parameters

Parameter Description Example
Value The new setting.
Pass 1 to enable or 0 to disable.		 1

Result

Returns OK or error.

Description

Set whether to show field and table IDs.
Our plugin can optionally show checkboxes for field and table IDs in database design dialog.

You can check them to show a column with IDs. As querying IDs can take a while, we make those checkboxes and have them off by default.

If IDs can not be found, we show a question mark.
If between two IDs one is missing, we add a star.

Please report sample databases which do not show them so we can fix issues.
This setting can be set via the preferences dialog, too.

The check box is hidden, if the initial gathering of table names via SQL fails, e.g. due to a permission error.

Examples

Turn on all the IDs for macOS:

Set Variable [$r; Value: MBS( "SyntaxColoring.SetShowValueListIDs"; 1 )]
Set Variable [$r; Value: MBS( "SyntaxColoring.SetShowScriptIDs"; 1 )]
Set Variable [$r; Value: MBS( "SyntaxColoring.SetShowLayoutIDs"; 1 )]
Set Variable [$r; Value: MBS( "SyntaxColoring.SetShowFieldAndTableIDs"; 1 )]

See also

Release notes

Blog Entries

This function is free to use.

Created 20th September 2017, last changed 14th January 2023


SyntaxColoring.SetScriptSearchColor - SyntaxColoring.SetShowLayoutIDs