Re: V19 Issues

[Randy Kaempen via 4D_Tech]

I still monitor the emails as well.


Randy Kaempen
Intellex Corporation


> On Oct 9, 2023, at 3:20 PM, Keith Goebel via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I may not be of any use to anyone (long time retired), but I’m still here…
> Cheers. Keith   :-)
> 
> 
>> it seems very few developers are using this list.
>> only 2 or 3 users have posted in the last couple of years.
>> the majority of the community discussion has moved to the forums.
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: [OFF] Domain Purchase & Hosting...

[Randy Kaempen via 4D_Tech]

Rob,

> On Aug 15, 2022, at 6:25 PM, Robert ListMail via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Best place to buy new domains? Does it really matter?  I have a need to 
> snatch a few domains. Last one was bought via 1and1 (now IONOS). Where do you 
> shop?
> 
> Also, is there a certain hosting company that you use for web hosting. I have 
> some machines in data centers that use 4D directly but in this case the web 
> server will be separate.

I like hover.com .  No upselling, good prices, easy to use 
update interface.


Randy Kaempen
Intellex Corporation

**
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: Where is the trace/debug command?

[Randy Kaempen via 4D_Tech]

Keith,

> On Oct 6, 2021, at 3:03 PM, Keith Goebel via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Also, v17 had a severely bad habit of ignoring breakpoints after a short time 
> tracing code during development. I never did figure out what triggered it 
> (modifying code in a method currently being traced?).
> The only solution to get breakpoints working again was to restart 4D.


I have seen this a lot and it continues in v18.  Oddly, I never saw it in the 
v17 R releases.  I think it is a memory issue.  I find that the more forms and 
methods I have open, the sooner it happens.  As you said, the only solution is 
to restart 4D.

It was driving me nuts for a while, because I wouldn’t see a trace where it 
_had_ to happen.  I found that if I put in a TRACE command, that still showed 
up.  It was just the bullets that failed.  That’s how I can tell it’s happening.


Randy Kaempen
Intellex Corporation
**
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: Import from an Excell files

[Randy Kaempen via 4D_Tech]

Fernandino,

> On Sep 26, 2021, at 4:36 PM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I know this, but i need to create an automated fuction into one 4D 
> application that import a .xls file without user action.

Then you need to get 4D View Pro.  It has features that let you access .xls 
files directly.


Randy Kaempen
Intellex Corporation

**
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: Duplicate Primary Key

[Randy Kaempen via 4D_Tech]

Paul,

> On Sep 1, 2021, at 6:32 PM, Paul Chernoff via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 4D 17.5
> 
> Somehow when I create a new record for a table it wants to assign an
> existing record’s primary key to a new record’s primary key field.
> 
> How do I get the database to know that this value is already in use for
> this unique field and to start incrementing primary key values starting at
> a higher value?

This code will fix the key for any integer or longint key.  Just pass a pointer 
to the key field.

  // FixAutoincrement  1/28/21
  //
C_POINTER($1)  // 1/28/16
C_LONGINT($MaxValue)  // 1/29/16
  //
$FieldPtr:=$1  // 1/28/16
$TablePtr:=Table(Table($FieldPtr))  // 1/9/21
  //
GET FIELD PROPERTIES($FieldPtr;$FieldType)  // 10/19/18
  //
If (($FieldType=8) | ($FieldType=9))  // Integer or Longint  10/19/18
  //
$OldMaxValue:=Get database parameter($TablePtr->;Table sequence number) 
 // 1/4/21
  //
$TablePtr:=Table(Table($FieldPtr))  // 1/28/16
  //
ALL RECORDS($TablePtr->)  // 4/19/16
ORDER BY($TablePtr->;$FieldPtr->;<)  // Get highest value  4/19/16
  //
$MaxValue:=$FieldPtr->  // 4/19/16
  //
If ($MaxValue>$OldMaxValue)  // 1/22/21
SET DATABASE PARAMETER($TablePtr->;Table sequence 
number;$MaxValue)  // 12/19/16
End if   // 1/4/21
  //
End if   // Integer or Longint?  10/19/18


Randy Kaempen
Intellex Corporation

**
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: [EXTERNAL] Run v15.4 in demo mode

[Randy Kaempen via 4D_Tech]

Bradley,

> On Aug 25, 2021, at 3:56 PM, Perkins, Bradley D  wrote:
> 
> I do have an both compiled and uncompiled structures. If I could find a v16 
> installer will that run on Catalina? Also do you know if there is still an 
> ftp site that has older version downloads that isn't restricted to Partners?

You’ll still need a license number in order to open it.

The only other alternative would be if you created a compiled merged version of 
the database on v16.  You could bring that to the client and open the database. 
 As long as you don’t need the user mode, you’d be fine.


Randy Kaempen
Intellex Corporation

**
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: Run v15.4 in demo mode

[Randy Kaempen via 4D_Tech]

Brad,

> On Aug 25, 2021, at 3:44 PM, Perkins, Bradley D via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I've had a request to retrieve some data from a v15.4 database that was last 
> used in early 2019. The customer still has the server with DB installed and a 
> compatible client machine, but the machines are in storage and off-network. 
> Given the current situation getting them online and remotely accessible isn't 
> possible. I am working remotely. I have a copy of the DB on an older Macbook 
> Pro, but it had been upgraded to Catalina and 15.4 will no longer open. I get 
> a '4D.app' needs to be updated dialog when attempting to launch. I expect 
> that is likely due to drop of 32-bit support in Catalina. My installed 
> licenses on the MPB were also those granted annually through the partner 
> program and have expired.
> 
> If I could copy the 4D.app and the structure and data files back to an 
> earlier MacOS Yosemite machine will I be able to temporarily run 4D v15.4 in 
> demo mode, or will 4D immediately request activation? I need less than 15 
> minutes to retrieve the requested data.
> 
> Beyond that I may need to travel to their site and hook the client and server 
> together with a crossover cable or maybe run a client from the server if one 
> is installed. Their institutional IT policies would not allow them to place 
> the machines on the network now (running very outdated OS versions, plus 
> these were in a DMZ that they no longer have access to). I'd prefer to try 
> off-site.
> 
> My last 4D experience was with v15 and I understand that things have changed 
> a lot. Could newer versions open the v15.4 DB in demo mode with minimal 
> effort?

Is the database compiled?  If not, a newer version will open it and convert it. 
 There are commands which are obsolete in the later versions, but you should 
