AClass Function (VFP)

ADatabases Function (VFP)

ADBObjects Function (VFP)

AddBs Function (VFP)

AddProperty Function (VFP)

ADel Function (VFP)

ADLLS Function (VFP)

ADOCKSTATE Function (VFP)

AElement Function (VFP)

AERROR Function (VFP)

AEVENTS Function (VFP)

AFONT Function (VFP)

AGETCLASS Function (VFP)

AGetFileVersion Function (VFP)

AIns Function (VFP)

AINSTANCE Function (VFP)

ALANGUAGE Function (VFP)

ALen Function (VFP)

ALines Function (VFP)

AllTrim Function (VFP)

AMembers Function (VFP)

AMOUSEOBJ Function (VFP)

ANetResources Function (VFP)

APrinters Function (VFP)

APROCINFO Function (VFP)

ASELOBJ Function (VFP)

ASessions Function (VFP)

ASize Function (VFP)

ASqlHandles Function (VFP)

AStackInfo Function (VFP)

ASubScript Function (VFP)

At Function (VFP)

At_C Function (VFP)

ATagInfo Function (VFP)

AtC Function (VFP)

AtCC Function (VFP)

AUsed Function (VFP)

AVCXCLASSES Function (VFP)

BagCount Function (VFP)

BAR Function (VFP)

BARCOUNT Function (VFP)

BARPROMPT Function (VFP)

BINDEVENT Function (VFP)

BinToc Function (VFP)

BitAnd Function (VFP)

BitClear Function (VFP)

BitLShift Function (VFP)

BitNot Function (VFP)

BitOr Function (VFP)

BitRShift Function (VFP)

BitSet Function (VFP)

BitTest Function (VFP)

BitXor Function (VFP)

Candidate Function (VFP)

CapsLock Function (VFP)

Cdx Function (VFP)

Ceiling Function (VFP)

ChrTran Function (VFP)

ChrTranC Function (VFP)

COMARRAY Function (VFP)

COMCLASSINFO Function (VFP)

CompObj Function (VFP)

COMPROP Function (VFP)

COMRETURNERROR Function (VFP)

CpConvert Function (VFP)

CpCurrent Function (VFP)

CpDbf Function (VFP)

CREATEBINARY Function (VFP)

CreateObject Function (VFP)

CreateObjectEx Function (VFP)

CreateOffline Function (VFP)

CToBin Function (VFP)

CToT Function (VFP)

CursorGetProp Function (VFP)

CursorSetProp Function (VFP)

CursorToXML Function (VFP)

CurVal Function (VFP)

DbAlias Function (VFP)

DbAppDelimFox Function (VFP)

DbAppendFromArray Function (VFP)

DbAppFox Function (VFP)

Dbc Function (VFP)

DbCopyDelimFox Function (VFP)

DbCopyFox Function (VFP)

DbCopyToArray Function (VFP)

DbGetProp Function (VFP)

DbSetProp Function (VFP)

DbSortFox Function (VFP)

DbUsed Function (VFP)

DDEAbortTrans Function (VFP)

DDEAdvise Function (VFP)

DDEEnabled Function (VFP)

DDEExecute Function (VFP)

DDEInitiate Function (VFP)

DDELastError Function (VFP)

DDEPoke Function (VFP)

DDERequest Function (VFP)

DDESetOption Function (VFP)

DDESetService Function (VFP)

DDESetTopic Function (VFP)

DDETerminate Function (VFP)

DefaultExt Function (VFP)

Descending Function (VFP)

Difference Function (VFP)

DisplayPath Function (VFP)

DMY Function (VFP)

DriveType Function (VFP)

DropOffLine Function (VFP)

DToT Function (VFP)

EDITSOURCE Function (VFP)

ERROR Function (VFP)

EVENTHANDLER Function (VFP)

EVL Function (VFP)

Field Function (VFP)

FileToStr Function (VFP)

Filter Function (VFP)

FKLABEL Function (VFP)

FKMAX Function (VFP)

FldCount Function (VFP)

FldList Function (VFP)

FontMetric Function (VFP)

For Function (VFP)

ForceExt Function (VFP)

ForcePath Function (VFP)

FullPath Function (VFP)

