Re: Calculated column in ALP v9 [SOLVED]

[David Rose via 4D_Tech]

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


**
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/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Calculated column in ALP v9

[David Rose via 4D_Tech]

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:
AL_SetCalcCall ($Area_l;4;"MyCalcCallMethod")

In the new code we set the fields like this:

ARRAY POINTER(aPtr;4)
aPtr{1}:=->[Vendors]ID
aPtr{2}:=->[Vendors]Last_Name
aPtr{3}:=->[Vendors]First_Name
aPtr{4}:=?? (see below)

$err:=AL_SetObjects ($Area_l;ALP_Object_Columns;aPtr)

And the callback method like this:
AL_SetColumnTextProperty ($Area_l;4;ALP_Column_Callback;"MyCalcCallMethod ")

I didn't see in the docs what you assign to the aPtr array element for the 
calculated column. If I size the aPtr array to 3, then set a callback method 
for column 4, I get an error.
Ditto if I size the array to 4 but don't assign anything to the 4th element.

Pls advise.
TIA,
David

**
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/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Problem moving SSL cert to a new Amazon server

[David Rose via 4D_Tech]

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 no  changes. I made 
sure 4D was added as an allowable app in the Windows Firewall settings. I made 
sure that the security settings in the Amazon AWS dashboard are the ones that 
were associated with the previous server. 

Now, when a user tries to connect to the website the home page is displayed, 
but a certificate error is generated. This occurs in multiple browsers. 
Clearing the cache and cookies doesn't fix the problem.
Any idea what the cause might be?

David

**
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/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Webserver IP Address on an Amazon EC2 instance

[David Rose via 4D_Tech]

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 it at the root of the webfolder and 
designated it as the default page in 4D's database settings window. But the 
only IP address available in the dropdown menu is the local IP address that was 
assigned to the instance, not the public IP address. If I set the IP address to 
"Any", and in a browser enter the public IP address no response is received 
from the webserver. I tested to make sure the webserver is running by launching 
a browser on the webserver and entering the local IP address - it serves the 
default page.

On other Amazon EC2 instances I have set up with elastic public IP addresses, 
the public address is available in the IP address dropdown in 4D, but not on 
this instance. I must be neglecting to do some set-up step.

Any suggestions?
Thanks,
David

**
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/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

PayPal Server-side SDK & 4D

[David Rose via 4D_Tech]

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

**
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/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Windows Server 2019 problem

[David Rose via 4D_Tech]

I am running 4D client/server v17R5 build 240287 on a Windows Server 2019, 
interpreted. Users connect via RDC. 4D is installed just once, and each user 
launches an instance of it.

Today, for the first time, one particular user cannot launch 4D. They get a 
series of -10510 error messages, the first of which is:
Error code: 650 (xbox)
Folder "{name}" not found ({path})
Xtoolbox
Task 19540
Cannot open structure of database
Error code: -10510 (4DRT)
Can't load component "development.4DC"
Etc...

If I connect remotely to that user's desktop on the server and launch 4D as 
Administrator, I am able to launch it with no errors. No other users have this 
problem.

There was a similar post last year about this, but it pertained to all users. 
The developer discovered that by running 4D v17R5 in compatibility mode the 
problem was solved. That is not a viable solution in 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/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Managing 4D Write Pro licenses

[David Rose via 4D_Tech]

Douglas,
Whether or not we restrict access to 4D Write via the method you suggested, the 
first user who logs on after a reboot grabs the 4D Write license whether that 
user actually uses 4D Write or not.
David

> Message: 12
> Date: Wed, 13 Jan 2021 10:37:32 -0800
> From: Douglas von Roeder 
>
> David:
>
> While it's true that 4D WP is not a plugin, access to 4D WP is controlled in 
> the same manner as the plugin — either on an individual user basis or by 
> creating a group and granting access to that group.
>
> With that in mind, you might be able to 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.4d.com>
> wrote:

> We have a 4D Server v17R6 database running in a Windows-only environment.
> We have a single 4D Write Pro license. Only one out of our dozen or so 
> users uses 4D Write Pro. Now that 4D Write is no longer a plug-in, we 
> have a problem managing access to that license. When 4D Server is 
> launched, 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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Managing 4D Write Pro licenses

[David Rose via 4D_Tech]

