SQL Functions

Functions
int	mdlDB_buildLink (short *link, int *linkLength, int linkType, LinkProps *props, WCharCP tableName, UInt32 mslink, int dasType)
	Constructs a user data linkage according to the passed parameters. More...
int	mdlDB_closeCursor ()
	Attempts to close an open cursor. More...
int	mdlDB_closeCursorByID (CursorID cursorID)
	This function operates exactly like mdlDB_closeCursor except that it allows the user to operate on more than one cursor at a time. More...
int	mdlDB_deleteRow (UInt32 mslinkKey, WCharCP tableName)
	Deletes the row from table tableName. More...
int	mdlDB_describeTable (MS_sqlda *sqlda, WCharCP table_name)
	Describes the structure of a table in the database. More...
int	mdlDB_fetchRow (MS_sqlda *sqlda)
	Retrieves the next row of the query for which the cursor has been opened. More...
int	mdlDB_fetchRowByID (MS_sqlda *sqlda, CursorID cursorID)
	Operates exactly like mdlDB_fetchRow except that it allows the user to fetch from more than one cursor at a time. More...
void	mdlDB_freeSQLDADescriptor (MS_sqlda *sqlda)
	Will free memory which has been allocated by MicroStation during mdlDB_openCursor, mdlDB_describeTable and mdlDB_describeColumn function calls. More...
int	mdlDB_getErrorText (WStringR message, int errorCode)
	Translates a database interface error code into a text message. More...
int	mdlDB_insertRowByForm (WCharCP table)
	Used to insert a new row into a database table using a screen form. More...
int	mdlDB_openCursor (WCharCP query)
	Opens a cursor for an SQL query. More...
int	mdlDB_openCursorWithID (CursorID *cursorID, WCharCP query)
	Operates exactly like mdlDB_openCursor except that it allows the user to open more than one cursor at a time. More...
int	mdlDB_processSQL (WCharCP sqlStatement)
	Submits general non-SELECT SQL statements to the database server. More...
int	mdlDB_readColumn (WCharP columnValue, WCharCP tableName, UInt32 mslinkKey, WCharCP columnName)
	Reads columns from table rows. More...
int	mdlDB_sqlQuery (WCharP column, WCharCP query)
	Designed for an SQL query that returns a single-column/single-row result. More...
int	mdlDB_writeColumn (WCharCP tableName, UInt32 mslinkKey, WCharCP columnName, WCharCP columnValue)
	Updates columns in table rows. More...
int	mdlDB_allocateDescriptor (MS_sqlda *sqlda)
	Allocates memory for the SQL data descriptor. More...
int	mdlDB_extractLinkages (DatabaseLink **link, int *linkCount, MSElementP element)
	Extracts an element's database linkages. More...
int	mdlDB_addRowWithMslink (UInt32 *mslink, WCharCP tableName, WCharCP insertStmt)
	Adds a new row to the indicated table and returns the new mslink number. More...
int	mdlDB_additionalRequest (void **returnData, int *returnLength, void *data, int length)
	Allows developers to define their own database request for the SQL Tool Kit. More...
int	mdlDB_copyTable (WCharCP tableName, WCharCP newTableName)
	Creates a new table with the same structure as an existing table. More...
int	mdlDB_databaseProfile (DatabaseProfile *profileP)
	Gets a description of the capabilities of the current database server. More...
int	mdlDB_describeColumn (MS_sqlda *sqlda, WCharCP tableName, WCharCP columnName)
	Returns a column descriptor for a column for a particular table in the database. More...
int	mdlDB_describeDatabase (StringListP *tableNames)
	Returns a string list containing the names of all of the tables to which the user has access. More...
void	mdlDB_disconnectDatabase ()
	Used to break the connection between MicroStation and the database to which it is connected at the time of the function call. More...
void	mdlDB_getMscatalogName (WCharP mscatName)
	Gets the value of the MS_MSCATALOG environment variable. More...
int	mdlDB_getLastError (WStringR errorString, int *errorcode)
	Returns the error message for the given error code, or the last error that was returned. More...

Detailed Description

Function Documentation

int mdlDB_additionalRequest	(	void **	returnData,
		int *	returnLength,
		void *	data,
		int	length
	)

Allows developers to define their own database request for the SQL Tool Kit.

Parameters