FV Function (VFP)

GetAutoIncValue Function (VFP)

GETBAR Function (VFP)

GetColor Function (VFP)

GetCp Function (VFP)

GetCursorAdapter Function (VFP)

GetDir Function (VFP)

GetFile Function (VFP)

GetFldState Function (VFP)

GetFont Function (VFP)

GETINTERFACE Function (VFP)

GetNextModified Function (VFP)

GetObject Function (VFP)

GETPAD Function (VFP)

GETPEM Function (VFP)

GetPict Function (VFP)

GetPrinter Function (VFP)

GetResultSet Function (VFP)

GetWordCount Function (VFP)

GetWordNum Function (VFP)

GoMonth Function (VFP)

IdxCollate Function (VFP)

ImeStatus Function (VFP)

InDbc Function (VFP)

IndexSeek Function (VFP)

INKEY Function (VFP)

InputBox Function (VFP)

InsMode Function (VFP)

IsBlank Function (VFP)

IsColor Function (VFP)

IsExclusive Function (VFP)

IsFlocked Function (VFP)

ISLEADBYTE Function (VFP)

IsMemoFetched Function (VFP)

IsMouse Function (VFP)

IsNull Function (VFP)

IsPen Function (VFP)

IsReadOnly Function (VFP)

IsRlocked Function (VFP)

IsTransactable Function (VFP)

JustDrive Function (VFP)

JustExt Function (VFP)

JustFName Function (VFP)

JustPath Function (VFP)

JustStem Function (VFP)

Key Function (VFP)

KeyMatch Function (VFP)

LASTKEY Function (VFP)

LeftC Function (VFP)

LenC Function (VFP)

LikeC Function (VFP)

LineNo Function (VFP)

LoadPicture Function (VFP)

LocFile Function (VFP)

Lock Function (VFP)

Lookup Function (VFP)

LTrim Function (VFP)

MakeTransactable Function (VFP)

Mdx Function (VFP)

MDY Function (VFP)

MEMORY Function (VFP)

MENU Function (VFP)

MESSAGE Function (VFP)

MessageBox Function (VFP)

Minute Function (VFP)

MkDir Function (VFP)

MRKBAR Function (VFP)

MRKPAD Function (VFP)

MROW Function (VFP)

MToN Function (VFP)

MWINDOW Function (VFP)

Ndx Function (VFP)

NewObject Function (VFP)

Normalize Function (VFP)

NToM Function (VFP)

NumLock Function (VFP)

NVL Function (VFP)

OBJTOCLIENT Function (VFP)

OldVal Function (VFP)

ON Function (VFP)

Order Function (VFP)

PAD Function (VFP)

PADPROMPT Function (VFP)

PARAMETERS Function (VFP)

Payment Function (VFP)

PCol Function (VFP)

PEMSTATUS Function (VFP)

POPUP Function (VFP)

Primary Function (VFP)

PRINTSTATUS Function (VFP)

PRMBAR Function (VFP)

PRMPAD Function (VFP)

Program Function (VFP)

PROMPT Function (VFP)

PRow Function (VFP)

PrtInfo Function (VFP)

PutFile Function (VFP)

PV Function (VFP)

Quarter Function (VFP)

RaiseEvent Function (VFP)

RAt Function (VFP)

RAtC Function (VFP)

RDLEVEL Function (VFP)

READKEY Function (VFP)

Refresh Function (VFP)

RegisterFoxMemVarSupport Function (VFP)

Relation Function (VFP)

RemoveProperty Function (VFP)

Requery Function (VFP)

RgbScheme Function (VFP)

RightC Function (VFP)

RTrim Function (VFP)

SavePicture Function (VFP)

Scheme Function (VFP)

SCOLS Function (VFP)

Sec Function (VFP)

Seek Function (VFP)

SetFldState Function (VFP)

SetFoxCollation Function (VFP)

SetResultSet Function (VFP)

SetTextFile Function (VFP)

SetTextMerge Function (VFP)

SetTextMergeDelimiters Function (VFP)

ShowFoxArray Function (VFP)

Sign Function (VFP)

SKPBAR Function (VFP)

SKPPAD Function (VFP)

SqlCancel Function (VFP)

