DC_AdsSQLQuery() suggestion
Posted: Fri Nov 25, 2016 10:38 am
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.
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.