still be able to work.  Picture fields will be an issue unless they are 
converted before going to 64 bit versions of 4D.

If the database is compiled, later versions will not be able to open it.


Randy Kaempen
Intellex Corporation

**
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: New Forum

[Randy Kaempen via 4D_Tech]

Walt,

> On Jun 4, 2021, at 1:54 PM, Walt Nelson  wrote:
> 
> I have signed up for the new forum to receive individual emails for all new 
> posts in the various areas I am interested in (mostly all the English ones).
> 
> I then have an Apple Mail Rule to move them into various folders.
> 
> Works just like this old list for me. No real difference.
> 
> I do like the ability in the new forum to post formatted code and 
> screenshots. So much better to get the point across that pure text like this 
> forum.
> 
> P.S. I don’t access the forum in a browser at all (after the one time setup). 
> Everything is handled in Apple Mail.

Nice compromise.  I may try that.


Randy Kaempen
Intellex Corporation

**
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: Base64 Image

[Randy Kaempen via 4D_Tech]

I agree guys.  I don’t think the new forum is a useful.

I’m still here.   :-)


Randy Kaempen
Intellex Corporation

**
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: 4D Chart replacement

[Randy Kaempen via 4D_Tech]

Jörg,

> On May 26, 2021, at 6:13 AM, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Are there any suggestions for a replacement for 4D Chart?

Personally, I wrote my own graphing procedure, based on SVG and what 4D returns 
for graphing.


Randy Kaempen
Intellex Corporation

**
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: 4D is acting strange?

[Randy Kaempen via 4D_Tech]

Dave,

> On Mar 29, 2021, at 3:13 PM, Dave Slayton via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> MacOS 10.13.6
> 4D 18.3 build 18.258288
> The next 4D build requires that I upgrade my OS.
> I've repaired the data file as well as the structure file..twice
> I replaced the date file with a backup
> restarted the mac
> I can't figure out why this doesn't work
> anyone have any ideas? 
> 
> read write([EXTRA 3]
> QUERY([EXTRA 3];[EXTRA 3]Li_1=250)
> If (Records in selection([EXTRA 3])>0)` 4D found 1 record
> [EXTRA 3]t_6:="Paid"  ` text field
> SAVE RECORD([EXTRA 3]
> UNLOAD RECORD([EXTRA 3])` after unload, 4D still shows one record loaded in 
> [EXTRA 3]
> `however the field values are cleared
> FLUSH CACHE` grasping at straws? 
> QUERY([EXTRA 3];[EXTRA 3]t_6="Paid")` NO records found
> End if 

Is there any chance that another process has locked the record?  You would get 
those results if the [extra 3] record was locked.  You might try testing for a 
locked record before assigning the ‘Paid’ value.


Randy Kaempen
Intellex Corporation

**
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: Copy and Paste

[Randy Kaempen via 4D_Tech]

I actually like this list better.  I like seeing the emails come in with the 
questions and I don’t have to work through a list of subjects on the forum.


Randy Kaempen
Intellex Corporation

**
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: [4D v18.3; Mac {10.13.6} + {10.15.7}] LEP-voodoo

[Randy Kaempen via 4D_Tech]

Peter,

> On Mar 4, 2021, at 10:03 AM, Peter Bozek via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> On Thu, Mar 4, 2021 at 1:59 PM Jörg Knebel via 4D_Tech
> <4d_tech@lists.4d.com> wrote:
>> 
>> $FoDoPath:=Get 4D folder(Current resources folder)
>> $FoDoPath:=Convert path system to POSIX($FoDoPath)
>> 
>> $cmd:=$FoDoPath+"./imagesnap -w 2.0 "
> 
> Jörg,
> 
> what seems suspicious to me is the "./" in above.
> 
> "./" is used as a "current folder" path, so IMHO it should not be used
> when you construct a full path. You should execute
> "/DATA/4Dƒ/TTTCorev18/TTTCorev18.4dbase/Resources/imagesnap -w 2.0"
> 
> BTW, you should enclose path in parenthesis, in case your path contains 
> spaces.
> 
> Second thing, what I found sometimes useful, especially when I need
> several command to execute, is write commands in separate .sh file and
> then execute the commands with LEP command "sh pathToFle.sh”.

I agree.  LEP operates in its own environment.  Every command gets a fresh 
environment.  You can’t count on changes made by previous commands or a 
reference like ‘./‘.  When I need to run multiple commands, I create a batch 
file and then execute that.


Randy Kaempen
Intellex Corporation

**
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: POSITION COMMAND

[Randy Kaempen via 4D_Tech]

Ferdinando,

> On Feb 20, 2021, at 11:18 AM, STARDATA via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I need to use this command:
> 
> $P:=Position(Char(92);$vStringa)
> 
> but in some cases, in some pc with windows in Spanish for example, he seems
> not to work.
> 
> $P:=Position(Char(92);$vStringa;*) <<<--- Use the * can be a solution?

Yes.  If you use the ‘*’ parameter, it will do the comparison by character 
codes.


Randy Kaempen
Intellex Corporation

**
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: Foundation Upgrade Question

[Randy Kaempen via 4D_Tech]

Ken,

> On Feb 2, 2021, at 4:43 PM, Ken Geiger Gmail via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> The foundation for 4D v16 and above is v5.7. This version eliminates the 
> PICTS. 

Keep in mind that if your database contains PICTs on forms, you need to fix 
that by the 32 bit v16 before going to 64 bit v16 or any later versions.

JPR has a tool and instructions for how to convert the PICTs and I have used it 
numerous times.  It’s much faster than trying to do it by hand.


Randy Kaempen
Intellex Corporation

**
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: Foundation Upgrade Question

[Randy Kaempen via 4D_Tech]

Ken,

> On Feb 2, 2021, at 12:13 PM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am not at all familiar with Foundation.
> 
> I inherited a customer that has a 4D database that is currently compiled with 
> 4D v15.1.  That database uses the Foundation_560.4dbase component.
> 
> I'd like to upgrade the customer to v17.3HF2 (and eventually to v18).
> 
> I'd like to know if the component that is currently being used (mentioned 
> above) will work with 4D v17.3HF2 (and v18.x)?

I have worked with Foundation for decades and it is the basis of most of my 
databases.  Personally, I liked the older version better than what they’re 
doing now, but that’s just me.

It’s supported at their website: https://foundationshell.com 


If you have any specific questions, feel free to post them.


Randy Kaempen
Intellex Corporation

**
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: Lost autocomplete for constants

[Randy Kaempen via 4D_Tech]

Bob,

Which document do you need?  I have most of them.


Randy Kaempen
Intellex Corporation


> On Jan 19, 2021, at 9:59 PM, Bob Finnerty via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Thanks - are the v13 docs still available? The 4D site only does back to v14
> 
> On Mon, Jan 18, 2021 at 2:10 PM Keisuke Miyako via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> the spec was originally published in the appendix of v13 upgrade reference.
>> 
>> but it might be easier to work off an example.
>> 
>> https://github.com/miyako/4d-plugin-mdi/blob/master/MDI/constants.xlf
>> 
>> I use UUIDs to avoid conflicts with constants from different plugins,
>> components, etc.
>> 
>> as you can see, groups and constants are not defined in an XML hierarchy.
>> they are linked by d4:groupName.
>> 
>> 2021/01/19 4:33、Bob Finnerty via 4D_Tech <4d_tech@lists.4d.com> 4d_tech@lists.4d.com>>のメール:
>> And BTW, anyone point me to the xlf definition for a constants file (or
>> have a blank)?
>> **
>> 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 Finnerty
> *Exodus Software*
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



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

Re: PING of life...

[Randy Kaempen via 4D_Tech]

> On Jan 15, 2021, at 9:54 AM, Neil Dennis via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I set my settings yesterday day to mute non-English… it made me smile today 
> when I opened up my email and could read every message :)

