Re: 4D <-> Development

[Lee Hinde via 4D_Tech]

My 2¢ is that you should start with simple server side rendered html (i.e,
use the 4D Transformation Tags in templates sent with WEB SEND
FILE($t_responseToSend)). Don't worry about using front-end technology
until you need it (and, you really only need it (and REST APIs) if some
other system (an phone app, another web app) needs access to your data.

I use Web Send File so that my file storage isn't 'revealed' by my urls.
I.e. 'main/account/user_profile' doesn't necessarily map to my web folder
template layout.

On Wed, Oct 20, 2021 at 10:17 AM Jody Bevan via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I have asked a similar question over on the FORUM, and got two responses.
> I know more people than two have developed web pages and 4D applications
> working together.
>
> I really need to get into designing both.
>
> - The advantage I have is that I am starting from scratch with web
> development and 4D and the web. The 4D database linked over the web that I
> personally developed with HTML back in the early 90s are way out of date. I
> want to learn the new way of working, because that will future proof my
> skills, and the sites/Applications I develop.
>
> - The disadvantage I have is that I am starting from scratch.
>
> OK, having said that what tools do you recommend (and why)? There are so
> many web development tools, and so many web developers that want to gobble
> up the Database application behind it all (thus my work) as they ‘can do it
> all’.
>
> - I have seen talk about Angular, AngularJS, React ( Frameworks - correct).
> - There are new tools in 4D since back in the early 90s obviously.
> - Yes, REST is important, but what does that mean.
>
> A white paper from 4D on 4D v19 and the web and working together would be
> very nice to have.
>
> The web sites I developed way back then, everything was in 4D. I wrote all
> the static HTML and stored, and sent it out from 4D. That was then, but
> from what I understand now things can work better as the WebServer itself
> can interpret the JavaScript to execute code there - thus being faster. Of
> course scalability is important to. No use using a tool that cannot scale.
> I remember the first time I installed at a site with 150 concurrent users,
> and a 20 x 300 foot chart room that would be put into our system along with
> all new data. That scared me, but 4D 2004 did it.
>
> Any comments, thoughts, warnings, or drop by and say hello are all
> appreciated.
>
> Thanks
>
> Jody Bevan
>
>
**
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 Online Manuals

[Lee Hinde via 4D_Tech]

Found that the readme in the web folder is more informative than the top-level 
readme.


> On Jun 29, 2021, at 7:57 AM, Lee Hinde  wrote:
> 
> Tried yarn build when I saw the package.json, but no love. How do you build 
> it?
> 
> 
>> On Jun 29, 2021, at 5:22 AM, Keisuke Miyako via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> its a github repo.
>> 
>> https://github.com/4d/docs
>> 
>> you can fork it.
> 
> 
> 

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

[Lee Hinde via 4D_Tech]

Tried yarn build when I saw the package.json, but no love. How do you build it?


> On Jun 29, 2021, at 5:22 AM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> its a github repo.
> 
> https://github.com/4d/docs
> 
> you can fork it.



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

Re: PING of life...

[Lee Hinde via 4D_Tech]

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

Well, I'll just launch my copy of Navigator and see what mine was...

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

Re: Foundation Status?

[Lee Hinde via 4D_Tech]

Check with Wayne Stewart. He'll probably jump in here.

> On Nov 6, 2020, at 8:44 AM, Ed Heckman via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Guys & Walt,
> 
> I couldn't ask this question via Walt's web site, but couldn't because the 
> Captcha wouldn't display.
> 
> Has Foundation been updated to support v18?
> 
> 
> Ed Heckman 
> Dimension i Technologies 
> (844) 477-4114
> 
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: "Optimal" 4D Server hardware

[Lee Hinde via 4D_Tech]

Are you having any performance issues now?

My 2¢, with that datafile size, I'd just get more of the same (current 
MacMini),  with 16GB RAM. 

Unless your in-house expertise is more comfortable with Windows.

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

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

Re: Hosts, sessions, and credentials

[Lee Hinde via 4D_Tech]

https://stackoverflow.com/questions/18492576/share-cookie-between-subdomain-and-domain
 



> On May 19, 2020, at 9:50 AM, Doug Hall via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Suppose I want to start user interaction on one website (within the same
> domain) and pass that session/cookie information along to a different host
> on my same domain. Is that relatively easy to do? For example, If I have a
> login process that's fed by a json-backed virtual host at api.acme.com and
> want to pass the logged in user to a website at somethingelse.acme.com,
> would that be difficult? I assume Active4D sessions are not shared across
> different virtual hosts.
> 
> Thanks,
> Doug

**
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: HMAC SHA256 in native 4D code (JWT)

[Lee Hinde via 4D_Tech]

Thanks.


> On Mar 21, 2020, at 8:24 AM, Bruno LEGAY via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi,
> 
> The component is now on github :
> 
>   https://github.com/blegay/jwt_component
> 
> Bruno LEGAY
> A&C Consulting

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

Re: Barcode

[Lee Hinde via 4D_Tech]

There are a bunch:

https://www.google.com/search?client=firefox-b-1-d&q=barcode+fonts+free

But we ended up using hmBarcode because the free fonts didn't work with new 
scanners that the client got.


> On Mar 20, 2020, at 9:26 AM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 
> Someone knows some links of free font barcode?
> 
> Thanks
> 
> /Ferdinando/
> 
> Il 20/03/20 12:23, 4d_tech-requ...@lists.4d.com ha scritto:
>> Send 4D_Tech mailing list submissions to
>>  4d_tech@lists.4d.com
>> 
>> To subscribe or unsubscribe via the World Wide Web, visit
>>  https://lists.4d.com/mailman/listinfo/4d_tech
>> or, via email, send a message with subject or body 'help' to
>>  4d_tech-requ...@lists.4d.com
>> 
>> You can reach the person managing the list at
>>  4d_tech-ow...@lists.4d.com
>> 
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of 4D_Tech digest..."
>> 
>> 
>> Today's Topics:
>> 
>>1. Re: Printing Listbox multiple pages (resolved) (John J Foster)
>>2. Re: Remote working with 4D networks - what are people using ?
>>   (Tim Nevels)
>>3. Re: barcode (Bernd Fröhlich)
>>4. Re: Gmail, LSA, and OAuth (Chuck Miller)
>>5. Re: Gmail, LSA, and OAuth (Tom Benedict)
>>6. Re: Remote working with 4D networks - what are people using ?
>>   (Keith Goebel)
>>7. Re: gitignore for projects (John DeSoi)
>>8. Re: Remote working with 4D networks - what are people using ?
>>   (Herr Alexander Heintz)
>>9. Re: Remote working with 4D networks - what are people using ?
>>   (Paul Dennis)
>>   10. Re: Remote working with 4D networks - what are people using ?
>>   (Milan Adamov)
>> 
>> 
>> --
>> 
>> Message: 1
>> Date: Thu, 19 Mar 2020 09:44:21 -0700
>> From: John J Foster 
>> To: 4d_tech@lists.4d.com
>> Subject: Re: Printing Listbox multiple pages (resolved)
>> Message-ID: <3e46f8d3-7bc0-432b-9909-d71c54422...@isomedia.com>
>> Content-Type: text/plain;charset=utf-8
>> 
>> Hi All,
>> 
>> Never mind - unless you found something a bit easier…
>> 
>> I found an older JPR example (I think) and it was really easy!
>> 
>> Just change the code to something like this:
>> 
>> C_BOOLEAN(vOver;$ref)
>> 
>> PRINT SETTINGS
>> If (ok=1)
>>  SET PRINT PREVIEW(True)
>>  OPEN PRINTING JOB
>>  FORM LOAD("Timescan_print")
>> 
>>  vOver:=False  // Flag for cancel printing
>>  Repeat
>>  $ref:=Print object(*;"tscanChartInfo")
>>  vOver:=Print object(*;"lb_Timeline")
>>  If (Not(vOver))
>>  PAGE BREAK
>>  End if
>>  Until (vOver)
>>  CLOSE PRINTING JOB
>> End if
>> 
>> For all those who might need it in the future.
>> 
>> John…
>> 
>>> Hi All,
>>> 
>>> I have an array based listbox of results that needs to be printed. I am 
>>> starting with simple code:
>>> 
>>> PRINT SETTINGS
>>> If (ok=1)
>>> SET PRINT PREVIEW(True)
>>> OPEN PRINTING JOB
>>> FORM LOAD("Timescan_print")
>>> $ref:=Print object(*;"tscanChartInfo")
>>> $ref:=Print object(*;"lb_Timeline")
>>> CLOSE PRINTING JOB
>>> End if
>>> 
>>> But this only prints a single page (rows printed based upon listbox 
>>> height). Obviously I haven’t designed it to calculate and print multiple 
>>> pages yet and want to be efficient as I proceed.
>>> 
>>> Before I stumble my way through this I have reviewed past NUG threads and 
>>> looked at Miyako’s and Keith’s examples But either, in Miyako’s case, it 
>>> creates random values on the fly but does create multiple pages, for 
>>> Keith’s example which stops at the size of the listbox.
>>> 
>>> So do I need to create a series of form pages: Header, row lines, footer, 
>>> etc. and then print object and calculate or….
>>> 
>>> Is there an easier way to manage array based listbox printing over many 
>>> pages?
>>> 
>>> Does anyone have any sample code of printing multi-page array based list 
>>> boxes?
>>> 
>>> Thanks,
>>> John…
>>> 
>> 
>> 
>> --
>> 
>> Message: 2
>> Date: Thu, 19 Mar 2020 14:44:11 -0500
>> From: Tim Nevels 
>> To: 4d_tech@lists.4d.com
>> Subject: Re: Remote working with 4D networks - what are people using ?
>> Message-ID: 
>> Content-Type: text/plain;charset=utf-8
>> 
>> On Mar 19, 2020, at 2:00 PM, Alexander Heintz wrote:
>> 
>>> OsX is as much a UNIX flavor as we are basically primates.
>>> 
>>> BSD split in 75 from UNIX and NEXTSTEP in 86 from BSD.
>>> 
>>> don't know why, but AFAIK the MacOS is not suited for multiple concurrent 
>>> user sessions.
>> Good that you prefaced your statement with “AFAIK”, because you don’t know.
>> 
>> macOS has supported multiple simultaneous users on the same machine with 
>> each having their own U macOS Lion 10.7. So it’s been around for a long 
>> time. Very easy to use from one Mac to another using built in Screen Sharing 
>> application.
>

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

[Lee Hinde via 4D_Tech]

1997 called and want their Slam-The-Mac back.  :-) 

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

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

Re: Bar code

[Lee Hinde via 4D_Tech]

There's a plugin for that:

https://www.hmplugins.com/en/hmBarcode/Features-133.html 


I haven't looked at Miyako's since he broke the plugin up.
https://github.com/miyako/4d-plugin-qrencode 


