Re: Moving from v12 to v15, any tips on memory and network settings?

[Bill Weale]

Hi Paul—

I’m pretty sure you can drop the timeout settings now. I don’t have any 
projects with that number of users, but I think, for at least the past 2-3 
versions, the connection defaults are fine.

Bill


William W. Weale

Business Owners Support, LLC.

Operations Analysis
MIS Advising
Decision Support Systems

> On Dec 27, 2016, at 12:20 PM, Paul Lovejoy  wrote:
> 
> Hi,
> 
> We’re moving a moderately large DB (210 tables, about 100gb of data, 150 
> concurrent users, about 700 processes) from v12 to v15. It will run on Mac OS 
> X (32 bit for now). All our licenses are on Mac but our server is an xServe 
> from 2011… Dual processor, 8 cores, 32gb RAM, SSD. Since Apple is building 
> server hardware anymore, it would seem our only upgrade path would be moving 
> to Windows, which we’re trying to avoid for as long as possible.
> 
> On v12 we have 1.5 gb of cache hard-wired. 
> 
> Does memory behave in a similar way on v15, or should I expect surprises?
> 
> As for the network settings, I’m referring to the database parameters.
> 
> What we do now, in the server startup method:
> 
> SET DATABASE PARAMETER(4D Server Timeout;2) 
> SET DATABASE PARAMETER(4D Remote Mode Timeout;2)
> SET DATABASE PARAMETER(Idle Connections Timeout;120)
> 
> I can’t even remember how we arrived at these settings. We spent a lot of 
> time tweaking to avoid lost connections from remote clients over WAN.
> 
> 
> Thanks for any tips.
> 
> 
> Paul
> 
> 
> **
> 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: Hourly Consulting Rates

[Bill Weale]

Isn't this post is simply recognition that we could get along a lot more easily 
without IT folks than we could without the building trades folks...

www

> On Dec 19, 2016, at 8:18 AM, Herr Alexander Heintz  
> wrote:
> 
>> Am 17.12.2016 um 13:59 schrieb Peter Jakobsson :
>> 
>> In the UK, the hourly rate for a plumber or electrician is around £60 = $75.
> 
> That rate is going to skyrocket in the next 2 years, at the same time work 
> quality will drop well below rock bottom once all plumbers have returned 
> (post BREXIT) to their native Poland..
> 
> 

**
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: styled/formatted text for email body contents

[Bill Weale]

Thank you.

Yes, I should have responded to Lutz some time ago, this seem to be the best 
approach.


Bill

> On Dec 10, 2016, at 4:16 PM, Jim Labos - infobase  wrote:
> 
> As Lutz wrote previously the way to do this the easiest is to use PROCESS 4D
> TAGS .
> 
> You can use loops in an HTML template to create your item lines or anything
> that would be variable and then concatenate your form (Blobs or Text) into
> one variable containing the entire body.
> 
> This will do exactly what you want (if I understood your needs).
> 
> If you need more detail let me know.
> 
> 
> Regards
> 
> Jim Labos - infobase
> 
> 

**
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: styled/formatted text for email body contents

[Bill Weale]

Thank you; yes, the emailing itself has worked fine. We’re trying to improve 
the appearance of the body content and have it as consistent as possible across 
all email clients.

www




> On Dec 2, 2016, at 3:51 AM, Epperlein, Lutz (agendo) 
>  wrote:
> 
> The task left to you is building the mail body. There are many ways to do it, 
> the easiest way IMO is using PROCESS 4D TAGS

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

styled/formatted text for email body contents

[Bill Weale]

I have a project that uses a web form for ordering. A selection list of 
products is offered in the form and the user fills in a few header fields along 
with the quantities he wants of each item.

Upon submittal, part of the web server’s task is to send back, via email, 
confirmation of the order. I’m looking for the most efficient way to format 
that content so that it looks reasonably professional—but not overly 
embellished—in the body, or as an attachment, of the confirming email message. 
I think the solution needs to be driven by the easiest-to-use tools in 4D.

Thanks for any suggestions,

Bill



William W. Weale

Business Owners Support, LLC.

Operations Analysis
MIS Advising
Decision Support Systems

**
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 from 4D client

[Bill Weale]