[out]	returnData	Specifies a buffer that holds the return data. returndata is dynamically allocated in the function. The user is responsible for freeing returndata.
[out]	returnLength	Specifies the size of the return data.
[in]	data	Specifies the data making up the message.
[in]	length	Specifies the length of the data in the message.

Returns

SUCCESS is returned if the request was successfully processed. Otherwise, an error status is returned.

Remarks

RDBMSLIB.DLO must be linked with your application to resolve this function.

Required Library: mdlbltin.lib

int mdlDB_addRowWithMslink	(	UInt32 *	mslink,
		WCharCP	tableName,
		WCharCP	insertStmt
	)

Adds a new row to the indicated table and returns the new mslink number.

Parameters

[out]	mslink	Specifies the new mslink for the added row.
[in]	tableName	Specifies the table to which the row should be added. If an insert statement is provided this argument is not necessary.
[in]	insertStmt	Specifies an insert statement to supply new values for the new row. Any columns but the MSLINK column can be specified. NOT NULL columns have to have specified values in the insert statement. The insert statement must have the form: insert into table (column list) values (value list)

Returns

SUCCESS is returned if the row was successfully added. Otherwise, an error status is returned.

Remarks

RDBMSLIB.DLO must be linked with your application to resolve this function.

Required Library: mdlbltin.lib

int mdlDB_allocateDescriptor

(

MS_sqlda *

sqlda

)

Allocates memory for the SQL data descriptor.

Parameters

[in,out]

sqlda

An MS_sqlda structure that specifies the number of columns to allocate memory for, and contains the pointers that are set to indicate the allocated memory areas.

Remarks

The structure MS_sqlda contains pointers to arrays of character pointers for column names, values and other attributes.

Returns

SUCCESS if the operation completed normally, or MDLERR_INSFMEMORY if any of the memory blocks could not be allocated.

Remarks

Required Library: mdlbltin.lib

int mdlDB_buildLink	(	short *	link,
		int *	linkLength,
		int	linkType,
		LinkProps *	props,
		WCharCP	tableName,
		UInt32	mslink,
		int	dasType
	)

Constructs a user data linkage according to the passed parameters.

The returned linkage link can be attached to an element using mdlElement_appendAttributes. The linkage length, in words, is returned in linkLength.

Parameters

[out]	link	database linkage
[in]	linkType	The linkage type linkType is one of the following values: ORACLE_LINKAGE Oracle linkage ODBC_LINKAGE ODBC linkage
[out]	linkLength	Length (words) of the linkage.
[in]	props	Properties word.
[in]	tableName	Specifies the name of the database table to which the linkage will point. The table row's unique integer key is specified by mslink. The displayable attribute type is given by dasType.
[in]	mslink	MSLK key.
[in]	dasType	Displayable attribute type.

Returns

SUCCESS is returned if a linkage is successfully constructed. Other error codes are listed in dberrs.h.

Remarks

The format of props is as follows:

typedef struct
{
   unsigned short  information;   informational linkage
   unsigned short  remote;        remote linkage
   unsigned short  modified;      data linkage modified
   unsigned short  user;          user data linkage
   unsigned short  class;         class of linkage
}LinkProps;

See also

mdlElement_appendAttributes mdlDB_largestMslink

Remarks

Required Library: mdlbltin.lib

int mdlDB_closeCursor

(

)

Attempts to close an open cursor.

If a cursor is already open when mdlDB_openCursor is called, CURSOR_ALREADY_OPEN is returned and the cursor remains open. This is a change from Version 4. MicroStation will no longer close the cursor if it is already open; the decision of when or if to use mdlDB_closeCursor is left up to the developer. To use multiple cursors refer to mdlDB_openCursorWithID.

Remarks

Note that mdlDB_openCursor, mdlDB_fetchRow and mdlDB_closeCursor should be replaced by mdlDB_openCursorWithID, mdlDB_fetchRowByID and mdlDB_closeCursorByID respectively.

Returns

SUCCESS is returned if the cursor is successfully closed.

See also

mdlDB_openCursorWithID mdlDB_fetchRowByID mdlDB_closeCursorByID mdlDB_describeTable mdlDB_fetchRow mdlDB_openCursor

Remarks

Required Library: mdlbltin.lib

int mdlDB_closeCursorByID

(

CursorID

cursorID

)

This function operates exactly like mdlDB_closeCursor except that it allows the user to operate on more than one cursor at a time.

