Get rid of users and groups (v15)

There are numerous past posts on this subject related to past versions of 4D, and none provide a way to delete all users and groups if some of those were created by the Designer. Is there a way in v15? --- This email has been checked for viruses by Avast antivirus software.

Interpreted vs. Compiled - current comparison

I have been working on a half dozen small 4D databases in the past several years, and have gotten away with running them interpreted in production with no complaints from users. I am wondering, though, how much of an improvement in performance will we see if we compile. Have improvements in

Problem saving blob to a record

In a Windows 7 v15 database I need to save an existing Excel workbook as a blob in a 4D record. I created a blob field and selected the "In record" option for storage. I ran this code: $TemplateFilePath_t:=Select document("";"";"Select a document:";0) If (OK=1) SET BLOB

RE: Problem saving blob to a record

Record is definitely unlocked and table is read/write. -- Message: 3 Date: Sun, 20 Nov 2016 18:32:19 + From: "Dennis, Neil" To: "4d_tech@lists.4d.com" <4d_tech@lists.4d.com> Subject: RE: Problem saving blob to a record Message-ID:

Spacebar doesn't advance cursor

In a 4D v15 client/server db on Windows 7, more than one user has reported that when typing in any alpha or text field they press the spacebar one or more times, the cursor does not advance. Only when they type any other character (following the spacebars) does the cursor jump ahead. Anyone

Problem launching a bat file via LAUNCH EXTERNAL PROCESS

RECTORY";"mybatfilefolder") SET ENVIRONMENT VARIABLE("_4D_OPTION_HIDE_CONSOLE";SW_SHOW) LAUNCH EXTERNAL PROCESS("c:\\Windows\\System32\\cmd.exe /C mybatfile.bat" The cmd.exe application file is set to always run as administrator. Any idea why this

Re: Creating a Word document from 4D

I erroneously looked at the 4DWrite documentation when I intended to read the 4DWrite Pro docs. So my post below should have asked whether one can generate a Word doc from 4DWrite Pro. -Original Message- From: David Rose Sent: Thursday, March 30, 2017 9:25 AM To: 4d_tech@lists.4d.com

PDFCreator and Windows 7

I installed PDFCreator v1.7.3 on my Win 7 box. I am running 4D v15 client/server. In 4D I want to programmatically set the destination folder and file name for pdf files. The code below works perfectly most of the time, but intermittently the PDFCreator file-saving dialog appears. My code

4D won't launch - Windows 10

I have been using 4D v12, 15, 16 on my Windows 10 computer for years, no problems until today. When I try to launch any of these programs (4D Developer Standard), the 4D window opens with the Help menu visible, the spinning cursor appears, but the programs just hang. I have made no changes to

Re: 4D won't launch - Windows 10

Yup. -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options:

RE: 4D won't launch - Windows 10 - SOLVED

Oddly, the problem was due to a networking issue on another computer on the LAN. 4D on my computer could detect that the other computer existed, but couldn't access any 4D resources on it. -Original Message- From: David Rose [mailto:drose...@gmail.com] Sent: Saturday, June 09, 2018 10

Re: Unicode characters and SQL queries

ARAMETER.301-3651635.en.html there is also a database setting http://doc.4d.com/4Dv16/4D/16.3/SQL-page.300-3670701.en.html > On Feb 20, 2018, at 03:20, David Rose via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Any way to modify the SQL query so that it works like the 4D query without

Unicode characters and SQL queries

This 4D Query will return records with Last_Name containing both "u" and "ü": QUERY([Donors];[Donors]Last_Name="@u@") This SQL query will only return records with Last_Name containing "u" Begin SQL SELECT Last_Name FROM Donors WHERE Last_Name LIKE 'u' INTO :DonorLName_at

4DIC - Hiding the authentication username in outgoing emails

I posted a question on this topic a while back but didn't find a solution, so I am posting again... In a 4D v15 application for Windows I want to use just one gmail account for authenticating all outgoing emails, but allow a variety of senders to send emails that are seen in the recipients'

4D Write v15 plugin problem

