Re: Built app in v18 can't find data file

[Spencer Hinsdale via 4D_Tech]

oh maybe i didnt answer the question. if you want it to open your data file 
that you include with your app, you can do this with New Architecture set to 
Off and by using Build Keys to set the default data file. This does not allow 
you to distibute a new app and have it open an existing data file, which New 
Architecture does. However the build key does not work with new arcitectire. so 
actually to do what you want you would use new architecture and include 2 data 
files, one in, one out. then detect if the inside one was opened automatically 
and use Open Data File to switch to the outside one. no this is not april fools 
joke

Spencer
spen...@bigsoftware.com
877-970-0022

From: Stephane Potvin 
Sent: Tuesday, April 5, 2022 1:22:32 PM
To: Spencer Hinsdale ; 4D iNug Technical 
<4d_tech@lists.4d.com>
Subject: Re: Built app in v18 can't find data file

Thank you Spencer.

That worked.

Is there no way to have 4D behave as in the past? ie. have the database 
recognizes the data file in the same folder instead of inside the package?

Thanks.

Stephane

> On Apr 5, 2022, at 16:16, Spencer Hinsdale  wrote:
>
>
> You can put a Data File with the same name as the Structure into the Database 
> folder inside the .app package...
>
> Right-click or control-click on Recordings.app and choose Show Package 
> Contents
>
> Double-click Contents; double-click Database
>
> Paste a Data File and Rename it to Recordings.4DD
>
>
>
> On 4/5/22, 1:10 PM, "4D_Tech on behalf of Stephane Potvin via 4D_Tech" 
> <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:
>
>Having no luck with built apps in v19, I decided to resort to v18. V18 
> generates the apps no problem. However, every time I open said app it always 
> asks for the data file.
>The data file is in the same folder.
>I tried changing the folder to a .4dbase package to no avail.
>I even deleted the data file and created a new one but it still asks for a 
> data file.
>
>Any idea on how to solve this?
>
>Thank you.
>
>Stephane
>
>**
>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: Built app in v18 can't find data file

[Spencer Hinsdale via 4D_Tech]

yes, there are now two possibilities...

1) there is a new checkbox in Database Settings, Compatibility for New 
Architecture.  If this is ON the app saves the path to the data file in an 
appropriate location (~/library/application support/myapp/ so some such; if you 
need to know try Get 4D folder (read docs for parameter))

2) there is the old mechanism when the above option is Off, which writes the 
path to the data file into the structure.  This does not work if you are 
deploying read-only or there any permission issue with that practice (not sure 
if this disallowed depending on where/how the app is installed)


So to cover the bases, use New Architecture, so the app always opens the user's 
Data File

Put your own Data File into Database folder to open when the user has no file.

And, provide instructions or coding to create a new data file, if needed, that 
is _outside_ the app package.  If you start with Option and select New Data 
File, 4D will prompt you to save inside the app package.
 

On 4/5/22, 1:22 PM, "Stephane Potvin"  wrote:

Thank you Spencer.

That worked.

Is there no way to have 4D behave as in the past? ie. have the database 
recognizes the data file in the same folder instead of inside the package?

Thanks.

Stephane

> On Apr 5, 2022, at 16:16, Spencer Hinsdale  
wrote:
> 
> 
> You can put a Data File with the same name as the Structure into the 
Database folder inside the .app package...
> 
> Right-click or control-click on Recordings.app and choose Show Package 
Contents
> 
> Double-click Contents; double-click Database
> 
> Paste a Data File and Rename it to Recordings.4DD
> 
> 
> 
> On 4/5/22, 1:10 PM, "4D_Tech on behalf of Stephane Potvin via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:
> 
>Having no luck with built apps in v19, I decided to resort to v18. V18 
generates the apps no problem. However, every time I open said app it always 
asks for the data file.
>The data file is in the same folder.
>I tried changing the folder to a .4dbase package to no avail.
>I even deleted the data file and created a new one but it still asks 
for a data file.
> 
>Any idea on how to solve this?
> 
>Thank you.
> 
>Stephane
> 
>**
>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: Built app in v18 can't find data file

[Spencer Hinsdale via 4D_Tech]

You can put a Data File with the same name as the Structure into the Database 
folder inside the .app package...

Right-click or control-click on Recordings.app and choose Show Package Contents

Double-click Contents; double-click Database

Paste a Data File and Rename it to Recordings.4DD



On 4/5/22, 1:10 PM, "4D_Tech on behalf of Stephane Potvin via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Having no luck with built apps in v19, I decided to resort to v18. V18 
generates the apps no problem. However, every time I open said app it always 
asks for the data file.
The data file is in the same folder.
I tried changing the folder to a .4dbase package to no avail.
I even deleted the data file and created a new one but it still asks for a 
data file.

Any idea on how to solve this?

Thank you.

Stephane

**
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: SuperReport printer choice not respected by Windows 10

[Spencer Hinsdale via 4D_Tech]

This is done with SR SetPrinter

If you go to enode site, download, previous version you can find developer docs:
https://www.e-node.net/ftp/SuperReportPro/3.4.1_Previous_Version/SuperReportPro_Developer_Manual.pdf



On 6/9/21, 12:40 AM, "4D_Tech on behalf of Wayne Stewart via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Peter,

Why not specify the printer immediately before the print job?

https://doc.4d.com/4Dv18/4D/18.4/SET-CURRENT-PRINTER.301-5233936.en.html

I have no experience with SuperReports.

Wayne

On Wed, 9 Jun 2021 at 17:30, Peter Adam via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> I am finding that the choice of printer that I specify in my superReports
> is not being respected by Windows 10. Instead the “Default” printer is
> being used.
>
> I am looking for a way around this.
>
> I am using 4D v17R6 and SuperReports 4.2.1
>
>
>
>
> Cheers,
>
> Peter Adam
**
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: Password Management System for Web Access

[Spencer Hinsdale via 4D_Tech]

look to see if you accidentally have the database method that overrides this. 
you can tell by by clicking in exlorer whether it is nonexistant (good) or 
blank (problemaic). hope this makes sesnse

> On Jan 23, 2021, at 8:23 AM, Philippe Willems via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> However, when I try this with my existing database structure which has been
> in use for years and years, unable to get this feature to work.
**
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: Need Help! - Customer upgraded from Win 7 to Win 10 Pro. 4D v13.6 Built Server Won't Run

[Spencer Hinsdale via 4D_Tech]

Does this maybe mean the Structure is locked?  Restart the computer to release 
any hold Windows has on it.  Get Properties and change Permissions as needed.  
Set the preference inside 4D Server to Allow Read Only Structure...



On 1/19/21, 7:21 AM, "4D_Tech on behalf of Ken Eyring via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

 “Cannot open structure of database”


**
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: Trace Command in V18.3

[Spencer Hinsdale via 4D_Tech]

check your license



> On Oct 28, 2020, at 10:20 AM, Dave Slayton via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I just installed v18…the trace command doesn’t seem to be working….
> anyone else having this issue or know of a work around ? 
> TRACE
> C_longint ($dave) 
> $dave:=12
> alert("dave = "+string($dave))
> TRACE
> 
> **
> 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: Old 4D Transporter (ResTransporter) or Equivalent

[Spencer Hinsdale via 4D_Tech]

Maybe you can do this with 4D?  There is a asterisk param for blob to document, 
document to blob.  You just read in the res fork and write out as non-res file 
with .rsr I would think.

Also maybe a moot point.  17.4 which is current may be the last 32-bit able 
version.  It is 64-bit by default and does not support resources whatsoever in 
that mode.  The "modern macOS" is Catalina which is 64-bit only and therefore 
no resources.

So you need need to convert which you do by reading JPRs presentations and 
running his and Miyako's conversion Components that do stuff like put all 
String resources into an XLF file or help you replace PICT files.  You run in 
32-bit to make the resources accessible, then run in 64-bit to verify success.




On 7/4/20, 8:01 AM, "4D_Tech on behalf of Peter Jakobsson via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Hi

I was wondering if there’s a tool to split the 4D resource fork on a 4D 
2004 database so I can transport it from Mac to Windows. I haven’t done this 
for years and have lost access to my old “Snowleopard” machine that I used to 
use for this type of thing.

I need the “transporter” tool to run on a modern Mac OS.

Any tips ?

Regards

Peter

**
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: How to build a standalone app for Windows using Mac

[Spencer Hinsdale via 4D_Tech]

you need to run Windows. one way is to buy Parallels online and have it install 
Windows 10

> On Jun 28, 2020, at 3:57 PM, James Knight via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
**
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 Notarization Issues

[Spencer Hinsdale via 4D_Tech]

Release notes for v17.4 indicate you can substitute PHP and Internet Commands 
from v18, or remove entirely:
https://download.4d.com/Documents/Products_Documentation/LastVersions/Line_17/VIntl/PDF_Format/4D_v17_4_ReleaseNotes.pdf

On 4/28/20, 4:33 AM, "4D_Tech on behalf of Jeremy Roussak via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Randy, thanks for that pointer and Miyako, thanks very much indeed, as 
ever, for that marvellous application.

The huge slew of notarization errors has now been reduced to just one:

  "issues": [
{
  "severity": "error",
  "code": null,
  "path": "PI_Calculator.app-1.84.app.zip/PI 
calculator.app/Contents/Resources/php/Mac/php-fcgi-4d",
  "message": "The binary uses an SDK older than the 10.9 SDK.",
  "docUrl": null,
  "architecture": "x86_64"
}
  ]
It seems I need a new version of the PHP binary. I seem vaguely to remember 
that this was discussed before, but I can’t recall what the solution was. Is 
there one somewhere?

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

