Re: iNUG Messages ― Is it time for it to be more than just 'plain text' ???

[Jeffrey Kain via 4D_Tech]

Same here - see y'all over there

> On May 6, 2020, at 1:37 PM, Jim Labos - infobase via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Yes! Finally! I'll be using the new one from now on.
> 
> However! Let's leave this one alone at least for searching old posts.
> 
> Looking forward to seeing you all on the new forum.

**
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: Multple windows within the same process

[Jeffrey Kain via 4D_Tech]

A lot more scalable too - one server process per client dedicated to the UI, no 
matter how many windows are open locally...

> On Apr 29, 2020, at 11:52 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Where workers come in is to do, well - work. All the heavy processing be it
> lookups, calculations, whatever can be done by workers and just the results
> are pass back to the form that initiated them. It's a really different way
> of thinking about building your forms.

**
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: Multple windows within the same process

[Jeffrey Kain via 4D_Tech]

DIALOG with the More Power parameter (*)... it's not a dream!

> On Apr 29, 2020, at 7:17 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Maybe it was in a dream ... but I'm sure I recall reading something about a
> new feature (v17) that allows more than one window to be open within a
> process. But now I can't find that info. Did I imagine it?
> Pat

**
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: WAN vs LAN Cache

[Jeffrey Kain via 4D_Tech]

In v17R5 that number changes if you use different instances of 4D.  As long as 
you use the same copy of the 4D application then it uses the same cache folder.

Is this on Mac or Windows, and where is your 4D application installed?

> On Apr 28, 2020, at 2:08 PM, Mitchell Shiller via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Today I logged in 4 times and have 4 caches folders all 228mb in size   
> Screenshot available on request.

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

Re: Long running reports

[Jeffrey Kain via 4D_Tech]

Hey John - 

If it's on a Windows server, check out Process Monitor (procmon). It runs in 
the background and gives you a log of every filesystem activity. It's pretty 
amazing the stuff it reveals... but it should be able to track down who/when 
deleted your file:

https://docs.microsoft.com/en-us/sysinternals/downloads/procmon



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

[Jeffrey Kain via 4D_Tech]

This is what I do as well.  Drop User doesn't work at all in v17R5, but killing 
off the processes does.

The issue of ghost users sounds like our experience when we tried the 
not-so-new network layer. We don't see it very often at all with the legacy 
network.

> On Apr 15, 2020, at 12:04 PM, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> The user was dropped when the last process successfully aborted.

**
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: NTK 32K limit in TCP Receive

[Jeffrey Kain via 4D_Tech]

Yeah, can you imagine how they could have sold and marketed 4D with A4D built 
in? Nothing on the market would have come close.

> On Apr 10, 2020, at 5:03 PM, James Wright via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> So should Active4D!

**
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: NTK 32K limit in TCP Receive

[Jeffrey Kain via 4D_Tech]

:)

I miss the days of lots of thriving plug-ins.  NTK should really be built into 
4D.

> On Apr 10, 2020, at 4:49 PM, Aparajita Fishman via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
>> Overreact much?
> 
> Yes, I do. All the time unfortunately.
> 
> We plugin authors are a dying breed. I plead guilty of circling the wagons.

**
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: NTK 32K limit in TCP Receive

[Jeffrey Kain via 4D_Tech]

> On Apr 10, 2020, at 1:09 PM, Aparajita Fishman via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> The documentation clearly says 32000 is the default maximum to read if you 
> **DON’T** specify the maximum. So I have to agree with Rob — what exactly is 
> the problem? Is it really so difficult to type a few more characters to 
> override the default?

You can specify a larger maximum but it doesn't work.

Also, the documentation also says 32000 is the maximum size of a text variable, 
which is wrong.

> Have any of you actually thought about what would happen if the default were 
> much larger? Do you think it should default to the maximum size of a modern 
> text variable, 2GB? Let’s say you have multiple listening processes receiving 
> data. An attacker sends 2GB+ multiple times simultaneously. Your server is 
> now dead, because all of the physical memory has been exhausted.

Overreact much?  Yesterday I needed 32023 bytes.  Fixed it, moved on, posted a 
light-hearted comment to this thread that maybe something got overlooked.

> NTK is awesome, keep up the great work, Rob!

Agreed.
**
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: NTK 32K limit in TCP Receive

[Jeffrey Kain via 4D_Tech]

Two problems;

First, the maximum size of a text variable isn't 32000 bytes anymore, which 
leads me to believe this was an oversight and not a feature... :)

Second, it was easy to receive text until a stop character is received, as long 
as the data is less than 32K.  When your packets become larger than 32K it 
becomes more complicated.  In my use case it was easy since we'll only ever 
receive one 'packet' per connection, but the code grows more complicated if you 
need to support an arbitrary number.

What's the problem with removing the arbitrary 32K limit?

> On Apr 10, 2020, at 9:09 AM, Rob Laveaux via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> The data that is available from the stream can be any arbitrary size. The 
> plugin does not know upfront how many bytes are available, so it needs a 
> limit. There is a default value, which you can override if it doesn’t suit 
> you.
> 
> So please tell me, what is the 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
**

Re: NTK 32K limit in TCP Receive

[Jeffrey Kain via 4D_Tech]

Nope, it's for real.

Easy enough to loop, etc.. But it's a bit of an anachronism in a modern plug-in 
like NTK.

> On Apr 9, 2020, at 4:24 PM, Ben Kershaw via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
>> Why? :)
>> "The bufferSize parameter indicates the maximum number of bytes to read. If 
>> it is omitted or set to 0, the plugin will use the maximum size for a text 
>> variable (32000 bytes).”
> 
> Have you tested it to make sure it’s not just a documentation error?

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

NTK 32K limit in TCP Receive

[Jeffrey Kain via 4D_Tech]

Why? :)

"The bufferSize parameter indicates the maximum number of bytes to read. If it 
is omitted or set to 0, the plugin will use the maximum size for a text 
variable (32000 bytes)."
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: v17.4 and UUIDs

[Jeffrey Kain via 4D_Tech]

Bug in your code?

> On Mar 27, 2020, at 11:44 AM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I would have assumed that all UUIDs would be filled. Indeed, most of them 
> were, but there were a few tables where there were duplicate values. Any 
> ideas as to why

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

[Jeffrey Kain via 4D_Tech]

You've got a smart quote in there... email post typo or is it in your code?

Could the line ending have change to something else like \n ?

> On Mar 25, 2020, at 9:31 PM, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I have a tab delimited text file and I want to get the first row with…
> 
> C_TEXT($TextValue)
> $DocRef:=Open document($IndexPath)
> RECEIVE PACKET($DocRef;$TextValue;”\r")
> CLOSE DOCUMENT($DocRef)
> 
> This was working fine until about an hour ago when it suddenly started 
> bringing in the whole document which has many rows. Using “\t” works fine 
> just bringing the first field in the first row.
> Any ideas?
> 
> Mac OS High Sierra
> 4D v14 in Unicode mode

**
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: ds.Table.query() field not available

[Jeffrey Kain via 4D_Tech]

Never seen this.  Remember everything in ORDA is case sensitive. 

> On Mar 9, 2020, at 10:08 PM, Sannyasin Siddhanathaswami via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> When I do a ds.Table.query() using a field/attribute of a non-indexed field, 
> I get an error.
**
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: Editing a time in a collection-based list box

[Jeffrey Kain via 4D_Tech]

Thanks, Erick...

> On Feb 14, 2020, at 3:48 PM, ericklui678 via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> You will have to convert the longint to Time then to a String in the
> Expression pane of the property list as shown below:
> 
> https://kb.4d.com/assetid=78298

**
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: Runtime Explorer

[Jeffrey Kain via 4D_Tech]

You can call CHANGE CURRENT USER on the fly - maybe add a button to your 
developer palette if you have one, or a button or menu command somewhere in 
your UI that only you have access to - and do a quick switch to Designer as you 
need it.  I do the same thing for OPEN ADMINISTRATION WINDOW.

> On Feb 1, 2020, at 4:33 PM, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> My understanding is that this is because I am signed in doing programming as 
> someone other than the designer. 

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

Re: 4D v16 in mixed mode 32 and 64bit

[Jeffrey Kain via 4D_Tech]

V17 64-bit is much better and unsupported now. It may have issues with Catalina 
that will never be fixed. 

I’d skip it and go to v17 or v18.  

> On Jan 29, 2020, at 4:45 AM, Andrew Hobson via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Until now, my main 4D Application runs on 4D v15.
> With new computers arriving installed with MacOS 10.15 Catalina, I need to
> move to 4D v16 and 64bit
**
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 Application as a 3-tier System

[Jeffrey Kain via 4D_Tech]

For a load balancer, you shouldn't care.  There's nothing special about 4D's 
web server.

> On Jan 28, 2020, at 4:54 PM, Stephen J. Orth via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> As an OEM, I do not get to dictate how the network is configured, or what 
> hardware can/cannot be purchased.  How, as an OEM solution provider, do I 
> build a web based solution knowing I cannot control these critical aspects?

**
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 Application as a 3-tier System

[Jeffrey Kain via 4D_Tech]

I don't manage them, but we use A10 load balancers for our 4 4D Client 
instances running as virtual machines that serve web service requests from our 
website and a variety of other non-4D applications. The 4D Clients are running 
an HTTP server based on NTK (very very similar to the sample HTTP server 
provided with NTK). It's pretty easy to add and remove clients if we need to 
beef up the number of 4D Client instances for a big event, or scale back if a 
VM goes offline or whatever

https://www.a10networks.com/products/thunder-adc/

I remember at Orchard that some of our more advanced customers also installed 
load balancers in front of 4D Client-based 4D web servers, pretty much on their 
own.  Your 4D code has no idea that there's a load balancer running, so you 
don't have to write anything special for it.

HTH (better) :)

