dm_db_query_update

public interface dm_db_query_update

Generic subroutine to add SET values to UPDATE query. The procedures do not validate that values have been added only once.

Help

Adds double precision SET parameter to query. Returns E_LIMIT in error if parameter limit has been reached.

Type	Intent	Optional		Name
type(db_query_type),	intent(inout)		::	db_query	Database query type.
character(len=*),	intent(in)		::	column	Column name.
real(kind=r8),	intent(in)		::	value	New column value.
integer,	intent(out),	optional	::	error	Error code.

Adds 32-bit integer SET parameter to query. Returns E_LIMIT if parameter limit has been reached.

Type	Intent	Optional		Name
type(db_query_type),	intent(inout)		::	db_query	Database query type.
character(len=*),	intent(in)		::	column	Column name.
integer(kind=i4),	intent(in)		::	value	New column value.
integer,	intent(out),	optional	::	error	Error code.

Adds 64-bit integer SET parameter to query. Returns E_LIMIT if parameter limit has been reached.

Type	Intent	Optional		Name
type(db_query_type),	intent(inout)		::	db_query	Database query type.
character(len=*),	intent(in)		::	column	Column name.
integer(kind=i8),	intent(in)		::	value	New column value.
integer,	intent(out),	optional	::	error	Error code.

Adds text parameter to SET query. Returns E_LIMIT if parameter limit has been reached.

Type	Intent	Optional		Name
type(db_query_type),	intent(inout)		::	db_query	Database query type.
character(len=*),	intent(in)		::	column	Column name.
character(len=*),	intent(in)		::	value	New column value.
integer,	intent(out),	optional	::	error	Error code.