We have a 4D Server v17R6 database running in a Windows-only environment. We 
have a single 4D Write Pro license. Only one out of our dozen or so users uses 
4D Write Pro. Now that 4D Write is no longer a plug-in, we have a problem 
managing access to that license. When 4D Server is launched, 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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Hide Application Process

[David Rose via 4D_Tech]

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

 

David,

 

In the Database Settings you can choose to hide the splash screen, so the Set 
Window Rect may not be needed.

 

David Ringsmuth

 

From: David Rose via 4D_Tech <mailto:4d_tech@lists.4d.com> 
Sent: Friday, November 6, 2020 8:51 AM
To: 4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com> 
Cc: David Rose <mailto:drose...@gmail.com> 
Subject: 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)

$Error_l:=gui_ShowWindowEx ($WindowHandle_l;SW_HIDE)

 

I just installed the application on a new Windows 10 computer, and now the 
Application window shows up.

 

How to fix?

David

 

 

**

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/options/4d_tech

Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com

**

 

**
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/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Hide Application Process

[David Rose via 4D_Tech]

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)
$Error_l:=gui_ShowWindowEx ($WindowHandle_l;SW_HIDE)

I just installed the application on a new Windows 10 computer, and now the 
Application window shows up.

How to fix?
David


**
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/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Parallels RAS on Amazon AWS

[David Rose via 4D_Tech]

My organization is considering migrating our 4D v17.5 client/server 
application, currently running in an all-Windows 10 environment, to an Amazon 
EC2 instance, with Parallels RAS providing virtual machines for 4D client 
access. Are any of you doing this or something similar?

Here is an article 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 Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Miyako's xpsviewer

[David Rose via 4D_Tech]

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?

**
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/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Gmail, LSA, and OAuth

[David Rose via 4D_Tech]

Google has announced that Less Secure Apps (LSA) will be turned off by Google 
in two stages:
1. June 15, 2020 - Users who try to connect from an LSA for the first time will 
no longer be able to do so. This includes third-party apps that allow 
password-only access to Google calendars, contacts, and email via protocols 
such as CalDAV, CardDAV and IMAP. Users who have connected to LSAs prior to 
this date will be able to continue using them until usage of all LSAs is turned 
off.
2. February 15, 2021 - Access to LSAs will be turned off for all G Suite 
accounts.

"If you are using an app that accesses your Google account with only a username 
and password, take one of the following actions to switch to a more secure 
method and continue to access your email, calendar, or contacts. If you do not 
take one of the following actions, when LSA access is discontinued after 
February 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 commands?

David Rose


**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Deprecated constants

[David Rose via 4D_Tech]

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:
https://doc.4d.com/4Dv17R6/4D/17-R6/Deprecated-or-removed-features-in-v17-product-range.200-4438814.en.html

For example, _o_Index compacting is not mentioned.

Thanks,
David

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Windows XPS Document Writer Preview problem

[David Rose via 4D_Tech]

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 this computer does not 
produce the preview screen - nothing happens.

The Windows XPS Document Writer is installed on this computer (I know it was 
phased out by Microsoft in the 1803 version, but it is in the printer list). 
The printer port for this driver is set to the default PORTPROMPT, and all 
controls on the Port tab of the Printer Preferences screen are disabled.

I tried selecting the Windows XPS Document Writer in the print settings screen 
- same result.

Any ideas besides Miyako's xpsview solution?

David

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Syntax Checking with Component

[David Rose via 4D_Tech]

