dbIsOpen ( )

Checks if the data connection is still open

Usage:

dbIsOpen (object me)

Parameter:

None

Returns:

(boolean)
0: connection is closed
1: connection is open

Example:

xtRose = xtra("Rosetta").new( )
xtRose.dbOpen( "Provider=MSDASQL;ExtendedAnsiSQL=2;DRIVER={Microsoft Access Driver (*.mdb)};Dbq="&the moviepath&"main" )
if ( xtRose.dbIsOpen( ) ) Then
  xtRose.dbClose( )
end if

Notes:

Calling the xtra function dbProperties( ) takes a bit more processing, thus it can be more efficient to verify if your connection is open by calling dbIsOpen( ).