Re: Windows Server Hardware Recommendations for 4DServer v17

Hi Neal, >We're planning to upgrade to v17 in Q1 this coming year. We're currently >running our 4DServer v16 r6 application on a Windows 2008r2 >server (DELL Server PER420 with Xeon CUP E5-2407 v2 @2.40Ghz 2.40 Ghz (2 >processors) with 32GB RAM, 64-bit). Our budget for the >coming year

Re: Audit File Updates via Triggers...

Kirk Brooks writes: >John, >Sure you can - you make a method to extract the data >you want. In selection based listboxes you can put the >method in a column formula. >On Tue, Nov 20, 2018 at 1:14 PM John DeSoi via 4D_Tech <4d_tech@lists.4d.com> wrote: >> Just note that you won't be able to see

Re: v13 - Why can a record NOT be Pushed?

Chip and Kirk comment: >> forgotten the whole idea for these two commands is to allow you to >> PUSH the record you are currently using to allow you to do queries on >> the same table without having to save it first. >Yes I know that about Push and Pop >In this case I have a complicated set

Re: Leaving the .4DB behind??

Robert says: >But what if the structure was that collection of files and that 4D runs as >it always does but the github version management is always in play without >an export? What if the .4db is simply a package that didn't have to be there? >Just a thought. I think at a minimum, we will be one

Re: Help->v11 to v17 Upgrade or New?

Dani Beaubien writes: > >I use the external git client for diffs against historical commits and I use >the >Code Analysis component for diffs between what is in the 4D structure >compares against the last export to the external folder. We did a similar thing based on Thomas Maul's MethodHistory

Re: Defining and documenting Objects

Peter Jakobsson so eloquently writes: >The original selling point of 4D was that it was stateful and that >statefullness >is what gave us massive productivity gains. Lower level languages like the >Microsoft developer platforms, Delphi and even Javascript/Python type >environments had the

Re: Defining and documenting Objects

Koen Van Hooreweghe writes: >Objects can be 'exported' to JSON quite easily: $json_text:=JSON >Stringify($4Dobject) Then you can expose this text data to the external system. >The other way around is: $4Dobject:=JSON Parse($json_text) >I really advise the step up to v15 and further. Objects

Re: Defining and documenting Objects

> On 5 Oct 2018, at 09:15, Paul Dennis via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > With tables and records and the structure it's relatively > straightforward to track through the code and work out what's going > on. I can see this being a real problem with

[Off] RE: How to get the current time in a specified time zone

Timothy Penner writes: >There are a lot of nuances for timezone data; here are a few that I find >interesting - >The following article is both interesting and funny in how it explains some of >these nuances: >https://zachholman.com/talk/utc-is-enough-for-everyone-right Indeed, the whole

Re: How to get the current time in a specified time zone

Pat Bensky writes: >The only thing I'm not sure about is how various time zones change in their >relationship to GMT (eg Summer Time etc.) For example if Country A is >normally on GMT -8 but they're currently on Summer Time so 7AM in that >time zone is CurrentHourGMT-8+1, how do we account for

Re: Volume Shadow Copy

Keith writes: >The 64bit compiled/built server application shows "Volume Shadow Copy up and >running" on the first page of the server admin window. >Googling "Volume Shadow Copy" shows it to be a system that allows backups >while an application is running. >I suspect this is not something

Re: Team Developer - Do all developers need to be on same minor version?

Jeffrey Kain jeffrey.k...@gmail.com writes: >Nope... >If 4D makes a major change to the protocol they'll block it. For deployment >we try to have matching versions always. > >> On Aug 28, 2018, at 2:24 PM, Dave Nasralla via 4D_Tech >> <4d_tech@lists.4d.com>

Re: New record numbering system and CALL WORKER

Kirk Brooks writes: >I am surprised this thread has drawn so much discussion. It's good >discussion but scanning back over it a key point is that all of these >contortions and workarounds to preserve a number sequence are based on the >single design decision to use an invoice (in this case)

Re: First day experience using 4D v17.0 HF1

Tim Nevels writes: > First day 4D Server Team Developer v17 experience over a WAN was very good. Thanks for the report Tim. I'm very impressed that anyone is doing development on 4D Server over the internet. When deployed does your app use 4D Client or does it have a web front end? I

RE: Export text columns containing carriage returns to Excel?

I didn’t have to escape the embedded commas. I think the quotes around all the fields took care of them. You will likely need to experiment. I found that Excel is fussy about CSV. It definitely doesn’t like importing CSV via the import wizard unless there are no embedded delimiters. Tom From:

RE: Export text columns containing carriage returns to Excel?

Brad, Here's a hint that you may (or may not) find useful. I used a single column in the QR Editor to hold the full 'record' I was exporting. I wrapped all the fields with double-quotes and used commas as field delimiters. I also had to escape any embedded quotes by replacing them with

