RE: What anti-virus to use with Windows 10

For development machines, I heard that NOD32 is a good choice: http://serverfault.com/a/5895/340831 The observation that I linked to above mentions: "have tested Symantec, Kaspersky, Norton, ZoneAlarm, Avast, and AVG. All of them have noticeable performance issues, and many were downright

RE: v13 - How do I turn on/off unique programatically

Maybe disabling constraints will help you: http://kb.4d.com/assetid=76498 http://doc.4d.com/4Dv16/4D/16/ALTER-DATABASE.300-3201303.en.html Begin SQL ALTER DATABASE DISABLE INDEXES; ALTER DATABASE DISABLE CONSTRAINTS; ALTER DATABASE DISABLE TRIGGERS; End SQL // do stuff Begin SQL

RE: 32 Bit or 64 Bit ? 4D Write

Hi Chuck, You plan to use 4D Server 64 bit to take advantage of more ram; makes perfect sense... but your curious if there is anything you need to know about 4D Write before switching to use 4D Server 64 bit (I assume this is for Mac since 4D Server 64 bit has been available for Windows since

RE: 32 Bit or 64 Bit ?

> I am pretty sure I read that 4DWrite Pro requires the 64-bit version, but I > can't find that reference now ... Actually the opposite is true; the legacy 4D Write only works in 4D 32 bit, while 4D Write Pro works in both 4D 32 bit and 4D 64 bit. > Is it just that you can have a bigger cache

RE: [Off] Multiple 4D 15 Icons in Mac Dock

> I have 4D 15.3 in the Doc on my Mac. When I launch it by clicking on it, a > second 4D 15 icon appears with the dot below it to indicate it's running. The > existing icon doesn't show a dot. If you create a shortcut or link to an application, then add that shortcut/link to the doc, then

RE: How to halt execution, to avoid Quit 4D

> Yes this is the problem. One way to switch is to start 4d and instead of > using a shortcut on the splash screen or a choice in recent menu, go File, > Open, Local Database. On the Open dialog you can choose Compiled/Interpreted > and Current/Other/New Data File.

RE: Cannot connect 4D client v15R5 64-bit with 4D Server v15R5 64-bit

Most likely this happened because: * The Structure was upgraded from v13 so it had the structure setting to use the legacy network, not the new network layer. * Launching the upgraded database on Windows with either 32 bit or 64 bit Server will utilize the legacy network, not the new network

RE: Comboboxes in v15 Bug

There was this: ACI0096062 [134570] Combo Box falls behind dialog window on Mac OSX Sierra Fixed in: Version : 15.3 Change : 206487 -Tim ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive:

RE: AWS Storage Gateway for Storing Images and 4DD file

Hi Balinder, I have heard of "issues" with using dropbox as a storage location for the database files (4DD, 4DB, journal, etc); specifically issues using dropbox as a way of synchronizing the database files offsite... In that situation simply moving the database files outside of the dropbox

RE: v13.5/6 on OSX 10.11 el capitan

Hi David, > I’m seeking a transition OSX that will run both 13.5/6 and v15.2. Look at the Certification Matrix for both v13.6 and v15.3... v15.3: http://download.4d.com/Documents/Products_Documentation/LastVersions/Line_15/VIntl/20161104_CertifV15_3_INTL.pdf v13.6:

RE: 4D Object Fields in ODBC

Hi Joshua, > Thanks. I've put in my plus one. Please use the star rating system; http://kb.4d.com/assetid=76726 The star rating system has 4 options: 1 = Bad 2 = Average 3 = Good 4 = Excellent Select the number of stars you feel the feature request deserves to cast your vote Kind Regards,

RE: v14 on macOS Sierra?

Kirk, > *** Terminating app due to uncaught exception 'NSInvalidArgumentException', > reason: '-[WK4D_CarbonWindowFrame contentFill]: unrecognized selector sent to > instance 0x9746380' I think I have seen this crash before and I believe it is fixed in the latest nightly builds of v15.x

RE: Most Current Cipher List for 4D and questions regarding OpenSSL versions being used

Mike, v15.2 used OpenSSL 1.0.1p v15.3 was updated to OpenSSL 1.0.2j as described in the release notes: http://download.4d.com/Documents/Products_Documentation/LastVersions/Line_15/VIntl/4D_v15_3_ReleaseNotes_US.pdf For a cipher list, I like to check https://cipherli.st/ * then click on the

RE: About using the same data file in two different structures...

Hi Kirk, > What I'm seeing is the table names don't seem to matter as long as the Tables > and Fields have exactly the same numbers. Please see here: http://kb.4d.com/assetid=76862 I hope this helps, -Tim PENNER ** 4D

RE: Memory settings

As Arnaud mentioned: > There is no "best settings" but "settings for each situation" and it's not > easy to evaluate. This is very true. For a proper recommendation we would need to know more details, such as: * How big is the data file? * How big are the indexes? * 64 bit 4D Server or 32

RE: v14 on macOS Sierra?

Kirk, > Tell me more then. I signed up for the public beta just because I'd heard > that but v15.3 still crashes right off when I try to boot it up. > Are you running on and old Mac or a new one? I'm using one of the new ones. Just a guess, but is 4D running from /Applications/4D.app ? If not,

RE: Debug Log tool

> https://github.com/j-genie/4D-DebugLogReader > Note that the log files are parsed into memory for performance reasons, so > there is a limit on how many you can process at a time. We tend to limit it > to 5 at a time. Solution: update to v16 (or v15R5) and use 4D Developer 64 bit, which has

RE: HTTPS failure to POST - Server Unreachable error

Hi Donald, >> HTTP server not reachable: xx.xx.xxx.xxx (sane ip address as in $url. >> Error #2 >> > Question: why does http succeed and https fail? Does the server use TLS / SNI ? If so, please see this feature request: http://forums.4d.fr/Post/EN/18160614/1/18160615#18160615 Kind

RE: Question about Web Areas and local cache

Have you tried using the NOTIFY RESOURCES FOLDER MODIFICATION command: http://livedoc.4d.com/4Dv16/help/Command/en/page1052.html The NOTIFY RESOURCES FOLDER MODIFICATION command "forces" 4D Server to send a notification to all the connected 4D machines indicating that the Resources folder of

RE: Question about Web Areas and local cache

I just read the original email: > So here's the odd part - 4D seems to be caching the js files. I noticed that > if I make a change to the .js files, save them and re-load the web area I can > see in the Web Inspector that it's still running the unchanged file. A common trick is to add a

RE: Question about Web Areas and local cache

Hi Kirk, > FWIW - if the context menu is enabled the Reload command on that does the > full relaod. > I'd still like to know how to do it via programming. I haven't tried it but what about using the JavaScript location.reload() or location.reload(forceGet) with WA EVALUATE JAVASCRIPT ?

RE: Passing Object Pointers vs References - slight 'gotcha'

I think this topic relates closely to a feature request from Rob: http://forums.4d.fr/Post/EN/18642977/1/18642978#18642978 -Tim -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Rob Laveaux >The only thing to keep in mind is when you pass an undefined

RE: Here's something cool about using Execute Method

Hi Kirk, I haven't used footrunner so I cannot comment on its comparison to the built in feature of 4D. Hope that helps, -Tim PENNER ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive:

RE: Here's something cool about using Execute Method

Hi Kirk, > This seems especially well suited to things like maintenance tasks. To expand on your existing idea: How about providing a file to the end user that uses the 4DCODE tag; http://livedoc.4d.com/4Dv15-R5/help/Title/en/page2850.html#2880146 Then have a UI that uses PROCESS 4D TAGS to

RE: v15.3 seems to be crashing on MACOS 10.12.1 & the new MBP

Hi Kirk, Actually it looks like I gave you incorrect information this morning; I had originally said you needed a paid Developer account with Apple to get the Beta of 10.12.2: > Here is the latest download from Apple, but it requires a paid Developer > account to download: >

RE: 4D Web Application

That's correct. > It's worth noting that if you use the NTK solution you are still obliged to > purchase the web server license. If you want to serve web clients from 4D, you are supposed to have a Web Server license for 4D, even if you are using NTK to do the serving. Kind Regards, Tim

RE: 4D Web Application

Hi Ferdinando, > I can use 4D Web Application Expansion even with a stand alone compiled 4d > application? If it is not merged (double-clickable) then you could use the "4D Web Application Server" license: http://www.4d.com/products/4dv15/4dwebappserver.html ^ This license allows a 4D (single

RE: v15.3 seems to be crashing on MACOS 10.12.1 & the new MBP

Hi Kirk, Indeed, the 16B2657 build of Sierra does not play well with 4D, while the older and newer builds of Sierra seem to be much better. Quote Douglas von Roeder: > I was just reading the release notes on 15.3 and > I think you're wise to roll back to 15.2. If

RE: Downloaded 4D app: structure file in read only mode

Quote Jim: >> 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

RE: Downloaded 4D app: structure file in read only mode

> actually - what I was pointing out is that Apple is doing all of this > security on applications which are (supposedly) 'safe', as in they have been > signed, presumably by Apple itself. > What are they doing to apps that are not signed? ^ My thoughts exactly... If the signed code (safer of

RE: Downloaded 4D app: structure file in read only mode

Hi Chip, > also notice this si specifically referencing "Signed Applications" Yes this is information came from Apple's changes to Gatekeeper, and is referenced in the documentation for code signing under the "Shipping your signed code" section. Although, if you think it doesn't/shouldn't

RE: Downloaded 4D app: structure file in read only mode

I should have also highlighted this quote from: "Starting with macOS Sierra, running a newly-downloaded app from a disk image, archive, or the Downloads directory will cause Gatekeeper to isolate that app at a unspecified read-only location in the filesystem. This will prevent the app from

RE: Downloaded 4D app: structure file in read only mode

Sorry Chip, I don’t know, I was paraphrasing the docs: https://developer.apple.com/library/content/technotes/tn2206/_index.html#//apple_ref/doc/uid/DTS40007919-CH1-TNTAG17 "This also applies to apps installed via ZIP or other archive formats or apps downloaded to the Downloads directory: ask the

RE: Downloaded 4D app: structure file in read only mode

Starting with 10.12.x Sierra, if you download an app.zip and unzip it then run it from the Downloads directory, Apple will quarantine the app into a Read-Only environment. Solution is to move it to the /Applications/ directory after unzipping it. Kind Regards, Tim PENNER

RE: Damaged database

> * Problem on the database : Last database flush did not complete. (1;139) This is usually only seen when the application crashed during a flush. Maybe your code that logged the successful quit had already executed when 4D crashed. You should check the Event Viewer to see if there are any

RE: Damaged database

Some comments/suggestions: > In one my customer that use one application developed in 4D V13.2 You are using a very old release of an unsupported product (v13 is no longer supported nor updated); I would suggest that you, at the very least, update to the final release of v13.6 so that you can

RE: Need help with LEP printing

Hi Kirk, If you are in Mac Terminal, and issue the same command, does it work from there? Make sure you are testing the same shell as you specified in the command, like this: 1) Open Mac Terminal.app 2) Navigate to the directory containing the pdf 3) Change the shell to /bin/sh by issuing

