Re: Unclear distinction between web server session and process

[John DeSoi via 4D_Tech]

Hi Kirk,

> On Apr 14, 2017, at 11:33 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> But that's not the way I see it actually work. ​A new process spins up each
> time new request comes in and gets assigned a new web session id which
> replaces whatever the 4DSID cookie is.

This is not what I'm seeing using 4D's http client. Server returns "set-cookie" 
header and I use that value for subsequent requests. Any further request using 
this cookie gets routed to the same process on the web server.

John DeSoi, Ph.D.

**
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 can I suppress the web server creating default index.html?

[Keisuke Miyako via 4D_Tech]

 just goto preferences > web > settings (path) and remove "index.html"

> 2017/04/14 23:37、Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> のメール：
> Can I suppress 4D's urge to create that page if it's missing?




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

Copying forms between structures: No 'Use Object with Same Name' option

[Peter Jakobsson via 4D_Tech]

Hi

I’ve always wondered why this option is available when copying tables between 
structures but not when copying formats.

It would save an enormous amount of time since every time you copy a form you 
have to manually go through the same formats over & over again mapping them to 
the format "with the same name” in the destination database.

Anyone found a more optimal approach to this ?

Best Regards

Peter
**
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: PDFCreator and Windows 7

[Chuck Miller via 4D_Tech]

Yup install version 1.2.? they changed comm interface and till it is stable you 
can not use a new version than that. I will check next wednesday for version we 
are using at client. I will not be there till then

Regards
Chuck

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

This message and any attached documents contain information which may be 
confidential, subject to privilege or exempt from disclosure under applicable 
law.  These materials are intended only for the use of the intended recipient. 
If you are not the intended recipient of this transmission, you are hereby 
notified that any distribution, disclosure, printing, copying, storage, 
modification or the taking of any action in reliance upon this transmission is 
strictly prohibited.  Delivery of this message to any person other than the 
intended recipient shall not compromise or waive such confidentiality, 
privilege or exemption from disclosure as to this communication. 

> On Apr 14, 2017, at 11:23 AM, David Rose via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I installed PDFCreator v1.7.3 on my Win 7 box. I am running 4D v15
> client/server. In 4D I want to programmatically set the destination folder and
> file name for pdf files. The code below works perfectly most of the time, but
> intermittently the PDFCreator file-saving dialog appears. My code looks like
> this:
> 
> $PDFFilePath_t:="(Full Path Here)"
> PAGE SETUP([MyTable];"MyList")
> SET CURRENT PRINTER(PDFCreator Printer name)
> FORM SET OUTPUT([MyTable];"MyList")
> SET PRINT OPTION("PDFOptions:UseAutosave";1)
> SET PRINT OPTION("PDFOptions:UseAutosaveDirectory";1)
> SET PRINT OPTION(Destination option;3;$PDFFilePath_t)
> PRINT SELECTION([MyTable];*)
> SET PRINT OPTION("PDFInfo:Reset standard options";0)
> 
> Any ideas how to fix this?
> David 

**
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: PDFCreator and Windows 7

[ADeeg via 4D_Tech]

David, If you like to get a well supported and stable pdf solution with much
more features than pdf creator, then have a look at our plugin. We
distribute it since 2004 (first version)

Link: http://www.node.de/indexplug.htm

Best Regards Armin


David wrote
> I installed PDFCreator v1.7.3 on my Win 7 box. I am running 4D v15
> client/server. In 4D I want to programmatically set the destination folder 
> and
> file name for pdf files. The code below works perfectly most of the time, 
> but
> intermittently the PDFCreator file-saving dialog appears. My code looks
> like
> this:
> 
> Any ideas how to fix this?
> David 





--
View this message in context: 
http://4d.1045681.n5.nabble.com/PDFCreator-and-Windows-7-tp5751292p5751296.html
Sent from the 4D Tech mailing list archive at Nabble.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
**

Unclear distinction between web server session and process

[Kirk Brooks via 4D_Tech]

Since I'm focused on the webserver today, I'm coming back to not being
clear on the distinction 4D makes between a 'web session' and the 'web
process' when using automatic session management.