A pool of cursors is available to the database server. Each time mdlDB_openCursorWithID is called one of these is allocated. The cursor is subsequently referenced using the identifier returned. When no more cursors are available mdlDB_openCursorWithID returns an error.

Parameters

[in]

cursorID

ID of cursor to close.

Returns

SUCCESS is returned if the indicated cursor was successfully closed. Otherwise, an error status is returned.

See also

mdlDB_describeTable mdlDB_closeCursor mdlDB_openCursorWithID mdlDB_fetchRowByID

Remarks

Required Library: mdlbltin.lib

int mdlDB_copyTable	(	WCharCP	tableName,
		WCharCP	newTableName
	)

Creates a new table with the same structure as an existing table.

Rows from the existing table are not copied into the new table.

Parameters

[in]	tableName	Specifies the name of an existing database table.
[in]	newTableName	Specifies name for the new database table.

Returns

SUCCESS is returned if the new table is successfully created. Otherwise, an error status is returned. If the new table contains an mslink column, the column will be set to accept NULL values.

Remarks

RDBMSLIB.DLO must be linked with your application to resolve this function.

Required Library: mdlbltin.lib

int mdlDB_databaseProfile

(

DatabaseProfile *

profileP

)

Gets a description of the capabilities of the current database server.

Parameters

[out]

profileP

Specifies a DatabaseProfile structure to be filled in by this function.

Returns

SUCCESS is returned if the database profile was successfully retrieved. Otherwise, an error status is returned.

Remarks

RDBMSLIB.DLO must be linked with your application to resolve this function.

Required Library: mdlbltin.lib

int mdlDB_deleteRow	(	UInt32	mslinkKey,
		WCharCP	tableName
	)

Deletes the row from table tableName.

This table has the unique integer key mslink.

Parameters

[in]	mslinkKey	MSLK key of row to delete.
[in]	tableName	Table name.

Returns

SUCCESS is returned if the row is successfully deleted.

See also

mdlDB_deleteElement

Remarks

Required Library: mdlbltin.lib

int mdlDB_describeColumn	(	MS_sqlda *	sqlda,
		WCharCP	tableName,
		WCharCP	columnName
	)

Returns a column descriptor for a column for a particular table in the database.

Parameters

[out]	sqlda	Specifies the information about the column. Since only the information about one column is returned, just the first position of each array in sqlda is allocated and populated. The user is responsible for calling mdlDB_freeSQLDADescriptor on sqlda.
[in]	tableName	Specifies the name of the table containing the column.
[in]	columnName	Specifies the name of the column.

Returns

SUCCESS is returned if the descriptor for the requested column is successfully retrieved. Otherwise, an error status is returned.

Remarks

RDBMSLIB.DLO must be linked with your application to resolve this function.

See also

mdlDB_copyTable mdlDB_describeDatabase

Remarks

Required Library: mdlbltin.lib

int mdlDB_describeDatabase

(

StringListP *

tableNames

)

Returns a string list containing the names of all of the tables to which the user has access.

Parameters

[out]

tableNames

Specifies a string list pointer which will point to a string list of the database table names. The user is responsible for calling mdlStringList_destroy on tablenames.

Returns

SUCCESS is returned if the database is successfully described. Otherwise, an error status is returned.

Remarks

RDBMSLIB.DLO must be linked with your application to resolve this function.

See also

mdlDB_copyTable mdlDB_describeColumn

Remarks

Required Library: mdlbltin.lib

int mdlDB_describeTable	(	MS_sqlda *	sqlda,
		WCharCP	table_name
	)

Describes the structure of a table in the database.

An MS_sqlda structure, allocated by the caller, should be passed to the function.

Remarks

This structure is defined in the header file dbdefs.h as follows:

typedef struct
    {
       short   numColumns;
       WChar   **name;
       WChar   **value;
       short   *type;
       short   *length;
       short   *scale;
       short   *prec;
       short   *null;
    } MS_sqlda;

If successful, mdlDB_describeTable will complete the descriptor's members.

The memory allocated by this function must be freed by calling mdlDB_freeSQLDADescriptor.

numColumns indicates the number of columns found in the table. The remaining structure members are arrays that can be indexed to obtain column information.

name points to an array of NULL terminated strings. This array indicates the column names.

value is used only with the fetch operation as described for the mdlDB_fetchRow function.

type points to an array of column types as defined in the dbdefs.h header file.

length points to an array of column lengths. This field is significant only for character columns and is set to zero for all other types.

