DC_AdsSQLQuery() suggestion

[reganc]

Hi Roger,

Is it possible that you could make a small change to the DCBROWSE in DC_AdsSQLQuery() that shows the list of queries in the top-left of the screen.

At present the ITEMMARKED clause is as follows:

ITEMMARKED {||cDescription := ADSSQL->desc, ;
cStatement := ADSSQL->statement, ;
DC_GetRefresh(GetList,,DCGETREFRESH_TYPE_EXCLUDE,{GETLIST_BROWSE}) }

but I think cStatement should be trimmed:

ITEMMARKED {||cDescription := ADSSQL->desc, ;
cStatement := alltrim(ADSSQL->statement), ;
DC_GetRefresh(GetList,,DCGETREFRESH_TYPE_EXCLUDE,{GETLIST_BROWSE}) }

It makes editing the queries a whole lot easier in my opinion as the extra space seems to get in the way of positioning your cursor at the end of the text.

Is this possible? I can make the change myself, of course, but I cannot see why this change would cause any problems elsewhere.

Thanks.

[rdonnay]

Regan -

That certainly was a simple change.
I made the change to _DCADS.PRG for the next build.

Roger