If you need significant 4D Client (not web serving) involvement with 4D Server 
or if the need of the web server for 4D data and functionality is non-trivial, 
I would forget the cloud as an option. Only solution in that direction I could 
think of would be to put 4D Server and 4D Client/webserver on the same cloud 
(you know what I mean) and hope that or arrange to have the 4D Clients on 
low-latency connections to  4D Server. This can be done with dedicated routed 
circuits but can be really expensive. We do have at least one setup like Arnaud 
describes, everything in-house with webserver/client in a DMZ. 

As he suggests, one way to avoid the expense under this last scenario is to 
design your db for higher latency connections with 4D Client. I just can’t get 
my head around the concept of putting 4D Server (as server to 4D Clients) in 
the cloud. Why deny your customer much of 4D’s potential? Why deny yourself the 
chance to provide it? Sure, you can whip something up that works ok at first, 
but unless you and your customer go into the project agreeing that it’s just 
going to be a short-term throw-away…

—Bill




> On Nov 18, 2016, at 5:18 AM, Paul Dennis  wrote:
> 
> Hello Scott, Bill, Tim
> 
> I'm trying to decide where to host the 4Dserver application. The options are
> 
> 1. 4D server inhouse and 4D Client web serving in cloud on a dedicated
> server. The limitation here is the speed of our connection as this is a
> consumer site and could be busy.
> 2. 4D server and 4D Client in cloud on same windows server
> 3. 4D server and 4D Client in cloud on with client running under hyper V on
> same machine ie isolate the server and the client.
> 
> At the moment I'm will be going with option 2.
> 
> Any thoughts
> Thanks
> Paul
> 
> 

**
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 a backup to a network share when running as a service

[Bill Weale]

I would get to the point where things would run for a few days, then break, for 
reasons I couldn’t explain. Only thinking was that of all the permissions 
potentially involved, network configuration change or OS patch could easily 
break things.

—Bill

> On Nov 17, 2016, at 4:19 PM, Joshua Hunter  wrote:
> 
> We have a customer running our 4D server application (compiled) as a Windows 
> service. They want to direct their backup to a network location. This works 
> when they run the application interactively, but not when they run it as a 
> service.
> 
> I've let them know that backing up locally is preferred for a number of 
> reasons, but they still want to backup to the network location.  I've tried 
> providing the same user credentials to the service that we use to run 
> interactively without any luck.
> 
> Has anyone had success with this?

**
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 Backup when running as a Service

[Bill Weale]

Can you check (manually or by code) if the target volume is mounted when the 
backup is run? I had so many problems with this at one site that we gave up 
trying.

A more serious problem, imo, is not having a reliable place to maintain the log 
file…

Bill




> On Nov 17, 2016, at 2:41 PM, Cheryl Michels  wrote:
> 
> This seems simple so I must be missing something very basic.  We have a 
> merged/built server application.  Customer wants to run it as a Service and 
> backup the data to a drive other than the one that it is currently installed 
> on.  The backups are not getting written.  There is no error.  They simply 
> don't write.  If the backup is configured to write to the same drive that 
> Server is on, then the backup writes without error.
> 
> 

**
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: Sequence Number Not Incrementing

[Bill Weale]

But you are seeing a non-zero value?

(I ask because in v14 Mac OS, I’m trying to track down an instance where the 
field isn’t populated at all after I’ve duplicated a record but before I’ve 
saved it.)

Bill


William W. Weale

Business Owners Support, LLC.

Operations Analysis
MIS Advising
Decision Support Systems

> On Nov 16, 2016, at 4:23 AM, Sujit Shah  wrote:
> 
> It is finding the duplicates but fails to increment the sequence number
> once the record is saved.

**
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: It's the little things (ordering parameters)

[Bill Weale]

Text-based coding would work better for me if the handling or ordering of 
language elements where consistent across languages. Nouns, verbs, subjects, 
objects, modifiers, etc. take different positions or ordering in different 
languages. My native language is English and my only backup is Latin. (Maybe 
THAT’S the problem!) The 4D “language” and, importantly its documentation, is a 
product of folks from many different cultures. My guess is that the varied 
ordering of elements such as parameters is partly because of this. Also, a 
translation of French documentation to English can, at least in my form of 
logical thinking, create a frustrating misunderstanding of what I need to do.

Pictures often circumvent this problem, but it seems to me more “supervision” 
of the work product—localized 4D commands and documentation—could help also.

—www


