_BUILD_WHERE_FORMAT_STRING_ Method

Builds a portion of the WHERE clause that provides the reach-through to detail data, including the variable format

Syntax

CALL SEND(OBJID,'_BUILD_WHERE_FORMAT_STRING_',metabase-id,variable-name,
in-data-value,out-data-value);

Required Arguments

metabase-id
the ID number of the metabase.
Type:Numeric
variable-name
the name of the variable in the metabase.
Type:Character
in-data-value
the unformatted data value.
Type:Character
out-data-value
the string to add to the reach-through WHERE clause.
Type:Character

Example

mbid=instance (loadclass('SASHELP.MB.METABASE.CLASS'));
myvar='MONTH';
myvalue='Jan';
fmtval=' ';
call send (webid,'_BUILD_WHERE_FORMAT_STRING_', mbid,myvar,myvalue,fmtval);
The following output is produced:
fmtval=put(MONTH,$MONTH.)='Jan'