Jeff

> On Jan 28, 2020, at 4:34 PM, Stephen J. Orth via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I was hoping for more specifics like:
> 
> 1. What options are available?
> 2. How it works with 4D?
> 3. Has anyone done this as an OEM and what issues/obstacles have you run 
> into?
> 4. and so forth...
> 
> This may be an ignorant request, but it's an area I know very little about, 
> but want to learn more.

**
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 Application as a 3-tier System

[Jeffrey Kain via 4D_Tech]

You stick a load balancer in front as the public-facing IP and let the load 
balancer, uh, balance the load.

> On Jan 28, 2020, at 4:22 PM, Stephen J. Orth via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> So, what is the solution for balancing multiple 4D Client web servers?

**
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 v17 and catalina

[Jeffrey Kain via 4D_Tech]

Maybe Spotlight isn't done indexing yet after the upgrade?

Catalina seems slightly faster to launch apps for me.

> On Dec 30, 2019, at 3:32 PM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am running combination on my development machine. Does anyone else notice 
> how slow 4D is in loading. Am I imagining that 4D and other programs are slow 
> to load

**
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: Automatic Excel to Text-tab delimited?

[Jeffrey Kain via 4D_Tech]

4D View Pro is also really nice and can read and write xlsx files. It’s a 
wrapper for spreadJS integrated into the 4D environment:

https://tinyurl.com/v7rz3r5

> On Dec 12, 2019, at 3:06 PM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Converting Excel to Text is a problem that others have tackled, so I would 
> rely on their work rather than trying to build it yourself. Plugger’s XL 
> Plugin is probably something you should look at, if you haven’t already. 
> There are components and libraries that do similar things with Excel docs, 
> but Rob’s stuff is very solid.

**
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: High Sierra or Mojave?

[Jeffrey Kain via 4D_Tech]

There's really no need for Catalina in my opinion. No big improvements, lots 
more headaches... 

The phrase macOS's Vista is pretty appropriate... :)

> On Dec 10, 2019, at 8:31 PM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Mohave works fine with 4D 17 including Mac Mini configurations older than 
> 2014. Catalina will be another story...

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

Re: Can't Define DEP Exception On Windows

[Jeffrey Kain via 4D_Tech]

Hey Ken  -

DEP hasn't been an issue for a very long time, unless you have some old plug-in 
that's requiring it. I thought it was since v11 or maybe even v2004... for sure 
v15 doesn't need it.

> On Dec 10, 2019, at 7:48 PM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Everyone,
> 
> I have a customer who has a Windows 2008 R2 Server.  I had 4D v12.5 installed 
> on the machine and added 4D Server and 4D Client v12 as DEP exceptions.  
> These ran with no problems for many years.  I want to update the 4D software 
> on the same machine to v15.4 and when I attempt to add the 4D Server v15.4 
> and 4D Client v15.4 applications to the DEP exceptions list, Windows displays 
> the following message:
> 
>"This program must run with data execution prevention (DEP) enabled.  You 
> cannot turn off DEP for this program."
> 
> I'm wondering if the 4D v15.4 applications will run properly without the DEP 
> exception, or if there is something that I need to configure in order to 
> allow DEP exceptions to be added for the 4D Server v15.4 and 4D Client v15.4 
> applications.

**
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: Jumpy forms in 64-bit

[Jeffrey Kain via 4D_Tech]

Hey Doug - 

I've never seen that, but I will say that I could never get our application to 
function properly on v16 in 64-bit mode. In contrast, on v17, it fired right up 
and required minimal changes.  Not sure if a v17 upgrade is possible, but maybe 
you could try it and see if that just magically fixes your issue.

> On Nov 22, 2019, at 3:42 PM, Doug Hall via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> So, why do my forms jump around in 64-bit mode when resizing the window?
> They don't do this in the same version, 32-bit app. (v16.6)

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

Re: FYI: [v17.3] Get System Info on Windows 10

[Jeffrey Kain via 4D_Tech]

The power button on the TV screen doesn't turn off the PC :)

> On Nov 6, 2019, at 7:47 AM, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I started the Win10-Box about 10 minutes before conducting the tests… 
> 
> 
> Out of curiosity I went to “Task Manager - Performance” and found out that 
> Win10 was running for the last 28+ 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: MySQL connection from 4D

[Jeffrey Kain via 4D_Tech]

Are you sure it's version 3? According to Wikipedia that version dates back to 
the 1990s... :)

Jeff



> On Oct 28, 2019, at 11:40 AM, Nigel Greenlee via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi
> 
> Does anyone know if 4D is able to connect to a MySQL server running version 
> 3x? 

**
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: Cache flushing did not complete... best practice

[Jeffrey Kain via 4D_Tech]

Or use a mirror. Highly recommended if the database is important...

> On Oct 28, 2019, at 12:59 PM, JPR via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> The only 100% accurate way is to restart from the Backup file (made by 4D) 
> and  integrate the current log file(s). This is the only way to be sure of 
> the data integrity.

**
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: MySQL connection from 4D

[Jeffrey Kain via 4D_Tech]

If you don't get anywhere with SQL LOGIN (which should work, given the right 
driver settings), Pluggers Software sells the MyConnect plug-in which works 
perfectly and is very fast/reliable.

https://www.pluggers.nl/product/myconnect-plugin/

We've been using it for many years performing crucial functions interfacing 4D 
with our web stack that run 24x7x365.

> On Oct 28, 2019, at 11:40 AM, Nigel Greenlee via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Should I be doing something else other that SQL 
> LOGIN(ODBC:xx.xx.xx.xx;username;password) for a MySQL server?

**
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: Capturing barcodes without a 'text' field

[Jeffrey Kain via 4D_Tech]

If you want to use a USB barcode scanner and still have complete control, you 
can use ON EVENT CALL to manage this. You'll need to program a prefix character 
and a suffix character into the barcode scanner, and have your ON EVENT CALL 
method watch for these characters to determine what to do.

For example, if you scan the text 123, and your barcode prefix character is 
 and the suffix character is , the stream passed to 4D will look like 
this:

123

So - for those forms where you want to process a barcode, you install an ON 
EVENT CALL method that's waiting for an  keypress event. When it sees one, 
it starts collecting the subsequent characters into a text variable (and 
filtering them from the event stream that would otherwise pass those characters 
to the form) until it sees an .

