NetTalk Central

Author Topic: Importing a Clarion report into NTWS app  (Read 3264 times)

Richard I

  • Sr. Member
  • ****
  • Posts: 398
    • View Profile
    • Email
Importing a Clarion report into NTWS app
« on: December 07, 2016, 03:59:43 PM »
Hi there,
I have a Clarion Report that  has code on a button on the Report Window.
this code writes to a table ( called (FOOD), the data to report.
and the report returns from this  table.- works well in Clarion.

Im wanting to total  the number of records conditionally by date range each day.

I can import the report and run it Ok with the  templates added as instructed as well as the prototype and Parameters set on the window.
PDFTools set as well as the NT templates

the problem is that the report only returns the data already in theFOOD table and does not add or delete from it according to the code.

Where should I relocate the code within the report embeds to do this?
ive tried server side without success...
and p_web.trace  doesnt return anything either.

this is the code I need to work....
loc:date and loc:enddate and Hal:name are from session variables

 LOOP locdate = loc:date to loc:enddate by 1
!        logout(5,food)
!        Foo:breakfasttotal =  0
!        Foo:lunchTotal     =  0
!        Foo:DinnerTotal    =  0
!       
!       
!        LOG:DateIn = locdate
!        set(LOG:keyDate,LOG:keyDate)
!        LOOP until access:log.next()
!        if log:datein > locdate then break. 
!        IF LOG:HallName not = Hal:name then CYCLE END
!        Foo:BreakfastTotal +=  LOG:breakfastcount
!        Foo:lunchTotal     +=  LOG:lunchcount
!        Foo:DinnerTotal    +=  LOG:dinnercount
!        Foo:Date            =  locdate
!     
!        END
!        IF  (Foo:BreakfastTotal + Foo:lunchTotal +  Foo:DinnerTotal) > 0
!        access:food.tryinsert()
!        END
!        COMMIT
!    END

There does not appear to be a NT example report that does anything like this
Thanks
Richard

using NT 8.71 C10

Richard I

  • Sr. Member
  • ****
  • Posts: 398
    • View Profile
    • Email
SORTED Re: Importing a Clarion report into NTWS app
« Reply #1 on: December 09, 2016, 06:40:08 PM »
Hi there,
Sorted that...
Took the code off the start button and put in the server-side of a new button, on the Form
Cheers
Richard