How?  I have checked my email settings and I can’t find anything about a 
language.


Randy Kaempen
Intellex Corporation

**
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: PING of life...

[Randy Kaempen via 4D_Tech]

Chuck,

> On Jan 15, 2021, at 10:53 AM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> OK I think we should start by going all the way back. I can be reached at 
> ,7 my old compuserv account. Boy wish I remembered it for real, 
> or perhaps when list was run outside of 4D by Karen (sorry don’t remember her 
> last name)

That’s hilarious.  I still have my 71270,1020 burned into my brain.  I want 
those bits back.


Randy
**
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: PING of life...

[Randy Kaempen via 4D_Tech]

Neil,

> On Jan 14, 2021, at 9:36 AM, Neil Dennis via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> One think I do like about this group vs the other group is that, with very 
> few exceptions, I can read all of the messages because I can understand the 
> language.
> 
> I only speak two languages, English and Gilbertese… there are no Gilbertese 
> messages. So I spend time on at the other place (not a lot but minutes) every 
> day looking at message to see if I’m interested, the first think I do is try 
> to read them, if they are in English I’m OK, if not it is wasted time.
> 
> I wish there was a filter so that I could only see messages in English.

Agreed.  That’s the main thing that puts me off.  I just want to see English 
messages and not all the other clutter.


Randy Kaempen
Intellex Corporation

**
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: PING of life...

[Randy Kaempen via 4D_Tech]

I’m on the list as well.


Randy Kaempen
Intellex Corporation


> On Jan 13, 2021, at 6:32 AM, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> G’day,
> 
> Are here still enough dinosaur/old timers present to have some decent 
> discussions without that white noise and smart-arse newbies in the forum?
> 
> I’m following the lead of my neighbour David Adams and don’t participate in 
> the forum any more.
> 
> Question is, are there other oldies willing to participate WITHOUT feeding 
> anything into the forum(s) following the slogan “What happen in/on iNUG stays 
> in/on iNUG”?
> 
> 
> Cheers
> Jörg
> 
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: "Optimal" 4D Server hardware

[Randy Kaempen via 4D_Tech]

John,

> On Sep 11, 2020, at 5:27 PM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 
>> On Sep 11, 2020, at 3:38 PM, Randy Kaempen via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> I have a client with about a dozen users and a 230GB data file.  They 
>> upgraded their server and we got a top of the line Mac Mini.  Since we 
>> expect to use it for a number of years, we got the best processor and maxed 
>> out the memory.  You can never have too much memory.  We also got the SSD 
>> drive so there won’t be any issues with drives crashing.  
> 
> I think SSDs are way more reliable, but I have never heard they are so 
> reliable that a second disk is no longer necessary. Any serious database 
> application needs to keep the database on a different disk from the backup 
> and journal files. I have a similar Mac Mini setup but added the fastest 
> external thunderbolt disk I could find for the journal file and backup files.

Agreed.  For the record, the client that uses the external SSD has their 
backups and journals on the SSD on the Mac itself, so they _are_ on separate 
drives.  We also have an offsite backup to Backblaze.  I also have a client who 
has their Time Machine backup on a Drobo, which gives double backup.


Randy Kaempen
Intellex Corporation

**
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: "Optimal" 4D Server hardware

[Randy Kaempen via 4D_Tech]

David,

I have a client with about a dozen users and a 230GB data file.  They upgraded 
their server and we got a top of the line Mac Mini.  Since we expect to use it 
for a number of years, we got the best processor and maxed out the memory.  You 
can never have too much memory.  We also got the SSD drive so there won’t be 
any issues with drives crashing.  

I also have clients who use an external SSD drive for their structure and data 
file.  The thought there is that if there is a problem with the computer, you 
just replace it with another one and you could get going again without losing 
or having to move your data.

Keep in mind that a new computer will come with the latest Mac OS.  You need to 
be running a version of 4D that works with that OS.   Sometimes, it’s better to 
buy a new computer with the previous OS before the new one is released (like 
now before Big Sur comes out).


Randy Kaempen
Intellex Corporation

> On Sep 11, 2020, at 3:08 PM, David Loeppky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I'm ready to upgrade our 4D server machine and would welcome any insights
> and recommendations.
> 
> Some details:
> - 40 Users (Mac and Windows)
> - 4GB data file
> - 120 tables
> - The current server is a 2011 Mac Mini with 8GB and raid 4XSSD HD
> 
> Questions about the new server:
> - Windows or Mac?
> - Recommended features.
> 
> Many thanks for the input.
> 
> -- 
> 
> Regards,
> 
> David Loeppky
> 
> Co-Owner
> 
> T: 360.380.1908 x111
> 
> M: 360.319.9141
> 
> F: 360.384.3673
> 
> *dav...@chuckanutbay.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
**

Re: automatically printing any "individual" pdf documents from 4D

