Re: EXCEL CSV conversion

[Chip Scheide via 4D_Tech]

Fernando,

here is link to the CSV specs - you should be able to write an import easily 
enough.
https://docs.fileformat.com/spreadsheet/csv/

Chip

> Hi All,
> 
> I need to convert some excell files in csv format, because i need to 
> import informations in 4D application.
> 
> Someone know how i can do this using 4D or other methods?
> 
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: Can't Disable Catalina Prompt "Do you want the Applicaiton "ApplicationName" to accept incoming network connections?

[Chip Scheide via 4D_Tech]

Ken,
generically speaking.
Apple has implemented a bunch of restriction in the OS.
these restrictions have been being implemented slowly, starting with 10.9
Apple's stated reason is safety and proaction for users, however, if I recall 
correctly you can not sign/noterize an application without paying apple $.

It may also be - I am not sure - that you have to continue to pay apple $ 
yearly to have your app continue to function

I did a quick search - I DID NOT READ these they appear to be documents 
regarding notarization

https://developer.apple.com/news/?id=12232019a
https://appletoolbox.com/everything-you-need-to-know-about-app-notarization-in-macos-catalina/


good luck :)

Chip
> No I did not.  Why would that cause this problem I described below?
> 
> Thank you,
> Ken
> 
> 
> 
> On 08/18/20 10:05 AM, Robert McKeever via 4D_Tech wrote:
>> Before you built the app, probably before you compiled the app, did 
>> you disable the web server upon startup and the SQL server upon 
>> startup under Database Settings?
>> 
>>> On Aug 17, 2020, at 9:02 AM, Ken Eyring via 4D_Tech 
>>> <4d_tech@lists.4d.com> wrote:
>>> 
>>> I've compiled and built a standalone version of my 4D database 
>>> (with v17.3HF2), and every time that I run it on Mac OS X 10.15.5 
>>> (Catalina), I get a prompt "Do you want the Application 
>>> 'ApplicationName' to accept incoming network connections?"
>>> 
>>> I click "Yes" and the application opens.  I have also added the 
>>> name of my standalone application into the Security & Privacy 
>>> control panel as an exception to "allow incoming connections"... 
>>> but I still get the prompt every time I open the application.
>>> 
>>> Any suggestions on what I need to do to get the prompt to stop 
>>> popping up is greatly appreciated.
>>> 
>>> Thank you,
>>> Ken
>>> 
>>> 
>>> **
>>> 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
>>> **
>> 
>> _
>> Bob McKeever  http://www.mswl.com 
>> 
>> McKeever's Software Wizardry
>> Port Coquitlam, B.C.
>> bobmckee...@mac.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
>> **
>> 
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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

[Chip Scheide via 4D_Tech]

Michael,
I have visited the new forum.
I have not moved there...
I have been told - but - have not idea of the functionality - that it is 
possible to at least receive forum posts via email. I would hope that it is 
also possible to send them.

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

Hell is other people 
 Jean-Paul Sartre
**
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: More values into one field

[Chip Scheide via 4D_Tech]

I would question the "requirement" to place the data into one field.
I would think that something like this would make more sense:

Test_Type

Based on test type
1 or more child records containing the value(s) you need to store

ex:
Test_Type_1 (needs 3 result values)
Result1 : 5
Result2 : 3
Result3 : 12.3

To make this flexible for the user, you can create a Test Setting record (for 
each test type)
This would minimally contain:
Record ID
Test type - this is what you would use for a lookup 
Number of results required

the users can then create/change/delete (only if the test type was never used) 
the test definitions as their requirements change


Chip

> Hi All,
> 
> I use 4D v16.
> 
> I've needed to save more values of the same type (more results for one test)
> 
> The number of values to save, must be variables based on test type, 
> and all values must be saved into the same record.
> 
> Until now I use one text field and separated from one character so: 
> val1;val2;val3
> 
> Does someone have a suggestion to improve this solution?
> 
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: IP address problem (likely resolution)

[Chip Scheide via 4D_Tech]

Chuck, 
by default
4D uses 1 IP address but at least 3 ports
- 4D (client/server default) 19813
- SQL 19812
- web service 80, and 443 for HTTPS
- PHP 127.0.0.1: 8002

it may be that you have (or there are) multiple 4D servers running (on the same 
machine)
which would require changing the default ports for at least one of them, and 
the clients would need to specify the port to connect.

4D server A is on default ports
4D server B could be on any other port number and +1 for SQL

as for IP addresses
each NIC (Network Interface Card) can have an IP address.
most modern computers have multiple ways of connecting to a network.
Ethernet and WiFi are 2 most popular.
on a Mac thoughtcrimes you can also have Thunderbolt, Firewire, Bluetooth, 
possibly NFS (Near field), and other options are possible as external add ons.

Each of these network connection options (if they are available and ON) can get 
an IP address.

Since you said this is a Mac, and the server is in an enterprise environment 
the likely cause of IP address confusion is: 
  :)

WiFI   ANDEthernet both being on and connected.

If there is an ethernet connection (most likely) and wifi is on then the 
computer will have 2 IP addresses.
It is possible that power testing causes one or the other network connection to 
drop.
- Ethernet
- the switch/router for the floor/subnet/room/building (as appropriate) 
goes down with the power (i.e. the battery back up for it has failed (or was 
never setup). This is an Enterprise IT issue
- WIfi
- the wifi router, or one or more extenders goes down with the power 
outage, again, this is an Enterprise IT issue.

The simple solution (if this is the problem)
-- if the server is supposed to connect via Ethernet -- turn OFF WiFi.  System 
Preference : Network : select WiFi from the list, click the button labels 'Turn 
WiFi Off'.
-- if the server is supposed to connect via Wifi (?!?!?!), disconnect the 
ethernet cable.


Chip

> OK I guess some more info may help. It seems that if I have a server 
> that I run at client with their IP address scheme and then run same 
> structure on server in my office it shows as broadcasting on more 
> than one IP address. So the question now is where does 4D get IP 
> address to show on the server admin window? I think this might be 
> part of the problem. I am going to post this on the new forum as well 
> with some screen shots
> 
> Regards
> 
> Chuck
> 
>  Chuck Miller Voice: (617) 739-0306
>  Informed Solutions, Inc. Fax: (617) 232-1064   
>  mailto:cjmillerinformed-solutions.com 
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D and Sybase connectivity
>   http://www.informed-solutions.com  
> 
> This message and any attached documents contain information which may 
> be confidential, subject to privilege or exempt from disclosure under 
> applicable law.  These materials are intended only for the use of the 
> intended recipient. If you are not the intended recipient of this 
> transmission, you are hereby notified that any distribution, 
> disclosure, printing, copying, storage, modification or the taking of 
> any action in reliance upon this transmission is strictly 
> prohibited.  Delivery of this message to any person other than the 
> intended recipient shall not compromise or waive such 
> confidentiality, privilege or exemption from disclosure as to this 
> communication. 
> 
>> On Jun 4, 2020, at 7:20 AM, Chuck Miller via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Thanks for input. I will address each below your response 
>> 
>> Sent from my iPhone
>> 
>>> On Jun 4, 2020, at 1:44 AM, Chip Scheide <4d_o...@pghrepository.org 
>>> > wrote:
>>> 
>>> Chuck,
>>> There are 2 ways to resolve this, and using both is probably best.
>>> (following assumes DHCP)
>>> 
>>> 1 - put a battery on the computer (server) so that when power goes 
>>> down during tests the computer does not turn off.
>>> 1a - if this is already the case (it should be if it is a server) 
>>> and IP addresses are being changed on the server then there is a 
>>> switch in the network who's battery has failed - and Enterprise IT 
>>> should track it and fix it ( might need to enter a ticket)
>>> 
>> There is a UPS. Indeed the machine and server never went down
>> 
>> 
>>> 2 - talk with the IT/network people, give them the server's MAC ID 
>>> (network card ID) and request a fixed IP address server through 
>>> DHCP 
>>> Notes on #2 : the network admin can assign a specified IP address 
>>> to a specific MAC address, which is assigned via DHCP, then 
>>> regardless of power outage, server reboot, etc and generally the 
>>> time off the network, the IP address of the computer does not 
>>> change.
>> This is the 

Re: IP address problem

[Chip Scheide via 4D_Tech]

Chuck,

>> 2 - talk with the IT/network people, give them the server's MAC ID 
>> (network card ID) and request a fixed IP address server through DHCP 
>> Notes on #2 : the network admin can assign a specified IP address to 
>> a specific MAC address, which is assigned via DHCP, then regardless 
>> of power outage, server reboot, etc and generally the time off the 
>> network, the IP address of the computer does not change.

> This is the setup. Indeed the IP is manual. 
The IP address should probably NOT be set at the machine, Allow the DHCP server 
to give the address to the server.
on the Mac, 
System preferences : Network : Advanced
the setting should be : using DHCP
click OK
Save if asked

Hell is other people 
 Jean-Paul Sartre
**
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: AW: IP address problem

[Chip Scheide via 4D_Tech]

Lutz,
I could/can post on new forum.
I really am not doing much with 4D right now, since the snug comes to my email, 
I read it occasionally,
also since the last version I worked with is 15 i am not up to date with 
current 4D.

so

Chip

Do not go gentle into that good night,
...
Though wise men at their end know dark is right,
...
Do not go gentle into that good night.
Rage, rage against the dying of the light. 
(bits and pieces) of Dylan Thomas



> Hi Chip,
> That's a very good answer. Are you able to post this on the new 
> forum? Chuck posted the same question there. You can find it here:
> https://discuss.4d.com/t/ip-adress-issue-on-server/14033?u=epperlein.lutz
> 
> Regards
> Lutz
> 
> -Ursprüngliche Nachricht-
> Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von 
> Chip Scheide via 4D_Tech
> Betreff: Re: IP address problem
> 
> Chuck,
> There are 2 ways to resolve this, and using both is probably best.
> (following assumes DHCP)
> 
> 1 - put a battery on the computer (server) so that when power goes 
> down during tests the computer does not turn off.
> 1a - if this is already the case (it should be if it is a server) and 
> IP addresses are being changed on the server then there is a switch 
> in the network who's battery has failed - and Enterprise IT should 
> track it and fix it ( might need to enter a ticket)
> 
> 2 - talk with the IT/network people, give them the server's MAC ID 
> (network card ID) and request a fixed IP address server through DHCP 
> Notes on #2 : the network admin can assign a specified IP address to 
> a specific MAC address, which is assigned via DHCP, then regardless 
> of power outage, server reboot, etc and generally the time off the 
> network, the IP address of the computer does not change.
> 
> and BTW 
> - MAC is a network card term and refers to the network card's ID
> - Mac(intosh) is an Apple Computer Co. computer.
> 
> DHCP with manual address usually means that the IP address has been 
> assigned by specific computer Admin, rather than network admin. The 
> IP address assigned this way can (and appears to) conflict with the 
> DHCP server assigning addresses.
> This is because, as I understand it, the DHCP server does not 'know' 
> about the manual address.
> 
> Quickly:
> DHCP hands out IP addresses in a specified range xxx.xxx.xxx.1 - 255. 
> the range can be restricted, say xxx.xxx.xxx.100 - 200.
> and/or the DHCP server can hand out specific IP addresses to 
> specified MAC address, and random to all others.
> Where I was working, IT did all of this.
> Servers, and other devices which required that IP address NOT change 
> over time, (requested to be fixed), were assigned in the range 1- 30, 
> 31 - 220 were for network attached devices (computers, tablets etc), 
> and 220 - 254 were for reserved for printers.
> However, ALL addresses were assigned via DHCP - assigning a manual 
> address was not allowed because:
> the DHC server did not know about it, and could/would hand out the 
> manual IP address to another device - creating a conflict.
> 
> 
> Hope this helps
> 
> Chip
> 
> 
>> Hi All,
>> 
>> We have a built Client server v 16.x running on a MAC
>> 
>> Network set up is
>> DHCP with manual address
>> 
>> This has been working till about 6n months ago.
>> 
>> The hospital seems to test power outages on  fairly regular basis. 
>> When they do change over to emergency power
>> 
>> The network pane in system preferences loses all except the IP 
>> address and her we go
>> 
>> The 4D server running starts listening on a different IP address. Has 
>> anyone ever seen this before. Tech support is telling me to switch to 
>> manual address.
>> 
>> I have run and used this setup at many other customers
>> 
>> Thanks and regards
>> 
>> Chuck
>> 
>>  Chuck Miller Voice: (617) 739-0306
>>  Informed Solutions, Inc. Fax: (617) 232-1064   
>>  mailto:cjmillerinformed-solutions.com 
>>  Brookline, MA 02446 USA Registered 4D Developer
>>Providers of 4D and Sybase connectivity
>>   http://www.informed-solutions.com  
>> 
>> This message and any attached documents contain information which may 
>> be confidential, subject to privilege or exempt from disclosure under 
>> applicable law.  These materials are intended only for the use of the 
>> intended recipient. If you are not the intended re

Re: IP address problem

[Chip Scheide via 4D_Tech]

Chuck,
There are 2 ways to resolve this, and using both is probably best.
(following assumes DHCP)

1 - put a battery on the computer (server) so that when power goes down during 
tests the computer does not turn off.
1a - if this is already the case (it should be if it is a server) and IP 
addresses are being changed on the server then there is a switch in the network 
who's battery has failed - and Enterprise IT should track it and fix it ( might 
need to enter a ticket)

2 - talk with the IT/network people, give them the server's MAC ID (network 
card ID) and request a fixed IP address server through DHCP 
Notes on #2 : the network admin can assign a specified IP address to a specific 
MAC address, which is assigned via DHCP, then regardless of power outage, 
server reboot, etc and generally the time off the network, the IP address of 
the computer does not change.

and BTW 
- MAC is a network card term and refers to the network card's ID
- Mac(intosh) is an Apple Computer Co. computer.

DHCP with manual address usually means that the IP address has been assigned by 
specific computer Admin, rather than network admin. The IP address assigned 
this way can (and appears to) conflict with the DHCP server assigning addresses.
This is because, as I understand it, the DHCP server does not 'know' about the 
manual address.

Quickly:
DHCP hands out IP addresses in a specified range xxx.xxx.xxx.1 - 255. the range 
can be restricted, say xxx.xxx.xxx.100 - 200.
and/or the DHCP server can hand out specific IP addresses to specified MAC 
address, and random to all others.
Where I was working, IT did all of this.
Servers, and other devices which required that IP address NOT change over time, 
(requested to be fixed), were assigned in the range 1- 30, 31 - 220 were for 
network attached devices (computers, tablets etc), and 220 - 254 were for 
reserved for printers.
However, ALL addresses were assigned via DHCP - assigning a manual address was 
not allowed because:
the DHC server did not know about it, and could/would hand out the manual IP 
address to another device - creating a conflict.


Hope this helps

Chip


> Hi All,
> 
> We have a built Client server v 16.x running on a MAC
> 
> Network set up is
> DHCP with manual address
> 
> This has been working till about 6n months ago.
> 
> The hospital seems to test power outages on  fairly regular basis. 
> When they do change over to emergency power
> 
> The network pane in system preferences loses all except the IP 
> address and her we go
> 
> The 4D server running starts listening on a different IP address. Has 
> anyone ever seen this before. Tech support is telling me to switch to 
> manual address.
> 
> I have run and used this setup at many other customers
> 
> Thanks and regards
> 
> Chuck
> 
>  Chuck Miller Voice: (617) 739-0306
>  Informed Solutions, Inc. Fax: (617) 232-1064   
>  mailto:cjmillerinformed-solutions.com 
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D and Sybase connectivity
>   http://www.informed-solutions.com  
> 
> This message and any attached documents contain information which may 
> be confidential, subject to privilege or exempt from disclosure under 
> applicable law.  These materials are intended only for the use of the 
> intended recipient. If you are not the intended recipient of this 
> transmission, you are hereby notified that any distribution, 
> disclosure, printing, copying, storage, modification or the taking of 
> any action in reliance upon this transmission is strictly 
> prohibited.  Delivery of this message to any person other than the 
> intended recipient shall not compromise or waive such 
> confidentiality, privilege or exemption from disclosure as to this 
> communication. 
> 
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: [off-ish]VPNs - free is better

[Chip Scheide via 4D_Tech]