prec and scale point to arrays of numbers where prec is the maximum number of characters in the number and scale indicates the maximum number of digits after the decimal.

null points to an array of short integers that are set to true if NULL values are allowed in this column and false otherwise.

Parameters

[in,out]	sqlda	table structure
[in]	table_name	name of database table

Returns

SUCCESS is returned if the table description is successfully obtained. Error codes are listed in dberrs.h.

See also

mdlDB_openCursor mdlDB_fetchRow mdlDB_closeCursor

Remarks

Required Library: mdlbltin.lib

void mdlDB_disconnectDatabase

(

)

Used to break the connection between MicroStation and the database to which it is connected at the time of the function call.

Remarks

RDBMSLIB.DLO must be linked with your application to resolve this function.

int mdlDB_extractLinkages	(	DatabaseLink **	link,
		int *	linkCount,
		MSElementP	element
	)

Extracts an element's database linkages.

Only the linkage types identified by MS_LINKTYPE will be recognized by this function. The user is responsible for freeing the memory allocated for the array of links.

Parameters

[out]	link	Specifies a pointer to a DatabaseLink which is set to point to an array of the linkages found. This function allocates the memory needed by the DatabaseLink.
[out]	linkCount	Specifies the number of linkages found on the element.
[in]	element	Specifies the element from which to extract linkages.

Returns

SUCCESS is returned if the element was processed successfully and even if there were no database linkages on the element. Otherwise an error status is returned. The linkCount should be used to test if database linkages were present.

Remarks

Required Library: mdlbltin.lib

int mdlDB_fetchRow

(

MS_sqlda *

sqlda

)

Retrieves the next row of the query for which the cursor has been opened.

It receives a pointer to an MS_sqlda structure. MS_sqlda is allocated by MicroStation.

Remarks

Its structure is defined in the dbdefs.h header file as follows:

typedef struct
    {
       short   numColumns;
       WChar   **name;
       WChar   **value;
       short   *type;
       short   *length;
       short   *scale;
       short   *prec;
       short   *null;
    } MS_sqlda;

If successful, mdlDB_fetchRow will complete the descriptor with the row in front of the cursor and move the cursor in front of the next row satisfying the query.

The members of the MS_sqlda are described with the mdlDB_describeTable function. The lengths pointed to by the length member describe column lengths, not necessarily value lengths. For example, the value for a 40-character column with the last 20 characters blank will be a 40-character string.

Note that mdlDB_openCursor, mdlDB_fetchRow and mdlDB_closeCursor should be replaced by mdlDB_openCursorWithID, mdlDB_fetchRowByID and mdlDB_closeCursorByID respectively.

Parameters

[out]

sqlda

current row of query

Returns

QUERY_NOT_FINISHED is returned if a row is successfully fetched. QUERY_FINISHED is returned when no rows remain in the query.

See also

mdlDB_openCursorWithID mdlDB_fetchRowByID mdlDB_closeCursorByID mdlDB_describeTable

Remarks

Required Library: mdlbltin.lib

int mdlDB_fetchRowByID	(	MS_sqlda *	sqlda,
		CursorID	cursorID
	)

Operates exactly like mdlDB_fetchRow except that it allows the user to fetch from more than one cursor at a time.

A pool of cursors is available to the database server. Each time mdlDB_openCursorWithID is called one of these is allocated. The cursor is subsequently referenced using the identifier returned. When no more cursors are available mdlDB_openCursorWithID returns an error.

Parameters

[out]	sqlda	Current row of query.
[in]	cursorID	ID of cursor for fetch.

Returns

QUERY_NOT_FINISHED is returned if a row was successfully fetched for the indicated cursor. QUERY_FINISHED is returned when no rows remain in the query.

See also

mdlDB_describeTable mdlDB_openCursorWithID mdlDB_closeCursorByID mdlDB_fetchRow

Remarks

Required Library: mdlbltin.lib

void mdlDB_freeSQLDADescriptor

(

MS_sqlda *

sqlda

)

Will free memory which has been allocated by MicroStation during mdlDB_openCursor, mdlDB_describeTable and mdlDB_describeColumn function calls.

The structure Ms_sqlda contains pointers to arrays of character pointers for column names, values and other attributes. When a database cursor is opened with mdlDB_openCursor MicroStation examines the query and allocates sufficient memory in the Ms_sqlda for the columns referenced in the query.

Remarks

