F
Frank Meulblok
Guest
But if you're not using DataServer, debug logging won't help. ABL client logging does have the QryInfo logging type, but that doesn't log the query string for static OPEN QUERY statements either. code: define query stuff for customer. log-manager:write-message("dynamic open"). query stuff:query-prepare("for each customer where custnum < 5 no-lock"). query stuff:query-open(). log-manager:write-message("static open"). open query stuff for each customer where custnum < 5 no-lock. Gives following log entries for Dynamic query-prepare()/query-open(): ... 2 4GL QRYINFO Type: Dynamically Opened Query ... 2 4GL QRYINFO PREPARE-STRING: for each customer where custnum < 5 no-lock ... 2 4GL QRYINFO Prepared at Runtime but static "open query" with same query string shows: ... 2 4GL QRYINFO Type: Statically Opened Query ... 2 4GL QRYINFO Prepared at Compile time May be worth submitting an Idea for some way to expose the query string for statically opened queries as well. But for short term, looks like there's no way to get what you want without somehow reworking your code. Replacing the static OPEN QUERY statements with dynamic prepare/open is probably a more elegant/more efficient approach, especially if you have to replace sets of OPEN QUERY statements. But depending on how many programs need to be reworked, it's still going to take a significant amount of time and effort.
Continue reading...
Continue reading...