Re: Administration window on Server

[Spencer Hinsdale via 4D_Tech]

There's a blog entry (somewhere, sorry) about customizing the admin window.  
I'm sure it tells how to open custom or default.

On 4/19/20, 12:18 PM, "4D_Tech on behalf of Mitchell Shiller via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Hi,

In previous versions when 4D Server would start up, the Administration 
window would automatically appear.
In v18, the window stays hidden. I realize that it consumed CPU cycles and 
is best hidden.
Is there any way to make it automatically appear?

Thanks

Mitch
**
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: Drop User NOT working (after client disconnected using Force Quit)

[Spencer Hinsdale via 4D_Tech]

Dude, 17.4 is the bomb.  The ultimate fix for our times is Sleep on SSL 
(ACI0096906).  This means you can run remote, encrypted, and shut your laptop 
for lunch and when you open again 4D client is Instant ON!

New Networking (ServerNet) works awesome.  64-bit Remote, Encrypted is FAST.  
32-bit Remote and Legacy Networking are still avail for those tardy to the 
party, who like slow.

Rumors are true!  New versions will be encrypted by default, there is a secret 
key for booting Sleeping users, and you should install 17.4 Clients with 17.4 
Server because it contains New SSL.

If you need more ammo read the Bugs.  I think 17.3 HF3 fixed the problem with 
SDI Client, Quit, still running (won't launch again), and many more...



On 4/15/20, 8:28 AM, "4D_Tech on behalf of John J Foster via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Hey All,

4D v17.2 64bit Windows


**
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: entitySelection.add and USE ENTITY SELECTION

[Spencer Hinsdale via 4D_Tech]

did you check database compatibility setting that dot notation is enabled

> On Apr 2, 2020, at 6:14 PM, Matt Bollwitt via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hello –
> 
> I’m running into a condition where USE ENTITY SELECTION is not working with 
> an entity selection that is built with entitySeletion.add() command. I’m 
> wondering if I’m using it correctly. I’m running 4Dv17r6. Here is a 
> simplified version of what I’m trying to do:
> 
> C_Object($sel;$sel_d;$sel_find)
> C_Date(vFindDate)
> vFindDate:=Date(ALERT("Enter date:"))
> $sel_d:=ds.People.query("Receive_Mail = :1";True)   //all records to 
> be compared
> $sel_find:=ds.People.newSelection()  //empty entity
> For each ($item;$sel_d)
>$sel:=ds.Entries.query("People_ID = :1 order by Entry_Date 
> desc";$item.LinkID)
>If ($sel.length#0)  //anything found?
>If ($sel[0].Entry_Date<=vFindDate)   
> //compare date of first entry
>$sel_find.add($item)
>End if
>End if
> End for each
> USE ENTITY SELECTION($sel_find)
> 
> I can trace this and see that the $sel_find is a selection of entities from 
> People. However, when I try to pull that entity selection back into a normal 
> selection it does nothing. The selection of records in the People table is 
> the same selection as it was before the method was ran.
> 
> Can you use the entitySelection.add command  to build the entity and then 
> later use the USE ENTITY SELECTION command? I had this working using classic 
> 4D commands and thought I’d convert it to ORDA. I’m wondering if I’m 
> understanding the .add command correctly or if something else needs to be 
> done with that object before I call the USE ENTITY SELECTION.
> 
> Thanks!
> 
> Matt Bollwitt
> 
> **
> 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: Receive packet stop character

[Spencer Hinsdale via 4D_Tech]

Does the behavior change if you insert
USE CHARACTER SET("iso-8859-1";1)
before receive packet


On 3/25/20, 8:01 PM, "4D_Tech on behalf of JOHN BAUGHMAN via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

> On Mar 25, 2020, at 3:54 PM, Jeffrey Kain via 4D_Tech 
<4d_tech@lists.4d.com> wrote:
> 
> You've got a smart quote in there... email post typo or is it in your 
code?

Actually I typed that in while drafting the email. This is old code 
that has worked for years. I also tried changing the code to char(carriage 
return)



**
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: Display off server process window on client

[Spencer Hinsdale via 4D_Tech]

CHANGE CURRENT USER("Administrator";"Password")
OPEN ADMINISTRATION WINDOW

On 3/23/20, 6:47 PM, "4D_Tech on behalf of Chuck Miller via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Hi all,

I have looked and tired and can’t figure out how to do this. v 17 running 
as  service so I need to be able to view settings etc on client. Where do I 
find this in documentation so I can set it up


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

[Spencer Hinsdale via 4D_Tech]

Looks like you pad the key, append the msg, then hash.  Then pad the key again, 
append the previous hash, and hash again.

https://stackoverflow.com/questions/11415055/how-to-use-hmac-sha256

From: Two Way Communications 
Date: Friday, March 20, 2020 at 9:37 AM
To: Spencer Hinsdale 
Cc: 4D iNug Technical <4d_tech@lists.4d.com>
Subject: Re: HMAC SHA256 in native 4D code?

Hi Spencer,

I have been looking at it, but it does not do what I want to do.

I need to construct a JSON Web Token (JWT)

For that, I need to encrypt a string with a secret key, to obtain the encrypted 
token.
As far as I can see there is no parameter in ‘Generate Digest' to do so.

I tried to use:

PHP 
Execute(“";"hash_hmac";$HMACSHA256;"sha256";($base64UrlHeader+"."+$base64UrlPayload);$key)

but the signature that is being returned does not work with JWT.

I tested it on jwt.io, and it returns ‘invalid’.

So I am looking for other ways to generate this HMAC SHA256


Regards,
Rudy Mortier
Two Way Communications bvba




On 20 Mar 2020, at 17:18, Spencer Hinsdale 
mailto:spen...@bigsoftware.com>> wrote:

Does this help?

https://doc.4d.com/4Dv17/4D/17.4/Generate-digest.301-4882385.en.html


On 3/20/20, 9:15 AM, "4D_Tech on behalf of Rudy Mortier via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

   Hi Bruno,

   I was looking in nabble to find a solution for generating HMAC-SHA256 keys.


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

[Spencer Hinsdale via 4D_Tech]

Does this help?

https://doc.4d.com/4Dv17/4D/17.4/Generate-digest.301-4882385.en.html


On 3/20/20, 9:15 AM, "4D_Tech on behalf of Rudy Mortier via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Hi Bruno,

I was looking in nabble to find a solution for generating HMAC-SHA256 keys.


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

[Spencer Hinsdale via 4D_Tech]

any chance In Transaction?

> On Mar 11, 2020, at 8:20 AM, Janet Jonas via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am running into an annoying bug with "Execute on client" functions. Even 
> though I have put UNLOAD RECORD and READ ONLY commands into the methods that 
> are executed there, the client process ke...
**
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?

[Spencer Hinsdale via 4D_Tech]

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
**
**
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: SSL Certificate parsing in 4D

[Spencer Hinsdale via 4D_Tech]

openssl?

On 10/21/19, 2:04 PM, "4D_Tech on behalf of Eric Naujock via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Is there a plugin or tool out there that can parse and breakdown a X509 
style certificate into its components to be able to display the fields within. 
I did the typical Google Foo, and the 4D Docs. Along with Miyako. I just am not 
using any such code. Any suggestions?

**
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: SSL Certificate parsing in 4D

[Spencer Hinsdale via 4D_Tech]

openssl?

On 10/21/19, 2:04 PM, "4D_Tech on behalf of Eric Naujock via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Is there a plugin or tool out there that can parse and breakdown a X509 
style certificate into its components to be able to display the fields within. 
I did the typical Google Foo, and the 4D Docs. Along with Miyako. I just am not 
using any such code. Any suggestions?

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

[Spencer Hinsdale via 4D_Tech]

I do this the opposite way--delete until it ain't broke.

Make a copy and delete half.  If it's still broke make a new copy and delete 
the other half.  If that works, make a new copy and delete half of the 
known-broke half.  Repeat ten times for 1 in 1024 granularity.



On 10/11/19, 1:29 PM, "4D_Tech on behalf of Tim Nevels via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

On Oct 11, 2019, at 3:21 PM, Chip Scheide wrote:

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

I know exactly what you mean. Nobody wants to spend hours rebuilding 
something. We all want to find that 1 line of code, change it and the problem 
is fixed. 

I just don’t know what you can do to isolate it down to one area. Only way 
I know is to start small with something that works. Then add to it and see if 
it still works. And when you add to it and it breaks, then you know what you 
just added caused it to break.



**
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: selecting pixels

[Spencer Hinsdale via 4D_Tech]

-> On Event Call `lmk if you need more suggestions
 
On 10/10/19, 4:12 AM, "4D_Tech on behalf of Peter Mew via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

A pointer to which commands to read up on would be good enough (I hope)
**
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: Apple Events Manager Process?

[Spencer Hinsdale via 4D_Tech]

Hi Tom,

I don't know how 4D figures here, but Apple Events appear to be product 
announcements which have adopted a QVC or Home Shopping Network format which 
entails a "personality" modelling a new product offering and then telling us 
the price, which always ends in 9-9.  The Apple Events Manager seems to be a 
guy named Tim, because after the personality says, the new eye-whatever is only 
one thousand and 99, they say, back to you, Tim.  If you need to speak with 
Tim, he has invited everyone on the internet to his fifth-avenue shop on Sept 
20.

HTH

spencer



On 13/9/19, 5:08 am, "4D_Tech on behalf of Tom Benedict via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

From time to time I see an empty window named “Apple Events Manager” on 4D 
Server. There is a process in Runtime Explorer named “Apple Events Manager”. 
What is the purpose of this window/process?

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
**
**
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: InnoSetup installer + Windows 7

[Spencer Hinsdale via 4D_Tech]

Hi Pat,

This sounds like Virtual Store...

Click Start, type "hidden" and show hidden files then go to
C:\
Users\
Pat\
AppData\
Local\
VirtualStore\

Look for the install path of your app, like:
Program Files(x86)\
CatBase\

There you may find folders like Database, which contains 93, because it was in 
Program Files and modified, if only by saving Data File path into itself.  
Delete this and the process will repeat making a new copy of 100 in this locale.

One simple way to solve for deployment is change the install path to either 
not-Program-Files or make directory unique (e.g. CatBase100\).

hth

On 8/10/19, 6:10 AM, "4D_Tech on behalf of Pat Bensky via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Well folks I have been banging my head against the wall for a whole day and
have not been able to solve this very strange problem ...
I have a need to compile an update to an old version of CatBase. This is
Version 7.3 (we are currently on Version 8). The previous compile was rev.
93; this one is rev. 100.

So I compile  and build a single-user app.
Run it and check to make sure it is the correct version (r100). It is.
Build an installer using InnoSetup.
Check that the installer is the correct one (ie - current date and time).
Run the installer.
Check the installed version: the files (including the .exe) have the
current date and time.
Run the app.
IT RUNS THE WRONG VERSION (rev 93 instead of rev 100)!

I have:
Scoured the machine and deleted ALL previous versions of the app.
Found and deleted out-of-date shortcuts.
Deleted an old version of the installer from the Downloads folder.
Emptied the Recycle bin.
Restarted the machine.
Checked the installer script to make sure it is pointing to the correct
folder. Checked this by removing the compiled app folder; running the
installer script generates an error. Put the folder back and the installer
script runs OK. This confirms that the script is pointing to the correct
folder.
Delete the installer and empty the Recycle Bin
Rebuild the installer.
Same problem every time!

No matter what I do, the newly installed .exe runs the old version, which
doesn't even exist anywhere!

Any suggestions?

Thanks!
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
**
**
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: Overlapping Objects in Data Segment #65

[Spencer Hinsdale via 4D_Tech]

can you drop indexes for the conversion?

Spencer


> On Aug 8, 2019, at 8:15 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> It seemed to be a problem with the address table. I had to end task while 
> indexing during an R5 upgrade of one of our mirrors due to the cache memory 
> release issue in current versions, and address table errors during journal 
> file integrations appeared shortly after bringing the mirror back online in 
> R5.
> 
> I restored that data file back to the 17.1 version and verified it and it 
> came back with a completely clean bill of health.  I'll try the R5 reindex 
> once again after I figure out how to get it to complete without locking up 
> when the cache memory (~ 400GB) is full.  
> 
> I'm thinking I'll set the cache very high (higher than physical memory) and 
> let Windows handle the memory overflow, so 4D never has to release cache 
> memory. Or buy more RAM.
> 
> Jeff
> 
> P.S. - I think issues in the .4DIndy are always indicated by a reference to 
> the table "Resources".
> 
>> On Aug 8, 2019, at 8:19 PM, Spencer Hinsdale  wrote:
>> 
>> no but i feel like _you_ posted a while back that is the indy index of 
>> structure ;)
>> 
>> https://kb.4d.com/assetid=76692
>> 
>> Spencer
>> 
>> 
>>> On Aug 8, 2019, at 4:58 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
>>> wrote:
>>> 
>>> I ran a verify of our data file, and records were fine, indexes were fine, 
>>> but at the end of the log was an error:
>>> 
>>> Error: Overlapping Objects in data segment # 65 : Address overlaps(31;140)
>>> 
>>> 
>>> Does anyone know what this means?
> 
> **
> 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: Overlapping Objects in Data Segment #65

[Spencer Hinsdale via 4D_Tech]

no but i feel like _you_ posted a while back that is the indy index of 
structure ;)

https://kb.4d.com/assetid=76692

Spencer


> On Aug 8, 2019, at 4:58 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I ran a verify of our data file, and records were fine, indexes were fine, 
> but at the end of the log was an error:
> 
> Error: Overlapping Objects in data segment # 65 : Address overlaps(31;140)
> 
> 
> Does anyone know what this means?
> 
> 
> --
> Jeffrey Kain
> jeffrey.k...@gmail.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
**

Re: 4D eMail Editor - full HTML support

[Spencer Hinsdale via 4D_Tech]

Have you looked at 4D PDF Printer?
http://node.de/indexplug.htm

We use it to automate printing from 4D to PDF and then emailing using Outlook.

However, it also has PRO features for reading from Outlook into 4D.  Looking at 
the Demo, when I click on Outlook Email Parsing Client it lists messages in 
Outlook (takes a minute with 6000 msgs) showing their details.  I don't see 
HTML offhand but it looks like you could automate the copy/paste (export, read 
.eml, ...)

Hth,
spencer




On 7/24/19, 12:34 PM, "4D_Tech on behalf of rooftop99--- via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Thanks to all who have offered suggestions.  Super helpful!  The biggest 
challenge I face is the spec calls for composing the email in Outlook first, 
then copying and pasting the final version into 4D with full preview and edit 
capability.  None of my tests have proved this is possible. (There is always 
something wacky in the transfer.)  However, your input has given me ideas on 
how we might take a different path to get to the same end result.  We’ll see...

Much appreciated!
Kirk

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

[Spencer Hinsdale via 4D_Tech]

Hi Dave,

I would assume you need a License for Developer and to be running Interpreted...

Go to Help menu, Licenses to see if you have "Developer".  If you just switched 
to R, you may need to re-enter.

Restart 4D, go to Open, select your Structure, and in bottom left of Finder 
window click Options.  Is it set to Open > Interpreted Database?  If you 
compile and test in 4D, it may automatically re-open in Compiled mode.

FYI, R5 was released yesterday.

I had not tried Mobile till I saw your email and now (55 min later) I have 
first test app running in iPhone XR Simulator and it totally works!

Amazing!

-spencer




On 7/20/19, 7:19 AM, "4D_Tech on behalf of Dave Tenen via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

I am trying to learn the procedure and tutorial for 4D Mobile Apps

I am having a problem where the menu item “ Mobile Project” is not active!
I have gone trough the steps in the tutorial to setup, launch and run the 
Mobile Project item in the New Menu, except it is not available to choose 
(grayed out).  
I am running 4d v17r4 on a MacBook pro running 10.14.5
Do I need a different version of 4D?

Any ideas on how to fix this?


Thanks in advance,
Dave Tenen


Personal Chef 

Coming to you from Spec Pond and I swear the fish was
[]
this big

dte...@me.com



Dave Tenen


Personal Chef 

Coming to you from Spec Pond and I swear the fish was
[]
this big

dte...@me.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
**

Re: Making sense of a crash report

[Spencer Hinsdale via 4D_Tech]

I don't know, but it seems weird the app appears to be in a system folder...

Shouldn't this say, Path: /Applications/Catbase8.app?

hth

On 1/18/19, 5:23 AM, "4D_Tech on behalf of Pat Bensky via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Path:  /private/var/folders/*/CatBase
8.app/Contents/MacOS/CatBase 8
**
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: AWS Experts - Need a little help

[Spencer Hinsdale via 4D_Tech]

did you edit Security Groups to add 4D ports 19812 to 19814?

> On Jan 14, 2019, at 2:15 PM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Spencer, thanks for the tip.
> 
> Yes, I'm using the public IP address
> (Same address that I use to connect via RDC)
> 
> No workie!
> 
> ;-(
> 
> Randy Engle 
> 
> Check that you are using the public ip displayed on the desktop not on server 
> admin window...
> 
> 
> 
> 
> **
> 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: AWS Experts - Need a little help

[Spencer Hinsdale via 4D_Tech]

Check that you are using the public ip displayed on the desktop not on server 
admin window...

On 1/14/19, 1:01 PM, "4D_Tech on behalf of Randy Engle via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

I'm testing an app on AWS (LightSail Account)

I've got a very lightweight app running on 4D Server (v17) Windows running 
on an instance of AWS.

I'm not able to connect 4D Client (from my location) to the 4D Server on AWS


**
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: MSC: why "Checking list of deleted records ..." persists?

[Spencer Hinsdale via 4D_Tech]

Hi Kirk,

Isn’t there an option for Compact to drop Address Tables?  This invalidates any 
Log Files but gives table(s) a clean start. There is a function like Table 
Fragmentation which returns ratio of remaining record to total address table. 
Sorry not at computer...

Spencer

> On Jan 12, 2019, at 8:12 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> A few months ago a bug resulted in a large number of records being created
> in a table ([email_que]) by mistake. Bug was fixed and 1 or 2 million bogus
> records were deleted.
> 
> Since then the data file has been verified and compacted at least once.
> 
> Just now I was running a verify on the data file again and notice 4D
> spending a - very - long - time verifying that table. Looking at the verify
> log I notice a few, but not all, tables with this message listed by them.
> 
> The table property "Records are definitively deleted" is not checked for
> [email_que]. At least one other table with the message do have it checked.
> 
> I have to assume it's connected with the the large selection that was
> deleted. But given that I would expect a repair/compact operations to have
> resolved it.
> 
> Anyone else run into this?
> 
> Thanks
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *We go vote - they go home*
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: sending mail through Office365 using SMTP

[Spencer Hinsdale via 4D_Tech]

in the docs for Send there is an Exchange example that set Port
587. 
Spencer


> On Nov 20, 2018, at 2:58 PM, Chris Belanger via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi,
> 
> I have a client that has switched its email provider to use Office365.
> My app sends emails using SMTP_Send( ) perfectly well with other providers, 
> but not Office365.
> 
> Any help you may offer will be appreciated.
> 
> 
> my significant part of my code currently is:
> 
> Case of
> 
>: (Not(eMail_ERRCHECK ("SMTP_New";SMTP_New (SMTP_ID
>: (Not(eMail_ERRCHECK ("SMTP_Host";SMTP_Host (SMTP_ID;$Host;0
>: (Not(eMail_ERRCHECK ("SMTP_From";SMTP_From (SMTP_ID;$From;1
>: (Not(eMail_ERRCHECK ("SMTP_ReplyTo";SMTP_ReplyTo (SMTP_ID;$From;0
>: (Not(eMail_ERRCHECK ("SMTP_To";SMTP_To (SMTP_ID;$To;0
>: (Not(eMail_ERRCHECK ("SMTP_Cc";SMTP_Cc (SMTP_ID;$CC;0
>: (Not(eMail_ERRCHECK ("SMTP_Bcc";SMTP_Bcc (SMTP_ID;$BCC;0
>: (Not(eMail_ERRCHECK ("SMTP_Subject";SMTP_Subject 
> (SMTP_ID;$Subject;0
>: (Not(eMail_ERRCHECK ("SMTP_Body";SMTP_Body (SMTP_ID;$Body;0
>: (Not(eMail_ERRCHECK ("SMTP_Attachment";SMTP_Attachment_It 
> (SMTP_ID;$Attachments;2;0
>: (Not(eMail_ERRCHECK ("SMTP_Auth";SMTP_Auth 
> (SMTP_ID;True;<>Auth_UN;<>Auth_PW
>: (Not(eMail_ERRCHECK ("SMTP_Send";SMTP_Send (SMTP_ID;0
>: (Not(eMail_ERRCHECK ("SMTP_Clear";SMTP_Clear (SMTP_ID
> Else 
> $SentOK:=True
> End case 
> 
> SMTP_Auth( ) works without error, but then
> SMTP_Send( ) returns error:   10032 ‘Unknown or invalid response’
> 
> Thanks for any help,
> 
> Chris Belanger
> Innovative Solutions
> **
> 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: Help->v11 to v17 Upgrade or New?

[Spencer Hinsdale via 4D_Tech]

It was Dani!  Yeah, 4D is awesome at this stuff.  We get upgrades old, old 
versions all the time and our current structure just opens these old data 
files, and 4d does its magic to uid them, unicode them, de'subtable them.  no 
problem.


> On Oct 18, 2018, at 2:19 PM, Robert ListMail via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Okay, I can’t find it now but someone said, "hey pop it into v17 and see if 
> it works…" or something like that. Well, I did just that and without any 
> changes it compiled (after toggling unicode on) and I created a built server 
> and client and ran a few tests. Yes, as I recall, I did fix all of the syntax 
> errors years ago. It seems to work for the most part (PICT icons and images 
> do not show and a couple of fields cannot be used for data entry, I’m sure 
> that’s an easy fix). I’m surprised this works at all! So, there are more than 
> 700 lines of code with the deprecated “_o_” prefix. Perhaps I could make a 
> lot of that go away via Search/Replace (a feature that I normally don’t use).
> 
> Thanks to all of you that have contributed. It looks like I can get this 
> running as it did before via v17 so that it can run on their new hardware 
> running the latest Windows server and Win10 clients…. Of course they want 
> this yesterday, so I could deliver the converted one and then upgrade 
> incrementally. Yes, it does look ugly as f*ck but sadly no one is complaining 
> about that.
> 
> Thanks,
> 
> Robert
> 
>> On Oct 17, 2018, at 3:11 PM, Spencer Hinsdale via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> 4D automatically converts Subtables. This should not be a problem.
> 
> **
> 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: Help->v11 to v17 Upgrade or New?

[Spencer Hinsdale via 4D_Tech]

4D automatically converts Subtables. This should not be a problem.

> On Oct 17, 2018, at 12:45 PM, Robert ListMail via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I have an old v11 database running on Windows that’s not particularly 
> well-designed and where there are more than a few subtables to deal with. 
> Assuming that there is no additional budget for writing a new clean app, 
> would you likely upgrade or re-write in v17 with the old v11 structure as 
> guide?  I’m concerned that the upgrade path will be difficult because of the 
> subtables and that by the time you deal with all of the legacy junk not this 
> database from the early 90s you could have created something fresh and new. 
> How might you approach this?
> 
> Also, the client originally said the new database would not have to migrate 
> data forward from the old system and now they are wanting to have the data 
> too.
> 
> Thanks,
> 
> Robert
> 
> **
> 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: Isolating the Cause of a Server Crash

[Spencer Hinsdale via 4D_Tech]

reboot the computer. it has been running for 40 days?

> On Aug 31, 2018, at 1:54 PM, Dave Nasralla via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> One of our systems is crashing about every 3 days
**
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: pdfCreator problem

[Spencer Hinsdale via 4D_Tech]

+1

> On Aug 29, 2018, at 8:19 AM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Keith,
> 
> Two thumbs up for Armin's plugin.
> Yes, there is a cost, but eliminates a lot of headaches
> 
> Randy Engle, Director
> XC2 Software LLC – XC2LIVE!
> 
> Keith wrote
>> Hi all.
>> We have suddenly struck a problem with pdfCreator v1.7.2 not working 
>> when using a built 4D Client via Remote Desktop Connection access.
>> It used to work, but started giving problems about a month ago (that's 
>> when we first detected it).
>> 
>> pdfCreator works just fine when the 4D Client is accessed via Ericom 
>> and the Chrome browser, but not when accessed via Remote Desktop Connection.
>> In the latter case, the problem manifests itself when the document 
>> that pdfCreator is told to create in the Temp folder in the User 
>> folder doesn't happen, and an error is then generated when the code tries to 
>> access it.
>> The error can be trapped but the document is needed.
>> It is not a user permissions problem because the code can write csv 
>> files to the same folder.
>> 
>> It happens for both 4D v15.2 and v17.0 HF1. 
>> The computer is a cloud server VM running OS is Windows Server 2008 R2 
>> Datacenter / Service Pack 1.
>> 
>> Has anyone come across this or something like it?
>> Thanks, Keith
> 
> Keith,
> 
> try this pdf plugin http://www.node.de/indexplug.htm
> 
> regards Armin
> 
> 
> 
> **
> 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: ORDA - updating data in listboxes

[Spencer Hinsdale via 4D_Tech]

is this relevant?

http://kb.4d.com/resources/inug?msgid=GmailId164f73d107b663e7 



> On Aug 12, 2018, at 11:55 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> The thing that's not working is the Name column of the listbox - 


**
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: Orphaned blobs and SSD drives

[Spencer Hinsdale via 4D_Tech]

John,

This might be a man in the middle of a weekend attack.  I'm pretty sure the 
real Jeff Kain would tell you to run Repair, TWICE, to fix Orphaned BLOBs.

> On Jul 29, 2018, at 3:32 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> To fix a table with orphaned blobs, export the data, truncate the table, and 
> reimport. Nothing to really worry about, except that you can't do a simple 
> compact without erroring out.

**
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: POW Function

[Spencer Hinsdale via 4D_Tech]

difference btwn log and natural log.  try LOG10

> On Jul 24, 2018, at 9:32 AM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 
> But I’m getting an exponent of 7 instead of 3. Any ideas what I’m doing wrong?
> 

**
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: POW Function

[Spencer Hinsdale via 4D_Tech]

is it caret?

7^3



> On Jul 24, 2018, at 9:15 AM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I’m looking for an equivalent function in 4D as the pow function in other 
> languages. For example:
> 
>   
> 
> 

**
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: Backup Settings window

[Spencer Hinsdale via 4D_Tech]

seems like a Resource error. assuming you are on macOS, maybe a fix is to Build 
using 32-bit Volume Desktop

-spencer

> On Jun 1, 2018, at 1:50 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I've just upgraded a client's custom database to v16.
> I compile it and build a stand-alone single-user app.
> When I launch this app, the Backup settings window opens with the window
> title ":StrLang,61".
> No matter what settings I choose, when I click the Save button I get the
> message:
> 
> *Backup settings not saved.*
> *Preferences path not found.*
> *No Backup XML file was opened.*
> 
> I've tried various backup settings but I always get the same result.
> I've tried with v16.3 and with v16r6 - same result.
> In the Database Settings, on the Backup tab, I selected *Never* for
> Automatic Backup but that did not fix the problem.
> 
> Want would be causing this?
> 
> PB
> 
> -- 
> *
> 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)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: Chromium Embedded Framework in built applications question

[Spencer Hinsdale via 4D_Tech]

Hi David,

My guess was it was added to support Tabbed interface on Mac, Developer.

v16.3 in December greatly reduced Built Client for us (506MB -> 282MB), and 
comes after R3 you are using.

So my guess is current R6 would do the same for you.


Spencer


> On May 19, 2018, at 4:14 AM, David Adams via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> A friend recently pointed out that built apps had unexpectedly increased in
> sizea lot. We used to come in at something like 150MB and are now at
> over 600MB.
> 
> macOS, 16.3 R3
> 
> Digging into the ressoures in the built app, this package appears:
> 
> Chromium Embedded Framework.framework
> 
> ...at about 260MB. The compiled database is less than 55MB.
> 
> Does anyone know what this Chromium Embedded Framework.framework file is
> and how to get rid of it? You can't just strip it out after the build as 4D
> complains on launch.
> 
> Thanks!
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: EC2 server on Amazon AWS

[Spencer Hinsdale via 4D_Tech]

Hi Rudy,

1) you need the public IP from your dashboard.  this may not be the IP that 4d 
server appears to be listening to

2) you need allow access from your dashboard by going to Security Groups and 
adding your Ports (19812 - 19814)

3)  you need to configure Windows Advance Firewall


https://www.bigbusiness.com/solutions/6779

> On May 11, 2018, at 7:21 AM, Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi,
> 
> Has anyone succeeded in setting up a 4D server on a virtual Windows server on 
> AWS?
> 
> I have set up the server (free version), installed 4D server 416R6, added the 
> licenses and launched the 4D database.
> Additionally I configured the ports on the AWS server to also listen to the 
> TCP and UDP addresses.
> 
> However, there is no way I can connect to it from a 4D client on my machine, 
> Neither on the public address provided, nor the private IP address.
> I tried with the public address, and even tried with appending :19813 as a 
> port after the IP address.
> 
> Any tips will be greatly appreciated.
> 
> 
> Regards,
> 
> Rudy Mortier
> Two Way Communications bvba 
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: Error -19191 ?

[Spencer Hinsdale via 4D_Tech]

It is old client cannot update via new network layer...

http://kb.4d.com/assetid=77427 

> On May 8, 2018, at 9:53 AM, Bob Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Everyone,
> 
> I have a 4D Client user (v15r5, Windows) who can't connect, with error 
> -19191.  I can't find this error in either the language ref, the server 
> reference, or the design ref.  Does anyone have an idea of what this error is?
> 
> Thanks,
> 
> Bob Miller
> Parker Hannifin Corp.
> 
> ll
> "PLEASE NOTE: The preceding information may be confidential or privileged. It 
> only should be used or disseminated for the purpose of conducting business 
> with Parker. If you are not an intended recipient, please notify the sender 
> by replying to this message and then delete the information from your system. 
> Thank you for your cooperation."
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: Label Editor problems v16 (doesn't recognize # of columns)

[Spencer Hinsdale via 4D_Tech]

maybe you are entering values in Euros and it is converting to Dollars (5:6)?  
Just kidding; I have no idea, except when I tested I used the up-down arrows 
not typing a value


> On Mar 9, 2018, at 1:23 PM, Robert C. Faucett via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Thanks Spencer - My problem is more simple that that . . .  If I enter “5"
> into the “Columns” boxing hit preview the document has 6 columns of labels
> (5.75 actually as it spills off the right side of the page).
> 

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Label Editor problems v16 (doesn't recognize # of columns)

[Spencer Hinsdale via 4D_Tech]

When I started 2 Columns took up 80% of the window.  When I switched to 3 
Columns the 3rd column extended to about 120% so I couldn't see half of it.  

This gave me the idea that maybe your columns take 100% of the width and when 
you add a column it appears in the 100-150% range, i.e. "off-screen".  If so, 
typing a smaller value in Label Width would make it appear.

Just a theory :)



> On Mar 9, 2018, at 12:46 PM, Robert C. Faucett via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Thanks Spencer.  How would a column be added ³off screen?"
> 
> 
> --
> Robert C. Faucett
> Collections Manager
> Ornithology
> Burke Museum
> Box 353010
> University of Washington
> Seattle, WA 98195-3010
> Office: 206-543-1668
> Cell: 206-619-5569
> Fax: 206-685-3039
> rfauc...@uw.edu
> www.washington.edu/burkemuseum
> http://www.washington.edu/burkemuseum/collections/ornithology/index.php
> http://www.washington.edu/burkemuseum/collections/genetic/index.php
> 
> 
> 
> 
> 
> 
> On 3/9/18, 12:12 PM, "4D_Tech on behalf of Spencer Hinsdale via 4D_Tech"
> <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:
> 
>> 
>> Hi Rob,
>> 
>> It seems to work for me, same setup, running 32-bit.  Maybe it's
>> different 64-bit?
>> 
>> One oddity is clicking the up arrow to go from 2 to 3 Columns worked but
>> did not re-scale in any way.  I then had to change Label Width to see the
>> column on page view.  Maybe you are adding a column off-screen?
>> 
>> HTH,
>> 
>> Spencer
>> 
>>> On Mar 9, 2018, at 12:05 PM, Robert C. Faucett via 4D_Tech
>>> <4d_tech@lists.4d.com> wrote:
>>> 
>>> Hello All - I am having problems getting the Label Editor to recognize
>>> how many columns
>>> of labels I want.  Anybody else having experience with this?  4D v16.3 &
>>> MacOS 10.13.3.  It seems to ignore the value in the ³Columns² box.
>>> 
>>> Thanks for any advice.
>>> 
>>> Rob
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> 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)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: Label Editor problems v16 (doesn't recognize # of columns)

[Spencer Hinsdale via 4D_Tech]

Hi Rob,

It seems to work for me, same setup, running 32-bit.  Maybe it's different 
64-bit?

One oddity is clicking the up arrow to go from 2 to 3 Columns worked but did 
not re-scale in any way.  I then had to change Label Width to see the column on 
page view.  Maybe you are adding a column off-screen?

HTH,

Spencer

> On Mar 9, 2018, at 12:05 PM, Robert C. Faucett via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hello All - I am having problems getting the Label Editor to recognize how 
> many columns
> of labels I want.  Anybody else having experience with this?  4D v16.3 &
> MacOS 10.13.3.  It seems to ignore the value in the “Columns” box.
> 
> Thanks for any advice.
> 
> Rob

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Blank Listbox

[Spencer Hinsdale via 4D_Tech]

my blank list boxes are always arrays, out of sync, which is easy to suss by 
backing off the fill instructions until it shows something.  hint, one column 
is always in sync.

however i don't think this problem makes headers blank.

i would suggest you try leaving listbox in group4 and showing group4 but NOT 
hiding group1.  if needed scoot some objects around so they can be viewed 
together.  does this make any difference?

> On Feb 23, 2018, at 7:32 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Why would it appear as a blank box in Group​4?
> 
> Thanks for any enlightenment you can offer!

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Problems installing built application

[Spencer Hinsdale via 4D_Tech]

oh, okay you can use Default Data File feature in XML Build Keys,
store last file opened in your own text file, test the data file opened and if 
it is default look for text file and use Open Data File. there is some trick 
like calling in a new process maybe...

> On Feb 5, 2018, at 3:36 PM, macjimbo via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> 'm running 15.5 on Mac OS 10.13.2
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Problems installing built application

[Spencer Hinsdale via 4D_Tech]

v16, database prefs, New Architecture

anything else?  :)

> On Feb 5, 2018, at 3:36 PM, macjimbo via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> that works until I install an upgrade.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Problems installing built application

[Spencer Hinsdale via 4D_Tech]

Well, if you go back to PackageMaker you can build an Installer that is signed 
with your Developer ID Installer

And in Package, Contents you can go to Scripts, Postinstall and add a script 
with contents like:

#!/bin/sh

chmod -R 777  '/Applications/MyAppFolder'

> On Feb 5, 2018, at 11:46 AM, macjimbo via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Help!
> 
> Cheers
> 
> James
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Screen capture code snippet found on the NUG that I am not able to make work. plse help

[Spencer Hinsdale via 4D_Tech]

Hi Ernie,

If you go to Terminal you can type or paste $command_t contents to test.

You could also type, "man screencapture" to see the the manual which documents 
options like -R, which I do not see in High Sierra.

My guess is that you need a single quote for path name since it contains space. 
 I will add it for you in the following:

$command_t:="screencapture "+$screenRectOption_t+" '"+Convert path system to 
POSIX($filePath_t)+"'"

or the human-readable version:

$command_t:="screencapture "+$screenRectOption_t+" "+Char(Quote)+Convert path 
system to POSIX($filePath_t)+Char(Quote)

HTH,

Spencer

> On Jan 25, 2018, at 10:04 PM, ernie hilgers via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi Tim Nevels,
> 
> I was trying to make the code work on my mac 10.6 / 10.8 but somehow I am not 
> getting the snapshot on the desktop. (where I want them, for now)
> 
> I changed some of your code  (see below) but I am not sure if I understand if 
> that makes it work.

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

Re: Programmatically Manage Parent Tab an Multi-Subforms

[Spencer Hinsdale via 4D_Tech]

old school is draw two subfoms. one off screen. then swap as needed. with 
move-object. works a charm ;)


> On Dec 24, 2017, at 8:37 AM, truegold via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 
> I have a parent form which has a subform container. Above the subform 
> container is a tab control object (5 tabs). Clicking on a tab selects the tab 
> an triggers (underlying code) a change to the underlying subform. Works great.
> 
> But I discovered I need one of the subform pages, let’s call it “Edits”, to 
> change, based upon a different context, to either a different page or a 
> different subform using code. The key here is that some action in the parent 
> form needs to cause the subform container to display a different form.
> 
> Seems easy… But I haven’t been able to get it to work.
> 
> Parent Form (Tab control)
>   -> Subform container
>  -> actual subform
> 
> Logically it seems that I need to programmatically set the correct tab and 
> tell the subform container to change the subform displayed. And then, of 
> course, have the subform appear in the subform container.
> 
> At the point where I need things to happen I’m not in a subform so I can’t 
> use CALL SUBFORM CONTAINER. I can’t use EXECUTE METHOD IN SUBFORM because I 
> am at the parent level. Well if I had a multi-page subform then I might need 
> to use the command.
> 
> I’ve tried many variations over the last few days. So… I am sure that not 
> having a clear understanding of what I am doing is contributing to my hit and 
> miss approach not working.
> 
> So what’s the secret sauce to manage programmatically the subform change 
> (parent level)?
> 
> Can someone point to where my understanding is off? Or other ideas?
> 
> Appreciate,
> John…
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Quick Report Editor Preview on Windows

[Spencer Hinsdale via 4D_Tech]

I'd guess you need XPS Viewer installed

> On Dec 11, 2017, at 12:16 PM, John Baughman via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> What do you have to do on windows to use the preview button in the Quick 
> Report Editor in Windows? When I click it I get “No application is associated 
> with the specified file for this operation”.
> 

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

Re: 4DLINK

[Spencer Hinsdale via 4D_Tech]

Hi Pavel,

See if you can use LastDataPathLookup, ByAppPath:
http://doc.4d.com/4Dv16/4D/16/LastDataPathLookup.300-3130241.en.html

If you Build your application (app_sss.exe) using XML Keys, you:
- use v16
- set Compatibility option for Use New Architecture--see bottom of this page:
http://doc.4d.com/4Dv16/4D/16.1/Compatibility-page.300-3373287.en.html
- Build with the key above

This is a great solution for distribution.  Each target machine remembers each 
Data File for each App.

There are other solutions (DateName=StructureName AND in-same-directory, Key 
for DefaultDataFile) if _you_ control the target machine.



> On Nov 9, 2017, at 1:45 AM, Pavel Cerny via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi,
> 
> Under WIndows I have 2 or more identical applications in different
> directories with different filename datafiles.
> For example :
> C:\A\app_sss.exe   C:\A\Database\app_sss.4DC and app_sss.4DD  - it is OK
> C:\B\app_sss.exe   C:\B\Database\app_sss.4DC and app_bbb.4DD - when I update
> the application, I always have to select the datafile again, can I set up
> for exe (4dc) which datafile to open?
> 
> Thanks
> Pavel
> 
> 
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: info.plist

[Spencer Hinsdale via 4D_Tech]

http://doc.4d.com/4Dv16/4D/16/4D-XML-Keys-BuildApplication.100-3130124.en.html


> On Oct 29, 2017, at 1:31 AM, Jeremy Roussak via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I’m sure I’m missing something obvious (and I think I’ve managed to solve the 
> issue in the past), but…
> 
> How do I tell 4D to put stuff into the info.plist file for a built 
> application? I’m particularly interested in version strings.
> 
> Mac, 4Dv14.
> 
> Thanks.
> 
> Jeremy
> 
> 
> Jeremy Roussak
> j...@mac.com
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: QUERY into variable vs. Records in Table

[Spencer Hinsdale via 4D_Tech]

maybe i don't understand but what about:

`trigger
execute on client("@";"flagPoll")

`flagPoll
c_boolean(<>flagPoll)
<>flagPoll:=true

...

if(<>flagPoll)
>   $x:=Records in table([ServerMigrations])
<>flagPoll:=false
else
 `skip 99,999 calls to server
end if

> On Oct 19, 2017, at 11:31 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Decided to test it. Here are the results, running interpreted, client-server 
> against a server under very low load:
> 
> Records in table: 565 ms
> Semaphore polling: 2482 ms
> Query into variable: 2749 ms
> 
> Here's my test code:
> 
> C_LONGINT($msRIT;$msSEM;$msQUERY;$x;$n)
> C_BOOLEAN($b)
> $n:=1000
> 
> $msRIT:=Milliseconds
> For ($i;1;$n)
>   $x:=Records in table([ServerMigrations])
> End for 
> $msRIT:=Milliseconds-$msRIT

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

Re: QUERY into variable vs. Records in Table

[Spencer Hinsdale via 4D_Tech]

trigger?

> On Oct 19, 2017, at 10:28 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I feel like I'm missing an obvious solution.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: How do you run MSC in a compiled/merged single user app?

[Spencer Hinsdale via 4D_Tech]

hold Option key while starting up to get the dialog where you can switch files, 
create new, or use msc

> On Oct 18, 2017, at 7:54 PM, Robert McKeever via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 4D V15.4, single user. The client is on the east coast (4 time zones), I’m in 
> the west.
> 
> I tried ‘Open Security Window’ in an execute statement (I’m logged in with 
> Teamviewer), and it does not work.
> 
> It is unable to save a record in a frequently used (adds only, no deletes) 
> table. So, I’ve compressed the datafile and its indexes, and I’m moving it 
> here to do the repair (He tends to shut his Mac off rather than quit 
> properly). 
> 
> Any ideas?
> _
> Bob McKeever  http://www.mswl.com 
> McKeever's Software Wizardry
> Port Coquitlam, B.C.
> bobmckee...@mac.com
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Anyone using 4D Write Pro with a semblance of success?

[Spencer Hinsdale via 4D_Tech]

doesn’t r4 have tables, ie columns?

> On Oct 16, 2017, at 3:04 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> We are creating a document-building system using WritePro. It creates
> data-based documents like catalogues, price lists, directories etc. -
> something that our software currently does by creating tagged files for
> importing into InDesign, QuarkXPress, or Word.
> 
> Currently there are two major features missing from WritePro that are
> holding us back:
> 
> - Columns
> - Creating stylesheets via code
> 
> The idea is that the user will be able to build the catalogue (or whatever)
> and then either open it in a WritePro area and review it, maybe tweak it a
> bit, and then print it or PDF it, or just go directly to PDF. We've got the
> bones of it working but have stopped development for the time being because
> of those two major shortcomings. I've submitted both as feature requests
> and hope they get implemented soon.
> 
> Pat
> 
> On 16 October 2017 at 22:56, BTB-David via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> From everything that I’ve read, High Sierra is the last version of OS X
>> that will support 32 bit apps.  This makes the 4D Write/4D View issue
>> imminent for me.
>> 
>> Thanks!
>> 
>> David Conley
>> By The Book, Inc.
>> Office: 815-234-7530
>> Direct Line: 815-406-5502
>> Fax: 815-234-7532
>> http://www.bythebook.com
>> 
>> 
>> 
>> 
>>> 
>>> Anybody heard comments from Apple or Microsoft as to when they will kill
>> support for 32bit applications?
>>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> This email was sent to 4d_tech@lists.4d.com (mailto:4d_tech@lists.4d.com)
>> unsubscribe from this list (http://emailclicks.bythebook.
>> com/track/unsub.php?u=30055319=55128fca61194ea7990a570d8e4be7
>> c5.6uKpduIsjJ%2FEqVQ1r%2BdLr66Tu1w%3D=https%3A%2F%
>> 2Fmandrillapp.com%2Funsub%3Fmd_email%3D4d_tech%2540lists.4d.com)
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: http://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
>> 
> 
> 
> 
> -- 
> *
> 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)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: San Fransisco Font

[Spencer Hinsdale via 4D_Tech]

Here's how to get font and something about style sheet "automatic":

http://kb.4d.com/resources/inug?msgid=GmailId15d3951d31795686 


I don't know from "Default" but I do vaguely recall having boxes for 95, 2000, 
and XP.  :)

> On Oct 9, 2017, at 1:46 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> In my experience, the Default style sheet doesn't work correctly. On El 
> Capitan and Sierra, it uses the Yosemite system font no matter what. But if 
> you make a new style sheet that refers to "System Font" you'll end up the 
> correct font on each OS. Not sure why "Default" doesn't work properly... I 
> never really dug into it.
> 
> Keep in mind that the Yosemite system font is significantly wider than its 
> successors.
> 
> --
> Jeffrey Kain
> jeffrey.k...@gmail.com
> 
>> On Oct 9, 2017, at 4:28 PM, Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> My thinking has been to use the “Default “ style sheet and explicitly set
>> it to the prevailing system font on both platforms. However, the stylesheet
>> editor has only one setting for macOS and some obsolete windows OS.
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Post Key command not working in converted 4Dv16 database

[Spencer Hinsdale via 4D_Tech]

You might try the key command to disable any event handler:
http://doc.4d.com/4Dv16/4D/16.2/ON-EVENT-CALL.301-3432983.en.html 




> On Oct 9, 2017, at 6:41 AM, Ken Daniel via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Koen & Steve, thanks for the tip, but in this case I am using POST
> KEY(Character code(".");Command key mask) and had the shortcut of Ctrl .
> assigned to a button. It only fails to work in this one converted database.
> I've converted another database to v16 for a different application and it
> works fine. I've compared the two databases and can't discern any
> difference. In another test, if I execute POST KEY (Character Code("a")), I
> can see it populate a variable field with the letter "a", but it just won't
> execute the code assigned to the button with that shortcut. Ken
> 

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

Re: Create multi array

[Spencer Hinsdale via 4D_Tech]

1) Use a Two Dimensional Array:
http://doc.4d.com/4Dv16/4D/16.2/Two-dimensional-Arrays.300-3433911.en.html

2) Decide if your arrays are Rows or Columns.  The Docs call them Rows.  If you 
decide your arrays are Columns, then you must REMEMBER the Docs need 
"translation" anytime you refer to them.