After completing a query by calling mdlDB_closeCursor the memory MicroStation has allocated must be freed with mdlDB_freeSQLDADescriptor.

Parameters

[in,out]

sqlda

Descriptor to free.

See also

mdlDB_openCursor mdlDB_fetchRow mdlDB_closeCursor mdlDB_describeTable mdlDB_describeColumn

Remarks

Required Library: mdlbltin.lib

int mdlDB_getErrorText	(	WStringR	message,
		int	errorCode
	)

Translates a database interface error code into a text message.

It is particularly useful for obtaining error messages for errors which occurred in the database (non-MicroStation) processing of an MDL function. In general, MicroStation error return codes are positive. Errors from the RDBMS are usually negative. mdlDB_getErrorText will process both positive and negative error codes.

Parameters

[out]	message	The argument message is a WString that will receive the error message corresponding to error code errorCode. message should be the size of MAX_ERROR_LENGTH+1.
[in]	errorCode	Error code.

Returns

SUCCESS is returned if the error code was successfully translated to a text message.

Remarks

Required Library: mdlbltin.lib

int mdlDB_getLastError	(	WStringR	errorString,
		int *	errorcode
	)

Returns the error message for the given error code, or the last error that was returned.

Parameters

[out]	errorString	The error message for the given error code.
[in,out]	errorcode	The error code to get the error message for, or LAST_ERROR to get the error code and message for the last returned error.

Remarks

RDBMSLIB.DLO must be linked with your application to resolve this function.

If LAST_ERROR is passed in the errorcode value, the integer indicated by errorcode will be changed to the code number of the last error.

Returns

SUCCESS is returned if the information was retrievable, DBLOADER_NOT_ACTIVE if the database is not available.

Remarks

Required Library: mdlbltin.lib

void mdlDB_getMscatalogName

(

WCharP

mscatName

)

Gets the value of the MS_MSCATALOG environment variable.

If no value is assigned, it returns the default control table name. For ODBC flat files, the default is `mscatlog' and for all other platforms it is `mscatalog.'

Parameters

[out]

mscatName

Points to a buffer to receive the control table name. The buffer must be at least MAX_TABLE_LENGTH + 1 bytes.

Remarks

RDBMSLIB.DLO must be linked with your application to resolve this function.

This function was implemented in MicroStation 95.

Required Library: mdlbltin.lib

int mdlDB_insertRowByForm

(

WCharCP

table

)

Used to insert a new row into a database table using a screen form.

The argument table specifies a table listed in MSCATALOG. MicroStation will display the screen form listed for table in the MSCATALOG column SCREENFORM. Completing the screen form will add a new row to the database table.

Remarks

The new row added will become the active entity. The mdlDB_insertRowByForm function is equivalent to the MicroStation CREATE ENTITY command.

Parameters

[in]

table

Table name in MSCATALOG.

Returns

SUCCESS is returned if the screen form was successfully displayed. Other error codes are listed in dberrs.h.

See also

mdlDB_executeScreenForm

Remarks

Required Library: mdlbltin.lib

int mdlDB_openCursor

(

WCharCP

query

)

Opens a cursor for an SQL query.

It places the cursor before the first row matching the specified query. After a cursor is opened, rows can be retrieved with the mdlDB_fetchRow function. The members of the MS_sqlda are described with the mdlDB_describeTable function. The lengths pointed to by the length member describe column lengths, not necessarily value lengths. For example, the value for a 40-character column with the last 20 characters blank will be a 40-character string.

Remarks

If a cursor is already open when mdlDB_openCursor is called, CURSOR_ALREADY_OPEN is returned and the cursor remains open. This is a change from Version 4. MicroStation will no longer close the cursor if it is already open; the decision of when or if to use mdlDB_closeCursor is left up to the developer. To use multiple cursors refer to mdlDB_openCursorWithID.

Note that mdlDB_openCursor, mdlDB_fetchRow and mdlDB_closeCursor should be replaced by mdlDB_openCursorWithID, mdlDB_fetchRowByID and mdlDB_closeCursorByID respectively.

Parameters

[in]

query

Query for which the cursor is to be opened

Returns

SUCCESS is returned if the cursor is successfully opened or CURSOR_ALREADY_OPEN if the cursor is already open.

See also

mdlDB_openCursorWithID mdlDB_fetchRowByID mdlDB_closeCursorByID mdlDB_describeTable mdlDB_fetchRow mdlDB_closeCursor