[Randy Kaempen via 4D_Tech]

Ernie,

> On Sep 9, 2020, at 10:39 PM, ernest hilgers via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I am looking for a way to give ONE print command and it needs to print via 
> the pdf printer option on W10 or Mac 10.14 / 10.15,  n  SEPARATE pdf 
> documents (and put then in a desinated folder), each document is destined to 
> be send to an individual reciepients at a differrent time during a process.  
> The name of the document must ALSO contain the name of the recipient. 
> 
> Printing 1 pdf document consisting of e.g. 5 pages is NOT what is meant.  
> 
> Can 4D v13.6 / v15.6 do that natively or does this require a plugin 
> (addition). 
> 
> Interested in any suggestions. 

I don’t know any way to do that with one command.

You can use SET PRINT OPTION with option 9 to set the printing to PDF and 
specify the file name to print to.  
You can use SET PRINT OPTION with option 12 to set the report name.  

You should be able to control what report you print to that document, either by 
selecting the appropriate records before a PRINT SELECTION or by controlling 
what you print with PRINT FORM.

That seems to give you the options you would need to make separate PDFs for 
individuals in separate folders.


Randy Kaempen
Intellex Corporation
**
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: Straw Poll - Does Get 4D file(Last backup file) fail for anyone?

[Randy Kaempen via 4D_Tech]

Dave,

Just as a sanity check, is the value of $1 in the On Backup Shutdown method 
zero?  That is the indication of a successful backup.  If, for some reason, 4D 
didn’t consider the backup successful, that could account for an incorrect file 
name.


Randy Kaempen
Intellex Corporation

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

[Randy Kaempen via 4D_Tech]

Keisuke,

> On Aug 17, 2020, at 3:06 PM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Did you code sign and notarise your application?
> 
> These are mandatory steps to distribute an app over the internet.

What if you just want to use it on your own computer.  I have several 
standalone applications I have created with 4D and I just use them on my own 
local machine.  Should I have to sign and notarize those?


Randy Kaempen
Intellex Corporation

**
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: Auto numbering method acting weirdly. Help needed

[Randy Kaempen via 4D_Tech]

Stephanie,

> On Jul 22, 2020, at 3:28 PM, Stephane Potvin via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I have a database for organizing my printed music collection.
> 
> I use a folder numbering system to do so, using this format: Letter-number
> i.e. A-25, A-26, B-17, B-18, etc.
> 
> I have one field for the letter and one field for the number.
> 
> To make it easy, I use the method below to automatically fill the number when 
> I enter a letter.
> If I enter the letter A, the number will automatically fill the number with 
> 27 if the last one in existence was 26 for the letter A.
> It behaves fine for single letters and combinations: AB, ED, etc.
> 
> Everything works perfectly well except when I enter the letters CH.
> When I do the number field gets the value 207119, and up, whereas it should 
> currently be CH-271
> 
> I need your help figuring our why it behaves this way only for those letters.

Just for sanity’s sake, did you check if you have a record with a 
[Repertoire]Folder number of 207118?


Randy Kaempen
Intellex Corporation


**
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: Capturing Full Path Names with Picture Imports

[Randy Kaempen via 4D_Tech]

Steven,

> On May 26, 2020, at 1:58 PM, Steven via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> I hope everyone in the community is holding up under the challenges of the 
> pandemic.  My best wishes go out to everyone.
> 
> I am trying to develop a small module to allow users to import images from 
> anywhere on the host computer, for now.  Using "READ PICTURE FILE","CREATE 
> THUMBNAIL” and "Get picture file name” I can accomplish most of what I want 
> to do.  But I am stuck on how to capture the long path to the picture 
> selected by the user in the selection dialog presented by "READ PICTURE 
> FILE”.  
> 
> I assume there must be a simple way to do this that I am overlooking.  Rather 
> than continuing to beat my head against the wall, I am hoping that someone 
> here might please point me in the right direction.  

The documentation says:
If the command is executed successfully, the system variable Document contains 
the full pathname to the open file and the system variable OK is set to 1. 
Otherwise, OK is set to 0.

I would look at the Document variable.



Randy Kaempen
Intellex Corporation

**
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: Printing a form (data from Form object)

[Randy Kaempen via 4D_Tech]

Chris,

Joy can just do PRINT FORM, Followed by PAGE BREAK.  Instead of PRINT 
FORM([Table];”Form”), you would just do PRINT FORM(“Form”) and it will use a 
project form.


Randy Kaempen
Intellex Corporation

> On May 3, 2020, at 5:44 PM, Chris Belanger via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> So I make a project form in 4D’s form editor. I place all the elements on 
> the screen, and give them data sources based on Form.
> I can open the form to view, looks great:
> Open form window (“Order”)
> DIALOG (“Order”;$obj_Data;*)
> 
> How do I now get this form to print?
> All the print commands seem to be tied to a table form (PRINT RECORD, etc) 
> but this form is not a table form.
> 
> Doesn’t seem it should be rocket science, but I can’t figure out how to get 
> this to print.
> 
> 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
> **
**
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: 64-Bit Quick Report related fields

[Randy Kaempen via 4D_Tech]

Guys,

> On Mar 6, 2020, at 9:47 AM, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Doug & Tim:
> 
> I thought it was only me not understanding things again.
> 
> What I ended up doing was building my own ‘Report Editor’, where I presented 
> the tables and field for the users.
> 
> Jody Bevan

Did any of you ever find where 4D posted the source for the 64 bit Quick Report 
editor?  I want to fix the interface on it.

Thanks.


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

Re: Object notation replacement for use of Self in a script — v18

[Randy Kaempen via 4D_Tech]

> On Apr 30, 2020, at 4:43 PM, lists via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> OK, based on this design, we are back to using variables (or dynamic 
> variables) for data entry of anything that needs any kind of processing done 
> to it after an entry, having to load the values to these data entry objects 
> when loading the form, and copying the values back when we want to save any 
> user changes.
> 
> OR
> 
> We can use the Form.XXX notation to gain the advantage of that new nifty 
> option, but lose the generic coding ability.
> 
> I'd say it's a choice, but the lack of the ability to address an object from 
> within generically definitely seems to be a glaring omission...

If there is such an issue trying to get object values to work right, what’s the 
reason to use them at all?