(I'm assuming bag is auto-correct for svg)

> On Feb 21, 2020, at 8:47 AM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 
> Hi all. 
> 
> I had thought there was a tech note or something on how to draw bar codes in 
> 4D using bag area. Can someone point me the the right direction
> 
> Thanks and regards 
> Chuck
> Sent from my iPhone
> **
> 4D Internet Users Group (4D iNUG)
> 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: High Sierra or Mojave?

[Lee Hinde via 4D_Tech]

I was a late migrator to Mojave and haven't found the security measures 
cumbersome. Nothing like what I'm reading is SOP with Catalina.


> On Dec 10, 2019, at 3:14 PM, Doug Hall via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I'm upgrading my 4D structure from 4D v15 to v17, to gain 64 bit
> compatibility on the client side with new Apple hardware. Question: Should
> I upgrade a late 2014 Mac Mini w/16GB Ram, running Sierra (10.12.6) to High
> Sierra or Mojave? I'm also using Homebrew on a Web Client machine I'm
> using, that shares the same specs as this 4D Server machine. I want to stay
> relatively close to the latest OS, but I'm a bit weary of the security
> measures Apple is imposing on Mojave/Catalina.
> 
> Recommendations?
> 
> Thanks,
> Doug



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

Re: Authorize.net integration?

[Lee Hinde via 4D_Tech]

You, of course, aren''t storing credit card info, but you can pre-populate a 
proposed name and billing zip code if you want. But you'd be surprised (I was) 
at how little relationship there is between the name you have on file and 
what's on the credit card a user will use.

> On Nov 20, 2019, at 12:35 PM, Joe Dombroski  wrote:
> 
> thanks.  I will take a look. I was curious about creating an embedded link 
> with 4D that has the billing information.
> 
> Most simple interfaces I see force you to enter all your info.
> 
> Joe 
> 
> 
> 
> On Wed, Nov 20, 2019 at 3:12 PM Lee Hinde  <mailto:leehi...@gmail.com>> wrote:
> I only did payments (not recurring, or pre-qual or anything like that.)
> 
> Also, I did this for a 4D hosted web site to take payments from (my 
> customer's) customers. There's web-side and 4D-side.
> 
> Start here: 
> 
> https://developer.authorize.net/api/reference/index.html 
> <https://developer.authorize.net/api/reference/index.html>
> 
> 
>> On Nov 20, 2019, at 11:40 AM, Joe Dombroski > <mailto:j...@bel.com>> wrote:
>> 
>> wow - big question. I guess where do you start?
>> 
> 

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

Re: Authorize.net integration?

[Lee Hinde via 4D_Tech]

I only did payments (not recurring, or pre-qual or anything like that.)

Also, I did this for a 4D hosted web site to take payments from (my customer's) 
customers. There's web-side and 4D-side.

Start here: 

https://developer.authorize.net/api/reference/index.html 



> On Nov 20, 2019, at 11:40 AM, Joe Dombroski  wrote:
> 
> wow - big question. I guess where do you start?
> 

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

Re: Authorize.net integration?

[Lee Hinde via 4D_Tech]

Yes. What would you like to know?

> On Nov 20, 2019, at 11:08 AM, Joe Dombroski via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Has anyone had any luck integrating Authorize.net or another provider with
> 4D?
> 
> -
> Joe Dombroski
> ---

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

Re: Web aficionados - Not allow user to access file directly

[Lee Hinde via 4D_Tech]

If you can't find it: 
http://www.island-data.com/downloads/books/4D_Web_Companion.pdf

Some hacker/pirate named David Adams has put David Adams book on the internet 
for all to see.


> On Oct 1, 2019, at 8:55 AM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Lutz,
> 
> Thanks for the info!
> 
> Yes, I've got a copy of "Web Companion" somewhere.
> 
> Will check it out.
> 
> Randy Engle
> 
> -Original Message-
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Epperlein, Lutz 
> (agendo) via 4D_Tech
> Sent: Tuesday, October 1, 2019 8:49 AM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Epperlein, Lutz (agendo) 
> Subject: AW: Web aficionados - Not allow user to access file directly
> 
> Use the so-called "Web decoy" technique. Basically you put your html files in 
> another folder outside your html root. Then redirect all requests using ON 
> WEB CONNECTION. For every http request 4D cannot serve directly, it uses ON 
> WEB CONNECTION.
> 
> This is more elaborated e.g. here:
> 
> How to skip over HTTP and redirect to HTTPS
> https://kb.4d.com/assetid=75313
> How to skip over HTTP and redirect to HTTPS: Part 2 (The Web decoy folder)
> https://kb.4d.com/assetid=75753
> 
> And there was a book "The Web Companion" by David Adams, it's a bit old now, 
> but the technique remains the same. If you can get a copy ...
> 
> HTH
> 
> Regards
> Lutz
> 
> -Ursprüngliche Nachricht-
> Betreff: Web aficionados - Not allow user to access file directly
> 
> Hi Web Experts,
> 
> I don't want the web users to access html files directly, without going 
> through ON WEB CONNECTION.
> 
> e.g.
> 
> http://myweb/foobar.html
> 
> If "foobar.html" exists in the web folder, Users can put in this in the 
> address and it will pull up the web page, but will not process the 4D Tags, 
> etc.
> Very, very funky.
> 
> So, I'm probably being a dope, but does anyone know what I can do to prevent 
> accessing html files directly?
> 
> Gracious thanks
> 
> Randy Engle
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> 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 Internet Users Group (4D iNUG)
> 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: [v17.3] - Clear 4D-Oject

[Lee Hinde via 4D_Tech]

Clear variable?

> On Sep 23, 2019, at 5:01 PM, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> G’day,
> 
> Is there a simpler way to clear/destroy a 4D-Object than to loop trough it?
> 
> I think of something already implemented in ObjectTools - OT Clear(ObjHandle) 
> / OT Clear (All)
> 
> Thanks
> 
> Cheers
> 

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

Re: Connecting to UPS

[Lee Hinde via 4D_Tech]

Thanks!

If it's that old, you're probably using the xml data structure, not json, 
correct?


> On Jul 31, 2019, at 2:39 PM, JasonH via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> I'm using the the UPS API, but haven't looked at the code in over 5 years. 
> If you run into specific problems I can try to help though.
> 
> I just checked, and I can still pull up tracking by reference. :-)
> Along with tracking, I also use their API for rate quotes, TIT, and address
> validation.
> 

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

Connecting to UPS

[Lee Hinde via 4D_Tech]

UPS used to support a url-based status check where the user could track
packages based on their internal data - an invoice number and the UPS
Customer number got you the status for that delivery. (Specifically
avoiding having to store a UPS tracking number in the database.)

About a month ago they stopped supporting that approach. And I've been
trying to figure out their API since.

Before I get going, I'm checking to see if anyone has pointers on
navigating the dev process and/or insights on the UPS API.

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: Microsoft Azure & 4D

[Lee Hinde via 4D_Tech]

+1 for Transloadit. Nice tool.

On Fri, Jul 19, 2019 at 5:13 PM Kirk Brooks via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> John,
> I have been using Bruno's AWS component for a few years myself. I'm going
> to be moving away from using the component soon. Not because of a problem
> with it but because I'm changing the way files are put into AWS. I'm
> looking at a service for managing file transfers called Transloadit
> . They have 'robots' pre-configured to transfer
> files to Azure, AWS, Dropbox, Instagram and others. And it's really easy.
> It's not free but it looks pretty good so far.
>
> What I particularly like is being able to defined a URL to receive a
> notification for each file. I set up an API to receive these and update the
> database with the specifics.
>
> On Fri, Jul 19, 2019 at 3:33 PM JOHN BAUGHMAN via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > I have a deployed database that is currently using AWS. We have 200gb of
> > PDFs stored on the same machine as 4D server. A Xojo Web App displays the
> > available PDFs, when the end user requests one of the PDFs Xojo sends the
> > request to 4D and 4D returns the PDF.
> >
> > At the present time we are using AWS to handle large files that stall our
> > the Xojo web app, by uploading the file to AWS and sending an email link
> to
> > the file to the requesting user. This all works great.
> >
> > Now the client wants to move the PDF archive to the cloud and have 4D
> > serve them all from the ASW cloud. I do not see that should be any
> problem
> > using Bruce Legay’s excellent AWS Component.
> >
> > Now the client suddenly has expressed a desire to use Microsoft Azure
> > instead of AWS. So my question to you all are…
> >
> > 1. Is anyone out there using Azure for data storage and
> retrieval?
> > If so any suggestions on where to look for help ie. Component or plug
> in. I
> > don’t see anything in the knowledge base.
> >
> > 2. Any thoughts on the pros and cons between using Azure or AWS.
> >
> > Thanks,
> >
> > John
> >
> >
> >
> >
> > John Baughman
> > Kailua, Hawaii
> > (808) 262-0328
> > john...@hawaii.rr.com
> >
>
>
>
> --
> Kirk Brooks
> San Francisco, CA
> ===
>
> What can be said, can be said clearly,
> and what you can’t say, you should shut up about
>
> *Wittgenstein and the Computer *
>
>
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Filter MSC Log File?

[Lee Hinde via 4D_Tech]

Yea, that was annoying to discover. You can still search for the xml tag in the 
source with a text editor. You had a 'warning' in your example. I think the 
other one of interest is ' On Jun 18, 2019, at 3:11 PM, Wayne Stewart via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> That doesn't work because it's a just a visual element rendered in the
> web browser.

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

Re: Blast from the Past!

[Lee Hinde via 4D_Tech]

Welcome back!

> On Jun 3, 2019, at 8:06 AM, Narinder Chandi via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Greetings Fellow 4Ders!
> 
> It's been quite some years since I was last here but since I have been doing 
> some 4D development on and off I thought it was time to return to the list to 
> give and (more likely!) receive help when needed! I've been supporting an old 
> client for many years and guided the system through various upgrades to v15. 
> We are shortly to commence an upgrade to v17. I might also be interested in 
> some new 4D development opportunities (if any are available!)... ping me if 
> you wish to talk further.
> 
> Most of these last few years I've been mostly involved full-stack development 
> on LAMP using a variety of PHP frameworks including Zend, Laravel and 
> Symfony. I've also been recently involved with Drupal v7 but the less said 
> about that the better ;)
> 
> I have been perusing the Nabble archive these last few days and although 
> traffic seems a fraction of what it used to be I still see many, many 
> familiar names so hello to those who may recall me through the list or in 
> person at the 4D Summits from years gone by.
> 
> Finally, I have an idea for setting up a 4D developer community on a 
> different platform but I will send a separate email to gauge interest.
> 
> Regards,
> 
> Narinder Chandi,
> ToolBox Systems Ltd.
> -- 

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

Re: Static Pictures to Library Pictures

[Lee Hinde via 4D_Tech]

I recently used this to fix some string resource issues. It's a v12
database, apparently, but I opened it in a later version without issue:

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

On Tue, Jun 4, 2019 at 4:11 PM Ben Sokal via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> We are finally moving to v17 and need to fix all our static PICT images.
> From previous posts and from the 4D knowledge base I understand how to
> convert library images by looping through them and running the conversion
> code. But the problem is we have over 1100+ static PICT images that aren't
> in the library. The MSC has identified these images but that's only
> somewhat helpful since that still means we have to go to every object on
> hundreds of forms, and change the properties from STATIC PICTURE to LIBRARY
> PICTURE. I can spend week(s) doing this but...maybe someone has found a
> more efficient way to handle bad static images that aren't in the picture
> library?
>
> - Ben
> **
> 4D Internet Users Group (4D iNUG)
> 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: Old String resources

[Lee Hinde via 4D_Tech]

Miyako's v12 resource converting database upgraded to v17 without issue. I
was able to convert an old .RSR file to Xliff and it worked without me
having to think about it or understand what was going on.

On Sun, Apr 29, 2018 at 9:13 PM Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> it did not "go away", at least in 32-bit versions,
> but you'd need to put the RSR file inside your resources folder.
> (until 2004, they could be placed adjacent to the structure folder)
>
>
> http://doc.4d.com/4Dv16R4/4D/16-R4/Deprecated-or-removed-features-in-v16-product-range.200-3425465.en.html
>
> jump to "Mac Resources"
>
> at some point, you'd want to convert your STR# resources to an XLIFF file,
> where the group ID and resource ID matches that of the old STR#.
>
> then, you won't have to change anything in your code or form,
> the "15001,1" syntax (as well as STRING LIST TO ARRAY) will continue to
> work.
>
> see also
>
> http://kb.4d.com/assetid=76783
>
> > 2018/04/30 3:32、Dave Tenen via 4D_Tech <4d_tech@lists.4d.com> のメール：
> >
> > Now I am working on what looks like old string text references (if I
> remember correctly).  It looks like they refer to a specific resource to
> pull the string out.  The reference is formatted this way “:15000,9”, etc.
> In this particular case they were being used as titles of a subform, but
> they are scattered throughout this db for various forms.
> > My questions are what version of 4D did these go away?
>
>
>
>
> **
> 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)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

e-nodes licensing

[Lee Hinde via 4D_Tech]

I just used e-node's new master-key password for the first time and I like
it. If you've not used it yet, the first time you launch, you use the
register command with a slightly different format that includes your email
address.

When the code runs it generates your serial number which is emailed to you
AND is placed in the licenses folder. So, basically, you're good to go at
that point.

The first time I used this was with a client where I had access to the
server. So, I ran an instance of the structure with master key and then
updated it right away with an instance that had the standard 'AL_Register'
with the final key that was emailed to me.

I'm now going to update a client where I don't have access to the server.
So, each update is an imposition on them and as a consequence I want to
minimize the updates.

My question is: can I run in production with the master key, or do I need
to do a 'next' version of the structure with the final serial number?

The docs also suggest:

