Cecil
19+ years progress programming and still learning.
Hi not sure if my question should be here under this section of this forum.
I need to convert some basic ABL queries into SQL and I through that there was a Progress/OpenEdge tool to this.
I do not know SQL very well I need to be able to explain some off my ABL reports and show the quires as SQL.
Here is an example of my ABL querie.
So how do I convert ABL quires into SQL?
Using OE 10.2A.
I need to convert some basic ABL queries into SQL and I through that there was a Progress/OpenEdge tool to this.
I do not know SQL very well I need to be able to explain some off my ABL reports and show the quires as SQL.
Here is an example of my ABL querie.
Code:
[COLOR=navy][FONT="]FOR EACH members NO-LOCK[/FONT][/COLOR]
[COLOR=navy][FONT="] WHERE members.number GT 500 [/FONT][/COLOR]
[COLOR=navy][FONT="] AND MEmbers.stat NE 'D'[/FONT][/COLOR]
[COLOR=navy][FONT="] AND (MEMBERs.METHOD EQ 'CARD' OR [/FONT][/COLOR]
[COLOR=navy][FONT="] MEMBERs.METHOD EQ 'MANUAL'),[/FONT][/COLOR]
[COLOR=navy][FONT="] FIRST Pay_terms NO-LOCK [/FONT][/COLOR]
[COLOR=navy][FONT="] WHERE Pay_Terms.terms EQ Members.terms[/FONT][/COLOR]
[COLOR=navy][FONT="] AND Pay_Terms.EXPIRE EQ FALSE [/FONT][/COLOR]
[COLOR=navy][FONT="] BREAK BY Members.Bill_Date:[/FONT][/COLOR]
[COLOR=navy][FONT="] IF FIRST-OF(Members.Bill_Date) THEN[/FONT][/COLOR]
[COLOR=navy][FONT="] inCount = 0.[/FONT][/COLOR]
[COLOR=navy][FONT="] inCount = inCount + 1.[/FONT][/COLOR]
[COLOR=navy][FONT="] IF LAST-OF(Members.Bill_Date) THEN[/FONT][/COLOR]
[COLOR=navy][FONT="] EXPORT STREAM sOutput DELIMITER ',' members.terms Members.Bill_Date Members.Acct_Status inCount.[/FONT][/COLOR]
[COLOR=navy][FONT="]END.[/FONT][/COLOR]
Using OE 10.2A.