I know everyone is all excited about object notation, but it’s not mandatory.  
Why should we even consider using it if doesn’t do what we need?  I’m sure 
there are some areas where it’s useful, but it sounds like there’s a lot where 
it isn’t.  Am I missing something?


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

Re: Opinion

[Randy Kaempen via 4D_Tech]

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

Re: 28 character file name limit for binhex encode SMTP_attachments?

[Randy Kaempen via 4D_Tech]

Joe,

> On Apr 23, 2020, at 1:41 PM, Joe Dombroski via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I have been having occasional -43 protocol not supported errors when I
> attach files to an email. I finally dug in and found that I must keep the
> file name under 29 characters.  Anyone else notice this? I am on 16.4r4.


That has been around a while.  You also have to worry about the ‘.b64’ added at 
the end.  Here’s how I handle it.

$err:=IT_Encode 
($AttachmentArrayPtr->{$x};vEncodedAttachment;$EncodingNumber)  //<<  Encode 
the file here  3/6/07
  //
If (($Err=-37) | ($Err=-1411) | ($Err=10083))  
// File name too long  9/30/11
  //
$Path:=""  // 5/17/10
$FileName:=$AttachmentArrayPtr->{$x}  
// 5/17/10
$Extension:=""  // 5/17/10
  //
Repeat   // 5/17/10
$y:=Position(Folder 
separator;$FileName)  // 2/22/19
If ($y#0)  // 5/17/10

$Path:=$Path+Substring($FileName;1;$y)  // 5/17/10

$FileName:=Substring($FileName;$y+1)  // 5/17/10
End if   // 5/17/10
Until ($y=0)  // 5/17/10
  //
$y:=Length($FileName)  // 5/17/10
While ($y>=2)  // 5/17/10
If 
(Substring($FileName;$y;1)=".")  // Found dot  5/17/10

$Extension:=Substring($FileName;$y)  // 5/17/10

$FileName:=Substring($FileName;1;$y-1)  // 5/17/10
$y:=0  // 5/17/10
Else   // 5/17/10
$y:=$y-1  // 5/17/10
End if   // 5/17/10
End while   // 5/17/10
  //
$FileName:=Substring($FileName;1;22)  
// Can olnly have 22 characters in file name to leave room for encoded file 
extension  5/17/10
$ShortName:=$Path+$FileName+$Extension  
// 5/17/10
  //
If (Test path name($ShortName)=1)  // 
Document already exists  5/13/09
DELETE DOCUMENT($ShortName)  // 
Delete document  5/13/09
End if   // 5/13/09
  //
MOVE 
DOCUMENT($AttachmentArrayPtr->{$x};$ShortName)  // Make name smaller  10/2/08
$AttachmentArrayPtr->{$x}:=$ShortName  
// 10/2/08
  //
$err:=IT_Encode 
($AttachmentArrayPtr->{$x};vEncodedAttachment;$EncodingNumber)  // Re-encode 
the file  10/2/08
  //
DELETE DOCUMENT($ShortName)  // Delete 
document  6/20/11
  //
End if   // 10/2/08
 

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

Re: Long running reports to disk intermittently disrupted and fail

[Randy Kaempen via 4D_Tech]

John,

> On Apr 16, 2020, at 3:47 PM, John J Foster via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Agreed!
> 
> I will try and change them if I can figure how to test the Server to see if 
> it can see the network drive.
> 
> I would imagine that it can but never assume…

You should be able to, but the path may surprise you.

I have a client who has a networked Drobo and it has volumes called FTP and 
Backup.  However, to access the drive, we have to use:

/Volumes/Drobo5N/drb153401a00827/1/FTP/

Go figure.  If you drag the volume into a terminal window, you’ll get the path 
you have to use.


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

Re: Long running reports to disk intermittently disrupted and fail

[Randy Kaempen via 4D_Tech]

> On Apr 16, 2020, at 8:41 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> John,
> 
> Better yet - re-write the file generation to run on the server. In my
> experience when a report like that takes so long to run it's due to moving
> lots of data back and forth. Move the code that actually creates the file
> to a method that can execute on the server.


I agree.  Definitely run the process on the server.  Big amounts of data 
process _much_ faster there.  Make the one file from the server and then move 
it where you need it.


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

Re: Word count in 4D write pro

[Randy Kaempen via 4D_Tech]

Eric,

> On Apr 15, 2020, at 5:00 PM, Eric Naujock  wrote:
> 
> When I do an export of the 4D Write Pro document into. Text object it always 
> exports as a mime type or an HTML with nonbreaking spaces document with other 
> elements. I can take a 5 page 4D Write Pro document Export it a plain text 
> and using the STR_Count_Words function and it will give me a count of 19 
> words. Where when it was in 4D Write it would return 19,365 words. There 
> seems to be a slight error in something. Both of the below will fail if the 
> to get e a usable word count.
> 
> 
> 
> WP EXPORT VARIABLE(WrProObject;$exportText;wk web page html 4D;wk normal) 
> ProtocolWC:=STR_Count_Words ($exportText)
> 
> WP EXPORT VARIABLE(WrProObject;$exportText;wk mime html;wk normal)
> 
> ProtocolWC:=STR_Count_Words ($exportText)
> 
> If there is a way to extract a raw plain text version of the text from the 4D 
> Write pro object I would love to find out how.

A lot of the former 4D Write commands are now the styled text commands.

$Text:=ST Get plain text($FieldPtr->)


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

Re: Word count in 4D write pro

[Randy Kaempen via 4D_Tech]

Eric,

> On Apr 15, 2020, at 4:48 PM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Is there a simple way to get a accurate word count for a 4d Write pro object? 
>  I am trying to be Abe to check if a document is long enough to be plausibly 
> done. In the past with 4D write I could convert the document to raw text and 
> use STR_Count_Words to be able to get a word count. But with the new way 4D 
> Write Pro extracts text out of the Write pro object I am finding that I do 
> not get a real word count. Has anybody else had something that can generate 
> an accurate word count for a given 4D Write Pro Object

What is wrong with the plain text you get out of 4D Write that gives a wrong 
word count?


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

Re: Drop User NOT working (after client disconnected using Force Quit)

[Randy Kaempen via 4D_Tech]

John,

> On Apr 15, 2020, at 10:28 AM, John J Foster via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 4D v17.2 64bit Windows
> Windows 10 Pro
> 
> Another issue (last month actually) that I’m not sure if there is a fix. 
> Although client believes there is one! Here’s what happened:
> 
> A User (client) froze up in the application and so they excited improperly by 
> quitting the 4D through the Task Manager. However they still show as being 
> logged in on the server. So on 4D Server -> Users tab they highlight the User 
> they want to Disconnect and hit Drop User…..it doesn’t work.
> 
> And since 4D “thinks” they were still logged in then they couldn’t reconnect 
> as that user.
> 
> Tried many times and the only fix was to restart the server.
> 
> Is there something that can be done besides reminding them to not “Force 
> Quit”, bringing the 4D Server down and restarting?
> 
> Anyone else experience this issues?

We have seen this numerous times on a client running a Mac server with people 
logging in from a Windows terminal server.

My understanding was that clients would automatically drop off after a certain 
period when the server could not contact them.  This does not seem to be 
working.  We also tried the drop user option and it didn’t work.  It seems to 
be a 4D problem.  If you say drop user, it needs to drop the user.

This can be a big issue when the client has a limited number of licenses and 
the users that won’t drop are preventing real users from logging back in.


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

Re: Longitude Index: B-Tree or Cluster

[Randy Kaempen via 4D_Tech]

John,

> On Apr 12, 2020, at 10:33 AM, John J Foster via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> If you happen to find any 4D bearing/distance code (anything related to 
> searching using longitude/latitude or both) I would enjoy looking at it.

I had worked out these calculations with a mathematician called C. E. Tiedemann 
many years ago.  Here is an except from our emails, entitled 'Ellipsoid Radius 
Calculation’.


Now I see what's going on.  The figures in the table are merdianally
oriented radii of hypothetical spheres for which the surface curvature
matches the (a, b, e) ellipsoid at the specified latitude.  Knowing these
allows use of fairly simple spherical formulae for computing distances
between points not too far apart on surfaces of ellipsoids.

- - - -

OK, I took a look at the URL and found my comment just below the material
we're looking at.  In fact I remember having made those observations, but
it was a LONG time ago and at the momen I've no recollection of the context
in which they were made.

But, all may not be lost:  bouncing up a way in the text I found the following:

R' = a * (1 - e^2) / (1 - e^2 * (sin(lat))^2)^(3/2)

The additional "^(3/2) will have the effect of increasing the denominator
and maybe bring things into agreement with your/our expectations.


This is the routine we came up with, which seems to work well.


  // CalcDistance  11/24/02
  //
C_REAL($0;$1;$2;$3;$4;$Lat1;$Long1;$Lat2;$Long2;$DegToRad;$Work;$Distance)  // 
11/24/02
  //
$Lat1:=$1  // 11/23/02
$Long1:=$2  // 11/23/02
$Lat2:=$3  // 11/23/02
$Long2:=$4  // 11/23/02
  //
$DegToRad:=57.29577951308  // 11/23/02
  //
$Work:=(Sin($Lat1/$DegToRad)*Sin($Lat2/$DegToRad))+(Cos($Lat1/$DegToRad)*Cos($Lat2/$DegToRad))*Cos(($Long2/$DegToRad)-($Long1/$DegToRad))
  // 11/23/02
$Distance:=3958.75*Arctan(Square root(1-($Work^2))/$Work)  // 11/23/02
  //
$0:=$Distance  // 11/23/02


Feel free to use this if it’s of help to you.


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

Re: How to Verify Page Setup for a Form?

[Randy Kaempen via 4D_Tech]

> On Apr 9, 2020, at 11:43 AM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> when you upgrade to v18, the property will be available in JSON forms (export 
> structure, form convert to json) too.

Yes, but why was the PAGE SETUP command taken away?  Currently, the page size 
and orientation are stored in the form.  When you call PAGE SETUP, those values 
are restored.  Now we’re supposed to use SET PRINT OPTION to set each value 
individually?  Where will we get those from?  Now, when a form is changed, we 
have to adjust it on the form, then determine the new page size and 
orientation, and then hard code them in SET PRINT OPTION commands?  Sounds like 
a huge step backwards and a lot more work for us.:-(


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

Re: Can't Access Design Mode in 6.0.6

[Randy Kaempen via 4D_Tech]

Steve,

> On Apr 7, 2020, at 2:25 PM, UKVetDerm via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Datacheck - that takes me back. Do we have a much better 4D now I wonder?

We do.  There was a time when it seemed that people like Paul Carnine knew a 
lot more about the details of the data file and structure than 4D did.  
DataCheck was definitely superior to the 4D Tools of the time.  Remember also 
that back then, if you had to run Recover by Tags, you knew you were going to 
lose a significant portion of your data.  The tags just weren’t reliable.  Now, 
touching the same piece of wood, the MSC is very good at diagnosing and fixing 
problems.

> I have not (touching a very big piece of wood) had a Datacheck moment for a 
> long time, although cheap storage makes very regular backups much easier.

Agreed.  Also, having the journals makes recovering from data problems much 
easier.

> Sorry to hijack your post!

No problem.


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

Re: Can't Access Design Mode in 6.0.6

[Randy Kaempen via 4D_Tech]

Chuck,

> On Apr 7, 2020, at 11:42 AM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Can you upgrade to a newer version, Let’s say 11 and see what happens

I opened it with 6.7.4 and I was able to get in to the structure.  Weird.

I was able to see what the structure looks like and what I’ll have to watch for 
as I run it through the later versions.  I really only need to open it in 6.0.6 
to run Tools to make sure the data is in good shape.  I actually still have my 
licensed copy of DataCheck, so I’ve got a great tool for fixing and data 
problems.:-)

Thanks for the suggestion.


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

Re: Can't Access Design Mode in 6.0.6

[Randy Kaempen via 4D_Tech]

Chuck,

> On Apr 7, 2020, at 11:42 AM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Can you upgrade to a newer version, Let’s say 11 and see what happens

I can and will, but the prevailing logic for this kind of update was to move to 
new versions in small steps, not one big jump.  I did this before for a 
different client and I would run Tools on the structure and data at each 
version before going to the next one.  I don’t want to risk losing data.

The reason to access the structure is so that I can tell the client what kind 
of changes will be required as we move along.

However, it’s a good point.  I’ll see about jumping a few versions and see if I 
can get in, just to take a look.

Thanks.


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

Re: Can't Access Design Mode in 6.0.6

[Randy Kaempen via 4D_Tech]

Chuck,

> On Apr 7, 2020, at 11:40 AM, Charles Miller via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> compiled?

No, the client said this is the file _without_ the running man icon.:-)

