Grass Valley K2 TX/MAM Database Protocol Manual v.2.2 - Manual (Page 20)

TX/MAM Database Protocol Manual - document version: 2.2 – Page 20
7.6 Retrieving the requested fields for the record with id == id and from
the table == table
The resulting field values are temporarily placed in library variables. Copy this to a local variable to
save the values even after a cob_fieldlist_clear call.
int cob_get_field_values( char *table, long long id );
Parameters
Name Description
char *table The table to get the record from, e.g. "asset_element".
long long id The id of the record, e.g. 1035.
Result
The result of the function is an integer and has following possible values:
Value Description
0 Success, the fields have been retrieved.
-1 Failure, the fields could not be retrieved.
Example
This example retrieves details for the asset_element record with id == 1035:
char *_artist;
int *_status_int;
long long *_id_category;
char artist[256];
int status_int;
long long category_id;
[..]
cob_fieldlist_clear();
cob_fieldlist_get_long( "id_category", &_id_category, ORIGINAL_DATA );
cob_fieldlist_get_string( "artist", &_artist, CUSTOM_DATA );
cob_fieldlist_get_integer( "status_int", &_status_int, ORIGINAL_DATA );
result = cob_get_field_values( "asset_element", 1035 );
if ( result == -1 ) {
printf( "Can't find asset_element: %Ld -> exit \n", 1035 );
return -1;
}
category_id = *_id_category;
strcpy( _artist, artist );
status_int = *_status_int;