RE: Missing Getters - Form Get Input, Form Get Output

> Why - yes, yes it would. v15.3 perhaps? "Current Form Name" was introduced in v14 actually. http://livedoc.4d.com/4Dv14.5/help/Command/en/page1298.html -Tim ** 4D Internet Users Group (4D iNUG) FAQ:

RE: Internet Commands plugin not working with Server v15.5

There are two locations you can place the plugins: 1) In the Plugins folder next to the Database, for example: Structure @ /path/to/mydatabae.4dbase/mydatabase.4db Plugins @ /path/to/mydatabae.4dbase/Plugins/ 2) In the Plugin folder next to Application (inside the package on MacOS),

RE: Correctly identify object clicked in a form method

Kirk, > How or where are you invoking Object get pointer? He is invoking Object get pointer at the Form level, not the object level Which to me explains why the Current Object is Nil. It should be called in the context of the Object, not the context of the Form - would you agree? -Tim

RE: Correctly identify object clicked in a form method

Hi John, I would use: C_POINTER($self) $self:=OBJECT Get pointer(Object current) I just did a quick test in v15.2 using a Boolean field on a form that had focus then clicking on a button that is not focusable. I am not getting Nil, in fact I get a pointer to the object as expected. When

RE: OSX Window Sheets versus what to do on windows