In a v15.6 client/server application for Windows, I have a license for 4D Write attached to the 4D Server license. I just moved all of the 4D server components to a new machine, including the licenses. They are definitely in the right Licenses folder. When I launch 4D Server and go to Update

SMTP_Sender, SPTP_From, SMTP_ReplyTo

In a 4D v15 app I am sending emails that have an email address for authentication that is different than the SMTP_Sender, SMTP_From, and SMTP_ReplyTo values. I am finding that if I have the following values, the recipient sees the authentication username in his/her email client, and I don't

SMTP_Sender, SPTP_From, SMTP_ReplyTo

In a 4D v15 app I am sending emails that have an email address for authentication that is different than the SMTP_Sender, SMTP_From, and SMTP_ReplyTo values. I am finding that with the following values, the recipient sees the authentication username in his/her email client, and I don't want

4D/Drupal Commerce Integration - Consultant Sought

. If you are interested in this job, please reply directly to me via email: David Rose drose...@gmail.com ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options

Using a mirror for web serving

Is anyone using New log file and INTEGRATE MIRROR LOG FILE to create a mirror db on a remote cloud server, like Amazon EC2, for the purpose of providing near-real-time read-only offsite web server functionality? If so, any advice for implementation? (I use WS_FTP for another process in the same

Error connecting to 4D Server

I have been developing a 4D v15 client/server application on a Windows 10 computer for years without a problem. I have always been able to connect from 4D to the server, with both server and client running on the same computer. Until today. Now, when I try to connect from 4D to the server, I am

RE: Error connecting to 4D Server - SOLVED

. Message: 1 Date: Wed, 3 Apr 2019 11:41:12 -0500 From: "Stephen J. Orth" To: "'4D iNug Technical'" <4d_tech@lists.4d.com> Cc: "'David Rose'" Subject: RE: Error connecting to 4D Server Message-ID: <00b801d4ea3c$0cdec390$269c4ab0$@the-aquila-group.com> Cont

RE: Error connecting to 4D Server

11:49 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: David Rose Subject: Re: Error connecting to 4D Server have you changed the default ports that 4D uses? if so, you need to specify the new/changed port number in the connection dialog and you need to change both ports (as I understa

RE: Error connecting to 4D Server

One thing has changed: I installed v17 on this computer several days ago, and did run a database in 4D Server several times. The error that I am getting occurs in both v15 and v17. -Original Message- From: David Rose [mailto:drose...@gmail.com] Sent: Wednesday, April 03, 2019 11:57 AM

Creating Word docs in 4D

As of August 2018, Write Pro could not export to a Word doc. Has that changed? I have a 4D v15 application that uses 4D Write pre-defined templates that contain home-grown embedded variables, and the code uses the WR Replace command to substitute data for these variables. Then the Write docs

RE: Creating Word docs in 4D

Word docs are compared with the PDF files. David -Original Message- From: David Rose [mailto:drose...@gmail.com] Sent: Thursday, April 04, 2019 10:09 AM To: '4d_tech@lists.4d.com' <4d_tech@lists.4d.com> Subject: Creating Word docs in 4D As of August 2018, Write Pro could not

Urgent! Port conflict - 4D Server

On a Windows 7 box running 4D Server v15, I rebooted the computer today and found, when I restarted 4D Server and tried to open the database (or a brand new database), I get this error: "Failed to launch DB4D Server. Please make sure that the port assigned to the DB4D Server is not used by another

RE: Urgent! Port conflict - 4D Server

quot; > To: "'4D iNug Technical'" <4d_tech@lists.4d.com> > Cc: "'David Rose'" > Subject: RE: Urgent! Port conflict - 4D Server > Message-ID: <00b001d4bf18$6529b720$2f7d2560$@the-aquila-group.com> > Content-Type: text/plain; charset="u

v17 Print Settings in a form's Property List

I'm running v17.1 in a Windows 10 client/server environment. In the Design environment, when I click on the Print Settings button in a form's Property List, I get a Print dialog, not the usual Print Settings (Page Setup) dialog. Is that a bug or a feature?

Re: v17 Print Settings in a form's Property List

https://doc.4d.com/4Dv17/4D/17.1/Printing-a-form.300-4201214.en.html "A Print Setup dialog box appears, which lets you modify the specific print settings of the form: paper format, orientation, etc. The options available in this standard dialog box depend on your system configuration. &qu

Syntax Checking with Component

the component methods. It's just a nuisance to see these syntax errors in the Compiler screen. David Rose ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman

Windows XPS Document Writer Preview problem

In a 4D v15 database running on Windows 10 computers, clicking the Preview box in the print settings screen invokes the Windows XPS Document Writer, and works fine on all existing computers. I just installed 4D and the database on a brand new Win 10 computer, and clicking the Preview box on

Deprecated constants

Is there a list of all deprecated constants, and how to replace them, in the knowledgebase or 4D Docs? I'm referring to all constants that show up as "_o_ ..." in v17. I don't think this page is complete:

Gmail, LSA, and OAuth

ry 15, 2021, you will begin receiving an error message that your username-password combination is incorrect." "If you are using [a third-party] email client, re-add your Google Account and configure it to use IMAP with OAuth." How is this done in 4D in conjunction with the 4D SMTP c

Miyako's xpsviewer

I downloaded Miyako's xpsviewer files from github and opened the example db in 4D v17 on a Windows 10 box. When I run the 3rd party preview method it executes without errors, and the print preview screen appears, but there is nothing displayed in the preview screen. Advice?

Parallels RAS on Amazon AWS

at the Parallels RAS website about this: https://www.parallels.com/blogs/ras/parallels-ras-on-aws/#:~:text=Parallels%20RAS%20automation%20capabilities%E2%80%94combined,in%20less%20than%20an%20hour. Thanks, David Rose ** 4D

RE: Hide Application Process

Thanks, David. The checkbox for showing the splash screen has always been unchecked. From: David Ringsmuth [mailto:davidi...@gmail.com] Sent: Friday, November 06, 2020 9:08 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: David Rose Subject: RE: Hide Application Process

Hide Application Process

In a 4D v16 single-user interpreted application for Windows 10, this code in the Startup method to hide the Application window has been executing successfully with no problem: SET WINDOW RECT(-10;-10;-10;-10) //Win32API: $WindowHandle_l:=gui_GetWindowFrom4DWinEx (Frontmost window)

Managing 4D Write Pro licenses

, the first user to log in grabs the license. Is there any way to prevent this? David Rose ** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com

Re: Managing 4D Write Pro licenses

either move the user into a group > that has access to 4D WP with the Change current user command or move them > into the "4DWP" group using Set user properties. > Douglas von Roeder > 949-910-4084 > On Wed, Jan 13, 2021 at 8:30 AM David Rose via 4D_Tech <4d_tech@lists.4

Windows Server 2019 problem

n my case - doing so breaks one of the plugins. Ideas, anyone? David Rose ** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/o

Webserver IP Address on an Amazon EC2 instance

I'm setting up a 4D web app on an Amazon EC2 instance. At Amazon I created an elastic public IP address and assigned it to the instance. In the security group for the instance I opened a port for both http and https access from anywhere, just for testing. I created a test.htm file and placed

PayPal Server-side SDK & 4D

If any of you have implemented the PayPal server-side SDK (current version) in a 4D application, in which 4D is the webserver, and would like to consult on a project for a fee, please contact me directly. Thanks, David Rose drose...@gmail.com

Re: Calculated column in ALP v9 [SOLVED]

That's it! Thanks, Doug. --- I use the ALP 9.9.5 docs in PDF format. Look at the command "AL_AddCalculatedColumn" and then click the link on that page to get to "Calculated columns" Douglas von Roeder

Problem moving SSL cert to a new Amazon server

I just moved a 4D v15 web app for Windows from one Amazon EC2 instance to a new one (Windows Server 2016). I disassociated the elastic public IP address from the old server and re-assigned it to the new one. I moved all of the 4D files, including the cert and key files to the new server, making

Calculated column in ALP v9

I am converting some older ALP code in a v17 database to the modern code. In the old code, if you have an area that is displaying fields, and you have a calculated column you would do this: $Error:=AL_SetFields ($Area_l;$TableNumber_i;4;1;0) //specifies the col as a calculated one Then this: