Would something like this help... ARRAY REAL(aFoot;0) // Use this array to give each column a unique REAL footer var
.... in the loop .... Append To Array(aFoot;0) LISTBOX INSERT COLUMN(*;$lbName;$i;"C"+$iStr;$nilPtr;"H"+$iStr;$nilPtr;"Foot"+$iStr;aFoot{Size of array(aFoot)}) .... in the loop .... Keith - CDI > On Jul 27, 2018, at 10:35 AM, mferguson--- via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi, > > Thank you for all your responses. I just need to get past this final road > block. > > I have gotten dynamic variables to work on headers and footers with the > exception of the LISTBOX SET FOOTER CALCULATION. > > Miyako pointed out that the default type for footers is text, and to change > it I have to use VARIABLE TO VARIABLE. > > The documentation, in connection with retyping dynamic variables, describes > this as > if(form event=on load) > > c_text($Init) > $Ptr_Object:=OBJECT GET POINTER(Object named;”Comments”) > $init:=”” > VARIABLE TO VARIABLE($Ptr_Object->; init) > > end if > > The documentation also says the dynamic variable can be subsequently be > referred to in the manner > > $p:=object get pointer(object named;”start”) > $p:=?12:00:00? > > I am using an EMPTY current selection listbox on load, footers enabled, with > columns being assigned in a loop for the number of columns, using INSERT > LISTBOX COLUMN. The example above seems to presume that the column is already > assigned in the listbox, but modeling after the above within the loop: > if(column = the one I want a footer total for) > c_longint($Init) > $Ptr_Object:=OBJECT GET POINTER(Object named;”Invoice Amount”) > $init:=”” > VARIABLE TO VARIABLE($Ptr_Object->; init) > > end if > > This is in client server mode. > > Please verify that the object should be the column name used in INSERT > LISTBOX COLUMN, or alternatively, the footer column name. > > I have tried this with getting a pointer to the footer column name used in > INSERT LISTBOX COLUMN, and using the dynamically assigned footer name > retrieved with GET LISTBOX ARRAYS. > > I get error 54. > > Once I get by this problem I should be able to use > > LISTBOX SET FOOTER CALCULATION(*;XXX;listbox footer sum) > > where XXX is either the footer object name submitted with INSERT LISTBOX > COLUMN, or the dynamic footer name retrieved with GET LISTBOX ARRAYS. I don’t > know which. > > Thanks, > > Michael > > > >> On Jul 26, 2018, at 4:30 PM, Keisuke Miyako via 4D_Tech >> <4d_tech@lists.4d.com> wrote: >> >> dynamic variables create for footers are typed as text by default. >> >> you need to change it to numeric by replacing it using VARIABLE TO VARIABLE. >> >> 2018/07/27 7:34、mferguson--- via 4D_Tech >> <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール: >> Seems like it should be simple, but I’m missing something. >> >> >> >> ********************************************************************** >> 4D Internet Users Group (4D iNUG) >> Archive: http://lists.4d.com/archives.html >> Options: https://lists.4d.com/mailman/options/4d_tech >> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com >> ********************************************************************** > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************