> On Nov 15, 2016, at 3:34 PM, Ed Glassgow  wrote:
> 
> There have been efforts at pure graphical programming software.  In fact, 
> there was a database program that was drag and drop in the relatively early 
> Mac days.  I wish that I could remember what it was called, but time has 
> wiped that from my memory banks.  It was very cumbersome to accomplish 
> anything of any complexity.  I don’t think that there is an ideal solution 
> for everyone and have always thought that 4D offered a good blend.

**
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: It's the little things (ordering parameters)

[Bill Weale]

As far as software “developers” are concerned, I may be an extreme example of 
someone who is bothered by this type of learning. I simply don’t have the 
patience/attention span/(motivation?) to devote the time and effort to the 
repetitive (to me, boring to the point of stifling) behaviors required to 
accomplish rote learning.

Specific to 4D and other scripting platforms where an important result is 
graphical, I’ve thought that I’d be a lot more productive if somehow the 
programming “language” itself were more, er, graphical. There surely have been 
improvements in my 25 years, but there’s still way too much text in this world.

8-)

Bill


> On Nov 14, 2016, at 6:26 PM, David Adams  wrote:
> 
> For those of you that pass parameters, order can matter. It's been, what,
> 30 years now I've been using 4D (!)  and I *still* have to double-check
> Position and Find in array
> 
> Position(Needle;Haystack)
> Find in array(Haystack;Needle)

**
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: Downloaded 4D app: structure file in read only mode

[Bill Weale]

Agreed. This has been long-standing issue, even before the latest changes in OS 
strategies.

—Bill


William W. Weale

Business Owners Support, LLC.

Operations Analysis
MIS Advising
Decision Support Systems

> On Nov 15, 2016, at 10:20 AM, James Crate  wrote:
> 
> Also, 4D needs to alter the startup mechanism to allow developers to write 
> code that runs before the datafile is opened. This would allow a developer to 
> much more easily do “the right thing”, which is to put the database (you 
> know, with data the user can change) in the Documents or Application Support 
> directories. Alternatively, if the data is indeed fully static, then the 
> embedded datafile could be opened in read-only mode.
> 
> 
> Jim Crate

**
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 from 4D client

[Bill Weale]

The machine selected to run the web server, the 4D User assigned to that 
machine (with or without a password), the HTML root file and anything else you 
wish to do to configure and authorize the WEB START SERVER call can be managed 
in 4D records and forms. And, obviously, they can be as “secure" as you are 
clever…

8-)

—Bill

> On Nov 11, 2016, at 3:50 PM, cswirth  wrote:
> 
> Paul Dennis wrote
>> Scott, I am about to implement serving via client. In your setup having a
>> "web user" does this mean you have to login manually when you restart the
>> client ?
>> Thanks
>> Paul
> 
> Paul,
> 
> We do log in manually after a restart, but I suppose you could make your web
> user the default user with no password... which may not be a good idea.
> 
> Scott
> 
> 
> 

**
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 from 4D client

[Bill Weale]

I can say that, as far as a version 14 built c/s system, a web serving 4D 
client can be set to auto launch while also starting the webserver. As Scott 
pointed out it’s important that the user assigned to the web server client be 
assigned to a group with web server privileges and (I’m quite sure) that group 
must not contain any more users than the number of web server licenses attached 
to the system.

Bill


> On Nov 10, 2016, at 3:18 AM, Paul Dennis  wrote:
> 
> Scott, I am about to implement serving via client. In your setup having a
> "web user" does this mean you have to login manually when you restart the
> client ?
> Thanks
> Paul
> 
> 

**
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 from 4D client

[Bill Weale]

Hi Scott—

It’s been a while, but I recall that there can be quirkiness involving the 
persistence, or not, of some of the settings in the configuration ui. I’ve 
worked around that by keeping them in db preferences records which can be 
modified by designer/administrator/user as appropriate. On startup (webserver 
startup in this case) those prefs can be invoked by code, using the db 
record/field values.

Bill


> On Nov 9, 2016, at 7:51 PM, cswirth  wrote:
> 
> Bill,
> 
> "Since the system is a built c/s project and we do auto updates quite often"
> 
> It's my experience in v15 that you need to reset the Default HTML root after
> an update.
> 
> Scott

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

web serving from 4D client

[Bill Weale]

