_BUILD_WHERE_FORMAT_STRING_ Method

Builds a portion of the WHERE clause that provides the reachthru 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);

Where...	Is Type...	And Contains...
metabase-id	N	the ID number of the metabase
variable-name	C	the name of the variable in the metabase.
in-data-value	C	the unformatted data value
out-data-value	C	the string to add to the reachthru WHERE clause.

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 result is produced:

fmtval=put(MONTH,$MONTH.)='Jan'