I have a v17 interpreted database that includes an interpreted component 
(Miyako's Excel Component). The component has a number of methods that have $0 
parameters. The component has a Compiler method in which all of the parameters 
are typed. The local variables in the host database to which the return values 
are assigned are all correctly typed.

When I check syntax in the Compiler window of the host database, it produces 
the following errors in the host methods that call the component methods that 
return a value:
The component 'Excel Library' must be compiled
Invalid constant type: real
Cannot make an assignment with those types
Changing the type of the variable $MyVar from type real to type text

(This problem also existed when the database was running in v12 and v15.)

Any way to fix this? It doesn't interfere with the operation of the program - 
no errors occur when calling 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/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[David Rose via 4D_Tech]

So in a 64-bit environment, how do you save paper size, orientation etc. with a 
form, so that PAGE SETUP ([MyTable];"MyForm") will load those settings?

Message: 1
Date: Wed, 10 Apr 2019 05:11:01 +
From: Keisuke Miyako 
To: 4D iNug Technical <4d_tech@lists.4d.com>
Subject: Re: v17 Print Settings in a form's Property List
Message-ID: 
Content-Type: text/plain; charset="utf-8"

I think this is the new (64-bit) behaviour for dialType:0

https://doc.4d.com/4Dv17/4D/17.1/PRINT-SETTINGS.301-4179613.en.html

that said, the Design Reference is a bit vague on this point

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. "

2019/04/10 11:31、David Rose via 4D_Tech 
<4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール:

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?



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

v17 Print Settings in a form's Property List

[David Rose via 4D_Tech]

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?

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Creating Word docs in 4D

[David Rose via 4D_Tech]

I found another solution, pending some testing. (This is in a Windows 
environment, btw.)
Print the Write Pro document to a PDF file (in my case, using Microsoft Print 
to PDF), then use a command-line utility that converts PDFs to Word, like Total 
PDF Converter from coolutils.com. This app costs $39, but there are probably 
some free apps out there as well that do the same thing. Command-line utility 
programs can be launched from 4D by creating a .bat file and launching it via 
LAUNCH EXTERNAL PROCESS.
Will experiment and report back. Will be interesting to see how accurate the 
resulting 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 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 are exported as Word docs. Works perfectly.

But in v17, I have to come up with a way to replicate this functionality.
Is anyone using the following methodology to do this?:
Outside of 4D:
1. Create a template in MS Word, with home-grown embedded variables, and save 
it as a .docx file. (Which is actually a zipped collection of xml and other 
files.) 2. Change the file extension to .zip .
3. Unzip the file, which creates a number of folders and files.

In 4D:
1. open the resulting document.xml file.
2. Replace the embedded variables with data.
3. Resave the file.
4. Zip the file, using Miyako's zip plugin for 4D.
5. Change the extension to .docx .

Anyone doing this or something like it?

David



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Creating Word docs in 4D

[David Rose via 4D_Tech]

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 are exported as Word docs. Works perfectly.

But in v17, I have to come up with a way to replicate this functionality.
Is anyone using the following methodology to do this?:
Outside of 4D:
1. Create a template in MS Word, with home-grown embedded variables, and save 
it as a .docx file. (Which is actually a zipped collection of xml and other 
files.)
2. Change the file extension to .zip .
3. Unzip the file, which creates a number of folders and files.

In 4D:
1. open the resulting document.xml file.
2. Replace the embedded variables with data.
3. Resave the file.
4. Zip the file, using Miyako's zip plugin for 4D.
5. Change the extension to .docx .

Anyone doing this or something like it?

David



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Error connecting to 4D Server - SOLVED

[David Rose via 4D_Tech]

It was something simple - a recent Windows update on this computer (grrr) 
changed the Ethernet IP address assignment method from static to dynamic, then, 
when the computer restarted, a new local IP address was assigned. So in the 4D 
connection window the database had the old IP address. 

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>
Content-Type: text/plain;   charset="utf-8"

David,

I don't have an solution for you but I would love to know how to stop these 
issues as they are regular problems facing our OEM Clients.

We have talked to our Clients about port time outs, external scanning software, 
etc.  We have made adjustments on our side where we can...but we just cannot 
seem to stop these issues.  What is worse, we really don't have any more 
suggestions for our Clients as this is only linked to 4D. 


Steve

-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of David Rose via 4D_Tech
Sent: Wednesday, April 3, 2019 11:34 AM
To: 4d_tech@lists.4d.com
Cc: David Rose 
Subject: 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 getting 
this error message:

**
Error code: -10002 (4DRT)
The connection for this process has been disrupted or the connection couldn't 
be established.
component: '4DRT'
task -1, name: 'Application process'

Error code: 10035 (WI32)
A non-blocking socket operation could not be completed immediately.

component: 'WI32'
task -1, name: 'Application process'
**

I deleted all of the files in the 4D folder, checked my virus protection 
software for possible blocks, restarted the router and the computer. Ran the 
network troubleshooter. Still have the problem. I created a brand new database, 
launched it in 4D Server, get the same error trying to connect to it. When I do 
these tests I only have one 4D database running on this computer.

David



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Error connecting to 4D Server

[David Rose via 4D_Tech]

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
To: '4d_tech@lists.4d.com' <4d_tech@lists.4d.com>
Subject: RE: Error connecting to 4D Server

Ports haven't changed. When I got this error, one of the things I tried was
changing the ports, and including the new port number in the connection
dialog, as you mentioned. No luck.

-Original Message-
From: Chip Scheide [mailto:4d_o...@pghrepository.org] 
Sent: Wednesday, April 03, 2019 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 understand) 4D, &  Sql
(usually -1 from 4D port) 