When it sees an , it stops collecting characters and then passes the 
buffer of what it collected back to the form (CALL FORM or CALL PROCESS if 
you're on an older version of 4D).

It's a fair amount of code and it takes awhile to shake out all the bugs, but 
it gives you complete control over the barcode scanner.

Jeff

On Oct 15, 2019, at 7:25 PM, Peter Jakobsson via 4d_tech@lists.4d.com> wrote:

> Was wondering what technique people used for capturing scans into 4D. At
> the moment I’m using a simple text field and the scanner simply ‘pastes’
> the code into the text field, but something a bit more sophisticated is
> called for ideally where a scan can be “detected” by the 4D form even
> though no text field may be present. (e.g. as one of a number of possible
> form actions or as an alternative to a manual lookup of the product).

**
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: QUERY WITH ARRAY - SQL Equivalent?

[Jeffrey Kain via 4D_Tech]

SELECT ... FROM Table WHERE [ID] in ( comma separated list of IDs )

ID is a reserved word in sql so if that’s the name of your field you need to 
escape it (I use brackets in 4D). 

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

Re: Object property inheritance - why does this this not work ?

[Jeffrey Kain via 4D_Tech]

I think you should stop thinking about dot notation as object orientation. 
Concepts like classes and inheritance aren't supported yet, and saying 
$animal:=$dog isn't inheritance -- it's just assigning one object's reference 
to another and kind of backwards at that.

Don't try to fit a square peg into a round hole just yet. 4D has said these 
things are coming.

4D had a weird example in their blog, though... you could make a method called 
"New Animal" (yes, with a space... cheap trick), that creates an object and 
sets some properties for all animals. Then you could write

$dog:=New Animal

... and then start customizing the properties of dog based on the 
not-really-a-superclass Animal. 

I think this is a waste of time knowing that a proper implementation is coming 
someday... and having a space in the method name is bad enough, but there's no 
proper support for this in the language, debugger, or compiler yet, and you'll 
probably end up rewriting it all someday relatively soon anyway.

> On Sep 15, 2019, at 6:12 AM, Peter Jakobsson via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Using the v17 dot notation I was unable to get one object to inherit 
> another’s properties using the assignment operator. Also when I inspect $dog 
> in the debugger after assigning the first property, it appears empty.

**
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: Sweetwater is hiring!

[Jeffrey Kain via 4D_Tech]

Oops - here's the link to our virtual tour:

https://www.sweetwater.com/tour/

> On Sep 13, 2019, at 5:44 PM, Jeffrey Kain  wrote:
> 
> Sweetwater is looking to add a Database Programmer/Application Developer to 
> our existing team of developers. As a Database Programmer, you will be 
> responsible for continuing the development of our custom business management 
> package running on 4D and PostgreSQL, supporting over 1500 users. 
> 
> This is a full-time position that requires relocation to our headquarters in 
> Fort Wayne, IN. 
> 
> Qualifications:
> 
>   • Expertise in a modern programming language such as 4D, Visual Basic, 
> C#, SQL
>   • Strong relational database skills
>   • Desire for a modern design and user experience
>   • Two years of programming experience
>   • High level of common sense and business judgment
>   • Willingness to keep up to date on all new technologies
>   • Sense of urgency and ability to thrive in a fast-paced environment
> 
> You can take a virtual tour of our amazing campus here:
> 
> If you're interested in joining a growing team of developers in the midwest, 
> please email me -- we'd love to talk with you.

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

Sweetwater is hiring!

[Jeffrey Kain via 4D_Tech]

Sweetwater is looking to add a Database Programmer/Application Developer to our 
existing team of developers. As a Database Programmer, you will be responsible 
for continuing the development of our custom business management package 
running on 4D and PostgreSQL, supporting over 1500 users. 

This is a full-time position that requires relocation to our headquarters in 
Fort Wayne, IN. 

Qualifications:

• Expertise in a modern programming language such as 4D, Visual Basic, 
C#, SQL
• Strong relational database skills
• Desire for a modern design and user experience
• Two years of programming experience
• High level of common sense and business judgment
• Willingness to keep up to date on all new technologies
• Sense of urgency and ability to thrive in a fast-paced environment

You can take a virtual tour of our amazing campus here:

If you're interested in joining a growing team of developers in the midwest, 
please email me -- we'd love to talk with you.
**
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: Views - how to access them

[Jeffrey Kain via 4D_Tech]

with a SELECT.  The FROM is your view name.  And remember views are read only.

> On Sep 12, 2019, at 3:01 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> How do I access the data in the view?

**
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 authentication system that allow for stronger security.

[Jeffrey Kain via 4D_Tech]

If your organization has AD or LDAP servers already I can't think of a 
drawback...


> On Sep 6, 2019, at 9:33 AM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Is there some news about Active Directory which I’ve missed lately? What 
> weaknesses should I be concerned enough about to devote my efforts at "home 
> brewing" something better?
> 
> Thanks,
> 
> Tom Benedict
> 
>> On Sep 6, 2019, at 06:15, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> Jeffrey,
>> 
>>> On 6 Sep 2019, at 01:17 AEST, Jeffrey Kain via 4D_Tech 
>>> <4d_tech@lists.4d.com> wrote:
>>> 
>>> 4D integrates well with Active Directory/LDAP servers. That's probably the 
>>> best way to go, along with some custom code to track failed login attempts
>> 
>> 
>> Arrgh, do you rely believe trusting/relying on an outside “system” is worth 
>> even considering?
>> 
>> Please think again, and than think different and again… 
>> 
>> Just as a warning,  “Active Directory” and everything coming from Microsoft 
>> - use at your customer risk…
>> 
>> 
>> EOD - no further comments!!
>> 
>> … my 2 ¢
>> 
> 
> **
> 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: "automatically repaired method"

[Jeffrey Kain via 4D_Tech]

Tom - 

We used to see this a lot after a repair. To confirm Miyako's comments, it 
seems to not happen very much anymore, and it seems like this should be 
impossible once we start using project mode someday.

Jeff

> On Sep 6, 2019, at 5:43 AM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Thanks for the comments. In this particular case, it happened on a object 
> method for a tab control (two tabs) on a form. Interestingly, I had 
> duplicated the form in the days prior to the MSC Repair and both instances 
> were “automatically repaired”.
> 
> Tom Benedict
> 
>> On Sep 6, 2019, at 01:09, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> seems like complex manipulation (combination of redo, undo, copy, paste, 
>> cut, duplicate, group, ungroup) can create orphans and widows.
>> less frequent with newer versions, but as long as resources are managed by 
>> association (itself not a bad solution) sync issues can happen.
>> 
>> 2019/09/06 4:08、Tom Benedict via 4D_Tech 
>> <4d_tech@lists.4d.com>のメール:
>> What would cause this to happen? No other errors in nearly 50,000 objects.

**
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 authentication system that allow for stronger security.

[Jeffrey Kain via 4D_Tech]

4D integrates well with Active Directory/LDAP servers. That's probably the best 
way to go, along with some custom code to track failed login attempts

> On Sep 5, 2019, at 10:22 AM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Does anyone have a replacement login system for 4D that offers stronger 
> authentication security than the current system. Since the current system 
> does not enforce password changes, or password complexity it is a pretty poor 
> system in the current age. While the encryption is crypt is is still brute 
> force attackable as well. There are no failed login lockouts. Nor is three 
> the ability to have two factor authentication? Or is this something beyond 
> what anyone out there is using. 

**
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: Possible to SELECT a record number?

[Jeffrey Kain via 4D_Tech]

Great - thank you!


> On Aug 29, 2019, at 9:46 PM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> select the virtual field __ROW_ID
> 
> https://doc.4d.com/4Dv16/4D/16/Replication-via-SQL.300-3201184.en.html
> 
>> 2019/08/30 7:10、Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com>のメール:
>> Is it possible to SELECT a 4D record number in the SQL engine? I'm not 
>> finding it in the documentation yet but I thought there was a way.

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

Possible to SELECT a record number?

[Jeffrey Kain via 4D_Tech]

Is it possible to SELECT a 4D record number in the SQL engine? I'm not finding 
it in the documentation yet but I thought there was a way.

Thanks in advance...

Jeff
**
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: Win32API setup woes

[Jeffrey Kain via 4D_Tech]

Hey David,

Why are you using a Win4DX folder and not just putting the bundle into the 
Plugins folder?

I’d start there.  

> Both are Windows and version 16.3 of 4D single user.  Both have the
> WIN32API.4dx and WIN32API.rsr installed in the \Win4DX directory found in
> the same directory as the .4DB
**
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

[Jeffrey Kain via 4D_Tech]

Yes, as far as I know.  But default R5 reindexes your alpha/text fields only.

> On Aug 9, 2019, at 7:13 AM, Spencer Hinsdale  wrote:
> 
> can you drop indexes for the conversion?
> 
> Spencer

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

[Jeffrey Kain via 4D_Tech]

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

Overlapping Objects in Data Segment #65

[Jeffrey Kain via 4D_Tech]

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

Re: Sending Text Messages From 4D

[Jeffrey Kain via 4D_Tech]

Are you URLEncoding the body of the text message?

Also, We have the country code with every phone number including the sending 
phone number (1 for US).  Did you try that?

> On Aug 5, 2019, at 2:06 PM, Jeffrey Kain  wrote:
> 
> Here's what I wrote for our app ($tUserName would be unique to you, along 
> with $tPassword and $tFromNumber). The method HTTP_Request_Build is just 
> building a text variable like:
> 
>"From=155=156=This%20is%20the%20text"
> 
> String_FixURL is just a URL-encode method that Miyako posted awhile back 
> (included at the end of this message).   
> 
> Also note that we're hard-coding the country code at '1' for US numbers only.
> 
>  // Twilio_Send
>  //
>  // $1 - TEXT - SendTo phone number
>  // $2 - TEXT - Message to send
> 
> C_TEXT($1;$tSendToNumber)
> C_TEXT($2;$tMessage)
> $tSendToNumber:=$1
> $tMessage:=$2
> 
> C_TEXT($tURI;$tUserName;$tPassword;$tPlugin;$tInfo;$tFromNumber;$tRequest;$tResponse)
> C_LONGINT($lJson;$lHTTPStatus;$lTimeout;$lPort)
> 
>  // Stuff unique to your Twilio account
> $tUserName:="Your Twilio username"
> $tPassword:="Your Twilio password"
> $tFromNumber:="Your Twilio mobile account number"
> 
> $tURI:="https://api.twilio.com/2010-04-01/Accounts/"+\
>  $tUserName+"/Messages.json"
> $tFromNumber:="+1"+$tFromNumber
> $tSendToNumber:="+1"+$tSendToNumber
>   
> $tRequest:=""
> HTTP_Request_Build (->$tRequest;"From";String_FixURL ($tFromNumber);"*")
> HTTP_Request_Build (->$tRequest;"To";String_FixURL ($tSendToNumber);"*")
> HTTP_Request_Build (->$tRequest;"Body";String_FixURL ($tMessage))
>   
> ARRAY TEXT($atHeaderNames;0)
> ARRAY TEXT($atHeaderValues;0)
> APPEND TO ARRAY($atHeaderNames;"content-type")
> APPEND TO ARRAY($atHeaderValues;"application/x-www-form-urlencoded")
> HTTP AUTHENTICATE ($tUserName;$tPassword;HTTP basic)
> $lTimeout:=10
> $lHTTPStatus:=HTTP Request (HTTP POST 
> method;$tURI;$tRequest;tResponse;$lTimeout;$atHeaderNames;$atHeaderValues)
> 
> 
>  // String_FixURL
>  //
>  // Returns urlencoded string in $0 from the string passed in $1
> 
> C_TEXT($0)
> C_TEXT($1)
>   
> C_TEXT($escaped)
> C_LONGINT($i)
> C_BOOLEAN($shouldEscape)
> C_BLOB($data)
>   
> For ($i;1;Length($1))
>   
>  $char:=Substring($1;$i;1)
>  $code:=Character code($char)
>   
>  $shouldEscape:=False
>   
>  Case of 
>: ($code=45)
>: ($code=46)
>: ($code>47) & ($code<58)
>: ($code>63) & ($code<91)
>: ($code=95)
>: ($code>96) & ($code<123)
>: ($code=126)
>  Else 
>$shouldEscape:=True
>  End case 
>   
>  If ($shouldEscape)
>CONVERT FROM TEXT($char;"utf-8";$data)
>For ($j;0;BLOB size($data)-1)
>  $hex:=String($data{$j};"")
>  $escaped:=$escaped+"%"+Substring($hex;Length($hex)-1)
>End for 
>  Else 
>$escaped:=$escaped+$char
>  End if 
>   
> End for 
>   
> $0:=$escaped
> 
>> On Aug 5, 2019, at 1:00 PM, Jim Labos - infobase via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> I tried and was unsuccessful probably because of syntax so I gave up and
>> moved on. I am trying Clickatell soon.
>> 
>> If you have a working example for Twilio I would much appreciate looking at
>> it.
> 

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