Quick and easy way – End-user online instant activation
1. Make sure that the machine where the plugin will be used is connected to
the Internet (single user workstation or in server mode the first remote
client that will connect to the server).
2. Launch your application. Displaying any layout that uses the plugin will
trigger the demonstration mode dialog.

*2.5 and only implied "Click the Register Button"*

3. Enter the Master key that was delivered by e-Node.
4. The plugin will display an alert indicating that it is now registered.


I'm assuming this means I don't need an AL_Register call in my database at
all if I do this. A license file is created in the 4D server's license
folder and all is well. But that's not stated and I don't have  way to test.
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP

[Lee Hinde via 4D_Tech]

But not sub-sub-tables. (actually had one of those handed off to me last year.)


> On Mar 26, 2019, at 3:35 PM, B.Bippus via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> (We're still
> working on converting subtables to real tables. That limits this project
> to v14 until that's done.)
> 
> Do you know that V16 works with subtables?
> 
> Bernd.
> 

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

Re: Doris Beaulieu 31 Year Anniversary at 4D

[Lee Hinde via 4D_Tech]

Happy Anniversary Doris!


> On Mar 13, 2019, at 2:02 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> LinkedIn sent out an email today that Doris Beaulieu has worked for 4D for 31 
> years, since March 1988. I’ve never known a time when she were not at 4D. 
> Always there to greet developers and 4D Partners at every 4D Summit too. 
> 
> Congratulations! I hope they give her a party or something at 4D. She 
> deserves it.
> 
> Tim
> 
> *
> Tim Nevels
> Innovative Solutions
> 785-749-3444
> timnev...@mac.com
> *

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

Re: Native 4D to make REST request to Django application

[Lee Hinde via 4D_Tech]

Django is a python web framework. Django Rest Framework (DRF) is a plugin that 
facilitates adding a REST Api. It’s the most popular plugin for this,  but it’s 
not the only way to do it.

When I did this before there was an explicit call to get the token - the django 
developer created it. They may have used the default path, I’m not sure 
(/get-token)  I used the 4D command :
HTTP AUTHENTICATE($user;$password)
for the request to get the token.

Thereafter I used the token in the header and built the headers using arrays 
with HTTP Request… In my case the format for the header was:

Header Name: Authorization, Header Value : Token 


> On Dec 10, 2018, at 3:52 PM, Olson, Brad via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am looking for assistance with developing a REST interface to a Django 
> application using native 4D v16R6 commands.  Is it possible to do this?  I 
> have been given a username, Password, and Basic Authorization token and  I 
> have tried using the HTTP AUTHENTICATE command to set username and password, 
> and then adding the Authorization to the http header but I am not getting 
> back the expected JSON results using the HTTP Get function.
> 
> Any suggestions would be appreciated!
> 
> Thank you,
> Brad Olson
> CommScope, Inc.
> **
> 4D Internet Users Group (4D iNUG)
> 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 to get "record number" value

[Lee Hinde via 4D_Tech]

That’s his thread. :-) 


> On Nov 28, 2018, at 10:48 AM, Christian Sakowski via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi,
> 
> see discussion here:
> 
> http://forums.4d.com/Post/FR/27391864/1/27436514#27436514
> --
> 
> Grüße/Regards,
> [heubach-media] | Christian Sakowski
> christian.sakow...@heubach-media.de
> Tel: +49/(0)40/52 10 59-23
> 
> 
> 
> 
>> Am 23.11.2018 um 18:10 schrieb Gianluca Rigotti via 4D_Tech 
>> <4d_tech@lists.4d.com>:
>> 
>> Hi all,
>> anyone know if there is a way to get the same value returned by “Record 
>> Number” using an ORDA query?
>> 
>> TIA,
>> Gianluca
>> 
>> 
>> Gianluca Rigotti
> 
> 
> --
> heubach media
> Osterfeldstr. 12-14 | Haus 1 | Eingang Nord
> 22529 Hamburg
> tel: 040 / 52 10 59 - 10 | fax: -99
> mail: i...@heubach-media.de
> home: www.heubach-media.de
> Geschäftsführer|CEO: Matthias Heubach
> =

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

Re: Sales Tax Solutions for 4D

[Lee Hinde via 4D_Tech]

TaxJar has a great api that works as advertised. You build a c_object, send it 
via http_request and process (deconstruct) the object returned.

You send the token they want in the headers array that is part of http_request.

https://developers.taxjar.com/api/reference/?shell#introduction 


The curl examples show you what the returned objects will look like, or use the 
example from the language you’re most familiar with.

> On Oct 31, 2018, at 10:58 PM, Dan Ivy via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> After some research it looks like we will settle on taxjar. Could you please 
> share some tips or 4D code on how you are communicating with their api? I'm 
> not sure where to start.
> 
> Thank you!
> Dan Ivy
> 
> 
> 
> I talked to this service via 4D. Best API I’ve dealt with aside from maybe
> Stripe.
> 
> https://www.taxjar.com/ 
> 
> 
>> On Aug 16, 2018, at 9:28 AM, Dan Ivy via 4D_Tech <4d_tech@lists.4d.com>
>> wrote:
>> 
>> I'm looking for suggestions to address the new US sales tax law and the
>> requirement for calculating sales tax across all states and jurisdictions.
>> I
>> have done sales tax calculations for some clients with a physical presence
>> in a couple of states, and that is manageable. Trying to keep up with tax
>> laws in all states and counties, seems unmanageable, kinda like a 50 state
>> payroll system.  
>> 
>> Has anyone done this directly in 4D? have you integrated 4D with a cloud
>> SaaS tax service?  Can regularly updated sales tax "tables" be purchased
>> from third parties? 
>> 
>> There's so little traffic on the 4D board about "sales tax" that it must
>> be
>> given there's readily available solutions for tax calculation.
>> 
>> Thanks for the ideas
>> 
>> Dan Ivy
>> ivyleaf systems
>> birmingham al
>> 
>> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
> 
> Quoted from: 
> http://4d.1045681.n5.nabble.com/Sales-Tax-Solutions-for-4D-tp5759604p5759607.html
> 
> _
> Sent from http://4d.1045681.n5.nabble.com
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Mac OS 10.14 Mojave and 4D 15

[Lee Hinde via 4D_Tech]

I’ve got a fairly complicated db in 15.4 that I can open ok and use as needed 
until It bails on ALP use. The client is budgeting for an update.


> On Oct 19, 2018, at 2:31 PM, macjimbo via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I just tried running 4D 15.6 (4D, not a built app) on a Mac with Mojave and
> it just crashed on launch.

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

Re: Sales Tax Solutions for 4D

[Lee Hinde via 4D_Tech]

I talked to this service via 4D. Best API I’ve dealt with aside from maybe 
Stripe.

https://www.taxjar.com/ 


> On Aug 16, 2018, at 9:28 AM, Dan Ivy via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> I'm looking for suggestions to address the new US sales tax law and the
> requirement for calculating sales tax across all states and jurisdictions. I
> have done sales tax calculations for some clients with a physical presence
> in a couple of states, and that is manageable. Trying to keep up with tax
> laws in all states and counties, seems unmanageable, kinda like a 50 state
> payroll system.  
> 
> Has anyone done this directly in 4D? have you integrated 4D with a cloud
> SaaS tax service?  Can regularly updated sales tax "tables" be purchased
> from third parties? 
> 
> There's so little traffic on the 4D board about "sales tax" that it must be
> given there's readily available solutions for tax calculation.
> 
> Thanks for the ideas
> 
> Dan Ivy
> ivyleaf systems
> birmingham al
> 
> 

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

Re: Who’s got the gazpacho?

[Lee Hinde via 4D_Tech]

:-)

On Thu, Jul 19, 2018 at 3:24 PM Keith Culotta via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Sorry, looking for the Paula Deen list.
>
> Keith - CDI
>
> **
> 4D Internet Users Group (4D iNUG)
> 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: What do you use to monitor your offsite servers?

[Lee Hinde via 4D_Tech]

Looking at the responses you’re getting makes me wonder about the use case.

I liked Join.Me for remote support. It was easy to get remote users online 
pretty easily (assuming they had permission to install software). That scenario 
was “Ben is having problems and I need to login to his computer to see what’s 
up. Installation didn’t require a restart, which is bonus. As time went on they 
started requiring everyone to have an account, which slowed things down. But, 
for the price, fine.

I also had a client using Splashtop, which is permanently installed on his 4D 
server so I can login and do stuff. I use Dropbox to transfer files, so I can’t 
speak to that part, But the screen sharing/driving the remote computer is aces.



> On Jul 15, 2018, at 1:27 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I've been using LogMeIn for a few years. It was great at $100/year. It was
> OK at $200/year but now it's going up to $350/year and it's time to loo for
> something else.
> 
> Suggestions?
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *We go vote - they go home*
> **
> 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: Best way to share large files with web users

[Lee Hinde via 4D_Tech]

The cost for S3 is minimal. Especially for dev use where you can control
file size. It'll be pennies.

On Fri, Jun 29, 2018 at 9:34 AM JOHN BAUGHMAN via 4D_Tech <
4d_tech@lists.4d.com> wrote:

>
>
> > On Jun 29, 2018, at 6:01 AM, Kirk Brooks via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> >  although you only ever get one year free.
>
>
> I was thinking that if I use my personal account or create a new account
> in my company name and use it for development, I could then for deployment
> create a new account for the client in their name. Would not the new
> account be eligible for a free year. Is that not the case? How are the 2
> accounts linked?
>
> I guess the development side should be pretty quick and leave at least 11
> months free for the client. Taking your advice and assuming the second
> account would not get a free year, then I should create a new account for
> the client with their credit card from the get go.
>
> John
>
>
> **
> 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: Content Security Policy - inline style

[Lee Hinde via 4D_Tech]

> On Jun 15, 2018, at 12:18 PM, Jim Hays via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> We wrestled with getting our web security up to snuff without having any
> in-house expertise.
> I found this site useful for testing and offering up next steps and links
> on how to fix the problems.
> 
> https://observatory.mozilla.org/ 
> 
> We found answers to exactly your issues by following these steps.
> 
> - Jim

Nice resource; 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
**

Re: Comparing all methods in structures

[Lee Hinde via 4D_Tech]

On Jun 15, 2018, at 10:15 AM, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com> 
wrote:
> 
> I have two structures, which contain quite a few methods. One has been edited 
> a bit but due to a slapdash approach to record-keeping, I can’t easily 
> establish which methods have been edited. Is there an easy way to compare the 
> methods in the two structures?
> 
> I suppose running a small method, in each structure, which exports all the 
> methods into a folder and then using something like BBEdit to do the 
> comparison would work, but has anyone had to do this and come up with 
> something better?
> 

Export and compare in BBEdit (or Kaleidoscope) is exactly what I do.

**
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: Import data in 4D format using XML

[Lee Hinde via 4D_Tech]

http://doc.4d.com/4Dv16R6/4D/16-R6.1660/Not-for-32-bit-versions_3546700.999-857020.en.html
 


Just swap the url to the language you want.

> On May 1, 2018, at 7:03 AM, Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> The link you have provided, unfortunately, is in Japanese ;-)

**
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: Access to Macintosh Accessibility tools from within 4D

[Lee Hinde via 4D_Tech]

Thanks Tim and Kirk. Does Miyako have a bat signal, like J*P*R does?


> On Apr 30, 2018, at 12:47 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> On Mon, Apr 30, 2018 at 12:17 PM Tim Nevels via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> On Apr 30, 2018, at 2:00 PM, Lee Hinde wrote:
>>> Someone working with the client is telling me that the 4D GUI isn't
>>> responding as other programs do. They're using v15.
>>> 
>>> Has anyone worked on making their database accessible? Any pointers?
>> 
>> I remember a plugin that was available for 4D that would accept voice
>> commands and you could then program 4D to respond. I forget the name of the
>> guy that created it. I went to his session at 4D Summit a few years ago.
>> You might be able to use that and do some custom programming to make your
>> 4D application voice accessible.
>> 
>> Anybody remember the name of this plugin or the guy that wrote it.
>> 
> 
> ​I'd check with Miyako. I recall him demoing something he wrote maybe 10
> years ago that allowed 4D to respond to movement. It was cool but I
> couldn't think of anything to do with it.
> ​
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *We go vote - they go home*
> **
> 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: Testing for Null is superior to OB is defined

