Strange behavior : I4GL , transactions AND reports = Lost data
Posted in 2012
Hi all, After a long fighting , we could not solve a very weird problem. In a program with I4GL transactions and reports, lost data in the report. (See example below) However, only if the report have an "order by" clause, never witout this clause or "order external by" clause. We tested two different environments and two different versions of the product with the same result. Test 1: Solaris 10, I4GL 7.50.FC1 Test 2: Centos 64b, I4GL 7.50.FC6 Someone can help us? What is wrong? Thanks in advance Isidre #----- Beguin example TEST.4gl---- #--------------------------------------------------------- # # Strange behavior I4GL : Transactions and reports # # (c) BASE - Gesti d'Ingressos # Isidre Pons # 11/30/2012 v 1.0 # #--------------------------------------------------------- database oartdb #------------------------------------------------------------------------------- main #------------------------------------------------------------------------------- define i smallint start report test_1 to "kk.out" for i = 1 to 10 begin work if (i mod 3) = 0 then display "Commited value :",i commit work else display "Rollback value :",i rollback work end if output to report test_1(i) end for finish report test_1 prompt "Press a key : " for char status end main #------------------------------------------------------------------------------- report test_1(r_value) #------------------------------------------------------------------------------- define r_value smallint output left margin 0 top margin 0 bottom margin 0 order by r_value # order external by r_value format after group of r_value display " ---------- > change of group ",r_value print " ---------- > change of group ",r_value on every row display " Row: ",r_value clipped print " Row: ",r_value clipped end report #---- End example TEST.4gl ----------- .