3) Decide if you will use array zero.  If you decide to use array zero, then 
you must REMEMBER to Clear it yourself.


That's it.


You will want to fill your arrays, so you may want to pass them to another 
method, or perhaps another process, or even another computer (method with 
execute-on-server attribute).  You will want to declare them.  You can declare 
20 arrays in 20 lines.  Or, see #1.

You may want to display your arrays.  If so, you will use a List Box.  And your 
arrays will be Columns.  See #2.

And you may want somewhere to put additional info, that goes with the data when 
you pass the arrays, and stays synchronized when your user moves or sorts your 
List Box.  And once your users see these arrays they will want others.  If so, 
you will likely re-use your code, your List Box, and your arrays.  In which 
case, see #3.


HTH,

Spencer




> On Oct 6, 2017, at 1:57 AM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 
> I need to create 20 arrays that have a similar name.
> I can do this using the pointers?
> I try with this code, but in compiled mode not work.
> 
> For ($I;1;17)
> $vPoint:=Get pointer("aAna_"+String($I))
> ARRAY REAL("aAna_"+String($I);0)
> End for
> 
> Have suggestions?
> 
> Thanks
> Ferdinando
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Resolving format

[Spencer Hinsdale via 4D_Tech]

Hi Jeremy,

I don't know.

I think it you use Filters and Formats to enter the format, i.e."£###,###" it 
is saved somewhere in your Structure and may be inaccessible.