Re: Sending Text Messages From 4D

[Jeffrey Kain via 4D_Tech]

Here's what I wrote for our app ($tUserName would be unique to you, along with 
$tPassword and $tFromNumber). The method HTTP_Request_Build is just building a 
text variable like:

"From=155=156=This%20is%20the%20text"

String_FixURL is just a URL-encode method that Miyako posted awhile back 
(included at the end of this message). 

Also note that we're hard-coding the country code at '1' for US numbers only.

  // Twilio_Send
  //
  // $1 - TEXT - SendTo phone number
  // $2 - TEXT - Message to send

C_TEXT($1;$tSendToNumber)
C_TEXT($2;$tMessage)
$tSendToNumber:=$1
$tMessage:=$2

C_TEXT($tURI;$tUserName;$tPassword;$tPlugin;$tInfo;$tFromNumber;$tRequest;$tResponse)
C_LONGINT($lJson;$lHTTPStatus;$lTimeout;$lPort)

  // Stuff unique to your Twilio account
$tUserName:="Your Twilio username"
$tPassword:="Your Twilio password"
$tFromNumber:="Your Twilio mobile account number"

$tURI:="https://api.twilio.com/2010-04-01/Accounts/"+\
  $tUserName+"/Messages.json"
$tFromNumber:="+1"+$tFromNumber
$tSendToNumber:="+1"+$tSendToNumber

$tRequest:=""
HTTP_Request_Build (->$tRequest;"From";String_FixURL ($tFromNumber);"*")
HTTP_Request_Build (->$tRequest;"To";String_FixURL ($tSendToNumber);"*")
HTTP_Request_Build (->$tRequest;"Body";String_FixURL ($tMessage))

ARRAY TEXT($atHeaderNames;0)
ARRAY TEXT($atHeaderValues;0)
APPEND TO ARRAY($atHeaderNames;"content-type")
APPEND TO ARRAY($atHeaderValues;"application/x-www-form-urlencoded")
HTTP AUTHENTICATE ($tUserName;$tPassword;HTTP basic)
$lTimeout:=10
$lHTTPStatus:=HTTP Request (HTTP POST 
method;$tURI;$tRequest;tResponse;$lTimeout;$atHeaderNames;$atHeaderValues)


  // String_FixURL
  //
  // Returns urlencoded string in $0 from the string passed in $1

C_TEXT($0)
C_TEXT($1)

C_TEXT($escaped)
C_LONGINT($i)
C_BOOLEAN($shouldEscape)
C_BLOB($data)

For ($i;1;Length($1))

  $char:=Substring($1;$i;1)
  $code:=Character code($char)

  $shouldEscape:=False

  Case of 
: ($code=45)
: ($code=46)
: ($code>47) & ($code<58)
: ($code>63) & ($code<91)
: ($code=95)
: ($code>96) & ($code<123)
: ($code=126)
  Else 
$shouldEscape:=True
  End case 

  If ($shouldEscape)
CONVERT FROM TEXT($char;"utf-8";$data)
For ($j;0;BLOB size($data)-1)
  $hex:=String($data{$j};"")
  $escaped:=$escaped+"%"+Substring($hex;Length($hex)-1)
End for 
  Else 
$escaped:=$escaped+$char
  End if 

End for 

$0:=$escaped

> On Aug 5, 2019, at 1:00 PM, Jim Labos - infobase via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I tried and was unsuccessful probably because of syntax so I gave up and
> moved on. I am trying Clickatell soon.
> 
> If you have a working example for Twilio I would much appreciate looking at
> it.

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

Re: No Object Auto-Completion for 4D Commands?

[Jeffrey Kain via 4D_Tech]

And if you misspell a property (or get the case wrong), it will suggest that to 
you forever as well.  So don't make a mistake... ever! :)

