Miyako's plugin vs CryptoKey

[mferguson--- via 4D_Tech]

Hi,

I have used Miyako’s HMAC-SHA256 with success, but how do I the same thing  to 
get $t_Signature using 4D’s new native CryptoKey command?

Thanks,

Michael


$t_BaseString:=$t_Realm+"&"+$t_Consumer_Key+"&"+$t_Token+"&"+$t_Nonce+"&"+$t_Epoch_TimeStamp
$t_SigningKey:=$t_Consumer_Secret+"&"+$t_Token_Secret
CONVERT FROM TEXT($t_BaseString; "utf-8"; $sourceData)
CONVERT FROM TEXT($t_SigningKey; "utf-8"; $keyData)
$t_Signature:=HMACSHA256($keyData; $sourceData; Crypto BASE64)  //Crypto BASE64



**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: iNug archives are available at the 4D Knowledgebase

[mferguson--- via 4D_Tech]

Thanks Kirk, I use KB a lot, but missed the KB archive of Nug postings. I’ll be 
checking it out to see if I can download anything I’m missing. :)

Michael
> On Aug 4, 2020, at 1:23 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> A lot of us have built our own database of postings here. My own is in this
> gmail account and stretches back to 2006. However, you can also search even
> further back at the KB;  https://kb.4d.com/
> 
> Note the sidebar on the right: Knowledge Base Articles/iNug Messages.
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ==
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Change list values in a listbow coloumn

[mferguson--- via 4D_Tech]

As Kirk pointed out the 4D Forum is another great resource. It has convenient 
search and tag features, but the thing I miss is there doesn’t appear to be a 
way to download the posts or the archive. On the other hand, email clients 
allow you to view all of the Nug posts offline. I supplement that with my own 
4D email client that has enhanced search features. I have over 13,000. To keep 
me in the loop, please post both places. 🙂

Michael Ferguson



> On Aug 3, 2020, at 8:28 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Ferdinando,
>> a list when the mouse enter in every row
> 
> First, do you want:
> a- the list to automatically popup when the user enters the row
> b- the list to popup when the user right clicks on the row
> 
> 'a' is going to be harder to do. Start with enabling the On mouse enter and
> On mouse exit form events on the listbox. This will tell you when the user
> is inside the listbox. To determine what row the mouse is over you will
> need to determine by from the mouse position, listbox object coordinates,
> listbox scroll position... this will be a bit of work but once you figure
> it out will be fast enough.
> 'b' is easy - just test for Contextual Click in the listbox.
> 
> Now you need to make the list. I use popup menus for this sort of thing.
> Either the Pop up menu command (for simple lists) or build a menu on the
> fly and show with Dynamic pop up menu. Both are very fast and give you
> complete control over what you display.
> 
> BTW - the Forum is a much better place for these sorts of questions these
> days.
> 
> 
> On Fri, Jul 31, 2020 at 6:14 AM stardata.info via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Hi All,
>> 
>> In one column of Listbox, I need to give a list of values to enter value
>> of the column.
>> 
>> The values contained in a list can be different for every row.
>> 
>> How can I prepare a list when the mouse enters in every row?
>> 
>> Thanks
>> Ferdinando
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> New Forum: https://discuss.4D.com
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> 
> 
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ==
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

San Jose 4D training roommate?

[mferguson--- via 4D_Tech]

Hi,

Anyone going or sending an associate to the San Jose 4D training 9/30-10/4? I’d 
like to split the cost of a room for 5 days beginning 9/29. Respond soon so we 
can get the best rates.

Thanks,

Michael Ferguson


**
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
**

Up-down arrows not working on mac

[mferguson--- via 4D_Tech]

Hi,

A client of ours can’t get his up-down arrows to work on his Mac within our 
application under v16. I have tried setting the shortcuts on the buttons and 
also tried by setting the shortcuts on the form load with OBJECT SET SHORTCUT.  
Nothing works.

I suspect that the problem is caused by a setting on his machine, although the 
arrow keys work in his other applications. I googled the problem and found 
suggestions that the scroll-lock was likely on and that it could be toggled on 
and off with the F14 key. That didn’t work.

Has anyone encountered this or have suggestions?

Thanks,

Michael

Michael Ferguson
Objective Systems, LLC


**
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
**

Sum Function will not add first in series

[mferguson--- via 4D_Tech]

Hi,

A customer reports about v15:

" when you Sum a field,  if there’s only 1 record,  the resulting value is 
returned as a 0 no matter if the field is <>0.”

Has anyone encountered this?

Thanks

Michael Ferguson
**
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
**

Connection to 4D via ODBC makes connection but cannot see tables

[mferguson--- via 4D_Tech]

Hi,

I am using LibraOffice, the open source equivalent Microsoft Office, to make an 
ODBC connection to a v16 database. LibraOffice sees the 4D ODBC 32 bit driver 
and verifies the connection on test, but says that there are no tables in the 
database. I have not set up the 4D password system so the default schema should 
be open access. I tried to do an ODBC query to list tables but it said there 
was no connection. What am I missing? 

Thanks,

Michael


**
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
**

How to tie 4D to barcode readers?

