DC_AdsSqlQuery

[reganc]

With v2.0, I had to set the presentation parameters for row heights to -1 as below:

aBrowPres := ;
{ { XBP_PP_COL_HA_FGCLR, GRA_CLR_WHITE }, /* Header FG Color */ ;
{ XBP_PP_COL_HA_BGCLR, GRA_CLR_DARKGRAY }, /* Header BG Color */ ;
{ XBP_PP_COL_DA_FGCLR, GRA_CLR_BLACK }, /* Row FG Color */ ;
{ XBP_PP_COL_DA_BGCLR, GRA_CLR_WHITE }, /* Row BG Color */ ;
{ XBP_PP_COL_DA_ROWHEIGHT, -1 }, /* Row Height */ ;
{ XBP_PP_COL_HA_HEIGHT, -1 }, /* Header Height */ ;
{ XBP_PP_HILITE_FGCLR, GRA_CLR_WHITE }, /* Hilite FG color */ ;
{ XBP_PP_HILITE_BGCLR, GRA_CLR_BLUE } /* Hilite BG color */ ;
}

or the browse that showed the list of SQL queries is messed up.

[rdonnay]

Regan -

Sorry I missed that. There is another way to fix that problem. Look at the below code.
It will be fixed in build 265.

Code: Select all

  @ 0,0 DCBROWSE oBrowseDesc ALIAS 'ADSSQL' SIZE 29,10.4 ;
      PRESENTATION DC_BrowPres() ;  <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
      NOHSCROLL ;
      RESIZE DCGUI_RESIZE_REPOSONLY_Y ;
      ITEMMARKED {||cDescription := ADSSQL->desc, ;
                    cStatement := ADSSQL->statement, ;
                    DC_GetRefresh(GetList,,DCGETREFRESH_TYPE_EXCLUDE,{GETLIST_BROWSE}) }