> with a web-area based UI, > you could do all sorts of things... Possibly related... http://kb.4d.com/assetid=77177 -Tim ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive:

RE: How to override "Remember Me" on login?

> You hold down the Shiftkey duringing login. Another option could be removing the 4dlink file: http://kb.4d.com/assetid=76151 ^this routine could be implemented in code if you wanted to prevent the user from saving the password. -Tim

RE: Generate Digest - SHA2

";$true_t) $in:=$1 $cmd:=$cmd+" dgst -sha256" LAUNCH EXTERNAL PROCESS($cmd;$in;$result;$err) $0:=$result End if Then test it like this: alert(UTIL_hash_sha256_text("test")) -Tim Timothy Penner Technical Services Engineer 4D Inc 95 S. Market Street, Suite #240 CA

RE: Generate Digest - SHA2

C15B0F0A8 which matches the output found here: http://md5decrypt.net/en/Sha256/ Sha256(test) = 9f86d081884c7d659a2feaa0c55ad015a3bf4f1b2b0b822cd15d6c15b0f00a08 Hope that helps! Kind Regards, Tim PENNER Timothy Penner Technical Services Engineer 4D Inc 95 S. Market Street, Suite #240 CA 95113 San Jose United

RE: Generate Digest - SHA2

For a recent tech note I just published I needed to do SHA256 hashing so I used a Launch External Process call to OpenSSL like this: If (Count parameters=1) C_BLOB($0;$result) C_TEXT($1) C_TEXT($cmd;$in;$err) If (Folder separator=":") // MacOS has openssl installed at the system level