[Lee Hinde via 4D_Tech]

How did I miss that… so much new stuff.

Also, FINALLY.

> On Apr 30, 2018, at 2:21 PM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> the command "Split string", although generic,
> was specifically created to help parse dot notation.
> 
> http://doc.4d.com/4Dv16R6/4D/16-R6/Split-string.301-3644822.en.html 
> 

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

Access to Macintosh Accessibility tools from within 4D

[Lee Hinde via 4D_Tech]

A client has been in an accident and has lost use of his hands and needs to
operate his 4D database via speech.  I'm told that the Mac Accessibility
System Preference can be configured so that you can talk to your mac and
verbally click buttons and operate menus (I'm getting an error right now
trying to configure it.)

Someone working with the client is telling me that the 4D GUI isn't
responding as other programs do. They're using v15.

Has anyone worked on making their database accessible? Any pointers?
**
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: Macro to check that local variables are declared in a method? [Solved]

[Lee Hinde via 4D_Tech]

I was looking at that string and testing it a bit more (after it’s been 
canonized, of course.)

Underscores aren't captured in the original, which a lot of us use -  e.g.e, 
$somestring_t

This captures those:  \$[_a-zA-Z0-9]*   All I did was add the underscore 
between the [].

What I’m not sure how to do (well, I’m unwilling to spend the time, because 
WTH) is capture spaces within a variable name.

**
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: Macro to check that local variables are declared in a method?

[Lee Hinde via 4D_Tech]

On Apr 27, 2018, at 8:54 AM, Bob Miller via 4D_Tech <4d_tech@lists.4d.com> 
wrote:
> 
> Hello,
> 
> Has anyone created a macro to check a method to make sure all its local 
> variables are declared?
> 
> I've thought about undertaking such a thing, but as it probably involves 
> getting into regular expressions, I've been looking forward to doing this 
> with some dread.
> 
> If anyone has done this already and is willing to share, I'd be much 
> obliged!
> 
> The "tough" issue for me is "how to identify a local variable":
> - it begins with a $
> - it may end with any of these characters: space, equals, semicolon, 
> colon, dash, left paren, left curly brace, end of line, or any arithmetic 
> or comparison operator
> - it is not fully enclosed in quotes; example: "$ ###,###.00" is a format, 
> not a local variable, but I'm ignoring EXECUTE ON SERVER, etc.
> 
> I'm probably making a mountain out of a molehill, but hey, that's what 
> this list is for - to let people show me exactly that.  I appreciate it.
> 
> 
> Bob Miller
> Chomerics, a division of Parker Hannifin Corporation


I just tried this as the search criteria, using BBEdit,  in a method and it 
found all the locals. \$[a-zA-Z0-9]*

I don’t think you have to worry about how the var ends, just look for valid 
characters in the var, which I think are numbers and letters. So, your format 
wouldn’t match because there’s a space and non-valid characters (#)
**
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: 4D Summit 2018 Comments

[Lee Hinde via 4D_Tech]

> On Apr 9, 2018, at 10:32 AM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Something that may not be immediately obvious is that using ORDA will reduce 
> the amount of code needed to query the database. In relational databases you 
> have to query this table, join to another table, query selection, relate 
> many, etc. We are all used to doing this and we need to know exactly what the 
> database structure is. What table is the one table, what table is the many 
> table, is there a many-to-many intermediate table we need to deal with, etc. 

I use Django, an open-source python web framework, for my pure-web projects.

This is what a user search looks like. I tell users they can search by last and 
first or by last name (this is for one specific search block, more complex 
searches are available. :-))

def people_name_search(name):
if name:
if ',' in name:
lname, fname = split_name(name)
return Person.objects.filter(last_name__istartswith=lname, 
first_name__istartswith=fname,
 deactivated=False)[:10]
else:
return Person.objects.filter(last_name__istartswith=name, 
deactivated=False)[:10]
else:
return Person.objects.none()

You can suss that out even though there is magic syntax (objects? 
istartswith?). What you can’t see is that the object “Person” has a default 
sort order defined (last name, first name), so that result gives you an ordered 
list of the first 10 records that match the query.

Below  is a cross table (join) query:

The table relationship are Person <—Enrollment—> Registration and Person 
<—ProductSale—> Registration..

The query gives me the registration records that have associated enrollment or 
product sales records that are linked to a person whose name is ….

The Q thing is the syntactic sugar needed to do OR searches. (all the 
frameworks have their wth.)

def enrollee_name_search(name):
if name:
if ',' in name:
lname, fname = split_name(name)
return 
Registration.objects.select_related().filter(Q(enrollment__person__last_name__istartswith=lname,
  
enrollment__person__first_name__istartswith=fname)
|

Q(productsale__person__last_name__istartswith=lname,
  
productsale__person__first_name__istartswith=fname)
)
else:
return 
Registration.objects.select_related().filter(Q(enrollment__person__last_name__istartswith=name)
|

Q(productsale__person__last_name__istartswith=name)
)
else:
return Registration.objects.none()

All of which is to say,  ORDA is going to make complete sense if you’ve done 
any work in a semi-modern framework.

**
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: 4D Summit 2018 Comments

[Lee Hinde via 4D_Tech]

Nice write up, Tim. Thanks!

> On Apr 9, 2018, at 7:06 AM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I got back from 4D Summit 2018 in Washington DC and thought I’d post a few of 
> my thoughts and comments about this year’s summit. 
> 
> I went to JPR’s advanced class and he made a statement at the end that I 
> think really sums of 4D v17. He said this is the biggest update in the 
> history of 4D. Bigger than 4D v3 and 4D Server v1 with multiple processes and 
> windows. And v17 is only the beginning of the changes that are coming.
> 
> There are more features and changes that are far along in development that 
> will be released in v17 R releases and in v18 that will position 4D as the 
> premier, cross-platform RAD package combining an integrated client/server 
> database that has a ORDA interface. There is nothing out there can come close 
> to it. Particularly when you realize this is a cross-platform solution. 
> Compiled, native macOS and Windows versions of a piece of software from the 
> same source code. Integrated, powerful client/server database included. The 
> same piece of software can run as a single-user application or as a 
> client/server application. Tell me who else is doing that? And don’t forget 
> “4D for iOS” as the delicious cherry on top! We’ve got a software application 
> development system that is going to be very hard to beat. 
> 
> What is ORDA? It is not a “a historical sociopolitical and military structure 
> of Mongol Eurasia”. This is a new term that 4D has created. It stands for 
> Object Relational Database Access. I’m guessing in a few years if you Google 
> ORDA that will be for number one link.
> 
> ORDA is coming to the 4D language. That is why we have the “dot notation” 
> option for the method editor. It is needed for ORDA. I think a quick way to 
> summarize ORDA is to say “if you know how Wakanda did database access with 
> JavaScript that is what ORDA is in the 4D programming language”. 4D is 
> bringing the advanced object oriented database access that Wakanda has to 4D. 
> This is going to change the way you will WANT to program in 4D.
> 
> I say “want” because if you are happy using the 4D language the way it is now 
> and has been for 25+ years you are free to continue to do that. JPR calls it 
> “classic 4D”. It will continue to work exactly as it has before.  But if you 
> use the new ORDA method you will reap many benefits. Easier to read code, 
> fewer lines of code, complete control of exactly what relations are used 
> between tables to retrieve data and big speed improvements. That’s right, 
> using ORDA to accomplish a relational database lookup and data retrieve task 
> can in many situations be much faster than doing the same thing with a series 
> of “classic” 4D language commands. So for all you “speed hounds”, you are 
> going to want to use ORDA. (Side note: when Laurent designed the 4D v11 
> database engine he had in mind ORDA and planned for the optimizations. This 
> thing has been in development for many, many years.)
> 
> If you have used Wakanda or know how it accesses the 4D database in an object 
> oriented way, you already know how to use ORDA in 4D. That’s because it uses 
> basically same syntax as Wakanda. In my opinion this the beginning of 
> bringing all that is great about Wakanda and making it an integral part of 
> 4D. Use it if you want, or ignore it and continue to use the classic 
> programing language. Or use them both. You have a choice.
> 
> When I heard about the 4D Summit Advanced class and that JPR would also 
> joined by Laurent I knew something special was coming to 4D. (Laurent had to 
> be there because the subject matter was so new and broad that JPR would not 
> have answers to all questions. And that turned out to be true.) I thought 
> they were going to introduce a new language to 4D. JavaScript for 4D. My 
> visions were that there would be “Begin JavaScript” and “End JavaScript” 
> commands like they “Begin SQL” and “End SQL” commands that would let you 
> write JavaScript and do fancy things like you can do in Wakanda with 
> JavaScript. I was wrong. There is no JavaScript support in 4D, and there 
> probably never be — outside of web areas. 
> 
> Many, many changes to the 4D language are coming. I sat at a table with 
> Laurent and some other 4D developers at lunch one day and Laurent said the 
> new 4D language will be “JavaScript inspired”. He intends to add features to 
> the 4D language so that it will be even better than JavaScript! Inheritance, 
> error handling, custom data classes and the list goes on and on. The days of 
> the 4D language not getting updated are over. The changes are just getting 
> started. Reminds me of that movie where the character says “Badges? we don’t 
> need no stinking badges”. JavaScript? We don’t need no stinking JavaScript. 
> We are going to have something better. This is good news!
> 
> One example of a change in the 4D language is the “For e

Re: Collections

[Lee Hinde via 4D_Tech]

Please. You mean like an array in almost any other language:

python:
x = ["fred", 2, {"test":4}]

javascript:
var x = ["fred", 2, {"test":4}];


> On Mar 21, 2018, at 1:00 PM, Tom Swenson via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> OK, like PHP arrays 
> 
> On 3/16/18, 8:23 AM, "4D_Tech on behalf of Jeff Grann via 4D_Tech" 
> <4d_tech-boun...@lists.4d.com  on behalf 
> of 4d_tech@lists.4d.com > wrote:
> 
>Haven’t worked with them yet, but my understanding is that a collection is 
> an ordered list of values of possibly varying types.  In 4D arrays, all of 
> the values must be the same type.  In a 4D collection, you can use mixed 
> types as the elements.
> 
>Example:
> 
>$MyCollection[0]:=“Hello”
>$MyCollection[1]:=5
>$MyCollection[2]:=$AnObject
>$MyCollection[3]:=$AnArray
>$MyCollection[4]:=True
> 
>--
>Jeff Grann
>SuccessWare, Inc.
> **
> 

**
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: 4D data on the web - what do you use?

[Lee Hinde via 4D_Tech]

My overarching advice is start with the basics. No plug-ins, no javascript 
front end.

It’s interesting that people want you to add a javascript front-end. I’m 
working on some React stuff now, so there’s a place for it, but I’d suggest you 
wait until you need it and not start there.

1. No plug-ins to start, use native 4D. Not that other tools aren’t great, but 
if you don’t know why you’re using them, they won’t make sense. You can start 
with any text editor, like the others I like WebStorm. But that has a learning 
curve too. Visual Studio Code is cross-platform, free and is a nice balance 
between a text editor and a full blown IDE.

2. I prefer to put 4D behind Apache (others use Nginx) so that 4D only deals 
with data. Apache can be configured to deal with static content (images, style 
sheets, etc.). Especially if your site could be accessed by the world, use a 
web server in front of 4D.

3. You're displaying data. So, you’ll need to modify 4D access the data 
(queries) and send the right template/json back to the browser.


> On Mar 14, 2018, at 1:08 AM, Keith Goebel via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi all. 
> We have an extensive 4D system to which we want to provide summary overviews 
> and drill-downs via the web.
> I have a couple of questions I'm hoping somebody will be able to answer...
> 
> Are you using 4Dv16 in a client server environment as well as providing a web 
> interface to the data?
> If so, we would like to know what software and plugins do you use to make the 
> web environment happen?
> - software and plugins for development?
> - software and plugins for deployment?
> - are you able to do the web development without getting the 4D programmer(s) 
> involved (apart from describing the data structure)?
> Thanks in advance, Keith
> 
> 
> **
> 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: Delivery problem

[Lee Hinde via 4D_Tech]

You can also walk him through the steps of ignoring the warning.

https://mac-how-to.gadgethacks.com/how-to/open-third-party-apps-from-unidentified-developers-macos-0158095/
 



