X# Runtime and VO SDK Reference
X# Runtime and SDK Reference
XSharp.VFP Namespace
Functions, Globals and Defines
List of Functions
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)
DbCopyStructFox Function (VFP)
DbCopyToArray Function (VFP)
DbCopyXStructFox Function (VFP)
DbGetProp Function (VFP)
DbSeekFox Function (VFP)
DbSetProp Function (VFP)
DbSortFox Function (VFP)
DbUseAreaFox 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)
HOME Function (VFP)
Hour Function (VFP)
ICase Function (VFP)
Id 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)
WFONT Function (VFP)
WLAST Function (VFP)
WLCOL Function (VFP)
WLROW 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)
Click or drag to resize

SqlIdleDisconnect Function

X#
-- todo --
Allows a SQL pass-through connection or connections to be temporarily disconnected.

Namespace:  XSharp.VFP
Assembly:  XSharp.VFP (in XSharp.VFP.dll) Version: 2.21
Syntax
Copy
 FUNCTION SqlIdleDisconnect(
	nStatementHandle AS LONG
) AS LONG
Request Example View Source

Parameters

nStatementHandle
Type: Long
Specifies the statement handle of the connection to be temporarily disconnected. Specify 0 for nStatementHandle to temporarily disconnect all active connections.

Return Value

Type: Long
Numeric.
1 is returned if SqlIdleDisconnect( ) successfully temporarily disconnects the SQL pass-through connection or connections. -1 is returned if SqlIdleDisconnect( ) was unable to temporarily disconnect the SQL pass-through connection or connections.
Remarks
The function fails (returns -1) if the statement handle is busy or a connection is in manual commit mode. The AError( ) Function can be used to obtain information about the cause of the error.
A temporarily disconnected connection is automatically restored as soon as it is needed to perform an operation; the original connection string is used. The ODBC ODBChstmt property returns 0 if the statement handle is temporarily released and the ODBChdbc property returns 0 if the connection is temporarily disconnected. A shared connection is temporarily disconnected as soon as all its statement handles are temporarily disconnected (released).
See Also