RE: Progressive slow

See here: http://kb.4d.com/assetid=76285 -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Timothy Penner Sent: Wednesday, November 02, 2016 12:18 PM To: 4D iNug Technical Subject: RE: Progressive slow > Since I think the question was about a v13 app

RE: Progressive slow

> Since I think the question was about a v13 app you can only flush data in > minute increments so try 1 minute Sorry that is wrong: the ability to set the flush interval in seconds began with v12. -Tim ** 4D Internet Users

RE: -50 Error

Hi Randy, If I remember correctly, the bug I referenced occurred both with Client-Server Encryption enabled as well as with it disabled, but the issue was much easier to reproduce with it enabled So if you are using Client-Server Encryption, maybe you can try disabling it to see if it

RE: -50 Error

Hi Randy, There was a recent bug fix in v15.x for an issue that occurred at login and would produce error -50: Fixed bugs v15.2 build 204924(Released on 2016-10-13) ACI0095490 : 4D Clients tries to connect to 4D

RE: Generate Digest MD5 - Max Input File Size?

The docs say that Generate Digest accepts either a BLOB or a TEXT variable: http://livedoc.4d.com/4Dv15-R5/help/Command/en/page1147.html The docs also say that both Blobs and Text variables are limited to 2 GB - here are the relevant excerpts: BLOB

RE: Any issues with %password font on MacOS and 13.6?

Hi Kirk, I wouldn’t say it is discouraged - it is still documented in example 3 of OBJECT SET FONT: http://livedoc.4d.com/4Dv15-R5/help/Command/en/page164.html#197877 Quote: "Note: You can use the %password option with field, variable and combo box type objects." I had to search my sent items

RE: HTML Tag Mismatch Finder!

Hi, Have you tried ATOM ? https://atom.io/ With the 4D Tags package from Miyako: https://atom.io/packages/language-4dtag 4D TAGS language support in Atom Based on language-html, with added support for 4D tags, dollar syntax, French/English controls, :C and :K notation. -Tim

RE: 4Dv11 & Microsoft Server 2016

Hi Paul, > according to the documentation v15 server requires > (Windows Server 2008R2 or above for 4D Server)​ Just to be clear, the certification for v15.2 does not say "or above" in fact it does not list "Server 2016" at all (because it did not exist and was not tested). As for certified

RE: Question regarding recommended compiler setting

Lutz, Maybe I am missing something, but for me, in v15.2 I get an error when using "Generate Typing" in this situation. The error clearly says "Changing the number of dimensions of an array" See here: https://i.imgur.com/Z7iejIA.png Kind Regards, Tim PENNER

