Page 1 of 1

DC_AdsSQLQuery() suggestion

Posted: Fri Nov 25, 2016 10:38 am
by 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.

Re: DC_AdsSQLQuery() suggestion

Posted: Fri Nov 25, 2016 11:14 am
by rdonnay
Regan -

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

Roger