int mdlDB_openCursorWithID	(	CursorID *	cursorID,
		WCharCP	query
	)

Operates exactly like mdlDB_openCursor except that it allows the user to open more than one cursor at a time.

A pool of cursors is available to the database server. Each time mdlDB_openCursorWithID is called one of these is allocated. The cursor is subsequently referenced using the identifier returned. When no more cursors are available mdlDB_openCursorWithID returns an error.

Returns

SUCCESS is returned if an unused cursor was available and if the query was successfully opened. Otherwise, an error status is returned. mdlDB_fetchRowByID returns QUERY_NOT_FINISHED if a row was successfully fetched for the indicated cursor. QUERY_FINISHED is returned when no rows remain in the query. mdlDB_closeCursorByID returns SUCCESS if the indicated cursor was successfully closed. Otherwise, an error status is returned.

Parameters

[out]	cursorID	ID For cursor opened.
[in]	query	Query for which the cursor is to be opened.

See also

mdlDB_describeTable mdlDB_fetchRowByID mdlDB_closeCursorByID

Remarks

Required Library: mdlbltin.lib

int mdlDB_processSQL

(

WCharCP

sqlStatement

)

Submits general non-SELECT SQL statements to the database server.

sqlStatement represents any character string (usually an SQL statement) that the database server can process. In MicroStation, these statements can be interactively submitted to the server when the statement is preceded with the vertical bar '|'. Note that SQL relational databases like Oracle frequently differ in their implementation of SQL by providing vendor-specific enhancements to ANSI SQL.

Remarks

The database server must be able to process SQL statements.

Parameters

[in]

sqlStatement

Direct "pass-through" server keyin.

Returns

SUCCESS is returned if the statement was processed without error. Positive error codes represent MicroStation errors and are listed in dberrs.h. Negative return values represent database specific error codes and may be found in the vendor's documentation.

See also

mdlDB_getErrorText mdlDB_sqlQuery mdlDB_openCursor mdlDB_fetchRow mdlDB_closeCursor

Remarks

Required Library: mdlbltin.lib

int mdlDB_readColumn	(	WCharP	columnValue,
		WCharCP	tableName,
		UInt32	mslinkKey,
		WCharCP	columnName
	)

Reads columns from table rows.

The row with an MSLINK key of mslink is read from table tableName. If using dBASE, tablename should be the alias.

Remarks

The column contents of column columnName are returned in columnValue.

Type conversion is automatically performed for all columns.

Parameters

[out]	columnValue	Column value.
[in]	tableName	Database table to read.
[in]	mslinkKey	MSLK key of column name.
[in]	columnName	Column name of table to read.

Returns

SUCCESS is returned if the row is successfully processed. Error codes are listed in dberrs.h.

See also

mdlDB_writeColumn

Remarks

Required Library: mdlbltin.lib

int mdlDB_sqlQuery	(	WCharP	column,
		WCharCP	query
	)

Designed for an SQL query that returns a single-column/single-row result.

It should be used only for queries that meet these criteria. If more than one column is required or if the query will return more than one row, a cursor must be used.

Parameters

[out]	column	The argument column is a character array that receives the result of the SQL SELECT statement query. All values are returned as character data. Appropriate conversions may be done on the result if numeric data is required.
[in]	query	SQL query.

Returns

SUCCESS is returned if the query is executed without errors. A syntactically correct query that returns no rows will return NO_ROWS_RETURNED (4040). If the query generated an SQL error, then SQL_LOOKUP (-100) is returned. Error codes are listed in dberrs.h.

See also

mdlDB_openCursor mdlDB_fetchRow mdlDB_closeCursor

Remarks

Required Library: mdlbltin.lib

int mdlDB_writeColumn	(	WCharCP	tableName,
		UInt32	mslinkKey,
		WCharCP	columnName,
		WCharCP	columnValue
	)

Updates columns in table rows.

The column columnName in the row with an MSLINK key of mslink is updated in table tableName. The column with the name columnName is updated with the value columnValue.

Remarks

Type conversion is automatically performed for columns with data types other than char.

Parameters

[in]	tableName	Database table to update.
[in]	mslinkKey	MSLK key of column name.
[in]	columnName	Column name of table to update.
[in]	columnValue	New column value.

Returns

SUCCESS is returned if the update is successfully processed. Error codes are listed in dberrs.h.

See also

mdlDB_readColumn

Remarks

Required Library: mdlbltin.lib