Under the Web topic of the Database Setting ui, is this config area effective 
only if the web server is run from 4D Server?


Another way to ask:

Must all web server database settings be configured via code, if the web server 
runs from 4D Remote?

Thanks,

Bill



William W. Weale

Business Owners Support, LLC.

Operations Analysis
MIS Advising
Decision Support Systems

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

web connection process

[Bill Weale]

Do these processes share a cache of any type? Or must they, individually, build 
their own?

Thanks,

Bill




William W. Weale

Business Owners Support, LLC.

Operations Analysis
MIS Advising
Decision Support Systems

**
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: Allow CR in text field

[Bill Weale]

Thank you. There also is a multiline field property that seems to interact with 
that. My issue is trying to *allow* CRs while still applying an entry filter 
via the form or filter editors.

Bill

> On Oct 31, 2016, at 3:16 PM, Bertrand SOUBEYRAND  wrote:
> 
> 
>> Le 31 oct. 2016 à 15:44, Arnaud de Montard  a écrit :
>> 
>> Hi Bill, 
>> the carriage return is not allowed in alpha fields, but allowed natively in 
>> text fields. Did you check that?
> 
> 
> There is a checkbox located in structure mode associated to the field’s 
> properties to avoid CR input.
> 
> 
> Bertrand SOUBEYRAND

**
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: Allow CR in text field

[Bill Weale]

Hi Arnaud and Chuck—

I think I understand (correctly?) that, without any filter, text fields will 
accept all characters. It’s also my understanding that a filter acts in a way 
that it will allow only those characters specified by the filter itself? And 
there’s no way to craft a “deny” filter?

I received a call from a user that she was seeing the handling of characters 
with diacriticals had changed. (Mac OS and 4D v14) For instance the previous 2 
keystrokes which produced é were now producing ´é. (she was having to go back 
and cut the first ´.)

Years ago the purpose I used text filters was to prohibit “control” characters 
which, if stored in data, might cause unpredictable results. Short story at 
this time is that, in trying to track down the diacritical problem, I’m getting 
different results between using no text filter vs an empty text filter and I 
can’t seem to find a way to allow CRs

It’s 2016 and we’re now all unicode; is there any reason to use a text filter 
at all if I’m not particularly concerned about controlling input? Has anyone 
else seen different behaviors between using no input filter and using a 
blank/null input filter?

Thanks,

Bill

All this demonstrates I’m more capable of confusing myself thananyone else is...



> On Oct 31, 2016, at 10:46 AM, Chuck Miller <cjmil...@informed-solutions.com> 
> wrote:
> 
> Hi Bill,
> 
> text fields by there nature except carriage returns. They accept all 
> characters. If you want to allow cut and paste from word for example, you 
> need to have a filter that will filter out those hidden characters that are 
> part of the copy. That is the purpose of filter on text fields, ti limit, not 
> allow characters
> 
> 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  
> --------
> 
> 
>> On Oct 31, 2016, at 10:11 AM, Bill Weale <bill.we...@builderman.com> wrote:
>> 
>> For a text field, is there any entry (other than no entry) we can make 
>> either in the Entry Filter of a form object’s property list or in the filter 
>> editor which would allow the entry of a carriage return?
>> 
>> In other words, can this be done without requiring code?
> 
> **
> 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
**

Allow CR in text field

[Bill Weale]

For a text field, is there any entry (other than no entry) we can make either 
in the Entry Filter of a form object’s property list or in the filter editor 
which would allow the entry of a carriage return?

In other words, can this be done without requiring code?

Thanks,

Bill


William W. Weale

Business Owners Support, LLC.

Operations Analysis
MIS Advising
Decision Support Systems

**
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: Apple Agrees with 4D !

[Bill Weale]

And, hopefully, also the proprietary/native client app, 4D Remote!

(I don’t care what you throw at it or even who the U.S. president is, a web 
browser is a p___-poor client—an insult to its users—for any non-trivial 
application.)

8-)

Bill




William W. Weale

Business Owners Support, LLC.

Operations Analysis
MIS Advising
Decision Support Systems

> On Oct 27, 2016, at 3:13 PM, Peter Jakobsson  wrote:
> 
> Desktops are here to stay :-))

**
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: Managing invoices - write the total or look it up?

[Bill Weale]