Re: Export text columns containing carriage returns to Excel?

Brad Perkins writes: >I've been asked to provide an export from a legacy 4D system delivered as an >.xlsx file. >The challenge I'm facing is that this table contains a number of text fields >and >the customer requires the imported column cells to retain the returns or line >feeds >in the

Re: v13+ Unicode characters 1-7

Keisuke Miyako writes: >.. may I suggest VT (vertical tab, Char(11)) which displays at \v in the >debugger. > >when you export the values tab-delimited, >vertical tabs fits all values in the same cell (multi-line). > >not sure about Excel, but at least it should be that way with Numbers

RE: 13.x Quick Report Export Max Output File Size?

Tim Penner writes: >Is the file system Fat32? >If so, then keep in mind that a Fat32 file system is limited to 4GB files. It's Windows Server 2008 R2 SP1. I'm pretty sure the disk that the file is being written to is NTFS. And there are other files, like the .4DD, on that disk which are

13.x Quick Report Export Max Output File Size?

I'm exporting data from 4D to a text file using the 4D Quick Report Editor in v13.x. It stopped writing to disk when the file size reached 4.0GB (4,194,304 KB). The disk it is writing to has plenty of space on it. Is there a file size limit to exporting data using the 4D Quick Report Editor?

Re: What do you use to monitor your offsite servers?

We have a number of 4D Servers which we run under a dedicated Windows Account. We use the same Windows Account to run all Production Servers on all machines. If someone needs to monitor the server they can do that via RDC using that Windows Account. That avoids any session confusion. However,

Re: Application Metrics

Robert writes: > in your 4D applications are you tracking usage levels of any kind? I suppose > it >would be useful to know what features are heavily used and which are almost >never used. What metrics does your system collect that you've found useful? We don't keep track of features used, but

Re: Server crash in MSVCR120.dll - help with debugging dump file

Hi Adrian, >Recently we've had server crashes on two customer sites with our >application (built with 4D v15R5), and in both cases the Windows event >log is pointing the finger at MSCVR120.dll (version 12.0.21005.1), with >an exception code of 0xc409. >I have a Windows minidump file from one

Re: 2 instances of 4D connected to different 4D Servers

Hi John, >Thanks Julio. Like you I duplicate 4D all the time to run multiple instances >on my Mac. > >On windows, however, I have been reluctant to fiddle with windows >installations as >I suspect that there are DLLs or other files installed in places that I know >not where. > >I did in fact

Re: setting up mirror

>Thanks for your update. I assume you have a process on mirror that runs and >delays >itself for x amount of time. What happens if you try and create a second log >but >first has not been integrated. What do you do? Would you mind sharing code. >I know it should be pretty simple, but I

RE: xml to array

Peter et al, The method was actually written by David Dancy. It was part of some XML methods he shared with the 4D community a number of years ago. Sure miss his presence in the 4D Dev world. Hope this helps. Tom // // User name(OS):

Re: v13 -Automatically repaired method

Chip Scheide writes: >Any way to recover the code? > >There is no backup, as the code was written today. > We use the old but solid MethodHistory component from Thomas Maul. It writes all methods to a 4D table, so all edits are preserved. It comes in very handy. We use it for a

Re: xml to array

Hi Peter, > >Is there a 4D command that will take a block of xml, and turn it into a number >of arrays (or pairs of arrays (attribute and value) Or is this a stupid >question Thanks -pm I have a method to do this. Let me know if you need it. Tom Benedict Optum Inc This e-mail,

RE: Using the new 4D SSO feature on Windows

Timothy Penner > responded to Bob Miller > >The whole idea with Single Sign On is that the user logs in to the machine, >and then subsequent system >they use while logged in to the machine will use the

Re: [SAD NEWS] legendary developer and 4D base-rock Ortwin Zillgen

> >it is with great sadness, that I have to inform you, that Ortwin Zillgen has >passed away end of last week. >Suddenly, unexpectedly and far too early at the young age of 64. > Sad indeed. I had not met the man, but admired his intellect and developer skills as expressed on the iNUG.

Re: 4D Parameter

Tim Nevels responded >On Feb 6, 2018, at 2:00 PM, Miguel Gonzalez wrote: >> Is there a way to make the processes running in 4D Server not taking >> too much resources? >> I know that this is for the processes to finish quickly when send to the >> server. >> >> My problem is that this

RE: Re: "Goodbye 4D Write" email

Whoops. Sent too soon.. I meant to add that if you are going to go to the trouble of writing a bunch of code to make 4D Write Pro work as you need, it might be a smaller effort to write the code needed to integrate one of the Javascript word processor libraries to your app. Tom From:

Re: "Goodbye 4D Write" email

There are plenty of Javascript text editor libraries available. This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or

Re: Anyone using 4D Write Pro with a semblance of success?

There are lots of Javascript word processing libraries available. Database/application integration and programmability is key to 4DWrite's value. Has anyone tried using callbacks in a web area hosting a Javascript word processor to do mail merge? I haven't tried, so I don't know how feasible it

RE: read from a MS SQL server with 4D

Fernando writes: >I need to read from a MS SQL server with 4D. >Someone can give a link with examples. SQL LOGIN is a good command to start with. Tom Benedict Optum Inc This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the

Re: [Off] Remote backup

Bob Miller writes: >[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 last journal file to [Server#2]. > >[Server#2] Runs 4D Server that users aren't

JSON Tools Was: Re: C-objects and memory use

David Adams dpad...@gmail.com writes: >Well, 4D's tools for manipulating JSON are sub-standard, if your goal is to >parse/produce JSON freely. In this respect, the XML tools (external libraries >built into 4D) are far more standard and comprehensive. Along these

Re: 4D Write Pro interface plug in or component?

John DeSoi writes: >> On Jul 10, 2017, at 5:55 PM, John Baughman via 4D_Tech >> <4d_tech@lists.4d.com> wrote: >> >> Pro looks to be a good upgrade, but I hate the fact that it comes without a >> typical word processor user interface built in. I just don't have time

Re: Optimizing and improving 4D queries.

Hi Eric, > I was hoping there way a way like in mysql to explain slow queries to tell my > how or what why the query was being slow. Have you tried the DESCRIBE QUERY EXECUTION command? It will tell you the query path and plan including execution time. HTH, Tom Benedict Optum

Re: Data mining from Oracle Application using 4D

Rooftop99 says: >I have a large Oracle database from which I need to regularly extract specific >data using a 4D >application. Is there a preferred way to connect the two for data mining? >ODBC, or ??? >Anyone doing this with success and willing to share the connection >architecture? I

Re: Get table fragmentation

Cannon writes and David responds: >I'm working on some server health reporting. I can get the percentage of table >fragmentation using "Get table fragmentation" for each table. >I'm not quite sure what to do with it, though. I'd like to get a report when >the overall fragmentation reaches some

Restart Client Under Program Control

In v 13.x, when a client 'loses a connection' to 4D Server due to a network interruption of some sort, 4D.exe will display and dialog which includes a "Restart" button. When "Restart" is clicked 4D.exe relaunches and auto-logs in using the same credentials (or maybe it is just using the 4DLink

Access Groups and Objects

I think this question comes up from time to time, but I couldn't find it in the archives. We use 4D Users & Groups for menu, form and method access control. Is there a way to get a listing of menus, forms and methods by access group? Thanks, Tom Benedict Optum This e-mail, including

Re: dog's breakfast

David Adams included this gem in a recent post: "It was enough of a dog's breakfast..." That's a phrase we don't hear enough of on this side of the pond. Thank you, David, for your enthusiastic use of language, programming or otherwise. It's always a pleasure to read your posts, whether or not

Re: Tom Benedict's rule engine - something that you need to know

David, >Tom Benedict mentioned in passing that a "rule engine" he presented at the >Summit in 2014 might be >the right tool to help John Foster solve a problem. >My ears perked up because I've long wanted to have a rule engine in 4D but >haven't taken the time to >write one. Tom hooked me up

Re: Dynamic Method Creation & Content Changing

Hi John, > I am wondering if anyone is modifying methods on the fly by inserting > selective lines of code. What >I have in mind is selectively inserting into case statements. >Why do I need it? Because I have have a client who needs to setup various >medical trials and routines that get

RE: Methods, Components, Comments, and Tooltips

Lutz writes: >we use a modified version of the mentioned vc-framework component. It saves >all changes in the code to text files >immediately and keeps track of the timestamps of the changes in an external >database. The text files can be >committed to a source code versioning tool like svn,

Re: Clean Slate - Modern User Experience.

Peter Jakobsson responds: >> Where could I go to see samples of what folks are doing with 4D which brings >> the UI into the modern era? Any thoughts? >Doesn't the O/S define 'modern era' ? I couldn't agree more. If you are using 4D "client" for your app, create style sheets and

Re:Server Mirroring

Cannon Smith writes: >I'm looking into the idea of setting up a mirrored server. One one hand I want >to be >pretty aggressive about sending log files to the mirror-probably every couple >of minutes. >On the other hand, I don't want to use "New log file" and then send the log >file if nothing

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 15.4 HF1 (windows) - crashes when run as service

Keith White writes: >Retaining access to 4D Server's user interface is currently essential for >system admins to be able to drop users or to see 4D error message dialogs that >may have appeared on the 4D Server UI. >Now I know you're going to tell me that you can use the 4D Remote

Re: Virtualization - Yea or Nay

Hi Doug, >My reason for posting this message is to solicit feedback on the pros and cons >of moving >an existing system to a virtual environment. The IT department at a client >site is pushing >a client to virtualize their 4D system and I've been asked to provide input. >In a short, my