ex:
123.123.123.123:123456

On Wed, 3 Apr 2019 11:34:10 -0500, David Rose via 4D_Tech wrote:
> 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 getting this error message:
> 
> **
> Error code: -10002 (4DRT)
> The connection for this process has been disrupted or the connection 
> couldn't be established.
> component: '4DRT'
> task -1, name: 'Application process'
> 
> Error code: 10035 (WI32)
> A non-blocking socket operation could not be completed immediately.
> 
> component: 'WI32'
> task -1, name: 'Application process'
> **
> 
> I deleted all of the files in the 4D folder, checked my virus 
> protection software for possible blocks, restarted the router and the 
> computer. Ran the network troubleshooter. Still have the problem. I 
> created a brand new database, launched it in 4D Server, get the same 
> error trying to connect to it. When I do these tests I only have one 
> 4D database running on this computer.
> 
> David
> 
 

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Error connecting to 4D Server

[David Rose via 4D_Tech]

Ports haven't changed. When I got this error, one of the things I tried was
changing the ports, and including the new port number in the connection
dialog, as you mentioned. No luck.

-Original Message-
From: Chip Scheide [mailto:4d_o...@pghrepository.org] 
Sent: Wednesday, April 03, 2019 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 understand) 4D, &  Sql
(usually -1 from 4D port) 

ex:
123.123.123.123:123456

On Wed, 3 Apr 2019 11:34:10 -0500, David Rose via 4D_Tech wrote:
> 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 getting this error message:
> 
> **
> Error code: -10002 (4DRT)
> The connection for this process has been disrupted or the connection 
> couldn't be established.
> component: '4DRT'
> task -1, name: 'Application process'
> 
> Error code: 10035 (WI32)
> A non-blocking socket operation could not be completed immediately.
> 
> component: 'WI32'
> task -1, name: 'Application process'
> **
> 
> I deleted all of the files in the 4D folder, checked my virus 
> protection software for possible blocks, restarted the router and the 
> computer. Ran the network troubleshooter. Still have the problem. I 
> created a brand new database, launched it in 4D Server, get the same 
> error trying to connect to it. When I do these tests I only have one 
> 4D database running on this computer.
> 
> David
> 
 

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Error connecting to 4D Server

[David Rose via 4D_Tech]

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 getting 
this error message:

**
Error code: -10002 (4DRT)
The connection for this process has been disrupted or the connection couldn't 
be established.
component: '4DRT'
task -1, name: 'Application process'

Error code: 10035 (WI32)
A non-blocking socket operation could not be completed immediately.

component: 'WI32'
task -1, name: 'Application process'
**

I deleted all of the files in the 4D folder, checked my virus protection 
software for possible blocks, restarted the router and the computer. Ran the 
network troubleshooter. Still have the problem. I created a brand new database, 
launched it in 4D Server, get the same error trying to connect to it. When I do 
these tests I only have one 4D database running on this computer.

David

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Urgent! Port conflict - 4D Server

[David Rose via 4D_Tech]

Neil and Steve - you both were correct - there was a 4D Server service
running that had been created since the last reboot many months ago.
Thanks to you both for the fast and accurate response!!

>
> Message: 12
> Date: Thu, 7 Feb 2019 13:07:39 -0600
> From: "Stephen J. Orth" 
> 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="utf-8"
>
> David,
>
> Is the system running as a service and you don't know it?
>
> Steve
>
 