> On Aug 2, 2019, at 1:10 PM, Narinder Chandi via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> This current behaviour as is means that there is a great chance of mixing 
> properties from multiple different objects within a given Method that can and 
> will result in unexpected coding errors. I guess for now it's simply a case 
> of "programmer beware"!
> 
> Having used other IDEs, in particular those from JetBrains, 4D still has a 
> ways to go to provide the "expected" behaviours for proper OOP style object 
> property auto-completion. Maybe in the future...

**
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: User and Group information error on validation

[Jeffrey Kain via 4D_Tech]

I have a bunch of these too - preventing a clean bill of health when I check my 
structure file.

I'd love to have a solution for this.


> On Jul 31, 2019, at 4:03 PM, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am getting the following error…
> 
> The group 15003 is referencing a nonexistent member -16.(0,0)
> 
> No clue how to fix it. I am getting several of these errors.
> 
> John

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

Re: can't load internal 4D component

[Jeffrey Kain via 4D_Tech]

Just a thought — 

We had similar errors on Mac due to our anti-malware package which actually 
removed contents of the 4D bundle that it thought were unsafe.  Have you 
written exceptions in your antivirus software?

> On Jul 28, 2019, at 12:42 PM, David Ringsmuth via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 4Dv17R4 build 233874
> Windows Server 2019 1809 build 17763.397 (64bit)
> 
> An installed 4Dv17R4 application began not correctly launching this morning 
> on the  error(s).
> 
> 650 (xbox) Folder (name) not found (path) xtoolbox task 1444
> Cannot open the structure of the database development
> Can’t load component development.4DC component ‘4DRT’ task 1444
> 
> This error occurs for every c:\Program Files\4D\Resources\Internal 
> Components\  of which there are six internal components.
**
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: MacOS Character Viewer (emojis) and 4D

[Jeffrey Kain via 4D_Tech]

Getting the Input Sources menu into the menu bar from the Keyboard system pref 
got this working for our user that wanted it.

Thanks all - 

> On Jul 17, 2019, at 12:44 PM, Jim Crate via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I use the emoji viewer in Messages, which includes a search function.
> 
> Jim Crate
> 
>> On Jul 16, 2019, at 4:00 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> It seems like 4D doesn't allow the macOS character viewer to open with 
>> cmd+ctrl+space. 
>> 
>> Has anyone found a workaround for this?

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

MacOS Character Viewer (emojis) and 4D

[Jeffrey Kain via 4D_Tech]

It seems like 4D doesn't allow the macOS character viewer to open with 
cmd+ctrl+space. 

Has anyone found a workaround for this?


**
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 v17r4 Windows Print To PDF ignoring PAGE SETUP

[Jeffrey Kain via 4D_Tech]

Paper names also differ across different drivers on the same platform.  In 
64-bit Mac 4D, SET PRINT OPTION fails with an OK of 0 if you specify a paper 
name that doesn't exist on your current printer, so you either need to get an 
array of all the available paper types and write some code to figure out what 
you want, or specify height and width in pixels.

--
Jeffrey Kain
jeffrey.k...@gmail.com




> On Jul 8, 2019, at 8:40 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Paper names can be an issue cross platform. I settled on using the “Paper 
> option” with 2 longint values for pixel width and pixel height. That works 
> cross platform for me. So 8.5” x 11” would be (8.5*72) or 612 and (11*72) or 
> 792. 

**
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 v17r4 Windows Print To PDF ignoring PAGE SETUP

[Jeffrey Kain via 4D_Tech]

On 64-bit Mac, if you specify a paper size that does not exist in your driver, 
OK gets set to zero and your job won’t print. This is new behavior.  Best to 
set pixels for page width and height.  Even different drivers on Macs have 
different names for paper sizes.  

> On Jul 8, 2019, at 4:24 PM, Cameron Ambrose via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Also a little annoying that paper names differ between OSs. I have to set 
> “Legal” on Windows and “US Legal” on Mac. Printing has always had it’s set of 
> challenges but this seems like more of a mess than it has been for a while.
**
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 v17r4 Windows Print To PDF ignoring PAGE SETUP

[Jeffrey Kain via 4D_Tech]

When we upgraded to v17 64-bit, the biggest thing we had to change were old 
printing forms.  To get them to work, I changed old reports that relied on 
saved page setups to use the equivalent SET PRINT OPTION command, and it worked 
in all cases...

--
Jeffrey Kain
jeffrey.k...@gmail.com

> On Jul 5, 2019, at 4:42 PM, Cameron Ambrose via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> What do you consider to be newest versions of 4D as this was working fine as 
> of v16R6. Are you aware of any 4D Blog entry or tech note that details how 
> printing/print setup has changed or provide best practices for 4D v17?

**
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 v17r4 Windows Print To PDF ignoring PAGE SETUP

[Jeffrey Kain via 4D_Tech]

The newest versions of 4D do better if you set these options in code instead of 
a saved page setup.  Try using SET PRINT OPTION to change it to landscape mode. 
 

> On Jul 3, 2019, at 6:13 PM, Cameron Ambrose via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Just updated to 4D v17r4 and it appears that when using the Windows 10 (64 
> bit) PDF printer, the client is no longer honouring the PAGE SETUP definition 
> and instead just printing in portrait letter.
**
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: Macs slow down generating PDFs

[Jeffrey Kain via 4D_Tech]

Interesting - Mac 32-bit is blazing fast and doesn't have this issue.  64-bit 
Mac can crank about a one per second (slowing down to a handful per minute 
after a few hours). Windows 10 is steady at about 1 per second on very fast 
hardware.  My 2017 iMac running v17 32-bit can rip through about 3 per second 
and it doesn't slow down.


> On Jul 2, 2019, at 10:29 PM, Jeffrey Kain  wrote:
> 
> Memory was stable for 4D - didn’t check the overall system though.  
> 
>> On Jul 2, 2019, at 6:26 PM, Wayne Stewart via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> What's memory consumption look like?

**
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: Macs slow down generating PDFs

[Jeffrey Kain via 4D_Tech]

Memory was stable for 4D - didn’t check the overall system though.  

> On Jul 2, 2019, at 6:26 PM, Wayne Stewart via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> What's memory consumption look like?
**
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
**

Macs slow down generating PDFs

[Jeffrey Kain via 4D_Tech]

Anyone notice that generating a large batch of PDFs on MacOS slows down? I'm 
trying to generate several thousand PDFs, and it starts out (on my Mac) at a 
clip of over 1 per second... after an hour it's down one every few seconds... 
after a few hours its a couple of PDFs per minute.

Same code on Windows doesn't have this gradual slowdown.
**
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
**

Username/password dialog timeout in v17

[Jeffrey Kain via 4D_Tech]

Does anyone know if the timeout that 4D Server will allow 4D Remote to stay at 
the username/password dialog can be adjusted?

I don't remember a timeout in previous versions, but it appears that there is 
one now. If you leave it for too long and then sign in, you get a "The 
connection to the database has been interrupted" message.

This is 4D Server 17.1 HF2 and 4D Remote 17.1.


Thanks...

Jeff


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

Re: Window type -724 (more info)

[Jeffrey Kain via 4D_Tech]

You should look at the v17 docs for the window types that will work going 
forward.  A lot of these old window types won’t work on 64-bit - it won’t crash 
but some odd things happen like opening the new form in the existing window, 
etc. 

Stick to the v17 documented window types for best results going forward

> On Jun 19, 2019, at 3:35 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I have no idea!  :)
> 
> this is a floating window I use for window management.
> In my system it contains a listbox with all open windows/processes.
> 
> I have been using this for ages. On a Mac.
> I was just working with windows version of a 4D app that uses this 
> window (same purpose) and it looks like crap because even though there 
> is *supposed* to be text in the title area there is nothing, and the 
> title area on windows is huuuge
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: V17 current release vs R-release

[Jeffrey Kain via 4D_Tech]

It's safe to do... as you said if you use new features in the R release you'll 
have to redo those parts of your code.

> On Jun 15, 2019, at 9:30 PM, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Any thoughts with regard to the soundness of deploying a structure that has 
> been upgraded to v17R4 using v17.2?

**
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: Konstants - trying to determine where it is defined

[Jeffrey Kain via 4D_Tech]

Is a Konstant a Russian version of a constant? :)

Constants are normally defined in an xliff file in Resources (for a 4D 
structure), or inside the bundle of a plug-in or component (probably also in 
Resources).  For example, our application's constants file is named 
Constants_Sweetwater.xlf and sits in the Resources folder next to the .4DC file.