> On Feb 21, 2018, at 10:09 AM, Keith Culotta via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> So I build a quick sample app for a client and send a zipped copy.  He writes 
> back and says his Mac won't open it because it’s from an undignified developer
> 
> Keith - CDI
> **
> 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: European Data Protection Reglementation to take effect on May 25 - 4D compliance?

[Lee Hinde via 4D_Tech]

https://scotthelme.co.uk/protect-site-from-cryptojacking-csp-sri/ 



> On Feb 12, 2018, at 12:47 AM, James Wright via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> The ICO's website was being used to distribute javascript based crytpo
> mining malware. Some third party JS library was hacked and they were using
> a public CDN version.
> 
> Funny :)
> 
> On 12 February 2018 at 07:57, Bernd Fröhlich via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Stephen Shaw:
>> 
>>> You may find the UK’s ICOs website more user friendly.
>>> 
>>> https://ico.org.uk 
>> 
>> Yup. It´s short and gets right to the point:
>> 
>> "We're sorry, but our website is unavailable at the moment. Please try
>> again later.
>> 
>> We apologise for any inconvenience caused."
>> 
>> :-))
>> 
>> Greetings from Germany,
>> Bernd Fröhlich
>> **
>> 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
>> **
>> 
> 
> 
> 
> -- 
> [image: logo]
> *James Wright* C.T.O.*, Drag and Drop*
> Tel: 08000 43 22 12 | Suite 6/7 Chichester House, 45 Chichester Road,
> Southend-on-Sea, Essex SS1 2JU
> supp...@draganddrop.co.uk | www.ezadspro.co.uk | www.draganddrop.co.uk
> **
> 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: ADA Compliance ???

[Lee Hinde via 4D_Tech]

I’m familiar with web accessibility:

https://www.w3.org/WAI/intro/accessibility.php 


I found this as an example for desktop software: 
https://www.justice.gov/crt/software-accessibility-checklist 


Generally, the question is how would a person with a disability use your 
software? On the desktop I assumed most people punted to the OS. Apple has done 
a lot in that regard.

I’m surprised (not) that this is the first time it’s come up for you, since the 
ADA was passed in 1990.


> On Jan 24, 2018, at 8:04 AM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Every week, or so, one of our customers comes up with something that they 
> do/need that I've never heard of before.
> 
> This weeks winner is a major city in Southern California.  (no names 
> mentioned...)
> 
> They want to know at  what "Level" our web product is ADA compliant.
> 
> I'm aware of ADA compliance when it comes to physical spaces, ramps, 
> bathrooms, etc., but not for software (web pages, specifically)
> 
> Anybody had the pleasure of handling this one yet?
> Know of any resources?
> 
> Thanks
> 
> Randy Engle, Director
> XC2 Software LLC – XC2LIVE!
> 
> 
> **
> 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 SQL Question

[Lee Hinde via 4D_Tech]

DELETE FROM users
WHERE id in [1,2.3];

would delete the three users with one of those ids (or none at all, if the ids 
didn’t exist.)

DELETE FROM users
WHERE last_name=“Smith”;

would delete all users with the last_name of Smith.

> On Jan 22, 2018, at 9:06 AM, Stephen J. Orth via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> SQL newbie here...
> 
> What is the correct syntax for deleting a number rows in a SQL database?  Is 
> it possible to use a 4D array which contains the values used by the WHERE 
> clause?
> 
> Or, do we have to delete each row individually?
> 
> Thanks!
> 
> 
> Steve
> 
> *
>  Stephen J. Orth
>  The Aquila Group, Inc. Office:  (608) 834-9213
>  P.O. Box 690   Mobile:  (608) 347-6447
>  Sun Prairie, WI 53590
> 
>  E-Mail:  s.o...@the-aquila-group.com
> *
> 
> 


**
4D Internet Users Group (4D iNUG)
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: Using web areas in v16, is there a way to 'talk back' to 4d...

[Lee Hinde via 4D_Tech]

Thanks. I appreciate that one avenue of effort might be to spend more time on 
tweaking the css to make it work. I’m just trying to see which is the path of 
least resistance.

> On Jan 4, 2018, at 8:00 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> the difference between system vs embedded is more significant on Windows,
> but in general, if a JS/CSS/HTML feature is missing, there should be a decent 
> polyfill to cover that.
> 
> the embedded engine is CEF on v16 64-bit, not the somewhat outdated version 
> of WebKit,
> which generally delivers excellent results on both platforms.
> 
> are you using an existing library "out of the box"?
> it might be misjudging the "browser" it is running on.
> 
> anyway, you shouldn't move away from embedded web area simply because "the 
> display goes hell".
> 
> there should be a good explanation at the JS/CSS/HTML level.
> 
> 2018/01/05 11:31、Lee Hinde via 4D_Tech 
> <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>> のメール：
> Again, once I start using the embedded webkit, where I get call-backs 
> built-in, the display goes to hell. It looks fine if I use the system 
> browser. (non-embedded.)
> 

**
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: Using web areas in v16, is there a way to 'talk back' to 4d...

[Lee Hinde via 4D_Tech]

Glad you asked, since this is your fault. :-)

I’m displaying a bunch of images. I want the user to be able to double click on 
the image and have 4D pop-up a different dialog.

Again, once I start using the embedded webkit, where I get call-backs built-in, 
the display goes to hell. It looks fine if I use the system browser. 
(non-embedded.)


> On Jan 4, 2018, at 5:14 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Lee,
> Be more specific about the scope of "talk back".
> 
> The easiest way to directly allow users to interact with a web area
> displaying a page you created is the filter URL option. This is how I use
> web areas and either do something like popup a 4D menu or make a connection
> to an actual web link. I've never tried filtering URLs on a website I
> loaded from the net.
> 
> Anyway, it's really easy if you make anything the user can click on an
> anchor. And it works using the webkit or not.
> 
> if you've got js doing things on the web page or the user is entering data
> and you need to tap on 4D's shoulder to get it to do something the $4d and
> URL callbacks Miyako linked to is what you need. In that case you may have
> to use the webkit.
> 
> On Thu, Jan 4, 2018 at 3:55 PM, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> without needing a web server license and without using the 'embedded web
>> rendering engine'?
>> **
>> 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
>> **
> 
> 
> 
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *The only thing necessary for the triumph of evil is for good men to do
> nothing.*
> 
> *- Edmund Burke*
> **
> 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: Using web areas in v16, is there a way to 'talk back' to 4d...

[Lee Hinde via 4D_Tech]

Thanks Keisuke, but the integrated webkit can't display the page I'm trying
to render...

I may have to get less fancy so I can use the callbacks.

Thanks.

On Thu, Jan 4, 2018 at 4:32 PM, Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> this example contains both $4d and URL-based callbacks.
>
> https://github.com/miyako/4d-tips-web-area-charts
>
> see also
>
> https://github.com/miyako/4d-utility-compare-webarea-features
>
> ---
>
> either way, web server license is totally unnecessary.
>
> URL-based callback doesn't talk to the web server,
> it simply triggers a form event.
>
> 2018/01/05 8:55、Lee Hinde via 4D_Tech <4d_tech@lists.4d.com d_t...@lists.4d.com>> のメール：
> without needing a web server license and without using the 'embedded web
> rendering engine'?
>
>
>
> **
> 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
**

Using web areas in v16, is there a way to 'talk back' to 4d...

[Lee Hinde via 4D_Tech]

without needing a web server license and without using the 'embedded web
rendering engine'?
**
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: Update from v12.6 to v16.3-64 (Mac)

[Lee Hinde via 4D_Tech]

That sounds like a license issue. Have you installed your v16 license?



> On Jan 3, 2018, at 11:40 PM, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 
> Could someone please refresh my memory on how to upgrade an application from 
> v12 to v16 on Mac?
> 
> I’m ending up not able to go to the design environment and the “Trace” in On 
> Startup is ignored.
> 
> Thanks
> 
> Cheers
> Jörg
> **
> 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: Log File does not correspond to data file after compacting

[Lee Hinde via 4D_Tech]

Did any of those dialogs give you the option of creating a new log file?


> On Jan 4, 2018, at 7:44 AM, Janie Marlow via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> v2004, 10.6.8
> 
> Yesterday I compacted my databases' data file, something I had not done since 
> v6 or before. Afterwards, when I opened the database, I was presented with a 
> series of alerts:
> 
> * The correct Log file for this data file could not be found. Try to find it. 
> If you cannot find the Log File, make a full backup of the data before 
> creating a Log File.
> * The Log File does not correspond to the data file.
> * A Log File is necessary to use this database.
> 
> I experimented with renaming the data file, but I could not get past the 
> alerts, so I ended up going back to using the uncompacted file.
> 
> I've searched the docs, and I cannot find any special instructions regarding 
> compacting a data file when using a Log File.
> 
> It doesn't say anything about unclicking "Use Log File" before compacting, 
> but is that what I should do?
> or should I backup immediately before compacting?
> 
> Thank you -
> Janie


**
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: Electronic Signature Pads

[Lee Hinde via 4D_Tech]

It’s on a web page hosted by 4D. The SVG is sent back to 4D and stored. Display 
it on a form in 4D with SVG EXPORT TO PICTURE.


> On Dec 28, 2017, at 9:40 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Lee,
> How did the 4D app present/communicate/capture the signature image?
> 
> On Thu, Dec 28, 2017 at 8:51 AM, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com
>> wrote:
> 
>> Justin,
>> 
>> I’ve used this https://willowsystems.github.io/jSignature/#/about/ <
>> https://willowsystems.github.io/jSignature/#/about/> in a project. It
>> looks similar to the one you mention. (GitHub link here:
>> https://github.com/szimek/signature_pad <https://github.com/szimek/
>> signature_pad>)
>> 
>> 
>>> On Dec 28, 2017, at 8:36 AM, Justin Will via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>> 
>>> What about using and html area and using the Signature Pad library?  I
>> use this on a web app and it works great.
>>> 
>>> https://szimek.github.io/signature_pad/
>>> 
>>> Thanks
>>> Justin
>>> 
>>> **
>>> 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
>> **
>> 
> 
> 
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *The only thing necessary for the triumph of evil is for good men to do
> nothing.*
> 
> *- Edmund Burke*
> **
> 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: Electronic Signature Pads

[Lee Hinde via 4D_Tech]

Justin,

I’ve used this https://willowsystems.github.io/jSignature/#/about/ 
 in a project. It looks 
similar to the one you mention. (GitHub link here: 
https://github.com/szimek/signature_pad 
)


> On Dec 28, 2017, at 8:36 AM, Justin Will via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> What about using and html area and using the Signature Pad library?  I use 
> this on a web app and it works great.
> 
> https://szimek.github.io/signature_pad/
> 
> Thanks
> Justin
> 
> **
> 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: Creating/Modifying 4DWrite/Pro Documents via Web Page

[Lee Hinde via 4D_Tech]

The licensing on that and the other contender, https://ckeditor.com 
, isn’t MIT open source, it’s LPGL open source…

https://ckeditor.com/ckeditor-5-framework/pricing/ 

https://www.tinymce.com/pricing/ 



