MDDB Report Viewer 9.2

_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);

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 reach-through 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'

Top of Page

Previous Page
|
Next Page
|
Top of Page