SQLData object error messages and codes

0

(none)

Success.

-75

Error: Cannot connect to database.

An error occurred during communication with or connection to the SQL Server database.

-100

Error: Invalid XML string.

An error occurred because of an invalid XML format in the _TableDef attribute.

-200

Error: No record found.

An error occurred during the attempt to find a requested record in the SQL Server database.

-201

Error: Updating an existing Record.

An error occurred during an update of an existing record in the SQL Server database table.

-202

Error: Adding a new Record.

An error occurred during the addition a new record to the SQL Server database table.

-203

Error: Unknown error while Deleting

An error occurred during the deletion of an existing record. Or, the object was unable to delete a record that does not exist in the SQL Server database table.

-204

Error: No record selected

A record was unable to be selected when one of the following command attributes were executed: DBToAttrCmd, DBToTempCmd, AttrToDBReplaceCmd, AttrToDBAppendCmd, TempToDBReplaceCmd, TempToDBAppendCmd, RecordSelectNextCmd, or RecordSelectPreviousCmd.

-205

Error: No more records

An attempt was made to scroll to a record that does not exist (that is, scrolling above the first record or scrolling past below the last record in the database table).

-206

Error: Cannot create Database.

An error occurred during the creation of the SQL Server database.

-207

Error: Trying to Modify Database.

An error occurred during a modification of the SQL Server database.

-210

Error: Failed deleting database record(s). No Record(s) found matching the current query.

An error occurred when an attempt was made to find a matching record in the SQL Server database table using the runtime query.

-211

Error: Failed to select next record. Last Record already selected

An attempt was made to scroll beyond the last record in the SQL Server database table.

-212

Error: Failed to select previous record. First Record already selected.

An attempt was made to scroll before the first record in the SQL Server database table.

-213

Error: Failed to select record. Table contains no records.

An error occurred during the selection of a record from an empty SQL Server database table.

-214

Error: Failed to select next record. Unknown Error

An error occurred during a scroll to the next record in the SQL Server database table.

-215

Error: Failed to select previous record. Unknown Error

An error occurred during a scroll to the previous record in the SQL Server database table.

-240

Error: Failed writing to Assigned Attribute(s).

An error occurred when a value was written to the attribute.

-241

Error: Delay connecting to database.

The database access command has been processing longer than the write timer (specified by the DBWriteTimeout attribute), and error has not been received.

-242

Error: Last command still processing. Please wait...

An attempt was made to perform a database access command before the previous database access command had completed.

-250

Error: SQL Query string cannot be empty.

Or

Error: Both 'QueryName' and 'QueryValue' must have a value

The QueryString attribute was used to access the database, and the query string was empty.

The QueryColumnName and QueryColumnValue attributes were used to access the database, and the column name or a column value was empty.

-300

Error: More than one record selected

Error resulting in more than one record returned from a query.

-310

Error: Failed to add record. Record already exists.

An attempt was made to add a duplicated record in the SQL database table.

-350

Error: Invalid Conversion of attribute type.

An error occurred during the conversion of the type of attribute.

-351

Error: Failed writing attribute value(s) to the Database table. Assigned Attribute(s) Quality is not Good.

An error occurred during the transfer of values to the assigned attribute when attribute quality was not GOOD.

-352

Error: Failed writing attribute value(s) to the Database. Temporary Attribute(s) Quality is not Good.

An error occurred during the addition of a record to the database when the assigned attribute quality was not GOOD.

-500

Error: Semaphore still active.

An attempt was made by multiple users to access to the SQL Server database or to the assigned attribute.

-550

Error: Database not connected. Manual connection required.

An attempt was made to access the database using database access commands when the object was not connected to the database and the DBAutoConnect attribute was not TRUE.

-551

Error: Already Connected.

An attempt was made to connect to a database using the DBConnectStateCmd command attribute when the object was connected to the database.

-552

Error: Not Connected.

An attempt was made to disconnect from a database using the DBConnectStateCmd command attribute when the object was not connected to the database.

-560

Error: AutoConnect must be off, before using DBConnectStateCmd

An attempt was made to perform a manual disconnection from the database when the AutoConnect attribute was enabled.

-561

Error: Database opened in Read-only mode

An attempt was made to write to a read-only SQL Server database.