> On Dec 21, 2017, at 12:34 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I'm pretty sure this cannot be done with any flavour of 4DWrite ... I'd
> maybe use something like TinyMCE (
> https://www.tinymce.com/docs/demo/full-featured/) and find a way to insert
> tags to merge data. TinyMCE is open source and either cloud- or self-hosted
> and mobile-friendly.
> 
> This is something that we've thought about doing also, but haven't yet got
> around to exploring it, so I'd be interested to know about any other
> solutions too.
> 
> Pat
> 
> On 21 December 2017 at 01:41, Randy Engle via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> If anybody has done anything like this, love to hear about it!
>> 
>> Our customers want a "complete" web solution.
>> This includes creating and Editing 4DWrite Docs(could be 4DWritePro), from
>> a  browser.
>> (No, probably can't do this with 4DWrite/4DWritePro... but maybe...)
>> Or... the equivalent or something close.
>> Need the usual styles/colors/fonts (Tab Stops!!!), etc.
>> Some fancy super-duper javascript thingy?
>> 
>> The intention is to be able to do a merge with e.g. a list of customers,
>> and print to a PDF.
>> (This is the easy part)
>> 
>> Creating and Editing them in the first place is the fun part.
>> 
>> My brain throws a hissy fit when I try to think of how to do this.
>> 
>> Any brainiacs out there who've done anything remotely like this?
>> 
>> Randy Engle, Director
>> XC2 Software LLC – XC2LIVE!
>> 
>> 
>> **
>> 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: Anyone have a link to a Northwind SQL dataset?

[Lee Hinde via 4D_Tech]

That looks like a sql server sample database.

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases
 


why were you curious about it?
> On Dec 9, 2017, at 1:14 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Folks,
> I would like to setup the Northwind sample data set. I found this site:
> 
> https://northwinddatabase.codeplex.com/
> 
> but 4D fails when attempting to use SQL EXECUTE SCRIPT on it. I looked at
> the Microsoft site but have no idea which flavor would/could work.
> 
> So - anyone have a suggestion?
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *The only thing necessary for the triumph of evil is for good men to do
> nothing.*
> 
> *- Edmund Burke*
> **
> 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: Saving an object array to disk

[Lee Hinde via 4D_Tech]

> On Dec 6, 2017, at 1:49 PM, Peter Jakobsson via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> At the moment I’m using “Selection to JSON” to dump the data into a text 
> variable and then SAVE VARIABLES to out it to disk. This is an absolutely 
> awsome way to do it I’ve discovered if you’re migrating between heterogeneous 
> table structures because you basically have the table at the other end in an 
> object array where each source record is accessible at field level by name 
> without requiring a temporary table to dump it do.

Is there a disadvantage to just saving it as text on disk?

**
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: New error about primary keys

[Lee Hinde via 4D_Tech]

Thanks for responding.

On Nov 21, 2017, at 4:34 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
wrote:
> 
> the two dialogs are flagging the same problem, only the context is different.
> 
>> I've seen the dialog that comes up with database with ambiguous primary
>> keys - the one that starts with  "This version of 4D provides a more robust
>> log file and you".
> 
> this one pops up when you have access to design mode.

I hadn’t noticed, but yes, it comes up after I’ve logged in.

> 
>> "Potential issues with primary keys have been found. Please contact your
>> database administrator."
>> With two buttons: Close Database and Continue.
> 
> this one pops up when you don't have access to design mode.
> 

The new one (to me) comes up before login, but I do have design access; I’m 
just not there yet. I am able to make changes to the structure and data after 
logging in.


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

New error about primary keys

[Lee Hinde via 4D_Tech]

I've seen the dialog that comes up with database with ambiguous primary
keys - the one that starts with  "This version of 4D provides a more robust
log file and you".

But I just converted a v13 database to v15 and got a different alert:

"Potential issues with primary keys have been found. Please contact your
database administrator."
With two buttons: Close Database and Continue.

I was upgrading from a backup; the index file was new.

I ran MSC/Verify on the datafile and it says everything checks out - no
errors. But it goes through the test in less than a minute with a 850 MB
data file, which doesn't seem right.

I searched the Doc center with the first sentence of the alert and
generated an http 504 error. Yay me!

Anyone know what this means?
**
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: "Resolve Pointer" doesn't work with $locals. Why?

[Lee Hinde via 4D_Tech]

btw, Resolve Pointer works fine with locals interpreted. This bit me with a
"works fine interpreted, breaks compiled" which hardly ever happens anymore.



On Mon, Nov 13, 2017 at 6:27 PM, Lee Hinde  wrote:

> Trying to understand this bit from the Resolve Pointer docs:
>
>-
>The RESOLVE POINTER command does not work with pointers to local
>variables. In fact, by definition several local variables with the same
>name could exist in different locations, so it is not possible for the
>command to find the correct variable.
>
> http://doc.4d.com/4Dv15/4D/15.5/RESOLVE-POINTER.301-3576828.en.html
>
> I hadn't noticed that and just got bit by it. But it doesn't make sense to
> me. Maybe when they say they can't find the correct variable they mean they
> can't find any local variable.
>
> All Resolve Pointer does for a variable is return the name, so I don't
> really care which instance of the local they find, I'm only after the name.
>
> In v15, is there a way to get the name of a passed pointer if it
> references a local variable?
>
**
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
**

"Resolve Pointer" doesn't work with $locals. Why?

[Lee Hinde via 4D_Tech]

Trying to understand this bit from the Resolve Pointer docs:

   -
   The RESOLVE POINTER command does not work with pointers to local
   variables. In fact, by definition several local variables with the same
   name could exist in different locations, so it is not possible for the
   command to find the correct variable.

http://doc.4d.com/4Dv15/4D/15.5/RESOLVE-POINTER.301-3576828.en.html

I hadn't noticed that and just got bit by it. But it doesn't make sense to
me. Maybe when they say they can't find the correct variable they mean they
can't find any local variable.

All Resolve Pointer does for a variable is return the name, so I don't
really care which instance of the local they find, I'm only after the name.

In v15, is there a way to get the name of a passed pointer if it references
a local variable?
**
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: Symlinks in Windows

[Lee Hinde via 4D_Tech]

> On Nov 8, 2017, at 5:14 PM, Justin Carr via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> On 9 Nov 2017, at 10:19 am, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
>> 
>> On a Mac, when I want apache to front my 4D web server, I create a symlink
>> in the Apache document directory to my web folder in the database directory.
>> 
>> That way, I only have to install and maintain the web folder in one place.
>> 
>> (The purpose of using apache is to have 4D only deal with database stuff
>> and to have apache serve static content.)
>> 
>> What's the Windows equivalent? Shortcuts don't seem to be it.
> 
> MKLINK should do what you're after.
> 
> cheers
> J

That was it. Thanks very much.

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

Symlinks in Windows

[Lee Hinde via 4D_Tech]

On a Mac, when I want apache to front my 4D web server, I create a symlink
in the Apache document directory to my web folder in the database directory.

That way, I only have to install and maintain the web folder in one place.

(The purpose of using apache is to have 4D only deal with database stuff
and to have apache serve static content.)

What's the Windows equivalent? Shortcuts don't seem to be it.
**
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
**

Can't start web server on any port with v15 r5

[Lee Hinde via 4D_Tech]

I have a client trying to setup a 4D server with the web server running and
they're getting "failed to create a listening socket" error. They've tried
port 80 (with the helper) and port 8080. Nothing else running on that
machine.

What else am I forgetting to check?
**
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: [Warning] Settings properties values on object field by object notation

[Lee Hinde via 4D_Tech]

I’m glad I came in today.


> On Oct 31, 2017, at 1:35 PM, Charles Miller via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> It must be a duck, cause calling this standard behavior is quackers. 

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

Placing cursor in text field in included form

[Lee Hinde via 4D_Tech]

in v15...

Input form with an included layout that is just a text field. User clicks a
"new" button which adds a related record, date/timestamps it as the first
part of the field.

User would like the cursor to be placed to the right of the time stamp.

Based on the commented out code, the previous dev tried to do it with :

*POST CLICK*(400;400)

*POST CLICK*(400;400)

I'm wondering if there is a more modern approach available.
**
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: Server Process "Frozen"-ish

[Lee Hinde via 4D_Tech]

That's pretty clever.

On Thu, Oct 26, 2017 at 7:35 AM, BTB-David via 4D_Tech <4d_tech@lists.4d.com
> wrote:

> Tim,
>
> FWIW, I’ve implemented a method which issues a resume process command for
> each of my stored procedures.  I invoke it via a new process command using
> the On Backup Shutdown command.  My backups run once per day so it gives me
> a clean way of resuming those procedures each day after the backup
> completes.  If they aren’t stuck then no big deal.  If they are then they
> get resumed.  Once completed the process dies.  It was the best solution I
> could come up with for a work around until the problem is fixed.
>
>
> Thanks!
>
> David Conley
> By The Book, Inc.
> Office: 815-234-7530
> Direct Line: 815-406-5502
> Fax: 815-234-7532
> http://www.bythebook.com
>
>
> > On Oct 25, 2017, at 4:13 PM, Tim Nevels via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> >
> > I’m a big user of Stored Procedure and I don’t need the headache of them
> acting up when everything is completely stable now. And it’s a bug I can’t
> even implement a work around for, other than to manually monitor all server
> every single day and executing RESUME PROCESS commands manually when I
> detect an issue. I’ve got work to do. I’m not going to become a server
> babysitter.
> >
>
>
>
>
>
**
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
**

v15 R(X) documentation

[Lee Hinde via 4D_Tech]

When I option click on a 4D command in v15 I get taken to a web page on that 
topic, for the v15 family.

When I do the same thing in v15R5, I get taken, sometimes, to 16v2 docs. But 
sometimes I end up, after much redirecting, to a random page.

Is there a right way to do this? Are the v15 R docs online?





**
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: Server Process "Frozen"-ish

[Lee Hinde via 4D_Tech]

I did not know you could do that on a live server running a compiled
database.

>
>
> > On Oct 18, 2017, at 7:33 PM, Timothy Penner via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > You can issue commands from the Runtime Explorer by adding a new
> expression and typing the command into the expression. For example, typing
> RESUME PROCESS(10) into the Runtime Explorer will resume the process with
> id 10.
> >
>
>
**
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: Subrecords with subrecords

[Lee Hinde via 4D_Tech]

Chip, your example worked great and kept me from having to wrap everything
with Execute (which would have been more annoying.)

It turns out, after all this, that there is no data in the sub-subtable.
Client, of course, had no idea... This is great because I can quit working
in 2004 and get back to v16.

And, if you want to renew your enthusiasm for the progress 4D have made in
the product over the years, go work in 2004 for a while...


On Fri, Oct 13, 2017 at 11:13 AM, Chip Scheide via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Kirk :
> yes.
> if I remember the subtable syntax correctly
>
> Execute formula("x_text:=[table]subtable1.subtable2.fieldname")
>
> Lee
> I am not sure that this will work, but if it does it might make your
> life easier...
> have 1 method (which will likely have to be hard coded) to get pointers
> to all the sub-subtable fields
> populate the pointers into an inter process pointer array.
> Then you can loop over them to extract data
>
> Get pointers to sub_subtable_fields
> array pointer(<>Sub_sub_Field_Pointers;number_of_Sub_sub_Table_Fields)
>
> execute
> formula("<>Sub_sub_Field_Pointers{1}:=->[table]
> subtable1.subtable2.field_1_name")
> execute
> formula("<>Sub_sub_Field_Pointers{1}:=->[table]
> subtable1.subtable2.field_2_name")
> execute
> formula("<>Sub_sub_Field_Pointers{1}:=->[table]
> subtable1.subtable2.field_3_name")
> 
>
> then for data extraction:
>
> For($i;1;number of records in sub-subtable)
>   For($ii;1;size of array(<> Sub_sub_Field_Pointers))
> Text_variable :=Text_variable + utility_convert_to_Text(<>
> Sub_sub_Field_Pointers{$ii})
>   end for
> end for
>
> send packet(Text_variable)
>
> On Fri, 13 Oct 2017 10:48:16 -0700, Kirk Brooks via 4D_Tech wrote:
> > Tim,
> > On Fri, Oct 13, 2017 at 8:50 AM, Tim Nevels via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> >
> >> If I remember correctly, the 2004 method editor will show sub-subtable
> >> field references, but as soon as you edit a line with the reference (or
> >> maybe even retokenize the whole method) it drops the sub-subtable
> >> references. So you have to replace all these lines of code with EXECUTE
> >> commands. And you’ll have to write all the sub-subtable conversion code
> as
> >> a series of EXECUTE commands for every line with a sub-subtable
> reference.
> >
> >
> > ​Really interesting hack. ​I'm trying to visualize this - "So you have to
> > replace all these lines of code with EXECUTE commands."  Do you mean
> > opening the structure in 2004 will show the names of the sub-subtable
> > fields so you can then write the code using that name and run it with
> > EXECUTE and not choke?
> >
> > --
> > Kirk Brooks
> > San Francisco, CA
> > ===
> >
> > *The only thing necessary for the triumph of evil is for good men to do
> > nothing.*
> >
> > *- Edmund Burke*
> > **
> > 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
> > **
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
> **
> 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: Subrecords with subrecords

[Lee Hinde via 4D_Tech]

The delimiter is a single quote:

Execute formula("x_text:=[table]subtable1’subtable2'fieldname")

All this talk of dot notation has confused you. :-)

> On Oct 13, 2017, at 11:13 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Kirk :
> yes.
> if I remember the subtable syntax correctly
> 
> Execute formula("x_text:=[table]subtable1.subtable2.fieldname")

**
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: Subrecords with subrecords

[Lee Hinde via 4D_Tech]

Interesting idea. Thanks.

> On Oct 13, 2017, at 11:13 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Get pointers to sub_subtable_fields
> array pointer(<>Sub_sub_Field_Pointers;number_of_Sub_sub_Table_Fields)
> 
> execute 
> formula("<>Sub_sub_Field_Pointers{1}:=->[table]subtable1.subtable2.field_1_name")
> execute 
> formula("<>Sub_sub_Field_Pointers{1}:=->[table]subtable1.subtable2.field_2_name")
> execute 
> formula("<>Sub_sub_Field_Pointers{1}:=->[table]subtable1.subtable2.field_3_name")
> 
> 
> then for data extraction:
> 
> For($i;1;number of records in sub-subtable)
>  For($ii;1;size of array(<> Sub_sub_Field_Pointers))
>Text_variable :=Text_variable + utility_convert_to_Text(<> 
> Sub_sub_Field_Pointers{$ii})
>  end for
> end for
> 
> send packet(Text_variable)

**
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: Subrecords with subrecords

[Lee Hinde via 4D_Tech]

Thanks to all who weighed in.

I wasn't entirely clear.

They're running a compiled 2004 database. And the sub-subtable is working
'fine'. I.e., it can be accessed via the ui and the code that references it
works.

They also gave me the 2004 source code, which I'm able to open and see, in
2004. I was hoping to be able to write an export on the sub-subtable in
2004.

As Tim describes, any code that references the 2nd level won't tokenize and
throws a compiler error if I try to compile. Existing code that references
the sub-subtable 'de-tokenizes' if I touch it in 2004.

The 'put it in an execute' rings a bell and I'll start with that. Thanks!



On Fri, Oct 13, 2017 at 8:50 AM, Tim Nevels via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> > On Oct 13, 2017, at 9:20 AM, Lee Hinde wrote:
> >
> > New client with a database to update to v16. It's currently running in
> > 2004. But it has subtables with subtables, which, as I'm discovering,
> isn't
> > really supported in 2004.
> >
> > So, how did they do that? That is, run a compiled database in 2004 that
> has
> > a two level deep subtable?
> >
> > And, is there a way to reference the 2nd level in 2004?
> >
> > In v16 the 2nd level subtable isn't moved over. The field is in the 1st
> > level subtable. My goal with all this is to write something to migrate
> the
> > data.
>
> I ran into an issue with 2nd level subtables many years ago. You may need
> to do an interim update with 2004 first. Open it in 2004. Gonna be hard to
> do with macOS as you need Mac OS 9 or the old “Classic” environment in
> macOS X. Probably easier to use Windows for the 2004 version.
>
> Create new tables for the subtables and subtables of subtables in 2004.
> Write some code to move the subtable data to the new tables. But doing this
> is tricky because of the method editor. If I remember correctly, the 2004
> method editor will show sub-subtable field references, but as soon as you
> edit a line with the reference (or maybe even retokenize the whole method)
> it drops the sub-subtable references. So you have to replace all these
> lines of code with EXECUTE commands. And you’ll have to write all the
> sub-subtable conversion code as a series of EXECUTE commands for every line
> with a sub-subtable reference. Yes, this is a super big drag.
>
> So old subsubtable code is tokenized correctly and will run interpreted
> and will even compile and run. But the method editor can’t handle it. So as
> long as you don’t touch it, it will keep working. EXECUTE is your savior in
> the case where you need to fix something or write something new.
>
> Tim
>
> 
> Tim Nevels
> Innovative Solutions
> 785-749-3444
> timnev...@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
**

Subrecords with subrecords

[Lee Hinde via 4D_Tech]

New client with a database to update to v16. It's currently running in
2004. But it has subtables with subtables, which, as I'm discovering, isn't
really supported in 2004.

So, how did they do that? That is, run a compiled database in 2004 that has
a two level deep subtable?

And, is there a way to reference the 2nd level in 2004?

In v16 the 2nd level subtable isn't moved over. The field is in the 1st
level subtable. My goal with all this is to write something to migrate the
data.
**
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: PostgreSQL SELECT... RETURNING ID

[Lee Hinde via 4D_Tech]

I haven't used the Postgres plug-in, but the MySQL plugin has: *MySQL Get
Last Insert Row ID* just for that purpose. Is there an equivalent?

On Thu, Sep 21, 2017 at 7:37 AM, Jeffrey Kain via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> We're using the Pluggers PostgreSQL plug-in, and trying to capture the ID
> of newly inserted rows. It seems like the best way to do this is to put the
> insert into a Select. The following seems to work, but we've just never
> done this before and it seems weird... :) Anything to worry about here?
>
> $tStatement:="INSERT INTO invoices (name, amount) VALUES (?,?)
> returning id"
>
> $lStatement:=PgSQL New SQL Statement ($lConnection;$tStatement)
> PgSQL Set String In SQL ($lStatement;1;$tName)
> PgSQL Set Real In SQL ($lStatement;2;$rAmount)
>
> $rowset:=PgSQL Select ($lConnection;"";$lStatement)
>
> $lInvoiceID:=PgSQL Get Longint Column ($rowset;"id")
>
> PgSQL Delete Row Set ($rowset)
> PgSQL Delete SQL Statement ($lStatement)
> **
> 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 dot releases versus R releases - a metaphor

[Lee Hinde via 4D_Tech]

Not to drill too deeply, but no new features != no new changes. 16.2 for 
instance updates the Xerces engine, which apparently changed the case 
sensitivity of existing XML commands.

And I think the company line is that R releases (the non-beta ones) are 
customer ready.

But generally, yes, the R releases have been presented as warm ups to the next 
X.0 release. I.e, v 16 R(the last one)  = v 17 

> On Sep 7, 2017, at 5:37 PM, David Adams via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> This new keyboard is just killing me. Anyway, ignore the incomplete version
> of this method.
> 
> I was reminded yesterday that it's pretty easy not to understand the
> difference between dot releases and R releases. I guess it's the numbering?
> I do understand it now (it took a few years), but it's still hard to
> explain. I though of a new way so I'm tossing out two explanation.s
> 
> Dot releases
> 16.0  16.1   16.2  etc.
> These are all incremental versions of 16.0. *No new features*, just bug
> fixes.
> 
> 16 R216 R3   16 R4
> These are 16.0+ bug fixes +new features.
> 
> New features do *not* go into dot releases, they *only* go into R releases.
> 16.x is feature set for its entire lifetime, only bug fixes are added.
> 
> Okay, that's the basic story but what hit me yesterday is that it might
> help to think of R releases in a different way:
> 
> 17 B1   17 B2   17 B3
> 
> Let me say right away that this is *not* accurate. They're not really quite
> betas, but if you're thinking about it from the features point of view,
> only dot releases ended in 0 get new features. So, in this sense, R
> releases are beta releases of *features* for the next whole number dot
> release.



**
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: Drag & Drop challenge - developer wanted

[Lee Hinde via 4D_Tech]

Thanks!

On Wed, Aug 30, 2017 at 11:58 PM, Daniel N. Solenthaler via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi Lee,
>
> Credits to Ortwin Zillgen (http://.mettre.de/wp/ <
> http://.mettre.de/wp/>), who did some fancy Apple Script and VB
> programming for us.
>
> He is currently working on an update of the Apple Script for Sierra, since
> Apple changed something in the way attachments are loaded.
>
> Cheers,
> Daniel
>
>
>
**
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: Drag & Drop challenge - developer wanted

[Lee Hinde via 4D_Tech]

I can get the database 'on drop' method to fire. You get the path to the email 
file.

I can’t get a form to respond in any case. My target is a subform, which 
doesn’t have an on drop event, so I tried with a button and the form itself and 
neither give me the green +.

The customer’s request is to be able to drag an email to a specific client 
record (input form) and have the email added to a related Contacts table.



> On Aug 30, 2017, at 1:09 PM, Chip Scheide <4d_o...@pghrepository.org> wrote:
> 
> THAT is a good challenge.
> I am working with a form with Drag n drop enabled.
> I put this code in the from method:
> If (Form event=On Drag Over)
> TRACE
> End if 
> 
> it does not fire when dragging mail from either my email client, don't 
> worry you don't use it :), nor from Apple Mail.app
> The Green + does appear though...
> 
> On Wed, 30 Aug 2017 12:42:29 -0700, Lee Hinde via 4D_Tech wrote:
>> Daniel.
>> 
>> How did you solve this problem?
>> 
>> On Tue, Jan 6, 2015 at 8:47 AM, Daniel N. Solenthaler <
>> dan...@solenthaler.com> wrote:
>> 
>>> Hi all,
>>> 
>>> I am looking for a developer who is able to provide a solution for one or
>>> all of the following requirements:
>>> 
>>> a) Direct Drag & Drop (not via Desktop) of an eMail from Apple Mail to a
>>> 4D listbox
>>> b) Direct Drag & Drop (not via Desktop) of an email from Outlook Windows
>>> to a 4D listbox
>>> c) Direct Drag & Drop (not via Desktop) of an email from Outlook Mac to a
>>> 4D listbox
>>> 
>>> Please contact me in private.
>>> 
>>> If anyone is interested in the same feature and cost sharing, please reply
>>> to this post.
>>> 
>>> Thanks!
>>> 
>>> Daniel
>>> 
>>> dan...@solenthaler.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: Drag & Drop challenge - developer wanted

[Lee Hinde via 4D_Tech]

Daniel.

How did you solve this problem?

On Tue, Jan 6, 2015 at 8:47 AM, Daniel N. Solenthaler <
dan...@solenthaler.com> wrote:

> Hi all,
>
> I am looking for a developer who is able to provide a solution for one or
> all of the following requirements:
>
> a) Direct Drag & Drop (not via Desktop) of an eMail from Apple Mail to a
> 4D listbox
> b) Direct Drag & Drop (not via Desktop) of an email from Outlook Windows
> to a 4D listbox
> c) Direct Drag & Drop (not via Desktop) of an email from Outlook Mac to a
> 4D listbox
>
> Please contact me in private.
>
> If anyone is interested in the same feature and cost sharing, please reply
> to this post.
>
> Thanks!
>
> Daniel
>
> dan...@solenthaler.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 and Git Connection

