× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



This is not something that happens all the time, just most of the time.
When I go to convert the following code to Free;

C/exec sql

     C+    Declare Str_Merch

     C+    Cursor For

     C+     Select *

     C+    From Ptdmrch

     C+    Where Txdate In(:CurTxdate,:PrvTxdate)

     C+      And Store = :Gps.Pm_Stor

     C+      And Mtype = 'M'

     C+      And Period = :CurPeriod

     C+    Order By Txdate

     C/end-exec

 

     C/exec sql Open Str_Merch

     C/end-exec

 

     C                   IF        Sqlstt = '24502'

     C/exec sql Close Str_Merch

     C/end-exec

     C/exec sql Open Str_Merch

     C/end-exec

     C                    ENDIF       

  

I get this;

      /FREE

       exec sql

          Declare Str_Merch

          Cursor For

           Select *

          From Ptdmrch

          Where Txdate In(:CurTxdate,:PrvTxdate)

            And Store = :Gps.Pm_Stor

            And Mtype = 'M'

            And Period = :CurPeriod

          Order By Txdate;

 

       exec sql Open Str_Merch;

 

       IF Sqlstt = '24502';

     C/  ec sql Close Str_Merch;  <-- It dropped the XE

     C/  ec sql Open Str_Merch;

       ENDIF;

      /END-FREE

 

Definitely not a show stopper, just annoying.  

      

Thanks

Bill Barnes

Sr Analyst/Programmer

The Pantry, Inc

919-774-6700

ext 5211

 


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.