> On May 30, 2019, at 4:29 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Is there a way to determine where a Konstant is defined?

**
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: Benefits of 64-bit 4D Remote

[Jeffrey Kain via 4D_Tech]

There's really no compelling reason if you're still on v16.  32-bit works fine. 
 As Arnaud wrote things may be changing in the Fall with the next release of 
macOS. My guess is that some kind of virtualization will be required to run 
32-bit stuff at that point.

Also, the 64-bit version of 4D v17 is a lot better than v16. 

> On May 23, 2019, at 1:35 AM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> That will ultimately be the compelling reason to move to 64-bit, but in the 
> meantime I can’t see any reason to make the move, especially since it would 
> require moving to 4DWritePro, which appears to be a massive undertaking. Am I 
> missing anything else if we stick to 32-bit 4D Remote? 

**
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: SET PRINT OPTION Fails on a New Macbook Air

[Jeffrey Kain via 4D_Tech]

Not sure if you're on 32-bit or 64-bit, but printing on 64-bit is fussier -- it 
wants to have paper sizes assigned with SET PRINT OPTION that match exactly the 
printer you're printing to, otherwise it sets OK to zero and it won't print.  
The workaround I found, since different drivers have wildly different paper 
sizes, is to use the variation of the command that specifies a print area in 
pixels instead of a named paper size.


Jeff

> On May 17, 2019, at 2:36 PM, Tom Dillon via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I'll give that a shot. I print the file with no extension then rename it 
> afterwards.
> 
> Thanks!

**
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: Windows Server transition - Best Practice Advice

[Jeffrey Kain via 4D_Tech]

I keep 4D Server in Program Files and the structure and data etc on a different 
storage system.  

If this was an OEM or merged app I would keep everything on the separate 
storage.  

> On May 7, 2019, at 12:45 AM, Tom Benedict  wrote:
> 
> Hi Ed,
> 
> We had 4D Server and all 4D files including .4DD and .journal files on the 
> same disk but separate from the . I know that it’s usually recommended to 
> keep the .journal on a different disk or even a different file server, but 
> since we were on a SAN, disk reliability was much higher than network 
> reliability. The chance of a network disconnect causing the link to the 
> .journal to break was avoided by having it on the same disk. We also 
> mirrored, via log shipping, every 15 minutes, so that provided sufficient 
> redundancy. Under WS2008 there were no restrictions on where an app needed to 
> reside, but there may be in WS2016, so I’ll let Jeff chime in on that.
> 
> HTH,
> 
> Tom
> 
>> On May 6, 2019, at 21:08, Ed Hammond  wrote:
>> 
>> Jeff and Tom,
>> 
>> Thanks for the pointing us in the correct direction. We are now all 64 bit, 
>> so that hurdle has been crossed. I’ll talk to our IT staff about defender 
>> issues. Any tips on where the application should be located? Pluses and 
>> minuses for running as a service?
>> 
>>> On May 6, 2019, at 1:14 PM, Jeffrey Kain  wrote:
>>> 
>>> One point - in Windows Server 2016, Windows Defender is turned on by 
>>> default (antivirus/anti-malware). You'll definitely want to either write 
>>> exclusions for all 4D-related directories and file types, or disable it 
>>> altogether (you can do a Google search for how to completely disable it if 
>>> your server is well firewalled... required command line access to do this).
>>> 
>>>> On May 6, 2019, at 1:45 PM, Tom Benedict via 4D_Tech 
>>>> <4d_tech@lists.4d.com> wrote:
>>>> 
>>>> Hi Ed,
>>>> 
>>>>> We are beginning to transition our servers from Mac to Windows. For those 
>>>>> of you who have made the journey, what have you found to be best 
>>>>> practices 
>>>>> for a built c/s app running on Windows Server 2016 Standard? Are there 
>>>>> any 
>>>>> gotcha's we should watch out for? Direct roads to smooth sailing?
>>>> 
>>>> Running 4D Server under Windows Server is pretty straightforward. I don’t 
>>>> know about specific WS 2016 issues, but in general there are only a few 
>>>> things to set for 4D Server to run best. 
>>>> 
>>>> One thing to make sure is to set it to be optimized as a data server, not 
>>>> a file server. In WS 2008 that setting was in the “Performance Options” 
>>>> control Panel, but may be elsewhere in v2016.
>>> 
>>> This setting is no longer around... it's smart enough to figure out what 
>>> you're doing and not run into dueling cache issues.
>>> 
>>> 
>>> Jeff
>> 
>> --
>> Edgar Hammondehamm...@questinformation.com
>> Quest Information Systems 847 234-1345
>> http://www.questinformation.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: Windows Server transition - Best Practice Advice

[Jeffrey Kain via 4D_Tech]

One point - in Windows Server 2016, Windows Defender is turned on by default 
(antivirus/anti-malware). You'll definitely want to either write exclusions for 
all 4D-related directories and file types, or disable it altogether (you can do 
a Google search for how to completely disable it if your server is well 
firewalled... required command line access to do this).

> On May 6, 2019, at 1:45 PM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Ed,
> 
>> We are beginning to transition our servers from Mac to Windows. For those 
>> of you who have made the journey, what have you found to be best practices 
>> for a built c/s app running on Windows Server 2016 Standard? Are there any 
>> gotcha's we should watch out for? Direct roads to smooth sailing?
> 
> Running 4D Server under Windows Server is pretty straightforward. I don’t 
> know about specific WS 2016 issues, but in general there are only a few 
> things to set for 4D Server to run best. 
> 
> One thing to make sure is to set it to be optimized as a data server, not a 
> file server. In WS 2008 that setting was in the “Performance Options” control 
> Panel, but may be elsewhere in v2016.

This setting is no longer around... it's smart enough to figure out what you're 
doing and not run into dueling cache issues.


Jeff
**
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: Split Screen Support with 4D and MacOS?

[Jeffrey Kain via 4D_Tech]

You could use Exposé to put your code windows side by side.  Or just drag 
methods from one Explorer window to another.

> On Apr 30, 2019, at 6:05 PM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Am I missing something? If not, how do others work with two 4D structures on 
> MacOS?

**
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 v17 R5 file and folder objects !!!

[Jeffrey Kain via 4D_Tech]

Time references for documents are a good weed-out mechanism - if you can find a 
millennial who just gets it, you have a keeper... :)

> On Apr 24, 2019, at 2:51 AM, Bruno LEGAY via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi,
> 
> I just noticed in 4D v17 R5 the new file and folder objets...
> 
> https://doc.4d.com/4Dv17R5/4D/17-R5/File-and-Folder.201-4282207.en.html
> 
> This is great !
> 
> I won't miss trying to explain/justify to new 4D developers why a document 
> reference is a TIME variable...
**
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: Setting to not Open Methods into One Window

[Jeffrey Kain via 4D_Tech]

It’s a strange setting. I couldn’t find it either and ended up posting a 
question too.  

So bizarre!

> On Apr 23, 2019, at 10:57 PM, Douglas von Roeder  wrote:
> 
> Jeffrey:
> 
> You mean the one labeled “Window tabbing (macOS only)”?  :-)
> 
> I simply did not see it. 
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Setting to not Open Methods into One Window

[Jeffrey Kain via 4D_Tech]

It is (was) in the first tab.  

> On Apr 23, 2019, at 6:18 PM, Douglas von Roeder  wrote:
> 
> Jeff:
> 
> That’s what I was expecting but I don’t see a setting that allows me to shut 
> it off. 
>  
> Which “tab” would it be under?
**
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: Setting to not Open Methods into One Window

[Jeffrey Kain via 4D_Tech]

Use tabbed windows setting in 4D prefs?

> On Apr 23, 2019, at 6:03 PM, Douglas von Roeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Using V17R3 64-bit on the Mac and methods are opening in the main window.
> 
> Is there a was to change this behavior?
**
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: I really recommend the 4D World Tour

[Jeffrey Kain via 4D_Tech]

I agree - it's easy to cherry-pick examples that are well-suited to ORDA.  The 
ORDA engine is definitely fast, but our tests show that the classic commands 
are still faster overall.  You just have to write a lot more code.