[Lee Hinde via 4D_Tech]

When are you doing your commits? With each method? Daily? Neil suggested he was 
looking for incremental commits. Which seems ‘noisy’.



> On Aug 22, 2017, at 9:00 AM, Drew Waddell via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I have done this.  I used Macros to run methods that would commit the text of 
> the methods edited to a Git repo, there is an on save event.  It's definitely 
> not perfect but it helps my team track changes and look up potentially 
> "ghost" changes in our codebase.
> 
> Drew Waddell
> Development Team Lead
> Orchard Software
> 
> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Dennis, Neil 
> via 4D_Tech
> Sent: Tuesday, August 22, 2017 10:17 AM
> To: '4D iNug Technical'
> Cc: Dennis, Neil
> Subject: 4D and Git Connection
> 
> I recall that someone has worked with Git as a 4D code repository but I don't 
> exactly remember where I heard it.
> 
> I'm looking to automatically check out and check in 4D methods to Git as they 
> are modified via a 4D client. To give you the full picture we want to use TFS 
> and single sign on to connect to TFS which can be setup as a Git repository. 
> The Git repository in TFS will store any changes our team makes to the 4D 
> server's code. Has anyone done this or can anyone point me in the right 
> direction?
> 
> Neil
> 
> 

**
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 Client/Remote as Web Server - One more item

[Lee Hinde via 4D_Tech]

Does  WEB SET ROOT FOLDER 
 help 
with the folder location?

And, could you put the web folder inside the resources folder, which is kept 
current 

 (as I understand it) and then move it to your desired location on startup?