However you do have a Localization mechanism available, which works sort like 
this (stop me if you've heard this one before):

toolbox, filters and format, |Money, Definition = ":20001;1"

then adjacent your structure in your resources folder:
resources:en.lproj:structureEN.xlf


http://doc.4d.com/4Dv16/4D/16/XLIFF-and-translation.200-3246844.en.html

Then, Get Indexed String(20001;1) would give you "£###,###"

Or you could access your resources file with xml commands:
$path:=get 4d foler(resources folder)+folder 
separator+"en.lproj"+folder separator...

hth,

spencer

> On Oct 2, 2017, at 2:06 AM, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> If have defined, for example, “|Money” in the Filters tab of Toolbox as 
> "£#,###,##0;-£,##0”, I’d like to be able to resolve the format name into 
> the text of the format.
> 
> Is there a valid way in which it can be done?
> 
> Jeremy
> 
> 
> Jeremy Roussak
> j...@mac.com
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Programmatic control of accept/reject new connections

[Spencer Hinsdale via 4D_Tech]

wouldn’t you just
$0:=123

in On Server Open Connection DB Method

Spencer

> On Sep 27, 2017, at 7:38 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Can this be done in code? Or is there a way to default it to rejecting 
> connections when you start the server?
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: QUERY BY ATTRIBUTE is slow af

[Spencer Hinsdale via 4D_Tech]

isn't there some trick to use a character code instead of at?  

and does the "beginning and end" pref possibly apply?

> On Sep 12, 2017, at 8:22 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Trying to figure out why our experience with QUERY BY ATTRIBUTE is so 
> different than the demos at the last 4D Summit.
> 
> We're running 4D Server 16.2 64-bit on Windows. The Invoices table has about 
> 9 million rows, and we added an index to the Extra field in this table which 
> is an object field.
> 
> The following query always runs sequentially - i.e. very very slowly. 
> Thinking it might be a wildcard issue with the email we also tried strings 
> with no '@', but no matter what we do the query runs sequentially.
> 
> QUERY BY ATTRIBUTE \
>  ([Invoices];\
>   [Invoices]Extra;\
>   "gift_card_line_items[].to_email";=;"desig...@sweetwater.com")
> 
> 
> What are we doing wrong here? The query returns one row, 20 minutes later.
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Edit in list / subform / 4D v16

[Spencer Hinsdale via 4D_Tech]

read write([contacts])?

> On Sep 12, 2017, at 4:15 AM, Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I thought this would be a no brainer but it’s starting to become a nuisance…
> 
> I create a subform for a table [Contacts] inside the form for the table 
> [Customers]
> The subform is set to display the [Contacts] Output form, is set to ‘Edit in 
> list’ etc.
> 
> However, when I display the list of [Contacts] inside my [Customers] input 
> form, they display fine, are selectable.
> 
> There is NO WAY however to ‘edit in list’. Whatever I do. Click, long click, 
> etc.
> And yes, the fields are set to be ‘enterable’.
> 
> This is 4D v16.1, on Mac OS Yosemite, 4D developer mode.
> 
> 
> Am I overlooking something or just getting old? ;-)
> 

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