Also, I ran a report and triggered the trace dialog.  Both Edit and Trace were 
enabled, which they wouldn’t be for a compiled database.


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

Can't Access Design Mode in 6.0.6

[Randy Kaempen via 4D_Tech]

This is for one you fellow old-time experts.

I have a new client, who is trying to convert from 6.0.6 to v17.  Yes, that's 
right, 6.0.6.  Believe it or not, I did one from this old a version a year ago.

I've got an old machine to run it on.  I have the database structure and the 
developer password.  However, I can't get into design mode.  I am logged in as 
Designer.  There is an option on their menu that says User Mode.  However, when 
I select it, the database quits.  If I do option-f, the database quits.  If I 
do option-F4, the database quits.  I have managed to run a procedure and 
interrupt it with option-click.  I get the dialog with Trace and Edit on it.  
The buttons are enabled.  However, when I click either one, the database quits.

I thought it might be an authorization issue.  I have license codes from back 
then, but I don’t see a place to enter them.  Also, I created a brand-new 
database and it let me access design mode and see the structure.

I can't figure out why it won't let me into design mode.  Any ideas?

Thanks.


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

Re: Image Export Issues

[Randy Kaempen via 4D_Tech]

Robert,

> On Mar 31, 2020, at 10:19 PM, Robert McKeever via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> The database is 4D v15.4, iMac 10.14.6, using a Pegasus 9Tb RAID (sweet 
> drive).
> 
> I have 151,814 images, in either JPEG or BMP format, and the format is known 
> for each image.
> 
> So, I cycle through the images and figure out what the export be, do a create 
> document for that name, close that file and then do Picture to Blob as 
> follows:
> 
> If (([ScannedDocuments]FileType="JPEG") | ([ScannedDocuments]FileType="JPG"))
> PICTURE TO BLOB([ScannedDocuments]FullImage;$MyBlob;".jpg")
> Else 
> PICTURE TO BLOB([ScannedDocuments]FullImage;$MyBlob;".bmp")
> End if 
> BLOB TO DOCUMENT(document;$MyBlob)
> 
> And I write the document name to a test file with some other info using 
> append document. 
> 
> Periodically, 4D just vanishes. In which case, the text file may or may not 
> contain the entry it died on. This generally happens when the BLOB TO 
> DOCUMENT results in the finder showing a file of zero bytes. In fact, I may 
> get several such files in a block before 4D disappears. No error messages, no 
> system “Hey, it crashed’ logs, just poof.