this is not a done deal -- yet - but has passed the US senate
https://www.businessinsider.com/groups-urge-congress-to-block-fbi-from-seeing-browsing-history-2020-5

> Hi Chip
> 
> What is the “recent legislation” you’re referring to ?
> 
> I don’t use a private VPN for accessing clients but do use a public 
> one for all my internet use (NordVPN). It’s excellent, cheap and 
> lets you switch between static and dynamic IPs according to need. 
> (e.g. I have a client network I access via Windows RDP that 
> whitelists only known IPs. When accessing I switch to the static IP I 
> have reserved by the VPN service. For all other internet use and 
> casually browsing I use a dynamic IP but still on the VPN).
> 
> Peter
> 
>> On 30 May 2020, at 08:42, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Hi all,
>> anyone have an experience with any VPNs?
>> as my title says, free is better :)
>> 
>> with the recent legislation passed in the US senate, and similar 
>> legislation elsewhere around the world, it seems that this is a good 
>> idea.
>> 
>> One of my concerns is I have heard (rumors - do not know how much to 
>> trust them) that some VPNs are run by goats, as well as poorly 
>> located/configured 
>> 
>> thought I would ask here.
>> 
>> Chip
>> 
>> 
>> Hell is other people 
>> Jean-Paul Sartre
>> **
>> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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
**

[off-ish]VPNs - free is better

[Chip Scheide via 4D_Tech]

Hi all,
anyone have an experience with any VPNs?
as my title says, free is better :)

with the recent legislation passed in the US senate, and similar legislation 
elsewhere around the world, it seems that this is a good idea.

One of my concerns is I have heard (rumors - do not know how much to trust 
them) that some VPNs are run by goats, as well as poorly located/configured 

thought I would ask here.

Chip


Hell is other people 
 Jean-Paul Sartre
**
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 Messages ― Is it time for it to be more than just 'plain text' ???

[Chip Scheide via 4D_Tech]

I have been to the new forums - much better then the old one.
however -
I really prefer everything coming to me (email) vs having to go get it (forum)

Chip


> Hi Chris,
> 
> Have you seen the new forums?
> 
>   https://discuss.4d.com
> 
> They should do what you’re after.
> 
> --
> Cannon Smith
> Synergy Farm Solutions Inc.
> 
> 
> 
>> On May 1, 2020, at 5:41 PM, Chris Belanger via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Do you think the iNUG would be so much more useful if it would 
>> support messaging with font attributes (bold, colour, whatever) and 
>> images?
> 
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: iNUG Messages ― Is it time for it to be more than just 'plain text' ???

[Chip Scheide via 4D_Tech]

you need to up your ASCII drawing skills   :)


> 
> It is so hard to explain ‘in text’ something that a snapshot would 
> explain in a second.

Hell is other people 
 Jean-Paul Sartre
**
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: Object notation replacement for use of Self in a script ― v18

[Chip Scheide via 4D_Tech]

Lahav,
not 'That', 'This'  :)

Chip
> 
>> I have one word that will do all of what we are after :   "This"
>> 
> Damn - I wish I'd said that.

Hell is other people 
 Jean-Paul Sartre
**
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: Opinion

[Chip Scheide via 4D_Tech]

A note: you can do all the things you need to do with pictures, UUIDs etc in 
v13 in preparation for v15+


> Ken,
> 
>> On Apr 24, 2020, at 6:41 PM, Kenneth Geiger via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Yes, this is why I’m trying to get their 4D System to point where 
>> it will run on a version of 4D that is happy on Win10. The only 
>> reason I mentioned Win7 is if the consensus were to be that moving 
>> from 4D v12 directly to 4D v15 is too big a step, I would move it 
>> through v14 on my Win7 development environment. So far, nobody has 
>> indicated that the jump from v12 to v15 would be a major issue. So, I
>> ’m planing to go v12 ―> v15 ―> v17.
> 
> Personally, I never thought much of v14.  It seemed bloated and 
> unstable.  I liked v13 and v15.  v15 also had both 32 and 64 bit 
> versions.  That makes it easy to use JPR’s tool to convert pictures 
> in the 32 bit version and them test them in the 64 bit version.
> 
> I would recommend v13 -> v15 -> v17.
> 
> 
> Randy Kaempen
> Intellex Corporation
> 
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: Using Document to text ala Receive Packet Was: Receive packet stop character

[Chip Scheide via 4D_Tech]

John,
unless you are reading data from a stream - 
why don't you just read the entire document into memory, THEN parse it?

every reference to the document (on disk) will take longer - by a factor of up 
to 1000 - than referencing the same information from memory. (spinning disks 
access in milliseconds, memory in nano seconds, SSDs are in between).

so read the entire document -
examine the text until you find a CR, LF or combination - 
if you find one check the next and/or previous character for the other.
now you know your EOL. 
You can not depend on the platform for the EOL determination.
A File created on a Mac can be read on a PC and vise verse.

if you need to process 1 'line' at a time just step through the text ending on 
the EOL from above.
you can check the size of the text, or the counter/pointer into your text 
(depending on your processing method) to determine if yo have processed 
everything.