Re: 4D server "pausing" every 15 minutes

[Spencer Hinsdale via 4D_Tech]

could this have anything to do with new volume shadow copy feature?


> On Aug 24, 2017, at 8:05 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I just made a very interesting discovery and thought I'd share it with the 
> group -- it's timely given the recent blog post by 4D about dashboards.
> 
> We're huge fans of dashboards here at Sweetwater, and our dashboard tool of 
> choice is Prometheus. We use this on all our major servers -- Exchange, 
> Postgres, MySQL, and others.  We decided to add our 4D Server to the mix. 
> This server is a 24-core Dell server running Windows Server 2012 Datacenter, 
> and it hosts, at peak, around 540 simultaneous 4D users and around 3000-3500 
> 4D processes. It runs great and it is extremely stable.
> 
> For the 4D Server dashboard, we feed certain statistics directly from 4D via 
> a SQL function call (poor-man's web service), and we recently installed the 
> Prometheus wmi_exporter tool which exports operating system-related data from 
> the Windows Management Instrumentation Service (WmiPrvSE.exe) into Prometheus 
> format.  The wmi_exporter tool is very fast and you have to look fast to see 
> it consume any resources at all, but when it is running, the Microsoft 
> WmiPrvSe.exe process periodically wakes up and consumes 4% of our 24-core 
> server for 10-12 seconds. This happens about once every 15 minutes.
> 
> When this is happening, 4D Server slows to a crawl. Clients start to 
> beach-ball, pause, or have their network connections broken and throw runtime 
> errors. Some astute users actually noticed this 15 minute cycle, and after I 
> dug into it it turns out that is exactly the case and is 100% reproducible.
> 
> We had the dashboard turned on all day Tuesday, and we received dozens of 
> support tickets from users complaining about slow performance in 4D. On 
> Wednesday, we ran without the seemingly harmless wmi_exporter service 
> enabled, and we didn't receive a single support ticket.
> 
> My guess is that wmi_exporter may be asking for a particular statistic that 
> takes Windows a significant amount of time to collect. We may try to scale it 
> back and turn our measured statistics on one by one until we can determine 
> the problem. But until then, we can live without the dashboard (beautiful as 
> it was on the 60-inch 4K display...).
> 
> Jeff
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Heads Up about Write Pro Style Transformations

[Spencer Hinsdale via 4D_Tech]

i'm confused.  he's getting the right plain text. isn't he saying that if there 
were an emphatic style that displayed . as ! then the plain text ought to 
change to ! too ?

> On Aug 1, 2017, at 1:05 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Keith,
> If you used ST Get Text instead of Get Plain Text, then you maybe could
> strip out the style tags and end up with the correct plain text? (I haven't
> tried this).
> 
> Pat
> 
> On 1 August 2017 at 15:08, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> Well, It looks like this has been declared standard behavior.  I can't say
>> it's unexpected to see the words "style" and "cosmetic" in the same
>> vicinity.  I question their use with a text "transformation".  This is more
>> about user expectations.  "a" and "A" have always been understood, by
>> technical and non-technical users, to be two different character values.
>> 
>> Transforming a character from one case to another changes the value of the
>> character in Text Edit, Word, other 4D commands, and so on.  In Write Pro
>> there is no way to tell which character is in the text.  Suppose a client
>> wants their customer name list to be Capitalized.  Write Pro would be a
>> great tool for that, except the final product would be wrong.  They are
>> unable to depend on the data.
>> 
>> All users of any software that I have met, have an expectation that the
>> case of a character is a "real" thing, and the attributes like bold, etc...
>> are the "cosmetic" part.  It seems unfortunate to introduce this kind of
>> ambiguity.
>> 
>> Keith - CDI
>> 
>>> On Aug 1, 2017, at 4:10 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
>> wrote:
>>> 
>>> Hi Keith,
>>> I suppose it could be argued that ST Get Plain Text gets plain (i.e.,
>>> unstyled) text ... text in its raw form ... but I agree with your point
>> of
>>> view.
>>> 
>>> Pat
>>> 
>>> On 31 July 2017 at 15:09, Keith Culotta via 4D_Tech <
>> 4d_tech@lists.4d.com>
>>> wrote:
>>> 
 This is something to be aware of if you plan to use Write Pro text
>> outside
 of Write Pro areas.
 
 A bug report has been submitted, but for now Write Pro Style
 Transformations are cosmetic only.
 
 For instance, if you apply the Write Pro transformation
 Uppercase to "This is a Test",
 you will see "THIS IS A TEST" in the document.
 
 If you copy the text, or retrieve it using "ST Get plain text", you end
>> up
 with "This is a Test".
 
 Keith - CDI
 **
 4D Internet Users Group (4D iNUG)
 FAQ:  http://lists.4d.com/faqnug.html
 Archive:  http://lists.4d.com/archives.html
 Options: http://lists.4d.com/mailman/options/4d_tech
 Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
 **
>>> 
>>> 
>>> 
>>> 
>>> --
>>> *
>>> 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)
>>> FAQ:  http://lists.4d.com/faqnug.html
>>> Archive:  http://lists.4d.com/archives.html
>>> Options: http://lists.4d.com/mailman/options/4d_tech
>>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>>> **
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: http://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
>> 
> 
> 
> 
> -- 
> *
> 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)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D Forums no longer accessible -- too many redirects