Have you run the MSC on the data, just to make sure there are no underlying 
data problems?

Have you tried putting in an ON ERR CALL command to see if you can trap an 
error before it causes a crash?

Could some of the images have gotten an incorrect file type, causing the wrong 
processing to be done on it?


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

Re: Receive packet stop character

[Randy Kaempen via 4D_Tech]

John,

This doesn’t answer your question, but there are other special cases as well.  
Even if you’re using a carriage return as the end-of-line, you could have it 
inside some of your data, if the text has quotes around it.  Many CSV files are 
like this.  In that case, you need to process character at a time to see if 
you’re inside of quotes or not.  If you are, then the carriage return is just 
more of the data for the field.  If you are not inside quotes, then it acts as 
the record delimiter.  That can cause lines to truncate early if you’re just 
doing:

RECEIVE PACKET($DocRef;$TextValue;Char(13))

Sorry to be a downer, but I’ve run into all sorts of exceptions doing imports.


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

Re: Gmail, LSA, and OAuth

[Randy Kaempen via 4D_Tech]

Alexander,

> On Mar 22, 2020, at 6:02 AM, Herr Alexander Heintz  
> wrote:
> 
> I just looked into accessing GMail through OAuth2.
> From the technical point it is not a problem, I can easily adapt the tools I 
> have for MS OAuth2 to work with Google.
> The process for app registration however is much more complicated than with 
> MS…
> You need to submit you application to Google for verification and depending 
> on the type of data you want to access with Google (that includes GMail) you 
> may be requested to do an external security audit for you App, costs anywhere 
> from 15 to 75 k.
> I will start that process for my App once I have the Connector going, and 
> will keep you posted on what to do.

Very cool.

> Most likely I will put it on my blog.

Where is that?

> If you want to start reading into the requirements, you might want to start 
> here:
> 
> https://support.google.com/cloud/answer/9110914 
> 
Thanks.


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

Re: HMAC SHA256 in native 4D code?

[Randy Kaempen via 4D_Tech]

Here is a method we use on Windows:

  // SHAHMACEncode_Server  3/21/18
  //
C_TEXT($1;$2;$3;<>SHAHMAC)  // 3/15/18
  //
$Value:=$1  // 3/15/18
$Key:=$2  // 3/15/18
$Client:=$3  // 3/15/18
  //
vCommand:="/bin/bash"  // 3/21/18
  //
vInput:="echo -n \""+$Value+"\" | openssl sha1 -hmac \""+$Key+"\""  // Do not 
base 64 encode  3/21/18
  //
vOutput:=""  // 3/15/18
vErrorText:=""  // 3/15/18
  //
LAUNCH EXTERNAL PROCESS(vCommand;vInput;vOutput;vErrorText)  // 3/15/18
  //
vOutput:=Replace string(vOutput;<>LF;"")  // 3/21/18


It obviously uses an outside command, but it doesn’t need a plugin.


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

Re: Remote working with 4D networks - what are people using ?

[Randy Kaempen via 4D_Tech]

Bernd,

> On Mar 19, 2020, at 7:21 AM, Bernd Fröhlich via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Alexander Heintz:
> 
>> Complete lack of a remote terminal solution for Macs is the primary reason 
>> why most businesses have switched to Windows in the last 8-10 years.
> 
> Sorry, but that´s just fake news.
> I can log in the severel dozen Macs from home just fine.
> Just switch on screen sharing and configure the router so that it connects to 
> different macs depending on the port you are specifying in the connection.

Exactly.  On one of my clients, I am set up so I can support all the users 
directly.  On the router, we have the port forwarding set up to go to different 
computers.

Port 5900 -> Server
Port 5901 -> User 1
Port 5902 -> User 2
etc.

It’s very easy then to connect to the different computers.  There is also a Mac 
menu bar app called ScreenSharingMenulet which gives you a menu of all the 
available screen sharing destinations and you can configure other remote 
entries.  Then, all your screen sharing is available in one place.


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