In my tests in client/server mode (and 4D always demos ORDA in single-user 
mode), ORDA is usually about 10x faster than equivalent SQL, but still several 
times slower than classic (and OMG 10x faster! .. but we're talking 
milliseconds usually). If all you care about is raw speed, then classic 4D is 
probably still the fastest... but ORDA is very elegant, and it makes 
development easier and fun.

If you get into tokenization vs. strings, then the picture gets muddier... but 
once 4D gives us the option to have a text file-based structure then a whole 
new world of tools open up for maintaining and refactoring code (with a steep 
learning code). Times are changing. 4D is joining the rest of the programming 
language world (and not forcing us to rewrite).

Jeff

> On Apr 11, 2019, at 8:16 AM, Jim Hays via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I'll disagree a bit on the value of ORDA.  JPR showed some examples of how
> much faster ORDA can be than the old "classic" way.
> I'm really interested in putting these to the test in our vertical market
> app.   We don't have huge data files, but we do a lot of cross-table number
> crunching in a normalized structure that may really benefit.

**
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: LEP - hide console?

[Jeffrey Kain via 4D_Tech]

Hi Pat,

Did you try calling SET ENVIRONMENT VARIABLE with the _4D_OPTION_HIDE_CONSOLE 
option?  It works with normal batch windows... not sure about PowerShell 
windows.

https://doc.4d.com/4Dv15/4D/15.6/SET-ENVIRONMENT-VARIABLE.301-3817570.en.html

Jeff


> On Apr 9, 2019, at 5:34 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> So I now have a Powershell script which converts a Word document to PDF.
> Unfortunately it briefly shows the Powershell console window when it starts
> the script, which is rather ugly and I would prefer not to inflict it upon
> my users.
> Is there any way to prevent it from appearing?
> 
> Here's my LEP code:
> 
> $tExecute:="powershell -windowstyle hidden -ExecutionPolicy ByPass -File
> "+Char(34)+$ScriptPath+Char(34)+" "+Char(34)+tDocnameWord+Char(34)
> LAUNCH EXTERNAL PROCESS($tExecute)
> 
> "-windowstyle hidden" stops the console from being displayed the whole time
> the script is running, but it still appears for a couple of seconds.

**
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: PDF viewing alternative in v17/64 bit

[Jeffrey Kain via 4D_Tech]

Are you sure it's a 64-bit client and that the embedded web area setting is 
marked?  The Google viewer only works in 64-bit 4D.

> -Original Message-
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Piotr Chabot 
> Stadhouders via 4D_Tech
> Sent: Monday, April 8, 2019 6:16 AM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Piotr Chabot Stadhouders 
> Subject: RE: PDF viewing alternative in v17/64 bit
> 
> Hi,
> 
> Suddenly I have a problem with viewing PDF's in the webarea, only on Windows 
> When using WA OPEN URL to show a PDF in an area, it just launches the 
> document, instead of showing it in the area Does anybody why this is, and how 
> to prevent this?
> 
> A second question: Is there an easy way to keep certain PDF viewing settings, 
> the zoom size 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: PDF viewing alternative in v17/64 bit

[Jeffrey Kain via 4D_Tech]

If I get time I’m going to try updating the open source pdfjs files in that 
component and see if it fixes that stuff.  The version in my component is a bit 
old.  

> Strangely, using right click to print, the pdf document is printed 50% 
> reduced at center of page: any idea, 
**
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
**

PDF viewing alternative in v17/64 bit

[Jeffrey Kain via 4D_Tech]

Just ran into a nice surprise in 4D v17 on 64-bit using the embedded "Blink" 
web area... it has a very nice cross-platform PDF viewer built in. Just pass 
the path of a PDF into WA Open URL and it will display exactly the same on both 
Mac and Windows -- no plug-ins or extra configuration required.
**
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: Call workers allowing multiple threads to run at once.

[Jeffrey Kain via 4D_Tech]

That's the point of workers.

You queue up messages for the worker to handle, in order, so your calling 
method doesn't block.

> On Mar 25, 2019, at 4:33 PM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> But I have found that my loop pushing photos to the server moves so fast it 
> outraces the call worker

**
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: Current time (*) incorrect today on v17?

[Jeffrey Kain via 4D_Tech]

Our server disconnected all users and stopped responding at the time of the 
time change in v17.1.  Coincidence? 

> On Mar 18, 2019, at 9:42 AM, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Just wanted to let everyone know that this is still happening in v17.0. Does
> anyone know if it is fixed in v17.1?

**
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: Current time (*) incorrect today on v17?

[Jeffrey Kain via 4D_Tech]

It was supposed to have been fixed in 17.0 HF4.  

> On Mar 18, 2019, at 9:42 AM, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hello out there,
> Just wanted to let everyone know that this is still happening in v17.0. Does
> anyone know if it is fixed in v17.1?
> Thanks,

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

[Jeffrey Kain via 4D_Tech]

I think Miyako has something on his github account...

> On Mar 15, 2019, at 12:02 PM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Has anyone tried to notarize a built 4D application with Apple yet? Is it 
> possible with 4D?
> 
> Thanks.

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

Re: 4D V16 R6 Vs 4D V16.5

[Jeffrey Kain via 4D_Tech]

I definitely agree that 4D's new internal processes and continuous delivery 
model have improved product quality a LOT.  There's no way I would have ever 
considered putting a .0 release into production, but we did just that with 
v17.0.

> On Mar 13, 2019, at 9:02 AM, GI -AJAR via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I think it improve the quality of 4D.

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

Re: 4D V16 R6 Vs 4D V16.5

[Jeffrey Kain via 4D_Tech]

It's really not that hard, nor that unusual.

Is Windows Server 2008R2 a beta of Windows Server 2012? Nope. It's an 
incremental release with new features.

> On Mar 13, 2019, at 6:14 AM, Bernd Fröhlich via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Maybe all the folks at 4D understand how those R version numbering works, but 
> for the rest of the world it is obviously quite confusing.

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

Re: 4D Server v17.1 and time change

[Jeffrey Kain via 4D_Tech]

No, not at all since v17.0 initial release.


> On Mar 11, 2019, at 7:07 PM, Cannon Smith  
> wrote:
> 
> Thanks. Good to know it has been solid otherwise.
> 
> P.S. Have you seen the delayed process not waking up issue since moving to 
> v17.1?

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

Re: 4D Server v17.1 and time change

[Jeffrey Kain via 4D_Tech]

Nobody else has responded... so I guess it was just us. Or maybe not that many 
are running client/server in v17.1 yet. Aside from this weird glitch v17.1 has 
been very solid.


--
Jeffrey Kain
jeffrey.k...@gmail.com




> On Mar 11, 2019, at 3:57 PM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Jeff,
> 
> We had to relaunch all our servers for them to get the time update, but they 
> are still on v16r6. I thought the daylight saving bug had been fixed in v17.1 
> so I’m curious to know what you find if you get more information.
> 
> Good luck.
> 
> --
> Cannon.Smith
> Synergy Farm Solutions Inc.
> Aetna, AB Canada
> 
> 
> 
> 
>> On Mar 10, 2019, at 9:20 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> Did anyone else have any weirdness with their 4D Server v17.1 and the change 
>> to Daylight Savings Time this morning?
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

4D Server v17.1 and time change

[Jeffrey Kain via 4D_Tech]

Did anyone else have any weirdness with their 4D Server v17.1 and the change to 
Daylight Savings Time this morning?

Most, but not all, of our users got disconnected around the time of the change, 
the SQL server and the 4D Server UDP port that broadcasts the server name 
stopped responding (we have Nagios checks on both of these and they both 
started alerting), and when we went to quit 4D Server it just quit immediately 
without giving the usual chance for a countdown.

Could be a fluke I guess? But it seems awfully suspicious that it happened 
right around the time change, so I'm just curious if anyone else saw anything 
weird?

Jeff
**
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: What is "DirectWrite API" and "GDI API"?

[Jeffrey Kain via 4D_Tech]

Different low level APIs in Windows for handling fonts and graphics.  GDI is 
older.  

> On Mar 3, 2019, at 9:55 PM, Jeremy French via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> What is the meaning of:


**
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: Highlighting rows using Row Font Color Array

[Jeffrey Kain via 4D_Tech]

If the color of your text is black, make sure the font color is set to 
automatic and not black.  If you have other font colors that you want to 
reverse when they are selected, you have to do this yourself per the blog. 

