RDTA.PickDP.Connector.connDatabase Class

Binds to a database and provides database manipulation functions. The connDatabase class provides the ability to:

Public Constructors

New

Constructor.

Public Methods

BeginTransaction

 

call

Calls a BASIC subroutine on the server.

ClearSelectList

Clears the specified select list created by a connDatabase.ClearSelectList method.

close

Closes the connection to the database. This method automatically removes all classes associated to this class.

Commit

 

createList

Creates a dynamic array of selected items.

CreateSelectList

Executes a selection on the database.

getBytesReceived

Gets the number of bytes received from the server since the connnDatabase.open method.

getBytesSent

Gets the number of bytes sent to the server since the database was opened.

getChannel

For internal use only.

getErrorMessage

Gets the error message from the last database request in platform dependent format.

getEnvironment

Creates the connEnvironment Object.

getFileManager

For internal use only.

getStatusMessage

Gets the status message for the specified status code.

getTable

Gets an unopened reference to the named table. In order to use the table, a connTable.open method must be called.

isConnected

Returns True if the database is connected or if the connection is active.

isExpired

 

MemberwiseClone

Returns a copy of the current instance.

open

Opens a database or an account. Creates the socket, connects to the server, and logs to an account. If the connection fails, it returns an integer containing the completion status. If successful, returns kSuccess.

RollBack

 

select

Creates a new record set from  a table.

set_Debug

Enables or disables debugging within the Visual Studio.NET environment.

ToString

Returns a string that represents the current instance.

Constants

Name

Type

Value

Value returned and Description

kDatabase_DemoLicenseExpired

Integer

97

Error returned when the demo (temporary) license activation expires.

kDatabase_IllegalAccount

Integer

80

Error returned when attempting to open an account that is not exposed, does not exist, or is password protected.

kDatabase_IllegalPassword

Integer

87

Error returned on invalid user passwords.

kDatabase_IllegalUser

Integer

86

Error returned on invalid user names.

kDatabase_LogtoFailed

Integer

81

Error returned when attempting to log on to an account that does not exist or is password protected.

kDatabase_NoAvailableLicenses

Integer

98

Error returned when no Pick Data Provider licenses are available to service the call.

kDatabase_NoConnectionsFile

Integer

84

Error returned when the temporary file containing the current connection's information does not exist.

kDatabase_NoHost

Integer

89

Error returned when the host server could not be reached.

kDatabase_NoLogConnectionsFile

Integer

85

Error returned when the connection log file does not exist.

kDatabase_NoMasterDictionary

Integer

82

  • For D3: Error returned when the request could not open the md file.

  • For U2: Error returned when the request could not open the VOC file.

kDatabase_NoMasterTable

Integer

83

Error returned when the database's master table is not found or is corrupted.

kDatabase_NoUsersFile

Integer

88

Error returned when the Pick Data Provider users file defined in MASTER does not exist.

kDatabase_SocketError

Integer

90

Error returned when a socket error occurs.

kDatabase_Success

Integer

0

No error.

kDatabase_WrongLicense

Integer

99

Error returned on invalid license information.

kDatabase_WrongVersion

Integer

91

Error returned on invalid license information.

Examples

 

5