RE: Windows 10: Plugin Error, unless Run as Administrator

Hi Randy, Which plugin and what is the full error stack (seen when clicking on the Details button of the error dialog - you can even click COPY to copy it to the clipboard from here). -Tim ** 4D Internet Users Group (4D iNUG)

RE: miyako/4d-plugin-audio

Hi Peter, > where is the demo database please I think the sample database is at the following location: 4d-plugin-audio/Audio/Audio.4dbase/ The plugin would then be here: 4d-plugin-audio/Audio/Audio.4dbase/Plugins/Audio.bundle Here is the download link:

RE: Connecting from Excel to 14.4 via ODBC - El Capitan & Office 2016

> Aren’t those drivers for 4D accessing other databases? Ie not for retrieving > data FROM 4D? > Or is it for both? The drivers I provided are for accessing data from 4D where 4D is acting as a ODBC Server, like in this text diagram: Generic ODBC Client Application <- communicates with -> 4D's

RE: v15 DLL Plugin Issue

Doug, Check if it is enabled from 4D's Explorer like shown here: http://kb.4d.com/assetid=76951 -Tim ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html

RE: Trapping for 'not a valid object'

Hi Lee, I think what you are looking for is this: http://kb.4d.com/assetid=77555 === Tech Tip: How to check if TEXT is an OBJECT / JSON PRODUCT: 4D | VERSION: 15.2 | PLATFORM: Mac & Win Published On: June 23, 2016 Here is a utility method that can be used to check if some

RE: How to find 2 digit years in legacy Database.

Also, if you want to build a timestamp in 4D here is the format: http://doc.4d.com/4Dv15R4/4D/15-R4/Principles-for-integrating-4D-and-the-4D-SQL-engine.300-2818873.en.html#1352502 Inserting === Begin SQL INSERT INTO Table_1 (Field_2) VALUES ({ ts '1998-05-02 01:23:56.123' }); End SQL

RE: spell check in v15

:4d_tech-boun...@lists.4d.com] On Behalf Of Charles Miller Sent: Friday, August 26, 2016 12:13 PM To: 4D iNug Technical Subject: Re: spell check in v15 On Fri, Aug 26, 2016 at 2:05 PM, Timothy Penner <tpen...@4d.com> wrote: > Take a look at the following commands that may help you: &

RE: How to find 2 digit years in legacy Database.

Hi Eric, I think the pivot year has been 2030 for quite some time, at least since 4D v6.7, see here: http://www.4d.com/docs/CMU/CMU00392.HTM "By default, 4D sets the century to be the 20th century and uses 30 as pivot year. " I had assumed dates were stored in 4 digits and that the default

RE: sql variables and 4D variables

It is my understanding that variables should only be used for the Data parts of a SQL expression, not for the Structural parts. I took a quick look at our examples for dynamically altering tables and it seems that the examples use concatenation along with EXECUTE IMMEDIATE like in this Tech

RE: Re(2): pdf creator on windows

Hi Tim, > I’ve not found a for sure way to set PDF Creator to never check for updates > for all users on Terminal Server. I’m sure there must be a settings file > stored somewhere for each user that has this setting, but I’ve not been able > to find it. I guess it also could be in the

RE: [Error message] RE: v13 - Can not add record & Maintenance issues

Hi Chip, Well, the message did say the index is invalid or missing, and it was in fact missing. I think it would be clearer if it told you which field though - too bad v13 is no longer being updated. FWIW: In v14+ the index is automatically created for you once you re-launch the database:

RE: How to remove a style sheet?

> This fix removes the requirement for me to remove a style sheet from a > listbox, but it is still curious that this can't be done except with code. For me, the stylesheet in the property list is removed (set to ) when I manually set a font in the Property List of a form object (i.e. list

RE: How to remove a style sheet?

Hi Bob, How about setting the style sheet to Automatic ? Quote: http://doc.4d.com/4Dv15R4/4D/15-R4/Overview.300-2880423.en.html " Finally, 4D provides a set of Automatic style sheets that you can use "as is" in order to create forms that comply with the rules of each interface platform. "

<    1   2   3   4   5