> On Mar 3, 2019, at 4:14 PM, James Knight via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I'm using the Row Font Color Array in a listbox to allow different rows to 
> have different font colours. However, this seems to break the row 
> highlighting system which would usually reverse the font colour in relation 
> to the highlight colour when a row is selected. 
> 
> So, when the rows are not highlighted they are in the correct font colour. 
> But, when the row is highlighted, the font colour remains as set in the Row 
> Font Color Array rather than being reversed out in white. This often makes it 
> very hard to read. 
> 
> Does anyone know a way to work around this? 
**
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: Replacing FootRunner in v16

[Jeffrey Kain via 4D_Tech]

This technique works great by the way. Add K @4D pointed this out to us last 
summer, and we implemented a secure, locked down way to do this in our compiled 
application; it has really saved us a few times!

--
Jeffrey Kain
jeffrey.k...@gmail.com

> On Feb 23, 2019, at 4:24 AM, GI -AJAR via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi,
> 
> I have fond this on their website. Must help you. 
> http://www.footprints-inc.com/Blog/13

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

Re: Can'r run as a service on Windows 2016

[Jeffrey Kain via 4D_Tech]

Pretty weird... I didn't have to change anything else, but I never tried 
connecting a client on the server machine while 4D Server was running as a 
service.  

Can you connect from a client over the network? Clients on the server machine 
seem to use an optimized protocol that doesn't involve the network stack.

> On Feb 27, 2019, at 11:56 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I made that change and now the service appears to be running OK.
> BUT ... I can't connect to it from a Client. It says Not Responding.  I've
> only tested with a Client running on the same server, but that should work
> - never had a problem doing that in the past. Makes no difference if I run
> the Client as Administrator or not.
> 
> Do I need to change something else as well?

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

Re: Can'r run as a service on Windows 2016

[Jeffrey Kain via 4D_Tech]

We have 4D Server v17 HF3 set up as a service on Windows Server 2016.  I 
checked the service properties -- the "Log on as:" is set to "Local System 
account" and "Allow Service to interact with desktop" is checked. 

I also have FireDaemon installed to make it easy to bounce into the "session 0" 
user interface if I need to view the 4D Server user interface.

> On Feb 27, 2019, at 9:43 AM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Pat,
> 
> I don’t have any experience with running 4D as a Service, but I see that 
> there is a Tech Tip from about 10 years ago which mentions having to “Run as 
> Administrator”
> 
> https://kb.4d.com/assetid=75056
> 
> HTH,
> 
> Tom Benedict
> 
>> On Feb 27, 2019, at 02:40, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> I'm having a bit of trouble trying to set up our 4D app to run as a service
>> on a Windows server.
>> 
>> The server version is Windows Server 2016 Standard.
>> If I run the app "As Administrator" it starts up OK and we can connect to
>> it.
>> 
>> If I don't start it as Administrator, I get a message that the database (or
>> one of its segments) is locked.
>> If I try to set it up to run as a service, it doesn't work - in the
>> Services window, it says it's running, but in the Task Manager it says
>> Stopped. I'm guessing this is because when it tries to start the service,
>> it can't because of the locked data file 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
**

Re: Where to Find Docs and Source Code for 4D Pop

[Jeffrey Kain via 4D_Tech]

Hey Doug - try this:

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

> On Feb 14, 2019, at 3:41 PM, Douglas von Roeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Can someone point me in the right direction for the source code and docs
> for 4D Pop?

**
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: Closing a window with another application in focus

[Jeffrey Kain via 4D_Tech]

Kirk/Albert Brooks pointed me in the right direction -- if you open the window 
with Open Form Window, then the behavior is just automatic. If you open the 
window with Open Window, then you need to enable the On Close Box event and 
write a handler for that event.  

64-bit seems pickier/more consistent than 32-bit.

> On Feb 7, 2019, at 2:19 AM, Bernd Fröhlich via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I read about a a "click through" property (a long time ago and not connected 
> to 4D).
> If that is not set, then the first click into a window brings it to the front 
> and the second click has the desired outcome.
> If it is set, then one click does both.
> Not sure if that was per window or per program or if 4D even supports it.
> Maybe something to do with the window type (composite vs. non composite)?
> 
> Sorry, that may be not much help, but that´s all I remember.

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

Closing a window with another application in focus

[Jeffrey Kain via 4D_Tech]

On macOS - some of the windows in my application will close if I click on the 
close box while another application has the focus, but others don't.

Does anyone know what the secret is for this? They all close fine if 4D is the 
frontmost application - even if other 4D windows are on top I can close 
non-focused window with a single click to the close box.

Thanks...

Jeff
**
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: BUG OR FEATURE

[Jeffrey Kain via 4D_Tech]

Could it be the difference between a 32-bit client and a 64-bit client?

64-bit clients on Mac get access to more printer driver features than the 
32-bit client.

> On Feb 4, 2019, at 2:17 PM, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> When I am connected to an uncompiled development server and I bring up
> print settings, I can see a check box Reverse Page orientation and can
> change it. When I connect to a merged server, with a built client,
> this check box is not visible and I can not check it. I need it as we
> are printing labels for samples and in one instance, we need this to
> be set to ease application of labels to sample tubes

**
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: Does 4D 64-bit Volume desktop use more than 1 core?

[Jeffrey Kain via 4D_Tech]

You can click it right click on the summary graph and have it display 
individual cores.  

> On Jan 31, 2019, at 4:31 AM, Epperlein, Lutz (agendo) via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Just out of curiosity, how can I visualize the use of the CPU cores on 
> Windows 
> using some inbuilt tools of the OS?
> The task manager shows a summary only. In the resource monitor I can see the 
> use the total use of all cores by an application, not the use of individual 
**
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: Does 4D 64-bit Volume desktop use more than 1 core?

[Jeffrey Kain via 4D_Tech]

No, not at all. You have to first mark the method that's called first from New 
Process as preemptive. That method, plus all methods called by that method, and 
all methods called by those methods, must be written in a preemptive-safe 
manner (i.e. no UI, no unsafe commands, no plug-ins).

If all that happens, that process will be scalable across cores.

> On Jan 30, 2019, at 1:25 PM, Piotr Chabot Stadhouders via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> So, does 4D automagically use more cores in 4D 64-bit or what?
> When I follow all pre-emptive advise in the docs or from the iNUG, do I have 
> a multi-core application?

**
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: Does 4D 64-bit Volume desktop use more than 1 core?

[Jeffrey Kain via 4D_Tech]

Compiled 64-bit Volume Desktop can use more than one core, depending upon how 
you write your code. 64-bit 4D is required, as is being compiled, in the 
current implementation.  

You need to write preemptive-safe methods and your methods need to be marked as 
preemptive in the method properties. 

> On Jan 30, 2019, at 4:48 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Piotr
> I believe the "bitness" has more to do with how it uses RAM than cores.
> Pat
> 
> On Wed, 30 Jan 2019 at 09:13, Piotr Chabot Stadhouders via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Hi all,
>> 
>> First of all, I must say I am no hardware expert, so maybe this is a
>> stupid question.
>> 
>> It seems that 4D 32-bit Volume desktop only uses 1 core.
>> But does 4D 64-bit Volume desktop use all available cores?
>> 
>> Gr,
>> Piotr
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> 
> 
> 
> -- 
> *
> 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: 4D Server V17.0 crashing on database open

[Jeffrey Kain via 4D_Tech]

Have you tried rebooting the server? Once in awhile our server will get into a 
pattern like this and the only solution is a reboot. I believe, but haven't 
proven yet, that it has something to do with 4D Server not closing all of its 
ports correctly when you shut down.

> On Jan 28, 2019, at 9:06 AM, Uist Macdonald via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I am having a problem with 4D Server 17.0 on Windows Server 2016. When I open 
> any database, even an empty one, it crashed. Anybody else had this? Of course 
> it happens only on the client machine. My dev server is fine.

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

Getting the workstation name for a locked record

[Jeffrey Kain via 4D_Tech]

We have a bunch of dedicated job clients that all log in to 4D with the same 
username. When a locked record occurs (I'm using LOCKED BY), I want to display 
the workstation name that's holding the lock... is there a way to get this, 
other than to assign each workstation a unique username?

Jeff

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