> On Aug 21, 2017, at 10:51 AM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> So all is working great with Client as Web Server... on my system.
> I just needed to copy the "Web/HTML" folder to the wonderfully obscure 
> location:
> 
> C:\Users\\AppData\Local\\
> 
> Easy Schmezey! Right?
> 
> What a PITB.
> 
> We have several customers that want to have Client as the web server.
> 
> So when having our customers install this, I'd like to come up with a way 
> that installs the "web/html" folder (and SSL cert files) into this location 
> when 4D client synchronizes from the server.
> 
> I suppose I could put these files/folders into the Client folder, and then on 
> startup of the client, copy into the above User/AppData Folder
> 
> But, what if I make changes in the "Web/HTML" folder (e.g. HTML files), then 
> customer would have to get a new copy of client with the updated Web Folder.
> 
> Hmmm.
> 
> Need to get the Web/HTML folder from the server, as that is the one that gets 
> updated regularly.
> 
> All input graciously welcome!
> 
> Randy Engle, Director
> XC2 Software LLC – XC2LIVE!
> 

**
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 to show / hide all on Property List in v16?

[Lee Hinde via 4D_Tech]

I never collapse/expand the sections…

> On Aug 14, 2017, at 2:04 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Um - does this mean no one else is seeing this behavior?

**
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: Method Header Strategies

[Lee Hinde via 4D_Tech]

The ‘false’ doesn’t cover the whole header.

> On Aug 9, 2017, at 5:35 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> that's what I thought at first but then the "False" block already does that 
> job.
> 
>> 2017/08/10 7:58、Guy Algot via 4D_Tech <4d_tech@lists.4d.com> のメール：
>> My guess… So you can click the triangle and hide everything in the header?
> 
> 
> 
> 

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

Method Header Strategies

[Lee Hinde via 4D_Tech]

From the conversation about converting images we saw this method header:


If (True)
If (False)
Begin SQL
/*
Name: UTIL_ConvertPICTs
Path: UTIL_ConvertPICTs

Purpose: Convert all PICT formatted images in the 
Picture Libraray to .PNG images

The v13.2 or later 4D Pack Plugin must be installed to use this method

*/
End SQL
End if 
C_TEXT($MethodName_T)
$MethodName_T:=Current method name
 //= Declare Variables 
==
 //method_parameters_declarations
 
//
 //method_wide_constants_declarations
 
//
 //local_variable_declarations
C_LONGINT($Ndx;$SOA;$RIS;$PictRef_L)
C_TEXT($PictName_T)
C_PICTURE($Pict_G)
C_POINTER($Pict_P)
End if 

I can suss two things out of this. One is the  "If (false)" bit at the top so 
you can do all kinds of things that break cross-referencing in the name of not 
running code.

In this case it’s ‘protecting’ a Begin/End SQL which is being used because the 
construct allows you just type things with out having to comment your comments 
out.

But, why wrap the whole thing in if (True)?


**
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: WEB SEND FILE - Duplicate HTML

[Lee Hinde via 4D_Tech]

> On Aug 9, 2017, at 2:10 PM, Matthew Bollwitt via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I know I’ve seen this before but I can’t remember how I resolved it. When I 
> send a file out using WEB SEND FILE command, the page comes out as intended, 
> but part of the HTML file gets duplicated and added on to the end. So I get 
> the page and then a lower section of the same page added on.
> 
> Am I hitting a page size limit? Is there still a 32K limit to 4D pages 
> getting served up with 4D tags?
> 
> Anyone else experience this? Know how to resolve it?
> 
> Thanks!
> 

I had a situation like this and Kirk Brooks kindly gave me a second pair of 
eyes to figure it out.  This may not be your cause, but I had a similar outcome.

In my case I had a method that both calculated some values and returned a page. 
I was calling that routine as part of a parent routine that just wanted the 
value calculation part (bad code design.). 4D, more or less, honors the final 
Web Send File, so I mostly saw the page I wanted but that call in the middle 
mucked things up.

So, the point is, do you have something calling Web Send File in the middle of 
the parent routine that’s sending the page you want to see?


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

Collections in v16R4

[Lee Hinde via 4D_Tech]

This is fascinating:

http://blog.4d.com/new-type-of-variable-collections/

   1. "Arrays" of random data types.
   2. Elements are accessed with [] not {}. E.g MyCollection[8]
   3. The first element starts at zero.
   4. They have an associated method - length. MyCollection.length
   5. Appending past the length of the collection results in padding. That
   is if your collection is currently 5 items long, adding something at
   position 10 MyCollection[10]:="something" will add intermediate null items.

http://doc.4d.com/4Dv16R4/4D/16-R4/C-COLLECTION.301-3342374.en.html
http://doc.4d.com/4Dv16R4/4D/16-R4/New-collection.301-3342875.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: version of openssl in 15.4 mac

[Lee Hinde via 4D_Tech]

Thanks Tim.

> On Jul 17, 2017, at 11:06 AM, Timothy Penner  wrote:
> 
> v15.3 had an update:
> http://download.4d.com/Documents/Products_Documentation/LastVersions/Line_15/VIntl/4D_v15_3_ReleaseNotes_US.pdf
> 
> Library Update
> Open SSL: Upgrade to version 1.0.2j
> 
> -Tim
> 
> 

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

version of openssl in 15.4 mac

[Lee Hinde via 4D_Tech]

I read somewhere that the openssl version got bumped in version 15.4. But I
can't find where.

I did find this:

http://kb.4d.com/assetid=76175 : Tech Tip: How to Find the Version of
OpenSSL used in 4D

with this:


   - Windows
  1. Locate the folder containing 4D.exe or 4D Server.exe
  2. In the same folder as 4D.exe (or 4DServer.exe) is a file named
  libeay32.dll and ssleay32.dll
  3. Locate the libeay32.dll or ssleay32.dll file and right-click on
  either of these files, then choose properties
  4. The version number specified in the properties is the version of
  OpenSSL used
   - Mac OS X
  1. This information is not available on the Mac side
**
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: Thinking through object/text fields: Findings summarized, advice solicited

[Lee Hinde via 4D_Tech]

On Mon, Jul 17, 2017 at 5:40 AM, David Adams via 4D_Tech <
4d_tech@lists.4d.com> wrote:

>
> My biggest problem with PostgreSQL is the relative lack of nice front-end
> tools. My beloved SequelPro for MySQL has long hinted at a PostgreSQL
> version, but it doesn't seem to be there yet. For MySQL though, it's great
> (and free):
>
> http://www.sequelpro.com/
>
> Navicat can do more (stored procedures, copy data across structures, better
> trigger support, etc.) but, dang, that "Look Ma! I wrote it in Java!" UI is
> just so ugly. I'll pay for it, I'll use it, I'll be grateful...but I won't
> be loving it.
>
> Any recommendations for good PostgreSQL tools?
>


Agreed on how great Sequel Pro is.

For Postgres, I use PostgresApp https://postgresapp.com/ to run Postgres on
my mac.

For the client I use Navicat Premium Essentials (their cheaper Swiss Army
Knife tool.) It's ugly, but you can do what you need to do.

The fellow who wrote the Postrgres Mac App has a client app, called
Positco: https://eggerapps.at/postico/

Something to check out.
**
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: Wiki software: Confluence

[Lee Hinde via 4D_Tech]

Of course you are.

I don’t mind Jira too much, but it’s horrible for customers. And I wasn’t happy 
making a career out of learning how to customize the customer view.



> On Jul 13, 2017, at 2:31 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> We're in the process of writing our own Jira replacement.

**
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: Wiki software: Confluence

[Lee Hinde via 4D_Tech]

What do you like?

On Thu, Jul 13, 2017 at 6:22 AM, Jeffrey Kain via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Jira sucks.
>
> --
> Jeffrey Kain
> jeffrey.k...@gmail.com
>
> > On Jul 13, 2017, at 5:26 AM, David Adams via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > ...Wow, thanks for all of the information about the features of
> Confluence
> > and Jira. I'm new to them, so pretty much everything you mentioned is new
> > to me.
>
> **
> 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: Object field storage: Questions and alternatives

[Lee Hinde via 4D_Tech]

On Tue, Jul 11, 2017 at 3:10 AM, David Adams via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> * Use a header object that describes the 'columns' and then use compact
> JSON arrays for the data. Rob Laveaux reminded me about this option some
> months back and it's a really decent compromise.
>

That seems like a good option - it's the same, mostly, as a TSV/CSV. But it
seems like JSON isn't appropriate for your storage needs (compactness
trumps all), irrespective of how 4D stores it internally.
**
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: Web serving on OS X Server

[Lee Hinde via 4D_Tech]

Thanks Ron and Jim for the great help.

On Fri, Jun 9, 2017 at 3:05 PM, James Crate via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> The easy way is to set up a webapp plist, and then just turn on that
> webapp for the appropriate domain (website).
>
> Here’s a sample plist. You should be able to mostly use the httpd.conf
> options you use behind Apache normally.
>
> 
>  http://www.apple.com/DTDs/PropertyList-1.0.dtd";>
>
> 
> 
> includeFiles
> 
> /Library/WebServer/exa
> mple.com/my_app/config/server_webapp.httpd.conf
> 
> name
> com.example.my_app
> displayName
> My WebApp
> installationIndicatorFilePath
> /Library/WebServer/example.com/my_app/config/server_
> webapp.httpd.conf
> sslPolicy
> 0
> 
> 
> 
> 
> 
> 
>
> 

Re: Web serving on OS X Server

[Lee Hinde via 4D_Tech]

Hi John;

Thanks for the links!

I'm punting for now and found this to just turn off the Apple Apache httpd
instances:

https://discussions.apple.com/thread/7247358?tstart=0

This has 4D doing all the serving, which i'm not keen on, especially with
this app which is graphic intensive.


I'm running Sierra server. Hopefully an update will make this easier.  (one
lives in hope.)



On Fri, Jun 9, 2017 at 12:33 PM, John Harrington via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Lee - I personally had no success in getting the new version of OS X
> Server to easily handle a reverse proxy to 4D’s port 8080 or 8443.  Snow
> Leopard Server (SLS 10.6.8) is the last version that included this granular
> feature and a simple interface to set things up with.  As of yet, I have
> found no good 3rd party alternative.  (We currently run a 4D 2004 legacy
> system, behind Apache on SLS 10.6.8, on a new Mini running OS X 10.11.6.)
>
> Tech support at MacStadium was only able to confirm they knew of no easy
> way to get OS X 10.11.6 to handle a reverse proxy to the 4D port.  Here are
> some server setup videos they produced that you may find helpful:
>
> Hosted Mountain Lion Server Part 1: Setting Up Your Server
> https://www.youtube.com/watch?v=OeJ_wwCT4tM  watch?v=OeJ_wwCT4tM>
>
> If you’re okay with it, you should be able to have 4D serve directly by
> just opening the related 4D web-port(s) in your firewall.
>
> Hosted Mountain Lion Server Part 3: Built In Firewall
> https://www.youtube.com/watch?v=AaWWmH_6oAY  watch?v=AaWWmH_6oAY>
>
> Looking forward to hearing thoughts about Apache reverse proxy on newer
> machines and solutions that may be working well for others.   -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: Web serving on OS X Server

[Lee Hinde via 4D_Tech]

For reasons that aren’t clear, Server uses different configuration files and 
processes.I.e, it’s not https.conf anymore.

 Sorting through what’s new to me is the basis for the request for help here.


> On Jun 9, 2017, at 12:06 PM, Chip Scheide <4d_o...@pghrepository.org> wrote:
> 
> Ive not setup apache - but what I was trying to get to is..
> whatever you have done in the past for apache (and maybe I mis-read 
> your question), just do that, the 'server' part should not make 
> anything change.
> 
> 
> On Fri, 9 Jun 2017 12:03:05 -0700, Lee Hinde via 4D_Tech wrote:
>> Correct, I need other parts of OS X Server on this computer.
>> 
>>> On Jun 9, 2017, at 11:54 AM, Chip Scheide 
>>> <4d_o...@pghrepository.org> wrote:
>>> 
>>> OS X server is OS X with a server application.
>>> 
>>> On Fri, 9 Jun 2017 11:14:02 -0700, Lee Hinde via 4D_Tech wrote:
>>>> I've setup apache as a front end to 4D on 'regular' macs without 
>>>> issue. But
>>>> now I need to do it on a Mac running the Server software and I'm not clear
>>>> where/how to configure that and my google fu is failing me.
>>>> 
>>>> Has anyone done that and can you point to directions?
>>>> 
>>>> I'd settle for having 4D serve directly, but OS X Server is running apache
>>>> even with Websites off.
>> 
>> 
>> **
>> 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
>> **
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 

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