[Spencer Hinsdale via 4D_Tech]

I guess I should have mentioned that it works fine for me, just the sign-on is 
new and improved

> On Jul 27, 2017, at 8:18 AM, Spencer Hinsdale  wrote:
> 
> 
> they have implemented Single Sign On.  there was a banner that took me to 
> partners sign-on, then a button to "migrate forums logon" or some such.  
> sorry to be vague. :)
> 
> 
>> On Jul 27, 2017, at 8:17 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com 
>> > wrote:
>> 
>> Is there a new way to access forums.4d.fr ? For the 
>> past few days I haven't been able to reach this site -- Safari displays an 
>> error saying too many redirects.
>> 
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html 
>> Archive:  http://lists.4d.com/archives.html 
>> 
>> Options: http://lists.4d.com/mailman/options/4d_tech 
>> 
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
>> 
>> **
> 

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

Re: 4D Forums no longer accessible -- too many redirects

[Spencer Hinsdale via 4D_Tech]

they have implemented Single Sign On.  there was a banner that took me to 
partners sign-on, then a button to "migrate forums logon" or some such.  sorry 
to be vague. :)


> On Jul 27, 2017, at 8:17 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Is there a new way to access forums.4d.fr? For the past few days I haven't 
> been able to reach this site -- Safari displays an error saying too many 
> redirects.
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Serious 4D Internet commands issue in v15.4 with SMTP on Mac OS X

