CALL FORM: Some notes on a command that's easy to misunderstand

I've seen CALL FORM come up in some recent threads where people have mistaken ideas about how it works. I think that the mistakes are entirely natural when coming from CALL PROCESS/On Outside call. I was going to add some comments to the docs, but I just looked and don't see how you do it.

Problem accessing 4D via ODBC and Excel Power Query

Hi All, (All Windows, 4D server v15.2, 32 bit Excel and 4D ODBC driver) We use Excel to access data in our 4D database via ODBC. Works great, except when we try and use the Excel add-in Power Query. It generates a connection error: Unable to Connect We encountered an error while trying to

RE: 4D Server - Not letting go of users

Hi Lahav, Thanks for the note. I'm pretty sure we are using the legacy network layer But I'll check. Thanks Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of lists via 4D_Tech Sent: Thursday, March 16, 2017 12:30 PM To:

RE: 4D Server - Not letting go of users

Hi Randy, I see this quite a bit, and it has something to do with the new network layer. I have reported it to tech support, but never really saw the issues resolved. The problem goes away if I use the legacy network layer. Cheers, Lahav -Original Message- From: 4D_Tech

RE: 4D Server - Not letting go of users

Bob, Yes! This is what I'm referring to. How come, why for? What can we do? Anybody got an idea? Thanks Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of bob.miller--- via 4D_Tech Sent: Thursday, March 16, 2017 12:05

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

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

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

Re: v13 MSC Maintenance Mode Activation—Mac.

Hi Robert ListMail < > >I’ve got a v13-based single-user web-serving 4D database running on a headless >Mac server (in a land far, >far away) that I maintain via Mac Screen Sharing. Recently I’ve been unable to >launch MSC in >Maintenance Mode (via option key depressed at startup) . Any ideas?

Re: 4D Server - Not letting go of users

On Thu, Mar 16, 2017 at 1:27 PM, Randy Engle via 4D_Tech < 4d_tech@lists.4d.com> wrote: > If a client/user does a force quit (i.e. Task Manager), > Their user account on 4D Server persists, and takes up a license. > I used to think that these would fall off in a short amount of time, but I >

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

Hi Thanks(scroll down for link to a nice video) Dont really know what was going on. Think i was being blind to an accidental reference to $tableNums. All working now.-replaced the locals with process vars and tidied it up and its all good. Incidentally i had lots of fun with updating records

v13 - Print settings and Setting Printers

I need some clarification please. Docs for Set Current Printer say : The SET CURRENT PRINTER command must be called before SET PRINT OPTION, so that the options available correspond to the selected printer. On the other hand, SET CURRENT PRINTER must be called after PAGE SETUP, otherwise the

4D Server - Not letting go of users

If a client/user does a force quit (i.e. Task Manager), Their user account on 4D Server persists, and takes up a license. I used to think that these would fall off in a short amount of time, but I found some that were 2-3 days old. Of course, if server is restarted, all is fine. This is Windows

RE: tab seperated text - what to use for Cr

easy to get... I am going to do a simple substation: Cr will be replaced by "" The users can 'read' it, and understand, the spacing will help to act like a return, and replacement in excel (or other program should be easy Thanks everyone On Thu, 16 Mar 2017 08:41:14 +, Epperlein, Lutz

RE: tab seperated text - what to use for Cr

The easiest way to get what Excel wants to get, is creating example data in Excel and exporting it as a tab delimited file. The problematic characters are line wraps, tabs and quotes inside a cell. The rules: - field delimiter is tab, record delimiter is CR LF (0x0d 0x0a) - Tabs inside cells

Re: tab seperated text - what to use for Cr

In my excel version a tab delimited file as long as the field has DoubleQuotes, then the tab delimited file can contain a LineFeed hex:0A in that field Then it will not cause a row break, it will instead contain a new line within the cell. If you don’t have the double quotes then excel will

Re: Larry Sharpe

On Wed, Mar 15, 2017 at 5:17 PM, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com > wrote: > Larry passed away last week.. Obit here: http://www.mtdemocrat.com/ > obituaries/larry-sharpe/ obituaries/larry-sharpe/> > Sorry to hear about this. My thoughts and prayers are