SqlColumns Function (VFP)

SqlCommit Function (VFP)

SqlConnect Function (VFP)

SqlDisconnect Function (VFP)

SqlExec Function (VFP)

SqlGetProp Function (VFP)

SqlIdleDisconnect Function (VFP)

SqlMoreResults Function (VFP)

SqlParameters Function (VFP)

SqlPrepare Function (VFP)

SqlRollBack Function (VFP)

SqlSetFactory Function (VFP)

SqlSetProp Function (VFP)

SqlStringConnect Function (VFP)

SqlTables Function (VFP)

SROWS Function (VFP)

Str Function (VFP)

StrConv Function (VFP)

StrExtract Function (VFP)

StrToFile Function (VFP)

StuffC Function (VFP)

SubStrC Function (VFP)

Sys Function (VFP)

SysMetric Function (VFP)

TableRevert Function (VFP)

TableUpdate Function (VFP)

Tag Function (VFP)

TagCount Function (VFP)

TagNo Function (VFP)

Target Function (VFP)

TextMerge Function (VFP)

Transform Function (VFP)

Trim Function (VFP)

TToC Function (VFP)

TToD Function (VFP)

TxnLevel Function (VFP)

TxtWidth Function (VFP)

UNBINDEVENTS Function (VFP)

Unique Function (VFP)

UPDATED Function (VFP)

VARREAD Function (VFP)

VarType Function (VFP)

WBORDER Function (VFP)

WCHILD Function (VFP)

WCOLS Function (VFP)

WDOCKABLE Function (VFP)

Week Function (VFP)

WEXIST Function (VFP)

WMAXIMUM Function (VFP)

WMINIMUM Function (VFP)

WONTOP Function (VFP)

WOUTPUT Function (VFP)

WPARENT Function (VFP)

WREAD Function (VFP)

WROWS Function (VFP)

WTITLE Function (VFP)

WVISIBLE Function (VFP)

XmlToCursor Function (VFP)

XmlUpdatefram Function (VFP)

IsExclusive Function

-- todo --

Returns true (.T.) if a table or database is opened for exclusive use; otherwise, returns false (.F.).

Namespace: XSharp.VFP
Assembly: XSharp.VFP (in XSharp.VFP.dll) Version: 2.19

Syntax

Copy

 FUNCTION IsExclusive(
	uArea,
	nType
) AS LOGIC CLIPPER

[ClipperCallingConventionAttribute(new string[] { ... })]
public static bool IsExclusive(
	Usual uArea = default,
	Usual nType = default
)

Request Example View Source

Parameters

uArea (Optional): Type: Usual
Specifies the alias of the table for which the exclusive use status is returned. X# generates an error message if you specify a table alias that doesn't exist.
Or
Specifies the work area of the table for which the exclusive use status is returned. IsExclusive( ) returns false (.F.) if a table isn't open in the work area you specify.
Or
Specifies the name of the database for which the exclusive use status is returned.
nType (Optional): Type: Usual
Specifies whether the exclusive status is returned for a table or a database. The table in the remarks section lists the values for nType and the corresponding status returned.
To determine the exclusive status for a database, you must include nType with a value of 2.

Return Value

Type: Logic
Logical

Remarks

IsExclusive( ) returns a value for the table open in the currently selected work area if you omit the optional uArea, or cDatabaseName arguments.
A table is opened for exclusive use by including the Exclusive keyword in Use, or by setting Set Exclusive to On before the table is opened.
A database is opened for exclusive use by including the Exclusive keyword in Open Database.

nType	Exclusive status returned
1	Table
2	Database

Examples

Copy

 1cExclusive = Set('Exclusive')
 2Set Exclusive Off
 3Set Path To (Home(2) + 'data\')
 4Open Data testdata  // Opens the test databsase
 5Use customer     // Not opened exclusively
 6Use employee IN 0 Exclusive    // Opened exclusively in another work area
 7IF IsExclusive( )
 8REIndex  // Can only be done if table opened exclusively
 9ELSE
10WAIT 'The table has to be exclusively opened'
11ENDIF
12Set Exclusive &cExclusive

Reference

Functions, Globals and Defines

XSharp.VFP Namespace