I usually maintain a Payments (or Credits, not not including goods and services 
for sale) table. It can include many “types” of payments and charges. It’s 
needed to maintain an audit trail for A/R. I know it’s not, er, normal, but I 
also maintain Total and Amt Due fields in the Invoice table. Along with these I 
also keep functions which can scan these fields, identify mis-matches and 
reconcile them to the Lines and Payments records for Invoices.

Some reports often hundreds of thousands of invoices and millions of invoice 
lines. I can’t imagine I’d live long enough for 4D to build them without an 
[Invoice] Total field.

Bill


William W. Weale

Business Owners Support, LLC.

Operations Analysis
MIS Advising
Decision Support Systems

> On Oct 14, 2016, at 12:20 PM, Kirk Brooks  wrote:
> 
> I'm going to fork this thread into a separate discussion because I think
> it's a good topic and way far afield of the OP.
> 
> I have never been at a point in my development career when I haven't had at
> least one project that had invoices involved. Most of my databases had the
> 'classic' structure of an invoice table and a line items table. You add
> line items, sum up them up and write the totals into the invoice record.
> Fine until you start trying to track payments also. Hmm. So now I add
> another couple of fields for 'payments' and 'balance due'. But now it's a
> de-normalized situation: the sum of line items and sum of payments may not
> be so static. What if a payment is being applied but the invoice record is
> locked? I can't update the invoice so does that mean the payment can't be
> entered? What do we do with the payment? And so on.
> 
> Lot's of high end accounting databases started dealing with invoices by
> looking up the values when needed. ie.
> 
> Invoice_get_total(invoice id) = sum Invoice Lines
> Invoice_get_balDue(invoice id) = sum Invoice Lines minus sum Payments
> 
> 
> ​I tried that approach in 4D years ago and it was just too slow to be
> feasible when building reports. Or maybe I wasn't as good at setting up
> structures back then. It is undeniably faster to write reports from static
> data. But in a dynamic environment (where someone is literally watching an
> invoice for the balance due field to change) it gets more complicated.
> 
> Another problem with the lookup approach is historical data. You spend a
> lot of computer resources looking up static data that hasn't changed in a
> long time and really won't ever change again. That's not what you want.
> 
> My approach to invoices currently is this:
> 
>   - ​There are 'active' and 'inactive' invoices. Inactive ones have the
>   totals written to the record. Active ones don't.
>   - ​Invoice records are never opened in a user window. I make a dialog of
>   the invoice data but not the actual record.
> 
>   - Changes are submitted as variables, submitted to a single method for
>   validation and updating the record.
> 
> ​I think this gives me the best of both worlds. A pref lets the user define
> how long to leave an invoice in the 'active' state after it's paid. A month
> or two is a usually enough. Plus, it's not like this is a one-time only
> designation. An invoice can be changed from active to inactive and back as
> needed, for some reason.
> 
> ​Getter methods look at the invoice record to know where to get the data.
> Like so:
> 
> // Invoice_get_total(invoice id)​
> ​if(invoice_active)
> 
> $0:=  lookup the line items
> 
> else
> 
> $0:=[invoices]total
> 
> end if​
> 
> 
> ​Editing invoices is restricted in various ways but the basics are pretty
> much anyone can view the record, you can submit changes if you have
> permission and those changes are managed by a central method.
> 
> The final part is a background method that loads on startup, runs once a
> day and looks for paid invoices that can be made inactive. ​
> 
> This is all probably overkill for single user applications. In busy
> multi-user dbs, where people creating invoices aren't necessarily the
> people entering payments or where payments arrive from external systems,
> this is a pretty good approach.
> 
> On Fri, Oct 14, 2016 at 7:57 AM, Chip Scheide <4d_o...@pghrepository.org>
> wrote:
> 
>> Invoice, and invoice item
>> - Invoice item is changed, which changes a total on the invoice
>> both are locked to other users, until the transaction is completed.
>> 
>> On Fri, 14 Oct 2016 16:49:10 +0200, Arnaud de Montard wrote:
>>> 
 Le 14 oct. 2016 à 16:11, Chip Scheide <4d_o...@pghrepository.org> a
 écrit :
 
 yes.
 But then :
 - if the 1 user changed a value, everyone probably needs to know that
 the record is being modified and whatever value(s) are displayed may
 not be correct.
>> 
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  

Re: Is there a 4D View User Manual?

[Bill Weale]

Thanks Chris and Bob…

