Greetings
Just had an interesting "discussion" with a colleague of mine.
He insists that when you run a progress query from the tram tracks, such as
for each customer no-lock:
display name.
end.
Progress converts the query to SQL before running it.
I argued that it did not - that it run native code and if in fact you entered a sql query, that would be converted to native code before running.
Any input from the cognescenti (that I demonstrably prove) would be gratefully accepted - I could be quids/beers in here!
Nigel.
Greetings
Just had an interesting "discussion" with a colleague of mine.
He insists that when you run a progress query from the tram tracks, such as
for each customer no-lock:
display name.
end.
Progress converts the query to SQL before running it.
I argued that it did not - that it run native code and if in fact you entered a sql query, that would be converted to native code before running.
Any input from the cognescenti (that I demonstrably prove) would be gratefully accepted - I could be quids/beers in here!
Nigel.
Flag this post as spam/abuse.
My remembrance exactly - thanks Mike.
Not exactly SQL ....
Not another one. I got hit with that one at a non-Progress job interview. The interviewer was adamant that as a 4GL it must get interpreted into SQL and Java.
You could always offer the embedded SQL as proof that the 4gl obviously does no such thing — if it did then surely that SQL syntax would be more capable.
On Jun 3, 2015, at 1:24 AM, Nigel Allen <bounce-prosmart@community.progress.com> wrote:Thread created by Nigel AllenGreetings
Just had an interesting "discussion" with a colleague of mine.
He insists that when you run a progress query from the tram tracks, such as
for each customer no-lock:
display name.
end.Progress converts the query to SQL before running it.
I argued that it did not - that it run native code and if in fact you entered a sql query, that would be converted to native code before running.
Any input from the cognescenti (that I demonstrably prove) would be gratefully accepted - I could be quids/beers in here!
Nigel.
Stop receiving emails on this subject.Flag this post as spam/abuse.
Greetings
Just had an interesting "discussion" with a colleague of mine.
He insists that when you run a progress query from the tram tracks, such as
for each customer no-lock:
display name.
end.
Progress converts the query to SQL before running it.
I argued that it did not - that it run native code and if in fact you entered a sql query, that would be converted to native code before running.
Any input from the cognescenti (that I demonstrably prove) would be gratefully accepted - I could be quids/beers in here!
Nigel.
Flag this post as spam/abuse.
right, brian. obsolete sql-89 statements in the procedure editor (or in a .p file) are compiled by the 4GL compiler and converted to r-code, same as 4GL statements are. you can mix the two and use them at the same time.
Kids these days just don't appreciate C code for data access