>
> Subject: 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 application." When I click Continue I get 
> "Failed to create a listening socket."
>
> I tried opening the database in 4D, but got a message asking if I wanted to 
> open it in read only mode. If I say yes, I am not able to get into the design 
> environment in order to get into Database Settings in order to try changing 
> the port numbers for the application server, web server, SQL server.
>
> I tried repairing both the structure and data files, trashing the 4D  and 4D 
> Server Preferences files, and reinstalling 4D Server. No luck. I also user 
> the Unlocker utility to check to see if the data files are falsely locked. 
> They're not.
>
> If you know of a solution to this problem, please email me directly:
> drose...@gmail.com.
>
> TIA,
> David
>
***
>
> From: "Dennis, Neil" 
>
> Ensure that no other version of 4D are running on the machine... as a service 
> or as another user.
>
> Neil
>
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Urgent! Port conflict - 4D Server

[David Rose via 4D_Tech]

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 application." When I click Continue
I get "Failed to create a listening socket."

I tried opening the database in 4D, but got a message asking if I wanted to
open it in read only mode. If I say yes, I am not able to get into the
design environment in order to get into Database Settings in order to try
changing the port numbers for the application server, web server, SQL
server.

I tried repairing both the structure and data files, trashing the 4D  and
4D Server Preferences files, and reinstalling 4D Server. No luck. I also
user the Unlocker utility to check to see if the data files are falsely
locked. They're not.

If you know of a solution to this problem, please email me directly:
drose...@gmail.com.

TIA,
David


Virus-free.
www.avg.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Using a mirror for web serving

[David Rose via 4D_Tech]

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 database to copy files from the db computer to a remote ftp site every n 
minutes, and I'm guessing I can do likewise with log files.)

David

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

4D/Drupal Commerce Integration - Consultant Sought

[David Rose via 4D_Tech]

I work for an organization that is considering the integration of two systems, 
one built with 4D, one with Drupal Commerce/MySQL.
We would like to engage the services of an experienced 4D developer who also 
has experience with Drupal in general and Drupal Commerce in particular.
The consultant's task will be to analyze all of the functionality in the two 
systems, and determine:
1. Whether it will be most prudent to keep the 4D system and port all of the 
existing Drupal functionality to it, or vice versa, or leave things as is.
2. If we don't leave things as is, what the estimated time required will be to 
accomplish the integration. (Two estimates will be required: one for a Drupal 
to 4D integration, one for a 4D to Drupal integration.) 

We have budgeted for approximately 50-100 hours of work to analyze our systems 
and produce a report with recommendations and cost estimates.

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/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

4DIC - Hiding the authentication username in outgoing emails

[David Rose via 4D_Tech]

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' email clients as coming from the 
senders' individual accounts, not from the authentication account. I haven't 
found a way to do that. The following combination of values results in the 
SMTP_Auth username showing up as the sender in the recipient's email client:

SMTP_Auth username: auth-em...@gmail.com
SMTP_From: from-em...@gmail.com
SMTP_Sender: from-em...@gmail.com
SMTP_ReplyTo: from-em...@gmail.com

Is there a way to do this?
David

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

4D Write v15 plugin problem

[David Rose via 4D_Tech]

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 License, it does show the 4D Write 
license. But when I launch 4D and connect to the server and log on as Designer, 
the 4D Write plugin does not appear in the method editor, nor in the User 
Groups window. 


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[David Rose via 4D_Tech]

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:51 AM
To: '4d_tech@lists.4d.com' <4d_tech@lists.4d.com>
Subject: 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 my computer in 
the last 48 hours, and I don't believe that Windows has done a system update. 
All other programs on this computer launch with no problems. Here's what I have 
tried, with no success:
* I trashed the AppData/4D folder
* I uninstalled my virus protection software
* I turned off Windows Firewall
* I moved the Licenses folder to the desktop (just to see if I could launch any 
of the programs in Demo mode.)
* I checked the Windows DEP setting and confirmed that it is set to apply only 
to Windows essential programs and services.
* I rebooted the computer
* I downloaded and installed a fresh version of one of the 4D programs - it 
won't launch.

I have lots of RAM and hard drive space.

Any other ideas anyone?
David
 


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D won't launch - Windows 10

[David Rose via 4D_Tech]

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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

4D won't launch - Windows 10

[David Rose via 4D_Tech]

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 my computer in 
the last 48 hours, and I don't believe that Windows has done a system update. 
All other programs on this computer launch with no problems. Here's what I have 
tried, with no success:
* I trashed the AppData/4D folder
* I uninstalled my virus protection software
* I turned off Windows Firewall
* I moved the Licenses folder to the desktop (just to see if I could launch any 
of the programs in Demo mode.)
* I checked the Windows DEP setting and confirmed that it is set to apply only 
to Windows essential programs and services.
* I rebooted the computer
* I downloaded and installed a fresh version of one of the 4D programs - it 
won't launch.