[Spencer Hinsdale via 4D_Tech]

Hi Paul,

Look at forms being used for data entry to see if these text fields have the 
Multi-style checkbox checked in Properties.

Here is a v14 picture:
http://kb.4d.com/assetid=77175

And v15 feature:
http://livedoc.4d.com/4D-Design-Reference-15.4/Properties-for-active-objects/Multi-style-Rich-text-area.300-3285451.en.html




> On Jul 25, 2017, at 9:36 PM, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> It seems this does not do the trick in all instances.
> 
> It appears there may be a problem with the text in the fields. I exported to 
> text and everything looks fine but some texts truncate with a “?” when the 
> email is sent. I have re-typed some of the offending texts and they work 
> fine. The strange thing is they are identical, character-to-character, to the 
> texts that are truncating in the emails. Could it be something to do with a 
> length byte or something else that 4D stores along with the text in the 
> fields?
> 
> 

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

Re: Packages-building an installer

[Spencer Hinsdale via 4D_Tech]

Assuming you are talking about Apple's PackageMaker, you can use a shell script 
to set read-write.  For the Package there is a Scripts tab with an entry for 
Postinstall that will run after install.  I think you are using this for 
AppleScript already.

You can create a shell script by going to Terminal and typing "pico" to run the 
text editor.