Re: Remote working with 4D networks - what are people using ?

[Randy Kaempen via 4D_Tech]

Peter,

> On Mar 19, 2020, at 7:05 AM, Peter Jakobsson via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 
> 
>> On 19 Mar 2020, at 12:39, Randy Kaempen via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> I have to disagree.  I use screen sharing to access remote Macs on many of 
>> my clients’ systems.  It is fast and easy to use.  I can do whatever I want 
>> on the remote machines.
> 
> What remote access tech do you use Randy ? Just the built in screen sharing 
> in macOS ? (Doe the client side work through a browser in that case ?).

Yes, just the Screen Sharing app.  I connect to a remote computer.  Usually, I 
am connecting to their server to put on updates or make changes.

> I have a client who has a huge Windows Server machine and they run all 
> instances of 4D client on it.  Everyone connects via RDP to those clients and 
> it’s fast.
> 
> 
> You mean server + multiple clients on the same machine ? How do screen 
> sharers connect to a particular instance of a 4D Client in that case if 
> they’re all on the same machine ?

Different people log in as different users.  They each have their own desktop 
and files.


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

Re: Remote working with 4D networks - what are people using ?

[Randy Kaempen via 4D_Tech]

> On Mar 19, 2020, at 6:34 AM, Herr Alexander Heintz via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Well, the problematic point here is „MACS“
> 
> Complete lack of a remote terminal solution for Macs is the primary reason 
> why most businesses have switched to Windows in the last 8-10 years.

I have to disagree.  I use screen sharing to access remote Macs on many of my 
clients’ systems.  It is fast and easy to use.  I can do whatever I want on the 
remote machines.

> I know it is not helping you to hear this…
> 
> Maybe you can set up a MS Terminal server (or much cheaper compatible tools, 
> like TSPlus, even works on Windows 10).
> Then have the Mac Users use MS RDP to access the Terminal Server und run the 
> 4D Client on Windows.
> May be unaccustomed to them and not always comfy, but works.
> 
> If a provider blocks RDP, then they are not suitable for business use and you 
> should switch to someone else, BT ?

I have a client who has a huge Windows Server machine and they run all 
instances of 4D client on it.  Everyone connects via RDP to those clients and 
it’s fast.


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

Re: Gmail, LSA, and OAuth

[Randy Kaempen via 4D_Tech]

> On Mar 18, 2020, at 4:52 PM, Herr Alexander Heintz via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Am 18.03.2020 um 22:43 schrieb David Rose via 4D_Tech <4d_tech@lists.4d.com>:
> 
>> How is this done in 4D in conjunction with the 4D SMTP commands?
> 
> NOT
> AT
> ALL
> 
> we apologize for the inconvenience…
> 
> but in all seriousness:
> 
> Everybody is currently switching to other system standards.
> Office 365 still supports imap/smtp with plain authentication, but that will 
> go away as well.
> We currently use office 365 vi Exchange Web Services, with MS OAuth2.
> It was a pain to implement…
> There is some good stuff from Keisuke concerning OAuth2, but a lot more needs 
> to be done in order to continue using IMAP.
> SMTP will live a little longer, IMAP will force you to switch from palin 
> authentication to bearer authentication where you send a token.
> It sadly requires interaction by the user from time to time, no idea if 
> Google has any system for Admin impersonation in place like MS Azure does.
> 
> I might release component in the near future that does MS OAuth against Azure.
> 
> As for Google and others, I will have to find the time to get into that.

Since the 4D Internet Commands are something that many companies use, it seems 
like it would be a good idea for us as a group to work on a way to move 
forward, either adding a framework which adds the OAuth around those commands 
or replacing them entirely.  An approach which handles to Google situation as 
well as other email systems would be useful to everyone going forward.


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

Re: 4D Summit Virtual?

[Randy Kaempen via 4D_Tech]

We’re fine here in Chicago.  I’m still going.


Randy Kaempen
Intellex Corporation

> On Mar 11, 2020, at 8:36 PM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Well, l'll gotta think the chances of 4D Summit happening in Chicago are 
> approaching nil now. Maybe there can be a virtual summit?
> 
> https://www.nytimes.com/2020/03/11/world/coronavirus-news.html
> 
> 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
> **
**
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: NEED HELP

[Randy Kaempen via 4D_Tech]

Tom,

> On Feb 23, 2020, at 5:33 PM, Tom Dillon via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am not sure if this is the right forum but I need help on a problem
> that's just cropped up.
> 
> I have been successfully  building stand alone apps using V13.3 for years
> now and suddenly each time I try to "Build the app" it starts coping over
> file but just before it finishes 4d crashes. I have tried everything to get
> it to work.
> 
> Anybody have any ideas as to what causing this?

To ask the obvious questions:

Did you run the MSC on the structure to make sure there’s no damage?

Did you try replacing the 4D Volume Desktop with a fresh copy?


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

Re: Best "back to school" pathway for upgraders

[Randy Kaempen via 4D_Tech]

Peter,

> On Feb 21, 2020, at 9:58 AM, Peter Jakobsson via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I’m collating resources for informing myself on new features and language for 
> moving from v15 to v18. Plan to do it in one leap over a year at least. I 
> don’t really see the point in hanging around in an intermediate version.

Do you have any images in the old PICT format?  I have done a lot of these 
updates and all my databases had objects on forms with PICT images.  I used 
JPR’s tool in the 32-bit version of v16 to upgrade them before moving to the 
64-bit version.  If you don’t stop there, you won’t have access to that tool.

I would recommend a stop at v16.


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

Re: Getting emails sent by 4D to show up in "Sent Items"?

[Randy Kaempen via 4D_Tech]

Brian,

> On Feb 7, 2020, at 2:39 PM, Brian Laurencelle via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I'm looking for a way to have emails sent by 4D using the SMTP Internet
> commands show up in the sender account's "Sent Items" mailbox. I know the
> next step involves using the IMAP internet commands but I am unsure exactly
> what I need to do.

Emails sent by the SMTP Internet commands are just the same as emails created 
by any other mail program.  They will show up in the Sent folder for the 
account that sent them.  I do this all the time for my clients and they know 
that the 4D emails will show up next to the emails they sent manually.

Are you sure the emails were actually sent?  Did you check the error code on 
the send command?


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