I have lots of RAM and hard drive space.

Any other ideas anyone?
David
 

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

SMTP_Sender, SPTP_From, SMTP_ReplyTo

[David Rose via 4D_Tech]

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 that:
SMTP_Auth: myauthem...@gmail.com
SMTP_Sender: sen...@gmail.com
SMTP_From: My Sender Office Name
SMTP_ReplyTo: same as SMTP_Sender

For example, in Outlook, the recipient sees "My Sender Office Name" in the From 
column of the list screen (that's fine), but "My Sender Office Name 
" at the top of the detail screen. SMTP_ReplyTo works 
fine - if a user clicks Reply, the ReplyTo email address is used.

What do I need to hide the authentication username from the recipient?
David

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

SMTP_Sender, SPTP_From, SMTP_ReplyTo

[David Rose via 4D_Tech]

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 
want that:
SMTP_Auth: myauthem...@gmail.com
SMTP_Sender: sen...@gmail.com
SMTP_From: My Sender Office Name
SMTO_ReplyTo: same as SMTP_Sender

For example, in Outlook, the recipient sees "My Sender Office Name" in the From 
column of the list screen (that's fine), but "My Sender Office Name 
" at the top of the detail screen. SMTO_ReplyTo works 
fine - if a user clicks Reply, the ReplyTo email address is used.

What do I need to change?
David

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Unicode characters and SQL queries

[David Rose via 4D_Tech]

Miyako,
This worked, thanks!:
SET DATABASE PARAMETER(SQL engine case sensitivity;0)

--

Message: 1
Date: Mon, 19 Feb 2018 20:58:10 +
From: Keisuke Miyako <keisuke.miy...@4d.com>
To: 4D iNug Technical <4d_tech@lists.4d.com>
Subject: Re: Unicode characters and SQL queries
Message-ID: <7d611e38-785f-4110-be05-917f41f2a...@4d.com>
Content-Type: text/plain; charset="utf-8"

have you tried

SET DATABASE PARAMETER(SQL engine case sensitivity;0)

http://doc.4d.com/4Dv16/4D/16.3/SET-DATABASE-PARAMETER.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 
> specifying each and every specific Unicode character that I want to search 
> for?


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Unicode characters and SQL queries

[David Rose via 4D_Tech]

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
End SQL

Any way to modify the SQL query so that it works like the 4D query without 
specifying each and every specific Unicode character that I want to search for?

David

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

PDFCreator and Windows 7

[David Rose via 4D_Tech]

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 looks like
this:

$PDFFilePath_t:="(Full Path Here)"
PAGE SETUP([MyTable];"MyList")
SET CURRENT PRINTER(PDFCreator Printer name)
FORM SET OUTPUT([MyTable];"MyList")
SET PRINT OPTION("PDFOptions:UseAutosave";1)
SET PRINT OPTION("PDFOptions:UseAutosaveDirectory";1)
SET PRINT OPTION(Destination option;3;$PDFFilePath_t)
PRINT SELECTION([MyTable];*)
SET PRINT OPTION("PDFInfo:Reset standard options";0)

Any ideas how to fix this?
David 


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Creating a Word document from 4D

[David Rose via 4D_Tech]

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
Subject: Creating a Word document from 4D

In a Windows-only 4D v15 db I need to generate Word documents. I haven't
used 4DWrite in a while, but see in the documentation for WR SAVE DOCUMENT
one can save a 4DWrite document as an rtf file. there is also this note:

"Compatibility note: To retain compatibility with previous versions, the
DOC8 (Word 8 Document) type is also supported."

Is anyone saving 4DWrite docs as Word docs, and if so, are there any issues?
Is the formatting in 4DWrite docs faithfully reproduced in the resulting
Word docs? Does the above compatibility note suggest that support for Word
may not be found in future 4DWrite versions?

Are there other ways to generate a Word doc from 4D? The documents I need to
generate will be parallel to a 4D "Detail form for printing" containing
multiple records on each page, and flowing to multiple pages when there are
more records than can fit on one page.

Thanks,
David 



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**