Yes, it appears the v 2004 version is the latest.

Bill


> On Oct 12, 2016, at 11:39 PM, Chris Patterson  wrote:
> 
> Hi Bill,
> 
> Yes, there is a 4D View User Manual, I have a PDF one that I appear to have
> downloaded as part of 4D v14.
> However, it does not seem to have been updated since 4D 2004!
> Both the v14 and v2004 copies I have are 186 pages and Copyright 2005.
> I just checked the 4D DocCenter and it is not there.
> They must have it, but I am not sure how one accesses the archives.
> 
> Hope this helps.
> 
> 

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

Is there a 4D View User Manual?

[Bill Weale]

For v 14 or something close?

Bill



William W. Weale

Business Owners Support, LLC.

Operations Analysis
MIS Advising
Decision Support Systems

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

Re: Auto Open last used database

[Bill Weale]

Thanks, Tim, that is exactly what I'm doing. Sure was nice when I didn't have 
to and it took a painful amount of time to determine why the auto update was 
suddenly failing for 20+ clients.

8-)

www

> On Sep 27, 2016, at 12:24 PM, Timothy Penner  wrote:
> 
> Hi Bill,
> 
>> Just to be more specific, I have to edit the IPAddress value into the 
>> BuildApp.xml file *every* time I run BUILD APPLICATION.
> 
> If you are making custom edits to the BuildApp.xml file that are not 
> available in the dialog you need to use the BUILD APPLICATION command and 
> pass it your custom XML file.
> 
> If you are using the BUILD APPLICATION dialog it will overwrite the 
> BuildApp.xml file each time and only use the fields available in the dialog 
> (omitting the custom changes)
> 
> -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
**

Re: v13 - How do I get iCal to provide User/password

[Bill Weale]

Could you use a formula (to build part of the URL) for each user that is known 
only by 4D and that user? I think this was described (more eloquently by 
someone else) in your earlier thread. It’s something I implemented some time 
ago. It’s subject to being shared between users, but so is using passwords.

Bill


William W. Weale

Business Owners Support, LLC.

Operations Analysis
MIS Advising
Decision Support Systems

> On Sep 6, 2016, at 11:30 AM, Chip Scheide <4d_o...@pghrepository.org> wrote:
> 
> I am still playing with this calendaring thing.
> I have the calendar itself working (yeah)!
> 
> now I want to subscribe to the calendar (in 4D) from iCal.
> using the old demo (from Dave Batton) I can get iCal to connect.
> What I can not seem to do is to get iCal to request/provide a username 
> and password
> so I can authenticate that the user subscribing to my 4D database 
> calendar is authorized to subscribe to the calendar they are trying to 
> subscribe too.

**
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: Print header, then PRINT SELECTION, then footer

[Bill Weale]

OBJECT MOVE might also be a possibility, if you can ID the last page.

www


William W. Weale

Business Owners Support, LLC.

Operations Analysis
MIS Advising
Decision Support Systems

> On Aug 31, 2016, at 11:45 AM, Koen Van Hooreweghe  
> wrote:
> 
> Hi David,
> 
> Have you tried by moving the data/footer marker lines by code using SET PRINT 
> MARKER
> When in print selection, you can only call this in the On Header form event. 
> So you might need to find a way to determine if it is the last page when that 
> header is printed to change the footer maker line.
> 
> HTH
> Koen
> 
> Op 31-aug.-2016, om 17:37 heeft David Rose  het volgende 
> geschreven:
> 
>> I want to print the header only on the first page and the footer only on the 
>> last page. In between I want to print a selection of records, with subtotals 
>> in the two break areas. What series of print commands and other code do I 
>> need?

**
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 command returning a value request

[Bill Weale]

ummm….

divine wisdom = Engineering?

or, Engineering:=divine wisdom?



www

> On Aug 30, 2016, at 12:47 AM, Keisuke Miyako  wrote:
> 
> but this is just my own way of reasoning, not divine wisdom (I did not 
> consult Engineering).

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

App Nap v 14 built client app

[Bill Weale]

Do we explicitly have to disable App Nap for v 14 built clients?

Will/can App Nap on 4D built client cause the client to drop its connection to 
4D Server?

Thanks,

Bill


William W. Weale

Business Owners Support, LLC.

Operations Analysis
MIS Advising
Decision Support Systems

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