Sending HTML Email?

2017-11-16 Thread bob.miller--- via 4D_Tech
Hi All, I've sent a lot of email generated by 4D over the years, but it is time to up the game and send crisper looking stuff. So I've been playing with sending HTML. The problem is that when the email arrives, it displays all the tags in the mail client! For some reason, the mail client

RE: What happened to 4D documentation in R releases?

2017-10-06 Thread bob.miller--- via 4D_Tech
Yes, v16 brings a somewhat frustrating "new" approach to documentation. In fact, I postponed looking at v16 until there were PDF docs, which were not released until several _months_ after v16 came out (there were html docs, but no PDF docs). I am also frustrated by how the documentation has

Object fields (Was: Re: QUERY BY ATTRIBUTE is slow af)

2017-09-13 Thread bob.miller--- via 4D_Tech
Along the lines of, "what is an appropriate use of an object field", I've been considering this: We are a manufacturing company with lots of tools and lots of products. Each tool has various attributes, but each tool type has a different set of characteristics. Silly example that I hope

[Off] Remote backup

2017-09-12 Thread bob.miller--- via 4D_Tech
Hi Jeff, This is a great idea, I had not thought of it. Let me repeat it back to see if I have it: [Server#1] Runs 4D Server that users are actively using. Code in a loop on the 4D Server calls "New Log File" every 10 minutes. Code in the loop then calls LEP to a script to transfer the

Re: Restricting a query

2017-07-31 Thread bob.miller--- via 4D_Tech
RE> I have a table which contains records for 10 different clients. I'd like to give a client the ability to search the table for only his records and not be able to see any of the other clients' records. Is it possible to do this using the standard 4D Query editor by always applying an

Re: Someone help me out, how do you get good information out of 4D

2017-07-12 Thread bob.miller--- via 4D_Tech
RE> The people I meant to write to know perfectly well my history and what I'm talking about - and know that it's form a quarter of a century ago. (By now, virtually no one from those days is even around.) David, Virtually no one? Really? Come back to the US for the next Summit and you'll

Using a custom icon in Confirm dialogs

2017-06-22 Thread bob.miller--- via 4D_Tech
Hi Everyone, Someplace I read that you can take an .ico file (icon) and place it somewhere so that when you build a 4D app, that icon is used instead of the 4D icon on the 'Confirm' dialog. I had this working, then rebuilt my system and obviously things moved around, because now it doesn't

Securing ODBC Connections?

2017-06-06 Thread bob.miller--- via 4D_Tech
Hi Everyone, I've been digging through the docs and not finding answers to my questions, which might be under my nose, but I'd appreciate help: > An outside application (non-4D; "real world" stuff) - needs to pull data from our 4D Server (Win, v15.x) via an ODBC connection. I can see how to

Re: USE DATABASE from 4D client

2017-05-30 Thread bob.miller--- via 4D_Tech
RE> rather activating the "execute on server" method property, I would recommend using the REMOTE keyword: http://doc.4d.com/4Dv15/4D/15/USE-DATABASE.300-2288124.en.html I don't understand how this would make any difference; the REMOTE database would still be held open until AUTO_CLOSE was

Re: Query selection by example.

2017-05-18 Thread bob.miller--- via 4D_Tech
RE> Is there a way of doing a query by example, on an aleady queried selection of records? I want to create a selection of records, based on some internal criterea, and then present that selection, in the form of Query by Example, to the user. Sure, I use this method with great results (the

4D World Tour - Go!

2017-04-06 Thread bob.miller--- via 4D_Tech
Hi Everyone, I'll pitch in here, too - I attended the World Tour in Chicago earlier this week (yeah, I live in Boston where it is also offered, but that's another story). I was impressed with the amount of preparation the 4D team did for the tour, with many good examples on the USB key and

Re: Host Structure in a component-Enhancing 4D Code-you really want to see this

2017-03-16 Thread bob.miller--- via 4D_Tech
Hi Nigel, One word: Niice! How did you insert an event 'on object method close', when you added code to the button? Bob Miller Chomerics, a division of Parker Hannifin Corporation ** 4D Internet Users Group (4D

Re: 4D Server - Not letting go of users

2017-03-16 Thread bob.miller--- via 4D_Tech
RE> If a client/user does a force quit (i.e. Task Manager) Just yesterday I had a problem where we had some 'license count exceeded' messages - very rare - and I noticed that we had people who were logged in for days. Some had force-quit and others had simply closed their remote desktop

Weird variable (non-)refresh issue

2017-03-15 Thread bob.miller--- via 4D_Tech
Hi Everyone, I have a situation where I have a variable on an input form that I set programmatically immediately before opening a dialog window (using the "Plain Window" window type). When I move the dialog to the side (to see the input form, now in the background), the variable still has its

Adding fields to tables using SQL

2017-03-02 Thread bob.miller--- via 4D_Tech
Hello, I'm tired of the structure editor and how it requires you to add fields one at a time and how the field palette disappears each time 4D loses focus. I created my own little "Field Adder"utility where I can specify a table, then drop a list of field names and data types from two rows

Structure and Data File do not match

2017-02-23 Thread bob.miller--- via 4D_Tech
Hi Everyone, During a recent upgrade where I created a compiled/merged app with 4D Server, when I deploy the new compiled/merged app I get this message: The structure and data fiels to not correspond to each other. The data file cannot be opened with the structure. This is in v15r4, and I

Detecting field properties that can take nulls

2017-02-20 Thread bob.miller--- via 4D_Tech
Hello All, In troubleshooting a recent problem, I found that I had inadvertently unchecked "Map NULL values to Blank values" on a field definition. I'd like to scan the database to see if I may have made the same mistake for any other fields. I'm coming up short on a way to do that using Get

RE: iNUG List "From" Change

2017-02-17 Thread bob.miller--- via 4D_Tech
Per Tim Penner > The new behavior you see is called munging the address Wow, a new tech word! Actually not new at all - the origin per Wikipedia is actually in 1958 at MIT. Geez, where was I? "Mung or munge is computer jargon for a series of potentially destructive or irrevocable changes to