[mferguson--- via 4D_Tech]

Hi,

I am familiar with plugins to print barcodes, but don’t know what interface is 
needed to get 4D to read barcodes from barcode wands, etc. Does anyone have 
advice or recommendations?

Thanks,

Michael Ferguson
Objective Systems

**
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
**

Re: Memory leak with dynamic variables in list boxes?

[mferguson--- via 4D_Tech]

Hi All,

The mystery opening the listbox demo database is solved. Apparently, the 
database I downloaded was set to open compiled by default, or my 4D 
installation must have a preference setting to that effect. The solution was to 
first open the 4D software, then navigate to the .db file, and then select the 
interpreted option from the dropdown menu in the lower right corner.

Thank you Miyako and everyone for all your patience and responses.

Michael



> On Aug 2, 2018, at 9:04 AM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Try bringing up the "User Interrupt" menu and select the Go to Design Mode 
> option. On the Mac it is control-option-click. Not sure about Windows.
> 
> John DeSoi, Ph.D.
> 
> 
>> On Aug 2, 2018, at 10:55 AM, mferguson--- via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> Puzzling. That doesn’t work on my Windows machine. It’s not a licensing 
>> issue because I am developing in v16.  :(
> 
> **
> 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
**

Re: Memory leak with dynamic variables in list boxes?

[mferguson--- via 4D_Tech]

Kirk,

Puzzling. That doesn’t work on my Windows machine. It’s not a licensing issue 
because I am developing in v16.  :(

Michael

> On Aug 2, 2018, at 8:25 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Michael,
> No idea what that's about. Here's what I did when I downloaded and ran it.
> 
> 1) opens to the demo dialog
> 2) closed the dialog
> 
> 
> and I'm in design. If you hit the Mode/Design menu command first just close
> the dialog.
> 
> On Thu, Aug 2, 2018 at 7:52 AM mferguson--- via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Uh, when I do that on my machine it gets into the pretend design
>> environment. All the menu items are grayed out.   : )
>> 
> Are you by any chance running it from a read-only volume? Or is the file
> locked? That sounds like a permissions error.
> 
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *We go vote - they go home*
> **
> 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
**

Re: Memory leak with dynamic variables in list boxes?

[mferguson--- via 4D_Tech]

Hi Kirk,

Uh, when I do that on my machine it gets into the pretend design environment. 
All the menu items are grayed out.   : )

Michael


> On Aug 2, 2018, at 7:34 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hey Michael,
> You don't need the source code. Just download the database zip.
> You have to close the demo dialog to get into design mode (because the
> dialog is opened with the On startup database method).
> 
> On Thu, Aug 2, 2018 at 6:25 AM mferguson--- via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Hi Miyako,
>> 
>> The example looks promising, except the source code download only had a
>> text file in it.
>> 
>> Can’t get into the design mode.
>> 
>> Thanks
>> 
>> Michael
>>> On Aug 1, 2018, at 9:20 PM, Keisuke Miyako via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>> 
>>> Hello,
>>> 
>>> this is 16R6 structure.
>>> 
>>> nothing special, just did what was suggested in the previous post.
>>> 
>>> 
>> https://github.com/4D-JP/4d-tips-office-document-information/releases/tag/iNUG-180802
>>> 
>>> 2018/08/02 11:32、mferguson--- via 4D_Tech <4d_tech@lists.4d.com> 4d_tech@lists.4d.com>>のメール:
>>> If anyone has a working example of assigning dynamic variables to a
>> footer so that SET FOOTER CALCULATION works, I’d really appreciate fairly
>> detailed outline or demo of it.
>>> 
>>> 
>>> 
>>> **
>>> 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
>> **
> 
> 
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *We go vote - they go home*
> **
> 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
**

Re: Memory leak with dynamic variables in list boxes?

[mferguson--- via 4D_Tech]

Hi Miyako,

The example looks promising, except the source code download only had a text 
file in it.

Can’t get into the design mode.

Thanks

Michael
> On Aug 1, 2018, at 9:20 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hello,
> 
> this is 16R6 structure.
> 
> nothing special, just did what was suggested in the previous post.
> 
> https://github.com/4D-JP/4d-tips-office-document-information/releases/tag/iNUG-180802
> 
> 2018/08/02 11:32、mferguson--- via 4D_Tech 
> <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール:
> If anyone has a working example of assigning dynamic variables to a footer so 
> that SET FOOTER CALCULATION works, I’d really appreciate fairly detailed 
> outline or demo of it.
> 
> 
> 
> **
> 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
**

Re: Memory leak with dynamic variables in list boxes?

[mferguson--- via 4D_Tech]

Hi,

I have tried and I am unable to get Miyako’s suggestion to work in compiled, 
even after modeling after his description and the example he linked to.

If anyone has a working example of assigning dynamic variables to a footer so 
that SET FOOTER CALCULATION works, I’d really appreciate fairly detailed 
outline or demo of it.  Note that there are two senses in which assigning 
dynamic variables can be taken: dynamically declaring a variable, and 
dynamically assigning an already declared compiler variable.  I was hoping not 
to have to pre-declare footer variables, but I don’t see how this is done.