Then type a script like:
#!/bin/sh
chmod -R 777 '/Applications/MyApp'

Type control-x (shown as ^x at the bottom of the window) to eXit and follow 
prompts to save as something like "myscript".

Back in Package, Scripts, Postinstall select your script (/Users/me/myscript).  
This script just says use bourne shell (bin/sh) set all contents (-R) to 
read-write for all (777).

hth,


Spencer


> On Jul 11, 2017, at 4:12 AM, Nigel Greenlee via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi
> 
> I wondered if anyone else has used ‘Packages’ for creating an installer(maybe 
> you can suggest a similar product). I am creating a simple installer for an 
> in-house application-i will rather give the users a link to an installer than 
> a .zip as they have a habit of installing stuff on the desktop.(this is on 
> OSX only)
> 
> I know this is slightly ‘off topic'
> 
> I am however having two problems:-
> 
> The first is with permissions. If i zip the .4dbase up and send it to a 
> machine the installed app runs fine. However when i create an installer 
> package(with user persmissions set to Owner Root and user Admin(i also tried 
> user Wheel) The installed application does not have the correct permissions 
> and wants to open read only. I wondered if anyone has a suggestion to 
> overcome that.
> 

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

Re: Error -19191

[Spencer Hinsdale via 4D_Tech]

this is cant use new network layer from old clients...
http://kb.4d.com/assetid=77427 

Spencer


> On Jun 27, 2017, at 6:15 AM, Douglas Cryer via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi,
> 
> We have a client trying to connect to a database from Austria and they are 
> getting a -19191 error when trying to connect.
> 
> Anyone know what this error is?
> 
> Regards,  Dougie
> 
> 
> telekinetix Limited- J. Douglas Cryer
> Phone : 01234 761759  Mobile : 07973 675 218
> 2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
> Email : jdcr...@telekinetix.com   Web : 
> http://www.telekinetix.com 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Rotate Picture in 4D

[Spencer Hinsdale via 4D_Tech]

did you try 270?

> On Jun 25, 2017, at 12:51 PM, Peter Mew via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi
> I am trying to use Miyako's rotate picture component in v13.
> I dont know if its not compatible but It wont run.
> So Ive extracted the code and made it a subroutine (Rotate_Picture)
> 
> C_PICTURE($1;$0)
> C_REAL($2;$w;$h;$ww;$hh;$s;$c)
> 
> PICTURE PROPERTIES($1;$w;$h)
> 
> $s:=Sin($2*Degree)
> $c:=Cos($2*Degree)
> 
> $ww:=($w*$c)+($h*$s)
> $hh:=($w*$s)+($h*$c)
> 
> $svg:=SVG_New ($ww;$hh)
> $g:=SVG_New_group ($svg)
> $image:=SVG_New_embedded_image ($g;$1;($ww/2)-($w/2);($hh/2)-($h/2))
> SVG_SET_TRANSFORM_ROTATE ($g;$2;$ww/2;$hh/2)
> 
> $0:=SVG_Export_to_picture ($svg)
> SVG_CLEAR ($svg)
> 
> 
> I then Call
> New_Picture:=Rotate_Picture(Old_Picture;degrees)
> 
> If I call this routine with 90 as the rotation degrees it works, if I try
> with -90 degrees it doesnt. Can anyone see why and suggest a modification
> to make it so
> thanks
> -pm
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Big Commerce v3 API

[Spencer Hinsdale via 4D_Tech]

can't you "manually" enter this detail, then get to see format, then put same?

-spencer

On Jun 11, 2017, at 12:33 AM, J. Douglas Cryer via 4D_Tech 
<4d_tech@lists.4d.com> wrote:

>> An unlikely ask but:
> 
>> Has anyone out there had any experience with integrating to Big Commerce
>> v3API?  I have done an integration but I am stuck on a very specific
>> issue of trying to add variants to an existing product.  BC
>> Documentation, Community and Support are all a bit useless for this kind
>> of detail.
> 
> Regards, Dougie
> 
> 
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Need plugin that will set macOS window modified indicator

[Spencer Hinsdale via 4D_Tech]

compiled!

thanks, Jeremy!

> On Jun 8, 2017, at 6:37 AM, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Try using 1 and 0 instead of True and False for the third parameter.
> 
> Jeremy
> 
> 
> Jeremy Roussak
> j...@mac.com
> 
> 
> 
>> On 8 Jun 2017, at 14:00, Spencer Hinsdale via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> Awesome!
>> 
>> I tried this and am having a problem creating a generic usage for "current 
>> window"...
>> 
>> I get compiler errors:
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Need plugin that will set macOS window modified indicator

[Spencer Hinsdale via 4D_Tech]

Awesome!

I tried this and am having a problem creating a generic usage for "current 
window"...

I get compiler errors:
the result of the function is not compatible with the expression
this value cannot be passed as a parameter to this method or command

from this line of code:
WINDOW SET ENABLED (Current form window;Window document modified;True)


Thanks!

Spencer

> On Jun 7, 2017, at 6:47 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> just posted:
> 
> https://github.com/miyako/4d-plugin-window-button
> 
>> 2017/06/08 4:25、Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> のメール：
>> 
>> I’m looking for a plugin that can be used with 4D v14+ to set the window 
>> modified indicator. You know the little black dot in the center of red close 
>> button in the window title bar.
>> 
>> I found a Miyako plugin called “Carbon Window Manager” but it specifically 
>> states it only works with old style Carbon windows. Newer versions of 4D 
>> have native Cocoa windows.
>> 
>> Miyako do you have a plug that works with current versions of 4D?
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: printing listbox v 15.4hf2

[Spencer Hinsdale via 4D_Tech]

I think someone recently posted a link to 4d today:
http://www.4dtoday.com

there is a generic list box print routine on the home page

however, since the host is in Australia it appears the site is actually 4D 
TOMORROW  :)

> On May 17, 2017, at 9:56 AM, Timothy Penner via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi Chuck,
> 
> There is an example in the docs:
> http://doc.4d.com/4Dv15/4D/15/LISTBOX-GET-PRINT-INFORMATION.301-2007323.en.html
> 

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

Re: Bar code

[Spencer Hinsdale via 4D_Tech]

Try PNG. I think scaling does not work with SVG because of crisp edges.

-Spencer

> On May 8, 2017, at 1:57 AM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hello,
> 
> I try to use Picture:=Picture*,09 but not work because some part of bar code 
> are differents
> 
> Thanks
> Ferdinando
> 
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Moving a window

[Spencer Hinsdale via 4D_Tech]

same works on windows except:
- modifier keys are different (see docs?)
- instead of one button, first hold right-mouse-click, then hold 
left-mouse-click TOO, then drag

> On Mar 31, 2017, at 6:26 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Should be easy enough ... right?
> Nope!
> Using Windows 7 (or any version of Windows, probably) we've opened a window
> in a new process, and it has somehow got itself moved up too far so that
> the title bar is hidden. On the Mac I can easily fix this by cmd+ctrl+click
> and drag. On Windows this can be done by typing Alt-spacebar-M. But that
> only works on the main 4D window - not the process window.
> 
> How can I move the process window if I don't have access to the title bar?
> 

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

Re: Copy or Drag from a listbox?

[Spencer Hinsdale via 4D_Tech]

http://kb.4d.com/assetid=49867 
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: auto update of clients

[Spencer Hinsdale via 4D_Tech]

19191 is the new-protocol error.  old clients can only update themselves if you 
use the old network layer option in compatibilty 
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**