something like this (assumes document in text var):
Last_Char_Counter:=0
repeat
local_text := get_text_to_next_EOL(TextVar; -> Last_Char_Counter)
if (local_text #"")
process text
end if
until (length(local_text) < 5) | (Last_Char_Counter + 5>=length(TextVar))

5 is to account for various extra characters I have often found at the end of 
documents, like multiple Cr/CrLf etc, YMMV on this number or it's need.

Chip


>> On Mar 25, 2020, at 8:21 PM, Keisuke Miyako via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> sometimes, it might just be easier to read the entire text with
>> 
>> Document to text (which can normalise the EOL character)
> 
> I took Keisuke’s advice to heart and looked closer at Document to 
> text. I did not realize that it provided a means to handle any EOL 
> confusion between Mac and Windows. For me this makes the use of 
> Document to text a much better way to read the contents of a document 
> by row than Receive packet. 
> 
>  In an effort to duplicate Receive packet’s functionality when used 
> in a repeat loop to get rows of a tab delimited text document, I 
> created a wrapper method as a replacement for Receive packet.
> 
> I am posting this method here in the event someone on on the NUG 
> might find it useful. More importantly for me, however, perhaps to 
> get some feedback with regard to anything I may have overlooked or 
> anything I may need to do to clean it up.
> 
> It was written in a v14 database so does not use any of the newer 
> features in v17 and later like Is Windows and/or objects.
> 
>  Thanks for any feedback.
> 
> John
> 
> 
> --
> 
>   // Method: ReceivePacket_DocToText 
> (->pathToDocumentVariable;->VariableToHoldDocContents;BreakMode)
>   // 
>   // Created by: John Baughman
>   // 
>   // Description
>   //Replacement for Receive Packet using Document To Text
> 
>   // Parameters
> C_POINTER($1;$pathPtr)  //$1 is a pointer to the variable holding the 
> path to the document. 
>   //In a repeat loop you can put an empty string in the variable to 
> allow the user to pick the document using Document Select.
>   //The variable will be updated to contain the chosen path for 
> subsequent calls for rows in the loop. 
>   //If the user cancels the Select Document, $rowText:="", and 
> $documentTextPtr->:=“"
> 
> C_POINTER($2;$documentTextPtr)  //Pass an empty text variable in the 
> first call and it will be loaded from the document with Document to 
> text.
>   //The variable will be loaded with the document contents minus the 
> row being returned.
> 
> C_TEXT($0;$rowText)  //$RowText will hold the first row in the 
> $DocumentTextPtr variable and returned in $0. 
>   //The first row in the $DocumentTextPtr variable wil be removed.
> 
> C_LONGINT($3;$breakMode)  //Document to Text will convert the EOL 
> character to the following desired break mode constants...
>   //Document with CR
>   //Document with CRLF
>   //Document with LF
>   //Document with native format
> 
>   //Example Call
> If (False)
>   C_TEXT($TextValue;$path)
>   $TextValue:=""
>   $path:=""
>   Repeat 
> $rowText:=ReceivePacket_DocToText (->$path;->$TextValue;Document 
> with CR)
>//If TextValue is “” then the text will be loaded from the 
> document and returned minus the first row in TextValue
>//Subsequent calls will return first row in $rowText and return the 
> text minus the first row in TextValue.
>   If (rowText#””)
>  //handle the row
>   End if
>   Until (TextValue =“")   //note: I do not use the ok variable as I 
> found that the ok variable may get set incorrectly by 4D if the last 
> row does not have CR.
> 
> End if 
> 
>   // 
> 
> $pathPtr:=$1
> $DocumentTextPtr:=$2
> $breakMode:=$3
> $rowText:=""
> 
> If ($pathPtr->="")
> //They want to select the document
>   ARRAY TEXT($aSelected;0)
>   

Re: Long running reports to disk intermittently disrupted and fail

[Chip Scheide via 4D_Tech]

:)
that was my point.

if the file is created on the client, 
new record
document to [table]blob
save record

blob is now on the server.
deamon running on server looks for new records in [table]
when found, it extracts it/them.

alternatively
after saving the new record on the client
execute on server(extract_file_method)
 
> 
> That is more complicated than just calling an "execute on server" method.

Hell is other people 
 Jean-Paul Sartre
**
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: Re: Long running reports to disk intermittently disrupted and fail

[Chip Scheide via 4D_Tech]

why not just save the blob in a (temporary) record?
the blob is auto transmitted to the server via 4D.

and you can then (on the server) do a blob to document if necessary

> Now I create the document as before, do a document to blob on the 
> client and call an "execute on server"-method that sends the blob to 
> the server where it gets written to the directory with blob to 
> document.

Hell is other people 
 Jean-Paul Sartre
**
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: Long running reports

[Chip Scheide via 4D_Tech]

John,
I've played with large files (reading) and 4D - and around 500 megs it starts 
to get wonky.

I would:
use an SSD
create the (local) disk file (blob to doc with an empty blob.
repeat 
build up your text to some size (100 megs?) then append it to the disk 
file
until no more text
move file to network

should give you maximum stability


> 
> I have been thinking along similar lines today. Just wondering if 
> keeping 2.4 million rows in a text array in memory will be an issue. 
> The text file is 831mb so if 4D can mange it that’s worth a try. 
> Likely faster as one of the reports is taking 3-4 hours. And there 
> are dozens of reports they need to run at the end of the month. 
> That’s why it’s an overnight affair. (Although we could distribute 
> the effort over several computers if we need to.)

Hell is other people 
 Jean-Paul Sartre
**
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: one server window on client

[Chip Scheide via 4D_Tech]

MCS?


> I did not, but this happens with multiple connection types and 
> points, but will try and advise but not today
> 
> Regards
> 
> Chuck
> 
>  Chuck Miller Voice: (617) 739-0306
>  Informed Solutions, Inc. Fax: (617) 232-1064   
>  mailto:cjmillerinformed-solutions.com 
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D and Sybase connectivity
>   http://www.informed-solutions.com  
> 
> This message and any attached documents contain information which may 
> be confidential, subject to privilege or exempt from disclosure under 
> applicable law.  These materials are intended only for the use of the 
> intended recipient. If you are not the intended recipient of this 
> transmission, you are hereby notified that any distribution, 
> disclosure, printing, copying, storage, modification or the taking of 
> any action in reliance upon this transmission is strictly 
> prohibited.  Delivery of this message to any person other than the 
> intended recipient shall not compromise or waive such 
> confidentiality, privilege or exemption from disclosure as to this 
> communication. 
> 
>> On Apr 14, 2020, at 4:25 PM, lists via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Did you try clearing the local resources and start over?, we have 
>> had unexplained issues on specific machines that went away when we 
>> started fresh.
>> 
>> Lahav
> 
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: Image Export Issues

[Chip Scheide via 4D_Tech]

to better mange the files you should (have)created a bunch of folders.
alphabetically, or every 1000 images, or whatever criteria make(ed) sense.

> OK. I applied this technique, along with WRITE PICTURE FILE. A single 
> pass for all images took about 3 hours (about 1/3 the time it took 
> before it would crash), and completely successful. I’m just waiting 
> on finder to display the list of 151,814 image files. It does take 
> awhile. 114.58Gb worth - previous versions of the extract using blobs 
> ended up well over 1,2Tb.
> 
> So, to all, thank you. I needed a success - my wife of almost 39 
> years passed away from a long battle (10 years or more) with Vascular 
> Dementia. My soulmate.
> 
>> On Apr 2, 2020, at 9:25 AM, Chuck Miller via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Remember why was stated. Launch a process. Do something like this
>> $CurrentNumber_L:=start
>> repeat
>> 
>> Launch new process($CurrentNumber_L)
>> wait til  new process completes
>> $CurrentNumber_L:=$CurrentNumber_L+50
>> 
>> 
>> 
>> until (end)
>> 
>> The new process will export 50 pictures_
>> 
>> This method probably will clear memory issues when new process ends
>> 
>> Regards
>> 
>> 
>> Chuck
>> 
>> Chuck Miller Voice: (617) 739-0306
>> Informed Solutions, Inc. Fax: (617) 232-1064   
>> mailto:cjmillerinformed-solutions.com 
>> Brookline, MA 02446 USA Registered 4D Developer
>>   Providers of 4D and Sybase connectivity
>>  http://www.informed-solutions.com  
>> 
>> This message and any attached documents contain information which 
>> may be confidential, subject to privilege or exempt from disclosure 
>> under applicable law.  These materials are intended only for the use 
>> of the intended recipient. If you are not the intended recipient of 
>> this transmission, you are hereby notified that any distribution, 
>> disclosure, printing, copying, storage, modification or the taking 
>> of any action in reliance upon this transmission is strictly 
>> prohibited.  Delivery of this message to any person other than the 
>> intended recipient shall not compromise or waive such 
>> confidentiality, privilege or exemption from disclosure as to this 
>> communication. 
>> 
>>> On Apr 2, 2020, at 11:54 AM, Robert McKeever via 4D_Tech 
>>> <4d_tech@lists.4d.com> wrote:
>>> 
>>> So, I modified the code to use WRITE PICTURE FILE. Nice. Runs much 
>>> faster. It did quit late last night. And again this morning when I 
>>> was also reading email, this time with a system crash message - 
>>> unable to grow buffer.
>>> 
>>> Once I finish with email, and the web, I’ll restart the machine and 
>>> restart the export from where it left off. It is having its 
>>> problems when it goes to export a series of 40Mb retinal scans.
>> 
>> **
>> 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
>> **
> 
> _
> Bob McKeever  http://www.mswl.com 
> McKeever's Software Wizardry
> Port Coquitlam, B.C.
> bobmckee...@mac.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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: All plugins are throwing a License or privilege error on windows. Was: Dll error help

[Chip Scheide via 4D_Tech]

my first thought is windows creates 'shadow' directories.
and that the plugins are being moved/referenced from there when the program 
runs - which breaks the expected path 4D is using to try to access the plugins.
I would consider this idea to more likely if the same database works on a Mac 

Chip
> This is an old database v12 that I am trying to upgrade to v16 and 
> later. I had upgraded it to v14 on a Mac, but when I moved it to 
> Windows Server 2008 I got the dll error that started this thread and 
> as noted that foundation’s Extras plugin was throwing a license or 
> privilege error. 
> 
> Walt... it is Foundation 3. I would upgrade it but do not have the 
> luxury of time in this particular case to go that route at the moment.
> 
> I Decided to move on to v16 and see what happens, Lo and behold, the 
> dll error went away, but the Extras plugin continued throw errors and 
> I have since realized that this was the case for all the plugins in 
> the plugin folder. The plugins are in fact being loaded as they are 
> recognized (tokenized) in the design environment. The error is thrown 
> when any plugin command is called.
> 
> I do have a working built application (v12) with the same plugins 
> installed and they work fine there. I copied the plugins from the 
> built application on the same windows machine to my upgraded version 
> with the same result. 
> 
> Being that 4D does recognize the plugin commands, I think this has 
> something to do with the OS security settings for the plugins folder 
> and it’s contents. Currently System, Administrators and Users all 
> have Full control are set for the Plugins folder and all of it’s 
> content..
> 
> Any ideas?
> 
> All my windows work is being done in VirtualBox VMs.
> 
> Thanks,
> 
> John
> 
>> On Mar 28, 2020, at 10:04 AM, Walt Nelson > > wrote:
>> 
>> John,
>> 
>> Which version of Foundation Shell are you using?
>> 
>> Foundation 5 or later does not require Foundation Extras.bundle anymore.
>> 
>> Thanks,
>> Walt
>> 
>> 
>>> On Mar 28, 2020, at 2:39 AM, JOHN BAUGHMAN via 4D_Tech 
>>> <4d_tech@lists.4d.com > wrote:
>>> 
>>> If I click ok to the error window, database startup, but the 
>>> constants in the Foundation Extras.bundle in the Plugins folder 
>>> throws a “License or privilege” error (-9949). Do not know if the 
>>> 2 are related.
>>> 
> 
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: Receive packet stop character

[Chip Scheide via 4D_Tech]

John,
you probably should not be reading individual lines of data from the disk.  
This takes mach more time...

it is too late here to dig up the code... but here is an outline of a better 
(best?) way to deal with text files:

Read_File_to_Text_Array
`$1 - pointer - to text array
`$2 - time - document reference

Repeat 
insert element into array
receive packet($DocRef; $Array_ptr->{$counter}; 300megs)
if (last character is not EOL)
receive until EOL
until end of file

NOTES:
- you can check for what EOL character is by examining the first text array 
element looking for whatever EOL marker you expect
- this in most cases reads the entire text file into a single text array element
- 300 megs was an empirically determined number (v13) where 4D was OK with 
reading and managing too much larger and 4D got/gets unhappy
- the test for EOL in the repeat loop is to allow each text array element to 
end on the end of 1 line of data - to avoid breaking a line across 2 text 
elements
- this works for any size file
- it makes processing the imported data much faster - as everything is in 
memory rather then reading from disk each line.
- if you do not have one written already, a text parser which keeps a numeric 
counter as to where it left off is very fast an efficient for moving through 
text data

if you need code for either the file reading or text parsing let me know I will 
get it you.

Chip




> I have a tab delimited text file and I want to get the first row with…
> 
> C_TEXT($TextValue)
> $DocRef:=Open document($IndexPath)
> RECEIVE PACKET($DocRef;$TextValue;”\r")
> CLOSE DOCUMENT($DocRef)
> 
> This was working fine until about an hour ago when it suddenly 
> started bringing in the whole document which has many rows. Using “\t
> ” works fine just bringing the first field in the first row.
> Any ideas?
> 
> Mac OS High Sierra
> 4D v14 in Unicode mode
> 
> John
> 
> 
> John Baughman
> Kailua, Hawaii
> (808) 262-0328
> john...@hawaii.rr.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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: Receive packet stop character

[Chip Scheide via 4D_Tech]

John,
try:

RECEIVE PACKET($DocRef;$TextValue;Char(13)) //return
or
RECEIVE PACKET($DocRef;$TextValue;Char(10)) // line feed
or
RECEIVE PACKET($DocRef;$TextValue;Char(13)+Char(10)) // both of the above

depending on how much control you have on the incoming file it could be any 
combination
my preferred way is:
$EOL := Test_EOL($DocRef)
if ($EOL #"")
RECEIVE PACKET($DocRef;$TextValue;$EOL)
`do stuff

below written in email so...

Test_EOL
`$1 - time - document reference
`RETURNS - text - EOL character or empty string if none found

c_time($1;$DocRef)
c_text($TextValue;Return;$0)
c_boolean($EOF)

$DocRef := $1

Repeat
RECEIVE PACKET($DocRef;$TextValue;100) 
case of
: (position(char(13)+char(10),$TextValue) >0)
$return := char(13)+char(10)
: (position(char(13),$TextValue) >0)
$return := char(13)
: (position(char(10),$TextValue) >0)
$return := char(10)
:(OK = 0)
$EOF:=true
end case
until ($return#"") | ($EOF)
`I forget the command - but reset read point in file to start
`end


> I have a tab delimited text file and I want to get the first row with…
> 
> C_TEXT($TextValue)
> $DocRef:=Open document($IndexPath)
> RECEIVE PACKET($DocRef;$TextValue;”\r")
> CLOSE DOCUMENT($DocRef)
> 
> This was working fine until about an hour ago when it suddenly 
> started bringing in the whole document which has many rows. Using “\t
> ” works fine just bringing the first field in the first row.
> Any ideas?
> 
> Mac OS High Sierra
> 4D v14 in Unicode mode
> 
> John
> 
> 
> John Baughman
> Kailua, Hawaii
> (808) 262-0328
> john...@hawaii.rr.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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: AW: Programmatically change the number format?

[Chip Scheide via 4D_Tech]

it is simplest to define the format in the structure under formats and filters 
giving the format a name like "MyNumericFormat"

then in code you can simply refer to the format as "|MyNumericalFormat"
NOTE: the pipe (vertical bar) in front of the name.

this way you can use the same format throughout the system, and if your needs 
change you can change it in one place and not have to search all over the 
system for, and change every occurrence of the format, where you to simply type 
the format inline (in your code directly).


Chip
> Hi,
> 
> I suppose you want to display noting (or a special value, e.g. "-") 
> if the value is zero?
> 
> Defining a number format has the following pattern: "positive 
> values{;negative values};{zero}".
> 
> Example: "### ### ### ###.00;-### ### ### ###.00;-"
> 
> In other words: you just need to define one display format, no need 
> to apply an other display format for zero values.
> 
> HTH,
> 
> Olivier
> 
> || https://flury-software.ch/
> 
> -Ursprüngliche Nachricht-
> Von: 4D_Tech <4d_tech-boun...@lists.4d.com> Im Auftrag von wangel--- 
> via 4D_Tech
> Gesendet: Sonntag, 15. März 2020 20:10
> An: 4d_tech@lists.4d.com
> Cc: wan...@online.no
> Betreff: Programmatically change the number format? 
> 
> In a listbox with a selection of records I have some columns with numbers.
> They have the number format 0.00. Not all the cells have numbers 
> greater than 0, so is it possible to programmatically change the 
> format to #.## in cell where the number is 0?
> 
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: [OFF] How to install 4D Demo?

[Chip Scheide via 4D_Tech]

they are VERY used to this situation  :)

> This past week, I was associating with some Linux professionals 

Hell is other people 
 Jean-Paul Sartre
**
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: Use Named Selection Unexpectedly Loads First Record of Named Selection

[Chip Scheide via 4D_Tech]

and I would read into that - IF there is no selected record, the command will 
load the First Record

Chip


> Hi Douglas
> 
> 
> Doc says:
> When you create a named selection, the current record is “remembered” by the
> named selection. USE NAMED SELECTION retrieves the position of this record
> and makes the record the new current record; this command loads the current
> record.
> 
> In your example, the first record is the "current record". So for me, it
> works like it should be.
> 
> Patrick
> 
> 
> 
> -
> Patrick EMANUEL
> 
> Administrator
> www.association-qualisoft.eu 
> (Soft1002, Simply Asso & QS_Toolbox)
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: [off-ish] v17 or 18 - Exported forms

[Chip Scheide via 4D_Tech]

if you have ever used React - it HAS to be simpler  :)

> Yes, forms are exported in JSON format. In project mode, CSS files 
> are used for some of the style information.
> 
> Converting a form into something usable by a web browser is certainly 
> possible, but it will not be a small or simple project.
> 
> John DeSoi, Ph.D.
> 
> 
>> On Mar 11, 2020, at 3:22 PM, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> I have not done ANY work with v18, and only opened v17 once to 
>> quickly test an app's compatibility.
>> I understand that it is now possible to export forms in a manner 
>> which is compatible with a code repository/version control system.
>> 
>> If this is correct what is the format of the form data?
>> I assume it is text, and probably JSON... 
>> 
>> IF these 2 assumptions are true, is it (reasonable) to parse the son 
>> into html for direct rendering in a browser?
>> 
>> My end quest is to find some sort of functional GUI for form 
>> building that I can use for/with React/javascript without having to 
>> manually code very F-ing pixel placement.
> 
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: Execute on client command - locking records

[Chip Scheide via 4D_Tech]

maybe a method called before the user prints is doing something like:
Read only([table])
  print routine

Chip
> Thank you so much, Chuck! Changing the order of the commands did the 
> trick! I will be sure to remember this next time.
> 
> My server process does not end, but I am not using any print jobs on 
> it, and, oddly, normal users use the exact same printing code in 
> processes that do not end for a long time and do not end up locking 
> the file with the report formats, either. So, still offbeat behavior, 
> but I can live with it.
> 
> JJ
> 
>> OnWed, 11 Mar 2020 14:06:30 -0400, Chuck Miller 
>> > > wrote:
>> 
>> Remember you must have code in the following sequence
>> 
>> Unload record
>> read only
>> 
>> The reason it may be unlocking on server is that the process ends
>> 
> 
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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
**

[off-ish] v17 or 18 - Exported forms

[Chip Scheide via 4D_Tech]

I have not done ANY work with v18, and only opened v17 once to quickly test an 
app's compatibility.
I understand that it is now possible to export forms in a manner which is 
compatible with a code repository/version control system.

If this is correct what is the format of the form data?
I assume it is text, and probably JSON... 

IF these 2 assumptions are true, is it (reasonable) to parse the son into html 
for direct rendering in a browser?

My end quest is to find some sort of functional GUI for form building that I 
can use for/with React/javascript without having to manually code very F-ing 
pixel placement.

maybe... the forms generated by Wakanda?

any help pointing me in the right direction would be appreciated.

THANKS in advance
Chip


Hell is other people 
 Jean-Paul Sartre
**
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: iOS 13.x User Agent Shows iPad as Macintosh

[Chip Scheide via 4D_Tech]

> 
> As always, I recommend a pot of coffee and suitable mood music before 
> starting.
Metallica, Pantera, Rob Zombie come to mind...
 :)

Chip

Hell is other people 
 Jean-Paul Sartre
**
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: ORDA - NOT(IN)

[Chip Scheide via 4D_Tech]

maybe because the array [] is not empty when there is a an empty string in it.
and the query, in the second case is looking for empty string values, or just 
string values

> 
> NOT(IN []) 
>versus 
> NOT(IN [""]) 

Hell is other people 
 Jean-Paul Sartre
**
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
**

For those using Javascript - here is a grid component...

[Chip Scheide via 4D_Tech]

AG-Grid (https://www.ag-grid.com/)
Javascript component which is supposed to play well with many other javascript 
environments such as React and Agular
it appears to be very powerful

Chip

Hell is other people 
 Jean-Paul Sartre
**
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
**

[offish] Anyone working with a Laboratory

[Chip Scheide via 4D_Tech]

Anyone working with/in/for a laboratory 
Please contact me off list.

Chip

Hell is other people 
 Jean-Paul Sartre
**
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: Reading and writing large arrays to disk

[Chip Scheide via 4D_Tech]

these size differences, compressing the blob, on any computer newer than about 
1990 is negligible.

> 
> Compressing the BLOB prior to writing slowed the process with times 
> of about 20-21 milliseconds.
> However, the file size was 1/3 as big. Shrinking from 2.3MB to 0.74 MB.
> Note that the files written with JSA  and OB/ JS were 1.1- 1.3 MB in size.

Hell is other people 
 Jean-Paul Sartre
**
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: Reading and writing large arrays to disk

[Chip Scheide via 4D_Tech]

Variable to blob
blob to document

done fast as possible from 4D
Chip


> On Jan 6, 2020, at 10:50 AM, Kirk Brooks via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
>> I agree with Chuck here - writing a line at a time is slow. It's very
>> secure though. So it's good if you may crash - whatever has already been
>> written stays written to disk. But otherwise better to buffer some and then
>> write.
> 
> I think that depends on whether it’s better to have partial data in 
> the file than correct data. If writing partial data will cause the 
> consumer of that text file to generate incorrect results or crash, 
> then it’s better to make sure it’s all or nothing, typically using an 
> atomic write mechanism like writing to a temp file, and when that’s 
> completed successfully, moving the temp file to the destination path. 
> 
> If performance is important, concatenating text 200K times is almost 
> definitely the wrong way, and the best way depends on what version of 
> 4D you’re using, the total size of the text, how fast is fast enough, 
> and possibly whether you’re writing to SSD or spinning hard drive.
> 
> Jim Crate
> 
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: Button is disabled when compiled - Mac only

[Chip Scheide via 4D_Tech]

assuming it is not an issue with the version of 4D...

disable itself:
- some other object/button/variable with the same name is disabled
- it is underneath some other object (like a group frame), and is not 
really disabled but is covered up. This would be the 'Z' (layer) of the 
form.
- there is a property for buttons (and other action objects) which is 
titled 'initially disabled', I may be thinking of initially invisible 
though...

off the top of my head...

Chip
On Wed, 18 Dec 2019 22:44:21 +, Pat Bensky via 4D_Tech wrote:
> Using v17r6
> 
> I have a small button on a data entry form. Click it and a popup menu lets
> you chose from a couple of options.
> When the app is compiled, this button is always disabled - on a Mac. On
> Windows it is enabled.
> There is no code that disables it.
> There is no Standard Action selected for it.
> The only Event selected is On Clicked
> 
> What could cause a button to disable itself? Only when running compiled on
> a Mac.
> 
> Pat
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: FLUSH BUFFER

[Chip Scheide via 4D_Tech]

no he is running v13.4 -
I and others have suggested updating to v13.6 as well.


On Wed, 18 Dec 2019 12:17:15 -0500, Chuck Miller via 4D_Tech wrote:
> I think he said he was running 2003.x If so I would make cache much 
> smaller. I would make it 1.5 gig and I would set auto flush on server 
> to 1 minute
> 
> Regards
> 
> Chuck
> 

>  Chuck Miller Voice: (617) 739-0306
>  Informed Solutions, Inc. Fax: (617) 232-1064   
>  mailto:cjmillerinformed-solutions.com 
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D and Sybase connectivity
>   http://www.informed-solutions.com  
> 

> This message and any attached documents contain information which may 
> be confidential, subject to privilege or exempt from disclosure under 
> applicable law.  These materials are intended only for the use of the 
> intended recipient. If you are not the intended recipient of this 
> transmission, you are hereby notified that any distribution, 
> disclosure, printing, copying, storage, modification or the taking of 
> any action in reliance upon this transmission is strictly 
> prohibited.  Delivery of this message to any person other than the 
> intended recipient shall not compromise or waive such 
> confidentiality, privilege or exemption from disclosure as to this 
> communication. 
> 
>> On Dec 18, 2019, at 11:42 AM, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Ferdinando,
>> try setting the cache to 8gig (8000MB) that is 50% of installed RAM.
>> 
>> run it for a bit, see if this helps.
>> 
>> Chip
> 
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: FLUSH BUFFER

[Chip Scheide via 4D_Tech]

Ferdinando,
try setting the cache to 8gig (8000MB) that is 50% of installed RAM.

run it for a bit, see if this helps.

Chip
On Wed, 18 Dec 2019 17:30:46 +0100, stardata.info wrote:
> These are the specific:
> 
>  10.385.729 Data file
> 
> 2.466.497 Index file
> 
> Window server 2016 64 Bit
> 
> Xeon E5 2620 v3
> 
> 16 Gb ram
> 
> Thanks
> /Ferdinando/
> 
> Il 18/12/19 17:21, Chip Scheide ha scritto:
>> Ferdinando,
>> the cache holds data previously accessed, in memory. This makes future
>> access to the same data faster, as the computer does not have to
>> re-read the source data from the hard drive. RAM is about 1000x faster
>> then a hard disk drive, (nano sec access for RAM, millisec access times
>> for hard drives).
>> 
>> Having data in the cache *is a good thing* and will increase the speed
>> of your program.
>> If your cache is set to be too large, you may not leave enough memory
>> (RAM) for the OS or the rest of 4D, or other program(s) running on the
>> same computer. This will have a compounding effect, as the OS will then
>> start to use virtual memory (memory slices stored on the hard disk),
>> which means EVEN MORE hard disk accessing slowing the machine further.
>> 
>> if you are running a 32 bit OS (look under control panel -> system ->
>> general (I think) ) you should see some information about the computer,
>> the OS, and whether it is 32 or 64 bit.
>> 
>> as I said in a previous message a 32 bit OS can NOT access more then
>> ~3.5 gig of ram, REGARDLESS of actual RAM installed.
>> 
>> If you are running a 32 bit OS, and have a cache setting of say 3gig
>> (3000MB) you are not leaving enough for other operations. Similarly, if
>> you have 32gig of RAM in a 64 bit OS, and allocate 31.5 gig of RAM to
>> the cache, you are not allowing enough room for other operations.
>> 
>> Others may have different opinions on this,
>> if you are running nothing but server on the machine - I would suggest
>> that you start by setting the cache to approximately 50% of available
>> RAM (set it to 1.75gig under 32 bit OS, 1/2 of installed RAM under 64
>> bit).
>> 
>> run the program for a while, see what happens. If things are good -
>> leave it alone, if things are not try adjusting the size of the cache,
>> again. larger if 4D is the only thing running, smaller if there are
>> other programs/services running.
>> 
>> Chip
>> 
>> P.S. get your database running on an SSD - this increases 'hard rive'
>> access speeds significantly (10x I believe).
>> 
>> 
>> On Wed, 18 Dec 2019 16:58:34 +0100, stardata.info via 4D_Tech wrote:
>>> Hi David,
>>> 
>>> I come back to you to let you know that the problem that i had told
>>> you about in the first post is persisting.
>>> 
>>> Now i noticed that the cache that is occupied keep raising on every
>>> interaction that the client make with the server or more specific
>>> with the database.
>>> 
>>> At this reguard i thought that closing the clients could have free
>>> all the cache that was occupied but wasn't as i supposed, so even
>>> closing all the clients i got still cache occupied.
>>> 
>>> I can't find a way to free the cache and this leads me to having all
>>> of it full making my software very slow.
>>> 
>>> Hoping to hear you soon..
>>> 
>>> Best reguards,
>>> 
>>> Ferdinando
>>> 
>>> Il 18/12/19 13:29, stardata.info ha scritto:
 Hi David,
 
 Thanks for your indications.
 
 Ferdinando
 
 Il 18/12/19 13:03, David Samson ha scritto:
> That is not such big data. Some places have 300GB of data. Maybe
> your cache is set too small on 4D server. Attached is an old
> document but it still explains the basics.
> 
> David
> 
> On Tue, 17 Dec 2019 at 18:28, stardata.info 
> mailto:stard...@stardata.info>> wrote:
> 
>  10.385.729 Data file
> 
>  2.466.497 Index file
> 
>  Window server 2016 64 Bit
> 
>  Xeon E5 2620 v3
> 
>  16 Gb ram
> 
> 
> 
>  Il 17/12/19 18:43, David Samson ha scritto:
>>  The suggestions on the NUG make sense.
>>  "After some hours of use the application slows down."this sounds
>>  like the memory is getting full. How much RAM is on the server
>>  and how big is your data file?
>> 
>>  On Tue, 17 Dec 2019 at 14:02, stardata.info
>>   >  > wrote:
>> 
>>  Hi David,
>> 
>>  I understand you observation, but i notice that if i restart
>>  the application, the problme is solved. After some hours of
>>  use the application slows down.
>> 
>>  Thanks
>> 
>>  Ferdinando
>> 
>>  Il 17/12/19 13:40, David Samson ha scritto:
>>>  This sounds like a network problem - not 4D. We had a
>>>  similar thing and when they restarted the network switch

Re: FLUSH BUFFER

[Chip Scheide via 4D_Tech]

Ferdinando,
the cache holds data previously accessed, in memory. This makes future 
access to the same data faster, as the computer does not have to 
re-read the source data from the hard drive. RAM is about 1000x faster 
then a hard disk drive, (nano sec access for RAM, millisec access times 
for hard drives).

Having data in the cache *is a good thing* and will increase the speed 
of your program. 
If your cache is set to be too large, you may not leave enough memory 
(RAM) for the OS or the rest of 4D, or other program(s) running on the 
same computer. This will have a compounding effect, as the OS will then 
start to use virtual memory (memory slices stored on the hard disk), 
which means EVEN MORE hard disk accessing slowing the machine further.

if you are running a 32 bit OS (look under control panel -> system -> 
general (I think) ) you should see some information about the computer, 
the OS, and whether it is 32 or 64 bit.

as I said in a previous message a 32 bit OS can NOT access more then 
~3.5 gig of ram, REGARDLESS of actual RAM installed.

If you are running a 32 bit OS, and have a cache setting of say 3gig 
(3000MB) you are not leaving enough for other operations. Similarly, if 
you have 32gig of RAM in a 64 bit OS, and allocate 31.5 gig of RAM to 
the cache, you are not allowing enough room for other operations.

Others may have different opinions on this, 
if you are running nothing but server on the machine - I would suggest 
that you start by setting the cache to approximately 50% of available 
RAM (set it to 1.75gig under 32 bit OS, 1/2 of installed RAM under 64 
bit).

run the program for a while, see what happens. If things are good - 
leave it alone, if things are not try adjusting the size of the cache, 
again. larger if 4D is the only thing running, smaller if there are 
other programs/services running.

Chip

P.S. get your database running on an SSD - this increases 'hard rive' 
access speeds significantly (10x I believe).


On Wed, 18 Dec 2019 16:58:34 +0100, stardata.info via 4D_Tech wrote:
> Hi David,
> 
> I come back to you to let you know that the problem that i had told 
> you about in the first post is persisting.
> 
> Now i noticed that the cache that is occupied keep raising on every 
> interaction that the client make with the server or more specific 
> with the database.
> 
> At this reguard i thought that closing the clients could have free 
> all the cache that was occupied but wasn't as i supposed, so even 
> closing all the clients i got still cache occupied.
> 
> I can't find a way to free the cache and this leads me to having all 
> of it full making my software very slow.
> 
> Hoping to hear you soon..
> 
> Best reguards,
> 
> Ferdinando
> 
> Il 18/12/19 13:29, stardata.info ha scritto:
>> 
>> Hi David,
>> 
>> Thanks for your indications.
>> 
>> Ferdinando
>> 
>> Il 18/12/19 13:03, David Samson ha scritto:
>>> That is not such big data. Some places have 300GB of data. Maybe 
>>> your cache is set too small on 4D server. Attached is an old 
>>> document but it still explains the basics.
>>> 
>>> David
>>> 
>>> On Tue, 17 Dec 2019 at 18:28, stardata.info  
>>> mailto:stard...@stardata.info>> wrote:
>>> 
>>> 10.385.729 Data file
>>> 
>>> 2.466.497 Index file
>>> 
>>> Window server 2016 64 Bit
>>> 
>>> Xeon E5 2620 v3
>>> 
>>> 16 Gb ram
>>> 
>>> 
>>> 
>>> Il 17/12/19 18:43, David Samson ha scritto:
 The suggestions on the NUG make sense.
 "After some hours of use the application slows down."this sounds
 like the memory is getting full. How much RAM is on the server
 and how big is your data file?
 
 On Tue, 17 Dec 2019 at 14:02, stardata.info
  >>> > wrote:
 
 Hi David,
 
 I understand you observation, but i notice that if i restart
 the application, the problme is solved. After some hours of
 use the application slows down.
 
 Thanks
 
 Ferdinando
 
 Il 17/12/19 13:40, David Samson ha scritto:
> This sounds like a network problem - not 4D. We had a
> similar thing and when they restarted the network switch
> all was OK.
> 
> David
> 
> 
> 
> 
> Message: 1
> Date: Fri, 13 Dec 2019 18:50:51 +0100
> From: "stardata.info "
> mailto:stard...@stardata.info>>
> To: Tom Benedict  >, 4D iNug Technical
> <4d_tech@lists.4d.com >
> Cc: 4d_tech-requ...@lists.4d.com
> 
> Subject: Re: FLUSH BUFFER
> Message-ID:
> <3b8782ae-5799-815c-b6ff-460530ddf...@stardata.info
> 

Re: All folders hidden in Apppackage/AppFolder...

[Chip Scheide via 4D_Tech]

I suggested, privately, that he just encrypt the file(s) and this might 
resolve the issue as then no-one, theoretically, can access the file(s).
 
On Wed, 18 Dec 2019 10:04:14 +, Jeremy Roussak via 4D_Tech wrote:
> Jörg,
> 
> I can’t say anything useful about Windows. On a Mac, though, I have 
> to echo Chip’s “why”? The folders you mention are already “hidden”, 
> in the sense that they’re inside a package; although it’s a folder, 
> it appears to be a single file and non-technical users won’t realise 
> that it isn’t. Users sufficiently au fait with MacOS to know how to 
> show the package contents (and what “package contents” means) are 
> likely to be sufficiently tech-savvy to defeat your attempts to make 
> the folders invisible.
> 
> What problem are you trying to solve?
> 
> Jeremy
> 
>> On 18 Dec 2019, at 03:46, Jörg Knebel > > wrote:
>> 
>> Jeremy,
>> 
>>> On 18 Dec 2019, at 04:55 AEDT, Jeremy Roussak >> > wrote:
>>> 
>>> Mac or Windows?
>> 
>> Both platforms.
>> 
>> Cheers
>> Jörg
> 
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: All folders hidden in Apppackage/AppFolder...

[Chip Scheide via 4D_Tech]

Jorg,
if by 'hide', you mean make them invisible (as in adding a '.' to the 
file & folder names) well...
then you are changing the names of the various files and folders that 
4D is expecting to be in place... so that will not work.

If you mean using 4D, or other means, to set the invisible bit without 
changing the name(s) that should not create any problem for your 
database.

NOTE: I have never done this with 4D required files and folders, 
however I do create and maintain invisible files and folders for 
internal use - and there is no problem.

Can I ask..?
Why?

Chip
On Tue, 17 Dec 2019 23:18:21 +1100, Jörg Knebel via 4D_Tech wrote:
> G’day All,
> 
> Out of curiosity, what effect would it have if I decide to hide all 
> folders in the application package/folder and even the data-file 
> programmatically from within 4D.
> 
> I mean hiding the PlugIn-, ComponentS-, etc. folders.
> 
> I know everything can still be accessed from the 4D-structure but 
> I’ve no idea of any ripple effect(s) it might has.
> 
> Any ideas, experiences, voodoo ... are appreciated.
> 
> Thanks
> 
> Cheers
> Jörg
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: lags

[Chip Scheide via 4D_Tech]

Fernando,
get v13.6 
here (windows) : 
https://download.4d.com/Products/Archives/Line_v13/4D_v13_6/Win/
here (Mac) : 
https://download.4d.com/Products/Archives/Line_v13/4D_v13_6/Mac/

no promise that it will solve the problem - but it can't hurt

Other issues that could cause server slowdowns
- too many users vs available RAM
- too many processes (on the server) vs available RAM
- memory leaks - (from memory) selections, sets, named selections, 
menus, (hierarchical) lists that are not released before a process 
exits.
- thrashing of the cache -- not a big enough cache requiring a lot of 
loading/unloading- changing the cache setting may help.
- thrashing of the drive (related to the above) - changing the cache 
setting may help.
- a mechanical hard drive vs SSD.
  - (heavy) fragmentation on a mechanical hard drive
- Other activities on the server? 

What windows version?
32 bit? 64 bit?

32bit OS accesses a max of ~3.5 gig RAM, regardless of installed RAM.


On Mon, 16 Dec 2019 22:42:29 +0100, stardata.info via 4D_Tech wrote:
> 
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: FLUSH BUFFER

[Chip Scheide via 4D_Tech]

you can use the flush buffer command, or you can shorten the time 
between automated flush buffers.

if this is writing into the very large table you mentioned in a 
previous post, I would insure that you do as little as possible in the 
trigger, and examine your indexes to determine if you use/need them.

*IF* you can remove an index, or reduce trigger execution time either 
will help speed buffer flushing

Chip
On Fri, 13 Dec 2019 16:39:48 +0100, stardata.info via 4D_Tech wrote:
> Hi All,
> 
> In one my application in 4D V13.4 on Windows, in some circumstances 
> 4D client freezes, seems when in one process he must to write more 
> records.
> 
> During these freezes periods, the 3/4 processes launched from my 
> applications work, but the front end interface is locked and is not 
> responsive.
> 
> After some seconds or minutes, 4D client work normally. Is possibile 
> that this is because he must to write more records ( i think around 
> 100 - 300 records )?
> 
> Is necessary to use FLUSH BUFFER commands?
> 
> 
> Thanks
> Ferdinando
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: maximum number of record

[Chip Scheide via 4D_Tech]

someone else will correct me if I am wrong, but I believe it is ~2 
billion.
a longint value for record numbers - (2^64)-1

Chip
On Fri, 13 Dec 2019 16:13:35 +0100, stardata.info via 4D_Tech wrote:
> Hi All,
> 
> In one my application in 4D V13.4 on Windows, i have in one table 
> over of 8.000.000 records.
> 
> What is the maximum number of records that 4D V13.4 can manage?
> 
> Thanks
> 
> Ferdinando
> 
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: v17.3 on Mac OS 10.15.2 Plugins "cannot be opened because the developer cannot be verified"

[Chip Scheide via 4D_Tech]

I do not think anyone as trying to shoot the messenger..

Apple has gone overboard with this.


> 
> please don’t shoot the messenger.
> I didn’t make the rules...

Hell is other people 
 Jean-Paul Sartre
**
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: v17.3 on Mac OS 10.15.2 Plugins "cannot be opened because the developer cannot be verified"

[Chip Scheide via 4D_Tech]

if you are distributing this...
then every user will need to do this :(

Chip
On Thu, 12 Dec 2019 13:56:04 -0500, Ken Eyring via 4D_Tech wrote:
> Awesome!  Great instructions!  It wasn't so bad to implement the 
> permissions - once I understood how.  Thank you!
> 
> Ken
> 
> 
> 
> On 12/12/19 13:33 PM, Robert McKeever via 4D_Tech wrote:
>> Yep, this is a pain.
>> 
>> Go to System Preferences, Security & Privacy, the General Tab.
>> 
>> Now start your database.
>> 
>> You will have to authorize each plug-in as not being recognized 
>> (Allow apps downloaded from:…).
>> 
>> Now quit your database.
>> 
>> Now start your database again. Answer yes for each plug-in (sorry, I 
>> don’t remember the dialog that comes up).
>> 
>> Now quit your database.
>> 
>> Now start your database again. You should be fine now.
>> 
>>> On Dec 12, 2019, at 10:20 AM, Ken Eyring via 4D_Tech 
>>> <4d_tech@lists.4d.com> wrote:
>>> 
>>> Hi Everyone,
>>> 
>>> I'm migrating from 4D v15.4 32-bit to v17.3 64-bit.  At the same 
>>> time, I am also moving my development machine from Mac OS 10.9.5 to 
>>> Mac OS 10.15.2.
>>> 
>>> So far it's going fairly smoothly, but a few quirks have come up 
>>> regarding plugins.  When I launch v17.3 on Mac OS 10.15.2, I get 
>>> the following alerts for these 4D Plugins:
>>> 
>>> - "4D InternetCommands.bundle" cannot be opened because the 
>>> developer cannot be verified
>>> 
>>> - "4D ODBC Pro.bundle" cannot be opened because the developer 
>>> cannot be verified
>>> 
>>> - "4D for OCI.bundle" cannot be opened because the developer cannot 
>>> be verified
>>> 
>>> I'm assuming there is a configuration somewhere that I can set to 
>>> allow the plugins to be opened - but can't find where.
>>> 
>>> 
>>> I'm also trying to find a way to capture the MAC address on Macs 
>>> and Windows.  Up until now, I've been using Miyako's Media Access 
>>> Control.bundle, but it doesn't look like it works with v17.  Any 
>>> suggestions to accomplish this task would be appreciated.
>>> 
>>> Thanks,
>>> Ken
>>> 
>>> 
>>> **
>>> 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
>>> **
>> 
>> _
>> Bob McKeever  http://www.mswl.com 
>> 
>> McKeever's Software Wizardry
>> Port Coquitlam, B.C.
>> bobmckee...@mac.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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: v17.3 on Mac OS 10.15.2 Plugins "cannot be opened because the developer cannot be verified"

[Chip Scheide via 4D_Tech]

OS X 10.15 -- catalina - I would suggest a not so good choice
however, given you can not/will not go back to 10.14

look online for how to disable gatekeeper (this is the software that is 
stopping the plugins).
here are 2 i found, although they do not apply specifically to 10.15... 
so your milage may vary in getting either of these to work
http://osxdaily.com/2015/05/04/disable-gatekeeper-command-line-mac-osx/
https://www.techjunkie.com/gatekeeper-macos-sierra/

Chip

On Thu, 12 Dec 2019 13:20:19 -0500, Ken Eyring via 4D_Tech wrote:
> Hi Everyone,
> 
> I'm migrating from 4D v15.4 32-bit to v17.3 64-bit.  At the same 
> time, I am also moving my development machine from Mac OS 10.9.5 to 
> Mac OS 10.15.2.
> 
> So far it's going fairly smoothly, but a few quirks have come up 
> regarding plugins.  When I launch v17.3 on Mac OS 10.15.2, I get the 
> following alerts for these 4D Plugins:
> 
> - "4D InternetCommands.bundle" cannot be opened because the developer 
> cannot be verified
> 
> - "4D ODBC Pro.bundle" cannot be opened because the developer cannot 
> be verified
> 
> - "4D for OCI.bundle" cannot be opened because the developer cannot 
> be verified
> 
> I'm assuming there is a configuration somewhere that I can set to 
> allow the plugins to be opened - but can't find where.
> 
> 
> I'm also trying to find a way to capture the MAC address on Macs and 
> Windows.  Up until now, I've been using Miyako's Media Access 
> Control.bundle, but it doesn't look like it works with v17.  Any 
> suggestions to accomplish this task would be appreciated.
> 
> Thanks,
> Ken
> 
> 
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Constants in code.

[Chip Scheide via 4D_Tech]

Kirk,
yes you can  :)

As I said in my post - I modified 4DPop constant editor do just that (among 
other things)

Chip
 

> I'll add a vote for Cannon's code for creating constant XLIF files. I
> really like being able to add comments to what the constants are for in the
> code. You just can't do that with the 4DPOP component.

Hell is other people 
 Jean-Paul Sartre
**
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: AW: Constants in code.

[Chip Scheide via 4D_Tech]

to expand
you can create 1 or more constants files in xlif format.
Inside each constants file you can create 'groups', logic assemblages 
of constants.
i.e. Web_Display, Interface_Colors, Listbox_Properties,  etc.
   
There is a tool in 4DPop (4Dpop constants editor) to help with this 
process.

The constant file(s) are then placed next to the structure in a folder 
titled "Constants". This folder may not already exist and you may have 
to create it. On a Mac you need to open the structure package (show 
package contents) to create/modify the Constants folder.

If you , or anyone else is interested, I have a version of 4DPop 
constants editor that I have modified to include the following 
enhancements (currently in v15 can/should be updatable to any newer 
version):
[send me an email making the request - and I'll send the modified 4DPop 
source code along.]

- open xlif files NOT in the current structure's path. i.e. open any 
xlif file, anywhere.
- drag n drop xlif files (as part of above).
- show all constants as a single list when there are groupings inside 
an xlif file, The constants are Not savable, including full sort order, 
in this 'mode'.
- able to re-load an xlif file, if modified by an outside program (i.e. 
text editor).
- sort (permanently if saved) not only the groupings, but the constants 
inside a group.
- add a comment to any constant.
- create and assign a UUID to each constant to avoid any issue with 
constant ID duplication.

there might be more that I do not remember off the top of my head.

Chip
On Mon, 9 Dec 2019 15:20:05 +, Epperlein, Lutz (agendo) via 4D_Tech 
wrote:
> You have to use xliff and you can find an example here:
> https://kb.4d.com/assetid=76583
> 
> Regards
> Lutz
> 
> -Ursprüngliche Nachricht-
> Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von 
> Eric Naujock via 4D_Tech
> Betreff: Constants in code.
> 
> Good morning,
>   This seem pretty rudimentary, but I don’t seem find anything in the 
> docs for this. 
> 
> Can you define your own Constants? I would like to define constants 
> in my database to cover various groups for permissions. But what I am 
> finding in the docs for v17r6 says they are listed in the constants 
> window. But there does not seem to be anything that tells you how to 
> create your own. Obviously there must be a way to do so since there 
> are constants for plugins. 
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Trapping the 'return' key in list forms

[Chip Scheide via 4D_Tech]

Typo in the previous message -
not 120 ticks 20 or 30 :)

On Tue, 3 Dec 2019 15:21:39 +, Peter Jakobsson wrote:
> Hi Chip
> 
> Thanks for the reply. I’ve seen that approach on some web based systems.
> 
> Could be good, could be bad. I see some users loving it and others 
> hating it. The machine trying to “second guess” that the user has 
> typed enough into the filter field sometimes makes it feel flaky 
> because it’s not immediately apparent what invoked the sudden query 
> unless you happen to know about the “timed action". At least with “
> type-ahead” the user knows that the keystroke will invoke a filter 
> at every character.
> 
> Having said that, I watched a user show me their product lookup on a 
> manufacturer’s booking site the other day - it had a timer just like 
> the one you described. He really liked it. But he also wanted the 
> filter to be invoked with the return key.
> 
> Regards
> 
> Peter
> 
> 
>> On 3 Dec 2019, at 15:12, Chip Scheide <4d_o...@pghrepository.org> wrote:
>> 
>> have you considered using a timer to auto search for the user?
>> 
>> i.e. user types: "App" 
>> and after a brief delay the searches auto executed using the user 
>> entered information?  I use 120 ticks.
>> 
>> then they do not have to hit return at all
>> 
>> 
>> On Tue, 3 Dec 2019 00:26:24 +, Peter Jakobsson via 4D_Tech wrote:
>>> Many thanks Kirk, and to those who responded to this thread.
>>> 
>>> I’ve tried a variety of approaches in a virgin structure. The 
>>> simplest appears to be one that was first suggested by Jeremy Rusak 
>>> but others also alluded to: simply remove the “Focusable” property 
>>> from the default button (or a button with the Return key shortcut 
>>> attached).
>>> 
>>> That allows the “Focus Object” functions to return the last object 
>>> instead of the current one. Hurrah !!
>>> 
>>> By the way, the reason this is coming up is because users tend to 
>>> regard the “Search” widget as a form in its own right. So they 
>>> expect to be able to hit the return key to execute a query, then use 
>>> tab to move between form object in the host form (which contains both 
>>> the list and the search widget), then use the return key again to 
>>> accept the form…..IF the cursor is not in the search widget, in 
>>> which case they expect “return” to execute the query again and not 
>>> accept the form.
>>> 
>>> Regards
>>> 
>>> Peter
>>> 
>>> 
>>> 
 On 2 Dec 2019, at 15:58, Kirk Brooks via 4D_Tech 
 <4d_tech@lists.4d.com> wrote:
 
 Hey Peter,
 I was just reading through your question and the answers and I 
 noticed the
 solutions get sort of complicated. I think the reason is the task you're
 describing a little unusual. Having one keystroke, the return key, 
 perform
 two very different actions can result in a non-intuitive UI. 
 Consider, on a
 web page hitting the return key NEVER closes the page. In fact it open a
 new one.
 
 I've inadvertently set up this sort of thing on forms of my own and it's
 really annoying. When I want to use the Return or Enter key for anything
 besides accepting the form (eg. initiating a query, moving around on a
 listbox, etc. ) I put an invisible button on the form to trap the 
 keystroke
 and then post an event, typically a TAB. This way I can still trap in the
 current object. For adding a CR to a text field I enable the After
 keystroke form event and trap the keystroke there.
 
 With this setup you will still handle the query stuff in the 
 context of the
 relevant object. I think someone else mentioned using the loosing focus
 form event. That's good because some users will probably get used 
 to using
 the TAB key to move around. There's nothing to stop your code from
 reselecting the search input object when it looses focus. The user won't
 know the difference. But if you do that how does the user get out of the
 field?
 
 For closing forms, not alerts, confirms or requests, with a given key I
 like to decide on some consistent action and stick to it on every 
 form. You
 could use Shift key + Enter. Whatever you choose matters less, I think,
 than applying it consistently throughout the database.
 
 On Fri, Nov 29, 2019 at 1:44 PM Peter Jakobsson via 4D_Tech <
 4d_tech@lists.4d.com> wrote:
 
> This is so that users can hit the return key to execute a query (like
> Google style). But if the cursor is not in the filter field but
> highlighting a row in the list then the return key should accept 
> the form
> (via regular default button action).
> 
 
 -- 
 Kirk Brooks
 San Francisco, CA
 ===
 
 What can be said, can be said clearly,
 and what you can’t say, you should shut up about
 
 *Wittgenstein and the Computer *
 **

Re: Trapping the 'return' key in list forms

[Chip Scheide via 4D_Tech]

have you considered using a timer to auto search for the user?

i.e. user types: "App" 
and after a brief delay the searches auto executed using the user 
entered information?  I use 120 ticks.

then they do not have to hit return at all


On Tue, 3 Dec 2019 00:26:24 +, Peter Jakobsson via 4D_Tech wrote:
> Many thanks Kirk, and to those who responded to this thread.
> 
> I’ve tried a variety of approaches in a virgin structure. The 
> simplest appears to be one that was first suggested by Jeremy Rusak 
> but others also alluded to: simply remove the “Focusable” property 
> from the default button (or a button with the Return key shortcut 
> attached).
> 
> That allows the “Focus Object” functions to return the last object 
> instead of the current one. Hurrah !!
> 
> By the way, the reason this is coming up is because users tend to 
> regard the “Search” widget as a form in its own right. So they 
> expect to be able to hit the return key to execute a query, then use 
> tab to move between form object in the host form (which contains both 
> the list and the search widget), then use the return key again to 
> accept the form…..IF the cursor is not in the search widget, in 
> which case they expect “return” to execute the query again and not 
> accept the form.
> 
> Regards
> 
> Peter
> 
> 
> 
>> On 2 Dec 2019, at 15:58, Kirk Brooks via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Hey Peter,
>> I was just reading through your question and the answers and I noticed the
>> solutions get sort of complicated. I think the reason is the task you're
>> describing a little unusual. Having one keystroke, the return key, perform
>> two very different actions can result in a non-intuitive UI. Consider, on a
>> web page hitting the return key NEVER closes the page. In fact it open a
>> new one.
>> 
>> I've inadvertently set up this sort of thing on forms of my own and it's
>> really annoying. When I want to use the Return or Enter key for anything
>> besides accepting the form (eg. initiating a query, moving around on a
>> listbox, etc. ) I put an invisible button on the form to trap the keystroke
>> and then post an event, typically a TAB. This way I can still trap in the
>> current object. For adding a CR to a text field I enable the After
>> keystroke form event and trap the keystroke there.
>> 
>> With this setup you will still handle the query stuff in the context of the
>> relevant object. I think someone else mentioned using the loosing focus
>> form event. That's good because some users will probably get used to using
>> the TAB key to move around. There's nothing to stop your code from
>> reselecting the search input object when it looses focus. The user won't
>> know the difference. But if you do that how does the user get out of the
>> field?
>> 
>> For closing forms, not alerts, confirms or requests, with a given key I
>> like to decide on some consistent action and stick to it on every form. You
>> could use Shift key + Enter. Whatever you choose matters less, I think,
>> than applying it consistently throughout the database.
>> 
>> On Fri, Nov 29, 2019 at 1:44 PM Peter Jakobsson via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>> 
>>> This is so that users can hit the return key to execute a query (like
>>> Google style). But if the cursor is not in the filter field but
>>> highlighting a row in the list then the return key should accept the form
>>> (via regular default button action).
>>> 
>> 
>> -- 
>> Kirk Brooks
>> San Francisco, CA
>> ===
>> 
>> What can be said, can be said clearly,
>> and what you can’t say, you should shut up about
>> 
>> *Wittgenstein and the Computer *
>> **
>> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Trapping the 'return' key in list forms

[Chip Scheide via 4D_Tech]

invisible button with  as the activation key, which could then POST 
KEY().
or you know...
User training  :)

CHip

> Hi
> 
> Could anyone kindly bring me up to date me how we trap the [Return] 
> key on a form these days with a default button when some other action 
> is to be taken rather than accepting the form, depending on the last 
> object that had the focus prior to executing the Default Button 
> script ?
> 
> In otherwords how can the default button script “know” that the 
> cursor was in a “filter list” widget just prior to executing and in 
> that case cancel the form-acceptance action in favour of executing 
> the list query.
> 
> This is so that users can hit the return key to execute a query (like 
> Google style). But if the cursor is not in the filter field but 
> highlighting a row in the list then the return key should accept the 
> form (via regular default button action).
> 
> many thanks
> 
> Peter
> 
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: Check boxes : Boolean or longing ?

[Chip Scheide via 4D_Tech]

my experience - through v15
checkbox VARIABLES are numeric (longint), however, boolean FIELDS can be 
represented on a form by a checkbox.
in either case if you want the label for the checkbox to be on the left side 
enter a space as the title and then use a static text object for the label

Chip
> Hi all,
> 
> If I insert a check box  ‘MyCheckbox’ in a form with a expression 
> ‘Form.MyCheckbox’, this expression has a numerical value.
> If I declare on load Form.MyCheckbox:=True, it is a boolean.
> 
> I find counter-intuitive to have a boolean represented by a numeric 
> value and prefer to write If (MyCheckbox) instead of If (MyChebox = 
> 1).
> 
> What is your experience ?
> Is there a risk to declare it as boolean ?
> 
> Thanks for your advices.
> 
> Bernard Escaich
> 
> 
> 
> 
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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
**

v15 - Designer user corruption

[Chip Scheide via 4D_Tech]

some of you may remember my frustration with a stack error when opening 
a database with an interpreted component, and getting a Stack error 
before any of my code was running.

Well, thanks indirectly to tech support I have determined the cause:
the designer user is corrupted in some manner

if I log in as administrator the database loads normally.
if I log in as designer I get the stack overflow error.

I now need some help in removing or repairing the users.

anyone else had this issue - if so how was it resolved?
and what about other users of the system how were they handled?

Thanks
Chip

We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: DOCUMENT LIST : how do I know the documents are valid

[Chip Scheide via 4D_Tech]

try testing for a locked file.
something like this:


Repeat
  on err call ("If_File_Locked_Return_True")
$Doc_Ref := Open document(New_Scan_Document_Path)
  on err call("")

  if (not(On_Err_call_File_Locked_Variable = true)) | ($Doc_Ref # †
00:00:00†)
close document($Doc_Ref)
File_Copy_Completed := move_file_Method
  end if
until(On_Err_call_File_Locked_Variable = false) | (File_Copy_Completed 
= true)


** note code typed in email - use at your own peril  :)

Chip
On Thu, 21 Nov 2019 10:20:46 +, Piotr Chabot Stadhouders via 
4D_Tech wrote:
> Hi,
> 
> We use DOCUMENT LIST and COPY DOCUMENT to handle scans
> The documents are copied by a scanner to a certain folder on a 
> Windows server, where we are picking them up and process them
> It seems that because of slow copying the documents are picked up too 
> early by us
> How can I ensure that the documents are totally copied by the 
> scanner? COPY DOCUMENT to an temporary folder doesn’t seem to solve 
> the problem
> 
> Gr,
> Piotr
> 
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Selection Based ListBox - How do I extract and apply values to a single cell?

[Chip Scheide via 4D_Tech]

also - formatting of the displayed data in the listbox (including 
column widths and titles)


Thanks
Chip
On Wed, 13 Nov 2019 17:59:41 +, Bob Miller via 4D_Tech wrote:
> 
> Can you step through a little example of how Form would help in this 
> case, to control a listbox?
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Selection Based ListBox - How do I extract and apply values to a single cell?

[Chip Scheide via 4D_Tech]

> Hi, 
> schematically, I do this:
>   save selection
>//  use userset

use listbox selected set
maybe simpler
apply to selection( = )

>//   selection to array
>//   replace values in array
>//   array to selection

>   use selection
>   highlight userset
> 
> -- 
> Arnaud de Montard 
> 
> 
> 
> 
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Event handler method in component

[Chip Scheide via 4D_Tech]

Jeremy,
Just to be clear

your code will *only* work if both the component and host are 
interpreted.
for me, one of the advantages of using a component is being able to 
compile it.

For that circumstance you will need to have some other means to inject 
code.
as I said I use text files in the resources folder, this is an 
abbreviated bit of code that runs ON EXIT of the component (when 
closing development).

then you can import/inject the code from the component even if the 
component is compiled. :)

ARRAY TEXT($Methods;0)

If (Application type=4D Local mode)
  //methods to be injected into host system
  //done this way to allow easy updating of the list
APPEND TO ARRAY($Methods;)
  // repeated for each method to export

  //insure that the most up to date versions of
  // the methods to be injected are saved to disk
shtdwn_Write_Code_to_Disk (->$Methods)


On Mon, 11 Nov 2019 16:16:46 +, Jeremy Roussak wrote:
> Exactly. FWIW, this is my code. 
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Event handler method in component

[Chip Scheide via 4D_Tech]

as a bonus you can update the code in the method(s) you are injecting 
as needs change (or bugs are found and fixed), by simply allowing the 
injection method to overwrite the existing code.

Chip
 
On Mon, 11 Nov 2019 15:09:34 +, Jeremy Roussak wrote:
> Chip, you read my mind - that is almost exactly what I implemented 
> yesterday afternoon. It was really easy to do and it works a treat.
> 
> Jeremy
> 
>> On 11 Nov 2019, at 15:06, Chip Scheide <4d_o...@pghrepository.org> wrote:
>> 
>> another option - depending on your view of doing this... is Code 
>> injection.
>> 
>> At startup of the host (will have to be started at least once 
>> interpretedly)
>> you copy the code for the event call method into a method in the host.
>> 
>> it looks something like this (interpreted host and component):
>> METHOD GET CODE() 
>> METHOD SET CODE(;)
>> 
>> Alternatively (compiled component and interpreted host):
>> - At component shut down, write the method(s) to be injected to disk as 
>> text (I use the resources folder)
>> - at host or component startup read the text files
>>  METHOD SET CODE(;)
>> 
>> Chip
>> 
>> On Sun, 10 Nov 2019 18:07:01 +, Jeremy Roussak via 4D_Tech wrote:
>>> I’d like to have a method set by ON EVENT CALL to live in a 
>>> component. It works, in that the method is called on each event, but 
>>> the system variables Modifiers and KeyCode are undefined so testing 
>>> for the event itself is tricky.
>>> 
>>> I can get round the absence of Modifiers by using Macintosh control 
>>> down, but I’m not sure how I get the keystroke that triggered the 
>>> event.
>>> 
>>> Is it possible?
>>> 
>>> Jeremy
> 
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Event handler method in component

[Chip Scheide via 4D_Tech]

another option - depending on your view of doing this... is Code 
injection.

At startup of the host (will have to be started at least once 
interpretedly)
you copy the code for the event call method into a method in the host.

it looks something like this (interpreted host and component):
 METHOD GET CODE() 
 METHOD SET CODE(;)

Alternatively (compiled component and interpreted host):
- At component shut down, write the method(s) to be injected to disk as 
text (I use the resources folder)
- at host or component startup read the text files
  METHOD SET CODE(;)

Chip

On Sun, 10 Nov 2019 18:07:01 +, Jeremy Roussak via 4D_Tech wrote:
> I’d like to have a method set by ON EVENT CALL to live in a 
> component. It works, in that the method is called on each event, but 
> the system variables Modifiers and KeyCode are undefined so testing 
> for the event itself is tricky.
> 
> I can get round the absence of Modifiers by using Macintosh control 
> down, but I’m not sure how I get the keystroke that triggered the 
> event.
> 
> Is it possible?
> 
> Jeremy
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Unable to download from kb

[Chip Scheide via 4D_Tech]

I tried...
get an error - no access
at/on.for this url : https://kb.4d.com/TN/2018/18-19_4DCollectionEntityLB.zip

not logged in, OS X 10.14 Firefox quantum 69.0.3
Chip
  
> Dear 4D collective
> 
> I am unable to download the technote materials 
> https://kb.4d.com/assetid=78151
> I have tried the usual range of browsers, have logged in and am 
> feeling a bit defeated. Any tips?
> 
> Thanks
> Steve Shaw
> 
> UKVD
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: v15 how do I feed a SQL query result to a listbox?

[Chip Scheide via 4D_Tech]

Thanks!

> 
> 
> See the bottom of this page:
> https://doc.4d.com/4Dv16/4D/16.6/Managing-List-Box-Objects.300-4445342.en.html
> 
> On 11/7/19, 3:11 PM, "4D_Tech on behalf of Chip Scheide via 4D_Tech" 
> <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> 
> wrote:
> 
> I believe that this is possible.
> I am not sure how to go about doing such.
> 
> Any help?
> thanks
> Chip
> We have done so much, with so little, for so long;
> We are now qualified to anything with nothing 
>   - unknown
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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
**

v15 how do I feed a SQL query result to a listbox?

[Chip Scheide via 4D_Tech]

I believe that this is possible.
I am not sure how to go about doing such.

Any help?
thanks
Chip
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Convert URL to Windows File Path

[Chip Scheide via 4D_Tech]

what do you mean by 'url path'?
example?
Chip
On Thu, 7 Nov 2019 16:55:04 -0600, Stephen J. Orth via 4D_Tech wrote:
> Does anyone have code they are willing to share regarding the conversion of
> a URL path to a Windows file path?
> 
> We have a user who is sending us URL paths to a PDF file and we need to
> download it locally to we can build it into another PDF document.
> 
> Thanks in advance!
> 
> 
> Steve
> 
> *
>   Stephen J. Orth
>   The Aquila Group, Inc.  Office:  (608) 834-9213
>   P.O. Box 690   Mobile:  (608) 347-6447
>   Sun Prairie, WI 53590
> 
>   E-Mail:  s.o...@the-aquila-group.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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: 4d v16.6 and OS X 10.11.6

[Chip Scheide via 4D_Tech]

Thanks!
I guess I have to look at what will be necessary to upgrade to 10.13..

Chip

On Sat, 2 Nov 2019 07:43:52 +1100, Wayne Stewart via 4D_Tech wrote:
> Chip,
> 
> It works but crashes frequently, especially in development.
> 
> I created a background process that brought process #1 to the front every
> five minutes.  That way at most I'll lose 5minutes of work.
> 
> Regards,
> 
> Wayne
> 
> 
> 
> 
> On Sat, 2 Nov 2019 at 07:31, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> does anyone have any experience with this combination?
>> 
>> Both from a development (stand alone) and Client/server installation.
>> I know the matrix says - not supported, but v16 starts on OS X
>> 10.11.6...
>> 
>> Thanks
>> Chip
>> We have done so much, with so little, for so long;
>> We are now qualified to anything with nothing 
>>   - unknown
>> **
>> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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 v16.6 and OS X 10.11.6

[Chip Scheide via 4D_Tech]

does anyone have any experience with this combination?

Both from a development (stand alone) and Client/server installation.
I know the matrix says - not supported, but v16 starts on OS X 
10.11.6...

Thanks
Chip
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Components and external data

[Chip Scheide via 4D_Tech]

Patrick,

THANKS!

Chip
On Wed, 30 Oct 2019 11:08:35 -0700 (MST), Patrick Emanuel via 4D_Tech 
wrote:
> 
> Hi,
> I understand that if a component needs to have access to 1 or more 
> tables there are 2 ways to do this:
> - Inject the table definition(s) into the host
> - USE DATABASE and connect to an external database/datafile.
> 
> I have some questions about using external databases in the context of 
> a component.
> 
> Given the following situation:
> [Host_Database] <- [component] -> [external_for_Component]
> 
> - in the case of client/server how is the external database managed?
>  -- would I place it in the component's resource folder?
>  -- is it automagically moved to the client via some other mechanism?
>  -- or is the component's external database call passed back to the 
> server, call(s) made and then data transferred to client from server?
>  -- something else
> 
> - As I read the 4D docs it seems that the external database can NOT 
> have/use a field of type C_Object as this is not supported by SQL, and 
> access is done to the external database only through SQL. 
>   -- Is this a correct interpretation?
> 
> - In a component with an external database, would I need to switch back 
> and forth between access to the external database and the host system?
> ex:
> method call from host includes pointer to table or field of host. To 
> satisfy the method call, data from the external database needs to be 
> accessed. I USE DATABASE(External) to the external database do query, 
> get data. 
> - do I need to place the retrieved external database data into 
> variable(s)?
> - do I need to then USE DATABASE(Host) before working with the host 
> table/field(s)?
> 
> Thanks for answering, and any other tips you may have regarding 
> external databases and components.
> 
> Chip
> We have done so much, with so little, for so long;
> We are now qualified to anything with nothing 
>   - unknown
> **
> 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
> **
> 
> 
> Hi Chip,
> 
> I use this mecanism every time in QS Toolbox and will speak about 
> this during the presentation planned next January.
> You really pointed out how to manage. Now, about C_OBJECT, I don't 
> save them. One trick could be to Jsonify it as text and perform the 
> reverse action when you need to get access to the information.
> 
> So, I manage action on server with the option 'Execute on server' as 
> method's property and for variable, I use GET/SET VARIABLE TO 
> VARIABLE commands.
> 
> Here is a SQL code on how to manage action executed on external 
> database and internal one:
> Begin SQL
>   USE REMOTE DATABASE DATAFILE :[$QS_VCS_COMP_DB_PATH] AUTO_CLOSE;
>   
>   SELECT count(*) 
>   from VCS
>   INTO :[$Count];
>   
>   USE DATABASE SQL_INTERNAL;
>   
> End SQL
> 
> You can ping me directly at: pat.emanuel67 @ gmail. com
> 
> Patrick
> 
> 
> _
> Sent from http://4d.1045681.n5.nabble.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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: VP IMPORT DOCUMENT in v17R6

[Chip Scheide via 4D_Tech]

Try using Posix - I know you should not have to
follows a posix converter - 4D's (at least as of v15 is 
incomplete/incorrect)


  //fileutl_Path_Convert_to_Posix
  // $1 - Text - Path to convert
  //$2 - Pointer (Optional) - to Error Return Text

  //Original from JorgeChB via iNug

  //Converts a Mac file path to a Posix form

  //RETURNS - Text - converted path, or empty string if path is empty
  // • Created 3/24/15 by Chip - 
  //• Updated 05-17-18 by Chip - added test for empty path
C_TEXT($Path;$Path;$0;$msg)
C_POINTER($2;$Error_ptr)

errutl_Start 

If (Count parameters>=1)
$Path:=$1

If (Count parameters>=2)
$Error_ptr:=$2
End if 

Case of 
: ($Path="")
$msg:="Source Path is empty"
errutl_Add ($msg)

: (Position(Colon_Char;$Path)>0)

If ($Path#"")
$Path:=Replace string($Path;Slash_Char;"__-sLaSh-__")  //'a/b' -> 
'a__-sLaSh-__b'
$Path:=Replace string($Path;Colon_Char;Slash_Char)  //'a:b' -> 'a/b'
$Path:=Replace string($Path;"__-sLaSh-__";Colon_Char)  
//'a__-sLaSh-__b' -> 'a:b'
$Path:=Replace 
string($Path;BackSlash_Char;BackSlash_Char+BackSlash_Char)  //'a\\b' -> 
'a\\b'"
$Path:=Replace string($Path;Space_Char;BackSlash_Char+Space_Char)  //'a 
b' -> 'a\ b'
$Path:=Replace string($Path;"*";BackSlash_Char+"*")  //'a*b' -> 'a\*b'
$Path:=Replace string($Path;"'";BackSlash_Char+"'")  //'a'b' -> 'a\'b'
$Path:=Replace string($Path;"&";BackSlash_Char+"&")  //'a' -> 'a\'
$Path:=Replace string($Path;Quote_Char;BackSlash_Char+Quote_Char)  
//'a"b' -> 'a\"b'
$Path:=Replace string($Path;"(";BackSlash_Char+"(")  //'a(b' -> 'a\(b'
$Path:=Replace string($Path;")";BackSlash_Char+")")  //'a)b' -> 'a\)b'
$Path:=Replace string($Path;"|";BackSlash_Char+"|")  //'a|b' -> 'a\|b'

  //make sure we do not prepend 'Volumes' if it already there
If (Position("/Volumes/";$Path)=0)
$0:="/Volumes/"+$Path
Else 
$0:=$Path
End if 
Else 
errutl_Add ("Source is empty.")
End if 
Else 
$msg:="Posix conversion is only applicable "
$msg:=$msg+"to paths formatted for use on a Macintosh."
errutl_Add ($msg)
End case 
Else 
$msg:="Required parameters (1) not passed."+Cr_Char
$msg:=$msg+"Parameters passed "+String(Count parameters)
errutl_Add ($msg)
End if 

errutl_End (Current method name;$Error_ptr;Nil($Error_ptr))
  //End fileutl_Path_Convert_to_Posix



NOTE: 
- errutl_start initializes an error reporting system
- calls to errutl_add builds a text message to return an error to 
calling method
- BOTH of the above can be removed or ignore or replaced with your own 
error reporter

Chip

On Wed, 30 Oct 2019 11:30:29 +, Jeremy Roussak via 4D_Tech wrote:
> I call VP IMPORT DOCUMENT(“vp”;Form.path) in the On VP Ready form 
> event. Form.path contains a path in Mac system format, 
> colon-delimited.
> 
> In v17R5, it works fine. In R6, on the same document, I get an empty 
> spreadsheet. No error; just an empty sheet.
> 
> Mac, Mojave.
> 
> Any suggestions gratefully received.
> 
> Jeremy
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: SV: OPEN DATA FILE gets endless loop

[Chip Scheide via 4D_Tech]

Carl,
Are you aware that once you point a 4D Database to a datafile - it 
remembers that data file?
So...
Open database
 -> where is my data file
Point database to data file
-> OK I'm happy!
startup completes.

You never have to do this again, unless you want to change data files.

Chip

On Mon, 28 Oct 2019 21:29:17 +0100, wangel--- via 4D_Tech wrote:
> Thanks for your response Jeremy. You have made it clear to me that 
> OPEN DATA FILE first closes the database and then reopen it with the 
> wanted datafile and then repeat that unless something stops it. I 
> tried with $dataPath:="" which obviously was not a particularly 
> brilliant idea. 
> I think I shall incorporate a Default.4DD file and try it from there.
> Regards
> Carl
> 
>> 
>> From: Jeremy Roussak 
>> To: 4D iNug Technical <4d_tech@lists.4d.com>
>> Cc: wan...@online.no
>> Subject: Re: OPEN DATA FILE gets endless loop
>> Message-ID: <8ef1b76a-1b3a-42d5-9bfb-aad0bd0fc...@mac.com>
>> Content-Type: text/plain;charset=utf-8
> 
>> Carl,
> 
>> I hesitate to suggest something quite so obvious, but it seems to me 
>> that each time you enter the On Startup method, you
> 
>> 1. Set $dataPath to a path
>> 2. Test $dataPath is “”, which of course it isn’t 3. Open a data 
>> file 4. Set $dataPath to “” (effectively pointless) 5. Re-enter On 
>> startup when the new data file opens 6. Go to step 1; hence your loop
> 
>> From the OPEN DATA FILE documentation:
> 
>> If the access path sets a valid data file, 4D quits the database in 
>> progress and re-opens it with the specified data file. In 
>> single-user mode, the Semaphore 
>>  >and the On 
>> Startup database method 
>>  
>> are successively called.
>> Warning: Since this command causes the application to quit before 
>> re-opening with the specified data file, it must be used with 
>> precaution in the On Startup database method 
>> <>file:///4Dv17/4D/17/On-Startup->database-method.301-3730029.en.html> 
>> or in a method called by this database method, so as to avoid 
>> generating an infinite loop. 
> 
>> Jeremy
> **
> 
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: How to lookup a value within an object within an object

[Chip Scheide via 4D_Tech]

without an additional component/plugin 

I would write a routine to extract the object, then no matter how deep 
or how your current configuration changes you can extract it.

I have only thought about this for a few moments but...
something like:
Get_object(Source_Object;Property) -> object

Get object properties with types

if the object/property desired is not at the first level
  for every object
Get_Object(ob get(Source_Object;Next_Object);Property)

else
  $0:=ob Get(Source_Object;Property)
end if


Chip
On Fri, 25 Oct 2019 13:58:10 -0700, Tom Benedict via 4D_Tech wrote:
> I’m new to objects. I have an object which holds a range of keys and 
> values. Some of the values are objects. I figured I could just use 
> the OB Get command with dot notation to reference a key in a nested 
> object, but that doesn’t seem to be supported.
> 
> Here’s my example:
> 
> C_OBJECT(myObject)
> 
> myObject :=
> "{
>   "id": "evt_1FXWZKGX5QBs0BzAQsOMqk3f",
>   "object": "event",
>   "created": 1572024442,
>   "data": {
> "object": {
>   "object": "charge",
>   "amount": 4275,
>   "billing_details": {
> "address": {
>   "city": "Burien",
>   "postal_code": "98166",
>   "state": "WA"
> },
> "name": "Willy Wonka",
>   },
>   "type": "charge.succeeded"
> }"
> 
> If I want to get the value of:
> 
> myObject.data.object.billing_details.address.postal_code 
> 
> I have to use:
> 
> OB Get(OB Get(OB Get(myObject;"data");"object");”billing_details");”
> address");”postal_code”) 
> 
> rather than:
> 
> OB Get(myObject;data.object.billing_details.address.postal_code)
> 
> I see that Cannon created a dot notation component some years ago. Is 
> that the only ‘easy’ way to do this or have I missed something?
> 
> Thanks,
> 
> Tom Benedict
> 
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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 sites down?

[Chip Scheide via 4D_Tech]

I can't get to forums, or 4d.com

We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: object searching vs Text

[Chip Scheide via 4D_Tech]

Jim,
Thanks!

The issue with updating to v17 (or newer as time wears on) has to do 
with other software compatibility, OS X version, and software update 
costs (actually NOT 4D in this instance as we are on maintenance).

If it was just 4D and OS version updating could be done quickly.

BUT - there are many other bits of software which we need to update as 
OS versions get newer, and this costs $$ that are hard to come by when 
you are grant funded.

I would guess that this group will never get to OS X 10.15+ as 
literally every bit of software (other then 4D and Apple supplied 
applications) will have to be re-purchased. We have applications which 
cost $3000-$6000/seat, and that adds up *Fast*! That is beside the 
normal desktop application, such as MS Office.

Chip
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: object searching vs Text

[Chip Scheide via 4D_Tech]

Kirk, Thanks!
Any input is helpful

On Tue, 22 Oct 2019 11:50:33 -0700, Kirk Brooks via 4D_Tech wrote:
> 
> The sentiment in the last post, "...I don't know of a good way. Here is a
> bad way that might be enough" is echoed in a lot of the responses to
> similar questions I saw on StackOverflow.
:)

if the objective is to complete a task, and the task gets completed, 
then it *is* a good way!  :)
It might not be the most efficient way, nor even *an* efficient way, 
but it gets done; which is better then an efficient way that can not 
complete the task.  :)

As I have only recently really starting playing/working with objects...
I do not have data to really test the differences between 'stepping' 
through a complex object, object by object and walking down the object 
tree structure, and simply JSON Stringify then searching the resulting 
text for the existence of a property/value pair.

also note - I am looking not just for the existence of a property but 
also the value of that property.
i.e. Person_name & "John Doe"


We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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
**

object searching vs Text

[Chip Scheide via 4D_Tech]

I am just getting started playing/using objects.

I wrote some routines to determine if a particular property/value 
exists either in an object, or in an object which is part of an object 
array.

Given:
- the object is complex, i.e. has 1 or more sub-objects included and/or 
an object array included
- the only interest is does the property/value pair exist (true/false)

It occurred to me last night, that this processes maybe significantly 
faster, and less complicated, by simply converting the complex object 
to text (JSON Stringify) and then use POSITION to locate the 
property/value pair.

Has anyone looked at this? is using JSON faster? slower? no difference? 
or 'it depends'?
other comments?

Thanks
Chip
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Determining object content types

[Chip Scheide via 4D_Tech]

This is how I am handling it 
Whatever_it_is:=OB GET(object;property;Whatever_Type_I_Need)


as for find in object array, basic processing:

  if requested property exists
check value
  else
see if element contains 
  an object - check it for property & value
  an object array [OB GET ARRAY( into object array)]
 call this method again with this found object array

Chip

On Mon, 21 Oct 2019 11:21:02 -0700, Kirk Brooks via 4D_Tech wrote:
> 
> You know I've seen a lot of JS code on other platforms where they tend to
> treat anything in a JSON as a text value and type it when it's accessed.
> It's not a bad approach.
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Determining object content types

[Chip Scheide via 4D_Tech]

John,
thanks

I was typing a reply, and realized I had not tested something.
OB GET ARRAY(Object;Property;Object_Array) when the 'object array' is 
not an object array.

if the array in the object is NOT an actual object array, then 
Object_Array is set to the size of the array inside the object, BUT all 
elements are 'undefined'.

so..
if I find an array, I can extract it into an object array, and if 
element 1 is undefined it is NOT an actual object array, and if element 
1 is defined then it is an abject array and I can recursively call my 
new find in object array method!

Chip
On Mon, 21 Oct 2019 12:14:21 -0500, John DeSoi via 4D_Tech wrote:
> You can't determine the type of the array. I think you can load any 
> type into a text array, but then you would have to convert it. The 
> best option for internal use is to include a property that indicates 
> the type, i.e. use "type" and "value" pairs.
> 
> John DeSoi, Ph.D.
> 
> 
> 
>> On Oct 21, 2019, at 11:27 AM, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> However, a longint array is NOT an object array, and vise verse.
>> So how do you determine the type of an array inside an object?
> 
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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
**

Determining object content types

[Chip Scheide via 4D_Tech]

given an object and its contents.

how do you determine the type of the contents? specifically arrays.
an object can hold an army of any defined type, long, real, text, or 
object

If I execute the command OB GET PROPERTY NAMES, or OB GET Type, if the 
contents of the object is an array the value returned is : 39 = Object 
array.

However, a longint array is NOT an object array, and vise verse.
So how do you determine the type of an array inside an object?

Thanks
Chip
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: stack error - again

[Chip Scheide via 4D_Tech]

My original reply to this message was eaten and finally kicked back.

I have tried converting both the component and host system to v16, run MSC on 
both.
the host, with an interpreted component crashes right to the desk top - no 
error.

Chip

> Chip,
> 
> Among the things that work differently compiled vs source code are: 
> RESOLVE POINTER($Var_p;$Var_t;$Tbl_i;$Fld_i)
> 
> …which returns an uppercase VARIABLE NAME compiled, and a mix-case 
> Variable Name when source code.
> 
> If using the result of RESOLVE POINTER as a Property Name, consider 
> uppercasing it.
> 
> I had this problem…..
> 
> David Ringsmuth
> 
> From: Chip Scheide via 4D_Tech
> Sent: Friday, October 11, 2019 4:07 PM
> To: Tim Nevels
> Cc: Chip Scheide; 4D iNug Technical
> Subject: Re: stack error - again
> 
> On Fri, 11 Oct 2019 15:48:39 -0500, Tim Nevels wrote:
>> 
>> You said it only happens when you use one specific compiled component 
>> with one specific host database.
> 
> actually its is not compiled component - it is the INTERPRETED version 
> of the component!
> compile it and it works?!?!?!?!
> 
> 
>> Why don’t you take 30 minutes and give it a try. 
>> Just copy over enough methods to make one shared 
>> component method available to the host. Compile 
>> that and install it in the host. 
> I did try a new version of the component and I get the same problem...
> 
> what I am trying to avoid is a new host100+ tables, 2200+ methods, 
> unknown number of forms, some with some very finicky object and maker 
> placements (reports).
> 
> :)
> 
> Chip
> We have done so much, with so little, for so long;
> We are now qualified to anything with nothing 
>   - unknown
> **
> 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
> **
> 

Hell is other people 
 Jean-Paul Sartre
**
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: Object Array - finding an object with attritbute value

[Chip Scheide via 4D_Tech]

Jim,
why does this not work?

C_POINTER($1;$Array;$3;$Value)
C_TEXT($2;$Property)

$Array:=$1
$Property:=$2
$Value:=$3

For ($i;1;Size of array($Array->))

  If (OB Is defined($Array->{$i};$Property))

If (OB Get($Array->{$i};$Property)=$Value->)
  $0:=$i
  $i:=Exit_Loop 
End if 
  End if 
End for 


We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Object Array - finding an object with attritbute value

[Chip Scheide via 4D_Tech]

Thanks!
no 'For each' command in v15 - but I get the idea.

I was hoping/expecting that 4D had modified (or written a new command) 
Find in Array to handle objects.

Chip

On Thu, 17 Oct 2019 22:37:27 +0100, Narinder Chandi via 4D_Tech wrote:
> Chip,
> 
> Use the For each...End for each loop construct to iterate over the 
> array of objects, something like (untested written off the bat):
> 
> For ($i;1; size of array(object_array))
>   For each(property;object_array{$i})
> If ([property="Object_Name")
>   If (object_array{$i}.property="Fred") //or 
> object_array{$i}[property] should also work I think if you prefer 
> bracket notation
> //do something here...
>   End if
> End if
>   End for each
> End for
> 
> Like I said though, I have not tested the above code!
> 
> Regards,
> Narinder Chandi,
> ToolBox Systems Ltd.
>  
> I am available for new consulting opportunities…
> http://4d.1045681.n5.nabble.com/ANN-4D-Developer-Available-td5765443.html
> -- 
> 
> -Original Message-
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of 4D Tech 
> Mailing List <4d_tech@lists.4d.com>
> Reply-To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> Date: Thursday, 17 October 2019 at 22:06
> To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> Cc: Chip Scheide <4d_o...@pghrepository.org>
> Subject: Object Array - finding an object with attritbute value
> 
> Given that I have an array of objects - Array Object(object_array;5)
> 
> (hand waving) I populate the array with objects ...
> 
> how do I find which object in the array has an attribute/property with 
> a specific value?
> ex: property "Object_Name" : "Fred"
> 
> How do I find the array element (object) in which the property 
> 'Object_Name = "Fred"?
> 
> Chip
> We have done so much, with so little, for so long;
> We are now qualified to anything with nothing 
>   - unknown
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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
**

Object Array - finding an object with attritbute value

[Chip Scheide via 4D_Tech]

Given that I have an array of objects - Array Object(object_array;5)

(hand waving) I populate the array with objects ...

how do I find which object in the array has an attribute/property with 
a specific value?
ex: property "Object_Name" : "Fred"

How do I find the array element (object) in which the property 
'Object_Name = "Fred"?

Chip
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Can a component access Filters/Formats of the Host?

[Chip Scheide via 4D_Tech]

I want to be able to access host formats actually, for use in a listbox 
component


> Chip,
> 
> I’ve been using Pluggers API pack plugin and this method, which works 
> fine for formats. It may be that OBJECT Get filter and OBJECT Get 
> format would do what you want (from v15R5, according to the dox).
> 
> Jeremy
> 
> 
> 
>   // resolve a format name into its string
> 
>   // $1: name
> 
> C_TEXT($0;$1;$resolveName)
> $resolveName:=$1
> If (Substring($resolveName;1;1)="|")
>   $resolveName:=Substring($resolveName;2)
> End if 
> 
> C_LONGINT($i;$err)
> C_TEXT($root;$filterRoot;$name;$value)
> C_BLOB($res)
> 
>   //%w-533.4 no "missing parameter to plugin" message from next line
> $err:=API Get Indexed Resource ("ST4D";1;$res)
> 
> If ($err=0)
>   $res:=API Bag To XML ($res)
>   $root:=DOM Parse XML variable($res)
>   If (OK=1)
>   ARRAY TEXT($names;0)
>   $filterRoot:=DOM Find XML element($root;"bag/filters";$names)
> 
>   For ($i;1;Size of array($names))
>   DOM GET XML ATTRIBUTE BY NAME($names{$i};"name";$name)
>   If ($name=$resolveName)
>   DOM GET XML ATTRIBUTE BY 
> NAME($names{$i};"value";$value)
>   $i:=MAXINT
>               End if 
>   End for 
> 
>   DOM CLOSE XML($root)
>   End if 
> 
>   $0:=$value
> End if 
> 
> 
>> On 16 Oct 2019, at 19:44, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> title says it all
>> 
>> Thanks
>> Chip
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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
**

Can a component access Filters/Formats of the Host?

[Chip Scheide via 4D_Tech]

title says it all

Thanks
Chip
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Making a package of a built Mac volume desktop

[Chip Scheide via 4D_Tech]

you have 2, maybe 3 choices
- you can distribute with a folder which contains the .app and a 
separate datafile (or folder) --my preference
- you can distribute a .app package with everything inside. Then manage 
the updates yourself, distribute an update application which will reach 
inside the existing package, copy in a new structure and leave the old 
data alone.
- you might be able to do this more easily with 4D's update system, 
BUT, i have not used so I have no idea.

in either of the all inside the package distributions you (your user) 
will need to worry about backups in case of equipment failure. many 
people (my self included) do not, in general, backup the application 
folder. If your .app package is in the application folder (c:/program 
folder) it is likely to NOT be part of a backup plan. You will/should 
need to be very proactive about getting your users to create backups.

Chip
 
On Tue, 15 Oct 2019 16:25:33 -0500, Paul Ringsmuth via 4D_Tech wrote:
> 
> But sometimes there will be updates and the old data should be used. 
> The everything in one package becomes problematic because it is too 
> hard for the user to deal with the data files.
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Making a package of a built Mac volume desktop

[Chip Scheide via 4D_Tech]

isn't this a package already?
If so, I'm not sure that you can have a package inside a package.

Chip
On Tue, 15 Oct 2019 14:24:52 -0500, Paul Ringsmuth via 4D_Tech wrote:
> 
> I have created a built volume desktop app for Mac. 
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: FYI: [v17.3] - Create Folder (hierarchy) findings

[Chip Scheide via 4D_Tech]

Ran into something similar recently.

Where  = disk : Users: Databases : Specific Database folder : specific 
database : Resources : New Folder
(spacing for readability)
  
v15 -- Create folder(;*) did not create 'New Folder'
there was an On Err Call routine running - it was NOT invoked.
turned it off, tried again. No New Folder, no error.
Removed the "*" - folder created.

If I get a chance I will look into it more.

> G’day,
> 
> If the following has been mentioned before - sorry for the noise.
> 
> Tested/confirmed on Mac  macOS 10.13.6 interpreted
> 
> $MyFolderHierarchy:=“MyRoot"
> Create Folder ($MyFolderHierarchy)
> 
>   creates the folder “MyRoot” at the same level as the structure file
> 
> 
> 
> $MyFolderHierarchy:=“MyRoot"
> Create Folder ($MyFolderHierarchy;*)
> 
>   does NOTHING
> 
> 
> 
> $MyFolderHierarchy:="MyRoot”+Folder separator+"Level1"+Folder 
> separator+"Level2"+Folder separator+"Level3"+Folder separator
> Create Folder ($MyFolderHierarchy;*)
> 
>   throws errors:
> 
>   Error when executing the method "_001_Test" at line number 26
> 
>   The file is locked or the pathname is not correct. (File: 
> MyRoot:Level1:Level2:Level3:)
> 
>   Error code: -45 (4DRT)
>   The file is locked or the pathname is not correct. (File: 
> MyRoot:Level1:Level2:Level3:)
>   component: '4DRT'
>   task -5, name: 'P_8'
> 
>   Error code: 652 (xbox)
>   Cannot create folder MyRoot:.
>   xtoolbox
>   task -5, name: 'P_8'
> 
>   Error code: 13 (POSX)
>   Permission denied
>   component: 'POSX'
>   task -5, name: ‘P_8'
> 
> 
> 
> $SourcePath:=Get 4D folder(Database folder)//!!
> 
> $MyFolderHierarchy:=$SourcePath+"MyRoot”+Folder 
> separator+"Level1"+Folder separator+"Level2"+Folder 
> separator+"Level3"+Folder separator
> 
> Create Folder ($MyFolderHierarchy;*)
> 
>   Will have the wanted effect ―> new folder hierarchy starting at the 
> structure level.
> 
> 
> Conclusion: It might be a good idea to use an absolute path at all times.
> 
> My 2¢
> 
> HTH
> 
> Cheers
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: stack error - again

[Chip Scheide via 4D_Tech]

On Fri, 11 Oct 2019 16:25:55 -0500, Tim Nevels wrote:
> On Oct 11, 2019, at 4:07 PM, Chip Scheide <4d_o...@pghrepository.org> wrote:
> 
>> actually its is not compiled component - it is the INTERPRETED version 
>> of the component!
>> compile it and it works?!?!?!?!
> 
> Thanks for the clarification, I thought this was a compiler issue. 
> 
> Since it is an interpreted only issue, I’ve got more ideas.
> 
> In the host database:
> 
> At the first line of the "On Startup" Database Method put in a 
> TRACE.  Do you hit this before the stack overflow?
> At the first line of the “On Host Database Event” Database Method 
> put in a TRACE.  Do you hit this before the stack overflow?
as I stated in the start of this thread -
I inserted a TRACE (in the host) and an ALERT(CURRENT METHOD NAME) in 
the component, as the first lines of code. Into EVERY SINGLE METHOD 
that already has code. which includes ON Startup, and ON Before ON 
Startup

The stack error occurs BEFORE any of this is hit.

The reason I inserted the code into every method is i was working on a 
different system, and I have a form which is the only form for the 
table, and is set as Input and Output - but it is an entry form and so 
is not really happy being an output form. During startup of this system 
(no password, no On Startup) I was getting errors from this form -- 
even though it was not being displayed.

 
> In the component database:
> 
> At the first line of the "On Startup" Database Method put in a 
> TRACE.  Do you hit this before the stack overflow?
> At the first line of the “On Host Database Event” Database Method 
> put in a TRACE.  Do you hit this before the stack overflow?
> 
> There are the only 2 entry points that can run when you start a 4D 
> database. It calls “On Startup” in the host and it can call “On 
> Host Database Event” in the component. That is if you have the “
> Execute ‘On Host Database Event’ method in components” Database 
> Settings -> Security setting turned on in the host. 
> 
> You might also try turning that off if you have it on and see if that 
> makes a difference.
the ON BEFORE STARTUP went was initially off when this problem first 
occurred.

 
> If you never get to the TRACE command before you get the stack 
> overflow error, then it’s a real puzzler. 
yes -- hence the long and related postings look for ideas and/or 
answers  :)


> Could the host be really, really old and upgraded through very old 
> versions of 4D? Wasn’t there a compatibility setting from a long 
> time ago when the “On Startup” database method was first introduced 
> that would actually automatically call a method named “Startup” or 
> “Debut”? Could that be involved in this strange problem? 

The original of this system was written in v11, however during the move 
to v13 I did what I am trying to avoid now, and had to build a new 
structure, so this system is a v13 system.

And btw, it basically passed 4D's 64 bit testing report. a few PICTS, a 
plugin (now updated) but that was all that failed.

Chip
 
> Tim
> 
> *
> Tim Nevels
> Innovative Solutions
> 785-749-3444
> timnev...@mac.com
> *
> 
> 
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: stack error - again

[Chip Scheide via 4D_Tech]

On Fri, 11 Oct 2019 15:48:39 -0500, Tim Nevels wrote:
> 
> You said it only happens when you use one specific compiled component 
> with one specific host database.

actually its is not compiled component - it is the INTERPRETED version 
of the component!
compile it and it works?!?!?!?!


>Why don’t you take 30 minutes and give it a try. 
>Just copy over enough methods to make one shared 
>component method available to the host. Compile 
>that and install it in the host. 
I did try a new version of the component and I get the same problem...

what I am trying to avoid is a new host100+ tables, 2200+ methods, 
unknown number of forms, some with some very finicky object and maker 
placements (reports).

:)

Chip
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: stack error - again

[Chip Scheide via 4D_Tech]

Thanks for the ideas - only:
On a Mac.
I have 4 copies of v15
it does not matter which copy I use

Other 4D databases, hosts with components (including the component in 
question), and stand alone all function normally.

The data base does not crash.
I get a 4D error, which states (in not exact words) 
there is not enough stack space .

clicking OK refreshes the error message. I must force quit 4D to get 
out.

Chip

On Fri, 11 Oct 2019 22:11:22 +0200, Peter Bozek via 4D_Tech wrote:
> Again giant PITA, I know, but what other choices do you have?
>> 
>> 
> if it is a machine specific problem,  rebuilding structure may not help.
> More useful may be to reinstall system - which is PITA, too.
> 
> What may help in such case (and is still PITA) is install Win developer
> tools. Then crash should trigger low-level debugger and then it would be
> possible to look which code crashed. That may point to particular plugin or
> to 4D code. Not sure if it can point to component or component method,
> though.
> 
> --
> 
> Peter Bozek
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: stack error - again

[Chip Scheide via 4D_Tech]

On Fri, 11 Oct 2019 14:57:57 -0500, Tim Nevels via 4D_Tech wrote:
> So you know it is a host specific problem. You know what you have to 
> do, but you don’t want to do it because it is a PITA and could take 
> hours. Start over fresh.

That is just it -
I am not sure it is *just* a host problem...
as the host is happy with other (interpreted) components
and the component in question (interpreted or compiled) does not cause 
a problem with other hosts.

Also unless there is -something- that MSC cannot see (even if it can 
not fix it) there is no apparent problem with the host, or component. 

In addition, the issue does not appear to be *directly* in my 
code/forms as no trace, nor alert is opened when the first line of code 
in **EVERY** project method, Form method, object method, & database 
method in the host is a TRACE, and in the component an ALERT -- and 
NOTHING is displayed (alert/component) nor traced (host) BEFORE the 
stack error.

If the component is compiled (with the above conditions of traces and 
alerts), and the host restarted using the compiled component - all of 
the alerts and traces display as expected -- Starting with On before 
Host Database Startup event in the component.  -- and yes there are a 
LOT  :)

and Tim, I may eventually have to do that...build from scratch
BUT since all of this worked at one point it would be nice to know what 
the root cause of the issue is, so that I (and possibly others) do not 
repeat it.

Chip
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: stack error - again

[Chip Scheide via 4D_Tech]

lol  :)
there are 3 oher threads, 2 here, 1 on the forums.
from memory, and without copy/paste, beside the things listed 
previously in this thread

NB: Issue summary (host has 1 component and 1 plugin)
Host started with COMPILED component starts normally
Host started with (specific) interpreted component gives a stack 
overflow error

Things I have done
- compared custom constants from both host and component against: 
  - each other
  - method names in both
  - against 4D constants
- compacted & repaired and compacted & repaired structures of both
- compacted & repaired and compacted & repaired data files of both
- created a new component from the old component
- removed all forms from the component
- removed the one plugin in use
result stack error on start with interpreted component

There is no problem starting the host
- using a different interpreted component
- removing all components 

The component works with a different host, both interpreted and 
compiled.

Chip
On Fri, 11 Oct 2019 18:28:11 +, Dennis, Neil wrote:
>> Anyone have any other ideas?!?!?!?!
> 
> Sorry Chip, I have mostly ignored this thread until now... did your 
> run a maintenance repair on the structure?
> 
> I would assume you did, but it wasn't mentioned specifically.
> 
> Neil
> 
> 
> 
> 
> 
> --
> 
> 
> Privacy Disclaimer: This message contains confidential information 
> and is intended only for the named addressee. If you are not the 
> named addressee you should not disseminate, distribute or copy this 
> email. Please delete this email from your system and notify the 
> sender immediately by replying to this email.  If you are not the 
> intended recipient you are notified that disclosing, copying, 
> distributing or taking any action in reliance on the contents of this 
> information is strictly prohibited.
> 
> The Alternative Investments division of UMB Fund Services provides a 
> full range of services to hedge funds, funds of funds and private 
> equity funds.  Any tax advice in this communication is not intended 
> to be used, and cannot be used, by a client or any other person or 
> entity for the purpose of (a) avoiding penalties that may be imposed 
> on any taxpayer or (b) promoting, marketing, or recommending to 
> another party any matter addressed herein.
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: 'Zip.bundle will damage your computer...' Error message in macOS Catalina ― how to keep it enabled

[Chip Scheide via 4D_Tech]

Not using it - look into turning off gatekeeper
you will need to use the command line to do this.

Google is your friend for this.

Chip
On Fri, 11 Oct 2019 12:31:34 -0600, Chris Belanger via 4D_Tech wrote:
> I stupidly installed macOS Catalina this week. Now it is ‘protecting 
> me’ from malware with no obvious option of how to override its silly 
> conclusions.
> 
> I particular, I get “Zip.bundle” will damage your computer. You 
> should move it to the Trash. 
> 
> Only option is to Move to Trash.
> 
> This is the latest version from Miyako
> 
> Is  there a way to persuade macOS Catalina to stop this behaviour?
> 
> Any help is appreciated
> 
> Thanks,
> Chris
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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
**

stack error - again

[Chip Scheide via 4D_Tech]

In addition to the previous attempts to track this problem down.
I have recently done the following:
- examined all forms (both host and component) for recursive calls to 
their respective form methods (which are project methods). - no 
recursion found
- insured that all host methods are NOT shared with the component. to 
avoid host calling component calling host loops.
- added* TRACE as the first (or last) line of code in ALL 3500 methods 
and object scripts
- added* ALERT(Current Method Name) as first (or last) line of code to 
all 800 methods and object scripts

* - done by code, every method *should* have 2 Cr in the comment 
header, but in case there is code that does not have this the 
additional line of code (above) was added at the end of the method.

even after all of this...
Starting the Host (interpreted) with the interpreted component results 
in a stack over flow error ---BEFORE--- and of the above traces or 
alerts fire.
The Stack error occurs After login (4D user login system) and after the 
base 4D splash screen opens, but as indicate just above ---BEFORE--- 
any code in either component or host runs.

Anyone have any other ideas?!?!?!?!

Thanks
Chip

We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Option click close box

[Chip Scheide via 4D_Tech]

Jeremy,
does 4D post an option close to each window?

you could place an inis button on the form to catch it -
you should not have to, but... it might stop the problem.

Are all the windows in the same process? or different processes?

Chip

On Thu, 10 Oct 2019 22:51:45 +0100, Jeremy Roussak via 4D_Tech wrote:
> Miyako,
> 
> In all honesty, I don’t really care about the splash screen; it 
> belongs to 4D and 4D can make it behave as it wishes; if I don’t 
> like it, I needn’t use the splash screen mechanism at all and, as 
> Keith observes, it’s not a tragedy if it closes. I mentioned it only 
> for completeness.
> 
> What does bother me is the closing of input windows with no chance 
> for the user to intervene and say “hang on - I made those changes 
> and I don’t want you to throw them away without asking me”. That 
> doesn’t seem right.
> 
> Jeremy
> 
>> On 10 Oct 2019, at 22:44, Keisuke Miyako via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> thank you for sharing,
>> 
>> so if that is the case, I suppose we can say that...
>> 
>> the splash screen is not a dialog; On Close Box is not applicable by 
>> default.
>> to prevent it from closing, you could use DIALOG in the application 
>> process.
>> that said, starting a DIALOG (event loop) in On Startup is a very bad idea.
>> you are never finished booting the app.
>> 
>>> 2019/10/09 7:51、kculotta via 4D_Tech <4d_tech@lists.4d.com>のメール:
>>> 
>>> All true what you said, with some observations (17.3):
>>> 
>>> If On Close Box is checked, an input window gets the event, but 
>>> does not close.  An output window did close.
>>> If not checked an input window will close, revealing the output 
>>> window it was opened from (when DIALOG was called without OPEN 
>>> WINDOW being called first).
>>> The windows were created with "DIALOG(outputForm)".
>>> 
>>> I saw the application window close, but was able to 
>>> option-command-E to get the Explorer.
> 
> **
> 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
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Converting 4D Server v11 to v17

[Chip Scheide via 4D_Tech]

I suggest v15 because setting transparency when doing PICT conversion 
is not available in v13

On Thu, 10 Oct 2019 19:58:24 +, Peter BURGESS wrote:
> Thank you Chip.
> The suggestion, from other users and from my local 4D rep in 
> Australia, is for a 2-step conversion from v11 to v13, then to v17. 
> So, similar to your advice.
> I will go that direction, and keep a watch out for PICT files.
> 
> Regards,
> Pete
> 
> -Original Message-
> From: Chip Scheide <4d_o...@pghrepository.org> 
> Sent: Friday, 11 October 2019 05:10 AM
> 
> I have done a conversion from v13 - v16, as an experiment. I had no 
> problems.
> I did not run this for my users.
> I did some, but not extensive testing.
> 
> as mentioned elsewhere there are a few things that I believe you can 
> not resolve without a 32 bit version of 4D (PICTs) from inside 4D, and 
> v17 is 64 bit only on windows (I believe).
> SO you may want/need to go to v15 to resolve the PICT issue before the 
> final conversion to v17.
> 
> If I am mistaken about the 32 bit/64bit part, or you are *SURE* you 
> have no PICTs, then you should be able to do the conversion in one step.
> 
> 
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: 4D Server Hosting - The Future ?

[Chip Scheide via 4D_Tech]

it is a repeating cycle.

change the paradigm to make more money.
Once everyone that needs one has a mainframe switch to desktops, now 
everyone has a desktop
switch to the 'cloud'.
eventually it will swing back to personal/business owned devices as 
data security becomes a (bigger) issue

BTW - when using a 'cloud' service, depending on your personal/business 
outlook you might want to think about who has access to your data, and 
what are they doing with it. This applies not just to colo and 4D but 
to everything in 'the cloud'.

What is Apple doing with your playlists and other purchasing habits 
(and what does that say about you), who else is looking at the files in 
your dropbox account, and nobody should have to wonder about what 
google, amazon, Facebook twitter etc are doing with all the information 
you maybe giving them.


Just because your are paranoid does NOT mean that they are not *really* 
out there...  :)

On Thu, 10 Oct 2019 08:59:48 -0700, Kirk Brooks via 4D_Tech wrote:
> It is kind of
> interesting that we are moving back to the topology the industry started
> with - what's the difference between a 'main frame computer' and 'cloud
> computing'?
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Converting 4D Server v11 to v17

[Chip Scheide via 4D_Tech]

I have done a conversion from v13 - v16, as an experiment. I had no 
problems.
I did not run this for my users.
I did some, but not extensive testing.

as mentioned elsewhere there are a few things that I believe you can 
not resolve without a 32 bit version of 4D (PICTs) from inside 4D, and 
v17 is 64 bit only on windows (I believe).
SO you may want/need to go to v15 to resolve the PICT issue before the 
final conversion to v17.

If I am mistaken about the 32 bit/64bit part, or you are *SURE* you 
have no PICTs, then you should be able to do the conversion in one step.

On Tue, 8 Oct 2019 00:46:06 -0700 (MST), Peter.Burgess via 4D_Tech 
wrote:
> 
> In the thread circa October 2018, the suggestion seemed to be that while v17
> has a different architecture and is primarily object orientated, it will
> still accept and interpret v11 style language. Is this truly the case?
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: Converting 4D Server v11 to v17

[Chip Scheide via 4D_Tech]

my biggest problem here was trying to find the PICTs that were static 
pictures, that as it turns out, 4D had placed for me. These came from a 
gradient background that 4D used as part of the Form Wizard for listing 
forms.

I let 4D create a bunch of these for me for tables which either had 
specialized listing forms which did not do well in the user 
environment, or which had no direct user interaction, such as (many 
many) linking tables.

Chip 
On Thu, 10 Oct 2019 16:52:10 +0100, Narinder Chandi via 4D_Tech wrote:
> 
> Other issues that most conversions will have is converting PICTs to 
> PNG, JPG etc as PICT is now deprecated but it's not difficult.
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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: 4D Server Hosting - The Future ?

[Chip Scheide via 4D_Tech]

that all is great until the hardware running the 4,382,619 VMs crashes
:/

Chip
On Thu, 10 Oct 2019 16:23:18 +0100, Peter Jakobsson via 4D_Tech wrote:
> 
> He also was of the categorical opinion that the only way to really 
> keep applications “isolated” from each other (i.e. not bring 
> everything else down when they crashed) was to give each mission 
> critical application or service its own VM.
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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
**

v15 - Error : objectmethodeditor.automatic_font Cannot get extra property

[Chip Scheide via 4D_Tech]

the above error occurs during startup and when switching from table to 
table in 'user' environment.

any clues as to what this is?

Thanks
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
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
**