Michael Ferguson


> On Jul 26, 2018, at 11:47 PM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> the workaround is to have an extra dynamic variable on the form,
> type it with VARIABLE TO VARIABLE,
> then use it with LISTBOX INSERT COLUMN
> 
> http://forums.4d.com/Post/FR/18014516/1/18014517#18014517
> 
> granted, you would need as many dynamic variable as the columns you insert.
> it's probably easier to use an array instead.
> 
> you could go really tricky and use OBJECT DUPLICATE.
> but I think an array is more simple.
> 
> 2018/07/27 14:14、Flury Olivier via 4D_Tech 
> <4d_tech@lists.4d.com>のメール:
> 
> Works interpreted, but not compiled.
> 
>   https://flury-software.ch/
> 
> 
> 
> **
> 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
**

Re: Memory leak with dynamic variables in list boxes?

[mferguson--- via 4D_Tech]

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
**

Re: Memory leak with dynamic variables in list boxes?

[mferguson--- via 4D_Tech]

Hi,

I converted it to use dynamic variables for the listbox columns insert, passing 
in nil pointers for the header and footer variables. It works great for regular 
columns but I can’t get it to work for footers.

Specifically:

LISTBOX SET FOOTER CALCULATION(*;Object name;listbox footer sum)

where the object name is either the column name or footer name, gives me 
incompatible type.

And
LISTBOX SET FOOTER CALCULATION(variable_Ptr->;listbox footer sum)

where variable_Ptr-> is a pointer to the the column name, column variable 
pointer, or footer

variable_Ptr:=OBJECT Get pointer(Object named;name returned by dynamic variable 
assignment obtained via listbox get arrays) 
gives incompatible type even though column is real
or
$ColumnPtr:=OBJECT Get pointer(Object named;column name)
etc.

Footers are turned on in the listbox properties.

I can’t get any combination to work.

Seems like it should be simple, but I’m missing something.

I’d appreciate an example from anyone who has this working.

Michael





> On Jul 26, 2018, at 7:48 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Michael,
> 
> On Thu, Jul 26, 2018 at 6:32 AM mferguson--- via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> We have a memory leak in our v15.6 Windows database and have narrowed it
>> down to a listbox where the columns are dynamically added using LISTBOX
>> INSERT COLUMN.
>> The header and footer variables are nil pointers, in accordance with the
>> documentation.
>> And to reference these variables for the assignment of properties, per the
>> documentation:
>> 
>> $FtrVar_P:=OBJECT Get pointer(Object named;FTR_Names_aT{$Ndx})
>> $HdrVar_P:=OBJECT Get pointer(Object named;HDR_Names_aT{$Ndx})
>> 
>> However, the get object pointer above returns nil pointers, so we can’t
>> assign properties.
>> 
> ​I was just writing about using Listbox get arrays for this purpose when I
> saw Olivier's post. I suggest this approach as well. ​
> 
> 
>> So, we set up our own variable manager that declares and reuses header and
>> footer variables for the listbox, using execute formula.  The variable
>> manager has been tested and the number of variables for the form does not
>> grow. However, the apparent search speed preceding the display gets slower
>> and slower. The queries themselves are fast, but the re-display seems to be
>> the culprit eating up memory.
>> 
> 
> Using EXECUTE ... is probably not the best solution for what you are
> attempting to do. ​4D is pretty good at managing these variables. It sounds
> like you're working with 4D interpreted. There are a lot of tricks you can
> get away with using Execute in an interpreted db that fail if you plan on
> compiling it later.
> 
> A few weeks ago another developer was having speed issues with listboxes as
> well. In that case he was rebuilding the listboxes every time there was a
> change and found the LISTBOX INSERT ARRAY command was slow. When I build
> listboxes dynamically I handle the chores of configuring the listbox (that
> is, inserting the columns, headers and footers) and populating them
> independently. Changes in the data may require a REDRAW command but usually
> not re-configuring the whole listbox. The point is once he changed his
> approach he found the speed issue disappeared and overall management was
> easier.
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *We go vote - they go home*
> **
> 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
**

Memory leak with dynamic variables in list boxes?

[mferguson--- via 4D_Tech]

Hi,

We have a memory leak in our v15.6 Windows database and have narrowed it down 
to a listbox where the columns are dynamically added using LISTBOX INSERT 
COLUMN.

The header and footer variables are nil pointers, in accordance with the 
documentation.

And to reference these variables for the assignment of properties, per the 
documentation:

$FtrVar_P:=OBJECT Get pointer(Object named;FTR_Names_aT{$Ndx})
$HdrVar_P:=OBJECT Get pointer(Object named;HDR_Names_aT{$Ndx})

However, the get object pointer above returns nil pointers, so we can’t assign 
properties.

So, we set up our own variable manager that declares and reuses header and 
footer variables for the listbox, using execute formula.  The variable manager 
has been tested and the number of variables for the form does not grow. 
However, the apparent search speed preceding the display gets slower and 
slower. The queries themselves are fast, but the re-display seems to be the 
culprit eating up memory.

I would really appreciate any insights or solutions!!

Thanks

Michael Ferguson
**
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
**