A web session, as I understand it, is an authorized connection between a
browser and the server and usually designated with a cookie. 4D uses the
4DSID cookie and there's a database param that let's me set the cookie
timeout period.

When a new connection is made from a browser 4D looks for the cookie and if
it's there looks for a web process with that session id. If it finds a
process it should use it, if it doesn't (and the cookie is still valid) it
starts a new process which should have that session ID assigned to it.

But that's not the way I see it actually work. ​A new process spins up each
time new request comes in and gets assigned a new web session id which
replaces whatever the 4DSID cookie is.

So I've got the feeling I'm not using the automatic session features the
way they should be - or it's something else. Again, comments from folks
doing more of this stuff are much appreciated.


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

Re: Unattended Mac OS X Sierra v15.4 remote disconnects

[Perkins, Bradley D via 4D_Tech]

Bob,

Thank you. I was aware of this but was confusing 'App Nap' with the 'Power
Nap' settings in the Energy Saver control panel. I changed these a few
hours ago and no disconnects so far.

Brad Perkins

From: Robert McKeever 
>
>Disable App Nap.
>
>>On Apr 13, 2017, at 6:30 PM, Perkins, Bradley D via 4D_Tech
>><4d_tech@lists.4d.com> wrote:
>>I'm trying to deploy a couple of system upgrades. We moved two 'web
>>client' machines from v14 on Mac OS X El Capitan to v15.4 on Sierra this
>>week. Previous versions of both systems have been deployed for years and
>>gone through many upgrades.
>>I am observing that 4D is losing its connection to the server. When this
>>happens I notice that Apache has stopped serving too, and that I often
>>can't remotely access the machine.
>>When moving to 15.4 do I need to change network settings for 4D?
>>On both machines I have turned off the Energy Saver settings that would
>>normally make a machine sleep. Are there other settings on Sierra that I
>>am missing?
>>Thanks,
>>Brad Perkins


**
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: PDFCreator and Windows 7

[Randy Jaynes via 4D_Tech]

Maybe not helpful, but I gave up on PDFCreator long ago because of 
inconsistencies like this.

We moved to Win2PDF and life is much more sane. It works right out of the box 
and was easy to implement.

True, it’s not free, but in 6 years I’ve only had to contact their tech support 
people 2 times and they fixed my problem quickly and easily.

The $30 (or $35) that it costs is extremely cheap next to the amount of time 
spent trying to figure out what the heck PDFCreator is doing, especially the 
intermittent nature of what you’re seeing.

Also, you could upgrade to Windows 10 which has a built-in option that seems be 
working well.

Having been where you are, I just wouldn’t spend time trying to fight 
PDFCreator.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • (845) 359-0298 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 




> On Apr 14, 2017, at 11:23 AM, David Rose via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I installed PDFCreator v1.7.3 on my Win 7 box. I am running 4D v15
> client/server. In 4D I want to programmatically set the destination folder and
> file name for pdf files. The code below works perfectly most of the time, but
> intermittently the PDFCreator file-saving dialog appears. My code looks like
> this:
> 
> $PDFFilePath_t:="(Full Path Here)"
> PAGE SETUP([MyTable];"MyList")
> SET CURRENT PRINTER(PDFCreator Printer name)
> FORM SET OUTPUT([MyTable];"MyList")
> SET PRINT OPTION("PDFOptions:UseAutosave";1)
> SET PRINT OPTION("PDFOptions:UseAutosaveDirectory";1)
> SET PRINT OPTION(Destination option;3;$PDFFilePath_t)
> PRINT SELECTION([MyTable];*)
> SET PRINT OPTION("PDFInfo:Reset standard options";0)
> 
> Any ideas how to fix this?
> David 
> **
> 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
**

PDFCreator and Windows 7

[David Rose via 4D_Tech]

I installed PDFCreator v1.7.3 on my Win 7 box. I am running 4D v15
client/server. In 4D I want to programmatically set the destination folder 
and
file name for pdf files. The code below works perfectly most of the time, 
but

intermittently the PDFCreator file-saving dialog appears. My code looks like
this:

$PDFFilePath_t:="(Full Path Here)"
PAGE SETUP([MyTable];"MyList")
SET CURRENT PRINTER(PDFCreator Printer name)
FORM SET OUTPUT([MyTable];"MyList")
SET PRINT OPTION("PDFOptions:UseAutosave";1)
SET PRINT OPTION("PDFOptions:UseAutosaveDirectory";1)
SET PRINT OPTION(Destination option;3;$PDFFilePath_t)
PRINT SELECTION([MyTable];*)
SET PRINT OPTION("PDFInfo:Reset standard options";0)

Any ideas how to fix this?
David 


**
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 can I suppress the web server creating default index.html?

[Justin Will via 4D_Tech]

Kirk,

Turn off 4D's web server in the settings of MSC and start the webserver 
programmatically and the folder will not be created.

Like this...

WEB SET OPTION(Web Port ID;80)
WEB SET OPTION(Web HTTPS port ID;443)
WEB SET ROOT FOLDER("MyWebFolderPathHere";Is text))
WEB START SERVER

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

Re: How can I suppress the web server creating default index.html?

[Kirk Brooks via 4D_Tech]

Joshua,

On Fri, Apr 14, 2017 at 8:02 AM, Joshua Hunter via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> a) Use WEB SET ROOT FOLDER to change the web root on startup to an empty
> directory
>

​Just thinking out loud - I have heard other's talk about this approach and
I like the idea but wouldn't it still leave me with the problem of 4D
creating the identified page in the otherwise empty directory?​

​Maybe someone actually doing this could comment.​

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

Re: How can I suppress the web server creating default index.html?

[Kirk Brooks via 4D_Tech]

Hi Joshua,


On Fri, Apr 14, 2017 at 8:02 AM, Joshua Hunter via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I haven't tried but could you either:
>
> a) Use WEB SET ROOT FOLDER to change the web root on startup to an empty
> directory

​I might try this - it's not the way I designed it though...​

> -or-
> b) delete the file after it is created on startup
>
​That's what I'm thinking is the easy solution.
​
-- 
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
**

RE: How can I suppress the web server creating default index.html?

[Joshua Hunter via 4D_Tech]

I haven't tried but could you either:

a) Use WEB SET ROOT FOLDER to change the web root on startup to an empty 
directory
-or-
b) delete the file after it is created on startup

Joshua Hunter
jos...@dwdev.com
(425)673-1974
www.dwdev.com
Dataworks Development, Inc.
Providing secure and configurable data management solutions for research and 
clinical labs since 1987.


-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Kirk Brooks 
via 4D_Tech
Sent: Friday, April 14, 2017 7:37 AM
To: 4D iNug Technical
Cc: Kirk Brooks
Subject: How can I suppress the web server creating default index.html?

I have my webserver (v15.4) set up to respond to the index page and prompt for 
login. It seems 4D will crate this page each time it starts up if it's not 
there. I don't want it there because I want to catch the it manually.

Can I suppress 4D's urge to create that page if it's missing?

--
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: 4D SQL Implementation

[Jeffrey Kain via 4D_Tech]

Totally agree with all of that. I was hopeful that since Wakanda uses the same 
engine that we'd see a lot of improvement in the SQL engine of 4D, but not so 
much. Another example: a SELECT on an indexed field using a nested SELECT works 
great until you reach a certain number of rows returned. Once you go past this 
magic number, 4D SQL forgets there's an index and drops you into the land of 
full table scans. So frustrating.

We're probably an exception, but we use the SQL/ODBC engine a lot here. The UPS 
and FedEx computers in the warehouse use ODBC connections to update shipping 
records in 4D, several FileMaker systems also use ODBC to receive up-to-date 
information from 4D and create pretty signs, and we make extensive use of the 
4D to PHP DataObjects library (http://www.php.net/manual/en/ref.pdo-4d.php) in 
a lot of custom projects for monitoring, dashboards, and reporting. The 4D SQL 
engine works great until it doesn't, and when it doesn't there's not much you 
can do other than push the data to MySQL or Postgres. 

And did I mention object fields? :)

Anyway, there's a lot of potential in the 4D SQL engine, and I hope that 4D 
hasn't abandoned it or decided to treat it as a marketing checklist feature.

Jeff

On Apr 14, 2017, at 10:29 AM, Bart Davis via 4D_Tech <4d_tech@lists.4d.com> 
wrote:

> I couldn't agree more with this statement "It's almost as if the SQL engine 
> is a bolted-on afterthought to 4D that doesn't receive much love at all from 
> the development team."
> 
> - The fact that you can't use SQL in a trigger when a record is inserted, 
> updated or deleted via SQL is baffling.  Every other SQL database seems to be 
> able to do it.
> 
> -  You still can't use local variables in a EXECUTE IMMEDIATE SQL statement 
> in a compiled application?  Is it really that difficult to implement?
> 
> - Could there be some internal semaphore/blocking code that prevents some 
> part of a SQL query in one process from executing (this includes ORDER BY) 
> when a SQL query in executing in a different process?  In two different web 
> applications that have heavy concurrent use, progress bar windows start 
> appearing on the screen saying ORDER BY or LOADING DATA and as more processes 
> are initiated more windows appear the application grinds to a stop and must 
> be killed and restarted.  These are simple queries with Order By on indexed 
> fields on small data sets.  I replaced the SQL queries with the standard 4D 
> Query language and there are no more performance issues.  On all heavily used 
> queries I have replaced SQL with 4D query language.
> 
> - Why isn't the use of 4D array variables in SQL queries supported?
> 
> Assuming $aRecordID is a populated Longint Array...
> 
> Begin SQL
>  Select * from Table where ID in :$aRecordID
> End SQL

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

[Justin Will via 4D_Tech]

Bart,

I have to agree with everything you stated.  At one point in time I had a 
number of SQL calls in a web app that had some heavy use.  The day I rolled out 
the SQL code I had to roll it back to 4D Query code because performance was so 
bad the site became unusable.  At this point in time I avoid using 4D's SQL 
engine like it’s the black plague or something.  I just find it too unreliable, 
to slow and has abysmal SQL support beyond the most basic of syntax.

I sure wish they would make the SQL engine much stronger, but until it gets 
some real effort I will certainly avoid it.  It's a real shame too, because 
reporting and analytical tool options would really open up some fun new 
possibilities.

Thanks
Justin Will
**
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
**

How can I suppress the web server creating default index.html?

[Kirk Brooks via 4D_Tech]

I have my webserver (v15.4) set up to respond to the index page and prompt
for login. It seems 4D will crate this page each time it starts up if it's
not there. I don't want it there because I want to catch the it manually.

Can I suppress 4D's urge to create that page if it's missing?

-- 
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 SQL Implementation

[Bart Davis via 4D_Tech]

> On Apr 14, 2017, at 2:35 AM, 4d_tech-requ...@lists.4d.com wrote:
> 
> 
> Message: 3
> Date: Thu, 13 Apr 2017 16:31:15 -0400
> From: Jeffrey Kain 
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Subject: Re: How to create Object field via SQL
> Message-ID: 
> Content-Type: text/plain; charset=us-ascii
> 
> It's almost as if the SQL engine is a bolted-on afterthought to 4D that 
> doesn't receive much love at all from the development team.

I couldn't agree more with this statement "It's almost as if the SQL engine is 
a bolted-on afterthought to 4D that doesn't receive much love at all from the 
development team."

- The fact that you can't use SQL in a trigger when a record is inserted, 
updated or deleted via SQL is baffling.  Every other SQL database seems to be 
able to do it.

-  You still can't use local variables in a EXECUTE IMMEDIATE SQL statement in 
a compiled application?  Is it really that difficult to implement?

- Could there be some internal semaphore/blocking code that prevents some part 
of a SQL query in one process from executing (this includes ORDER BY) when a 
SQL query in executing in a different process?  In two different web 
applications that have heavy concurrent use, progress bar windows start 
appearing on the screen saying ORDER BY or LOADING DATA and as more processes 
are initiated more windows appear the application grinds to a stop and must be 
killed and restarted.  These are simple queries with Order By on indexed fields 
on small data sets.  I replaced the SQL queries with the standard 4D Query 
language and there are no more performance issues.  On all heavily used queries 
I have replaced SQL with 4D query language.

- Why isn't the use of 4D array variables in SQL queries supported?

Assuming $aRecordID is a populated Longint Array...

Begin SQL
  Select * from Table where ID in :$aRecordID
End SQL

Bart

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