Re: File Excel created from 4D

[Koen Van Hooreweghe via 4D_Tech]

Hi Ferdinando,

It depends of what your needs are.

The very basic is a tab delimited txt file or an csv file which you can 
open/import in Excel. No formatting.

Second option is to create a text file containing a html formatted table using 
   tags. Formatting possible using css. Can be easily imported 
in Excel too.

Third possibility is to use 4D View Pro, which has an export to Excel. 4D 
native, but license required. Op 14 sep. 2021, om 16:20 heeft stardata.info via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I need to create an excel file from 4D application.
> 
> Someone know how i can do?




Compass bv
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: Method Editor 4D-version≥18.5

[Koen Van Hooreweghe via 4D_Tech]

4D Preferences > Methods > Options > Show Lists (uncheck)

HTH,
Koen

> Op 26 jul. 2021, om 14:12 heeft Jörg Knebel via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> Is there a trick to hide the lists at the button of the editor by default?




Compass bv
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: How to get information about a connected camera

[Koen Van Hooreweghe via 4D_Tech]

Hi Jörg,

'imagesnap -l' returns a list of available video devices.

I remember you had some trouble with the signing process and imagesnap (were 
you able to solve it?). Me too, I did not succeed to capture an image using 
imagesnap, but retrieving the list of video devices actually works (tested 
v17R6 and v18R6, interpreted)

HTH,
Koen

> Op 15 jun. 2021, om 10:09 heeft Jörg Knebel via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
>> Is there a (simple) way to get “True or False” to the question “Camera 
>> connected” for Mac and Windows?
>> 
>> Terminal and Command Prompt approach are just fine.
> 




Compass bv
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: Base64 Image

[Koen Van Hooreweghe via 4D_Tech]

Hi Jorg,

I was only trying to be helpful. I don't have any 4D shares (;-) , but as a 
long time developer (+30 years) I dare to count myself in the experienced group 
too.
There are currently 9036 users on the 4D forum, which is actively used (not 
moderated or censored) by 4D staff members too. Your mileage might vary, but 
chances are good you will get or find answers there.

Personally I liked this e-mail mailing list, but fact is there is little 
activity recently. Unless I'm not getting all messages?

Maybe sometimes one just has to follow the crowd,...

Kind regards,
Koen

> Op 4 jun. 2021, om 14:47 heeft Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> But lots of the well experienced one do and they are not on that web-forum. 
> :o
> 
> And there even some they don’t participate at all anymore since all those 
> hypes broke loose… 
> 
> Please stop the propaganda for that web forum, or some people could get some 
> ideas against it.




Compass bv
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: Base64 Image

[Koen Van Hooreweghe via 4D_Tech]

Hi Ferdinando,

This is a piece of code I've been using:

TEXT TO BLOB($base64string;$pictBlob;UTF8 text without length)
If (BLOB size($pictBlob)>0)
BASE64 DECODE($pictBlob)
BLOB TO PICTURE($pictBlob;$picture;"JPEG")
End if 

HTH,
Koen

PS: I'd advise to switch to the official 4D Forum: discuss.4d.com, not many 
developers are using this mailing list.

> Op 4 jun. 2021, om 13:40 heeft stardata.info via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I need to obtain an image from a base 64 string.
> 
> How i can do using 4D Commands?




Compass bv
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: "4D View Pro License required", but I have a license...

[Koen Van Hooreweghe via 4D_Tech]

Hi Ernie,

Just a wild guess. Could it be the current user/group doesn't have access to 
the 4D View Pro plugin in your converted db?

HTH
Koen

> Op 13 apr. 2021, om 16:54 heeft eachilgers via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> Mac, os X 10.13.6  4D v17.5 (with 4D View Pro license)
> Took a v15 program and upgraded to v17 and wanted to implement in an array 
> based listbox the optional “variable rowheigth’ 
> 
> I have the required 4D View Pro license and have successfully created other 
> 4d solutions using Array based Listboxes with variable rowheight. 
> 
> I already replaced the array based listbox in the converted V15 to v17 layout 
> but get the same message. 
> As long as I don’t tick the -variable rowheight- the listbox functions normal.
> 

**
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: [4D v18.3; Mac {10.13.6} + {10.15.7}] LEP-voodoo

[Koen Van Hooreweghe via 4D_Tech]

Hi Jörg,

I had a very old version in Imagesnap in one of my projects but it doesn't work 
any more. Using this old version 4D always hangs.

Unfortunately updating to the latest version did not help. No more hang, but no 
image data returned. Thus far I suppose it's an issue of privacy setting. 4D 
doesn't get access to the camera (I'm on 10.14.6 and using 4D v17R6).

When trying the command from terminal, the first thing Terminal asked was 
permissoin to access the camera.

Now I have to find a way to give accesss to 4D too. But simply dragging and 
dropping the app in the system preferences does not work.

Investigating further, but maybe you know a way to do this? I found a 
tccutil.py python script for managing apps permissions, but did not test it 
yet. Seems to be quite a hassle to get this working on customers machines.

HTH
Koen

> Op 4 mrt. 2021, om 13:59 heeft Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> $cmd:=$FoDoPath+"./imagesnap -w 2.0 "
> 
> LAUNCH EXTERNAL PROCESS($cmd;$StdIn;$StdOut;$StdOut;$PID)
> 




Compass bv
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: Remember password

[Koen Van Hooreweghe via 4D_Tech]

Hi Miguel,

If I'm not mistaking, when holding the shift key pressed when connecting to the 
server, the password dialog should appear. Allowing you to reset that setting.

But I don't know if it is possible to disable that feature.

HTH,
Koen

> Op 22 dec. 2020, om 11:18 heeft Miguel Gonzalez via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I'm using 4D version 12.6 on windows server 2012
> 
> I have a user that checked the remember password box. How can I revert this?
> How can I disable this 4D feature when it shows the list of users that
> can connect to 4D.
> 
> My problem is that the client runs on a share drive. This means that
> different users are using the same 4D client so I can't allow the
> "remember password" feature because it affects all the users that are
> using the same client to connect to 4D.
> 
> Thank you in advance for any advice on this.
> 




Compass bv
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: PDF Creation

[Koen Van Hooreweghe via 4D_Tech]

Hi Ferdinando,

To save a 4D report to PDF, you just print it to pdf using a pdf driver. On Mac 
this is built in, on Windows you might need to install PDFCreator (1.7) or 
Windows pdf driver (according to your os).

Take a look at the printing section of the 4D documentation.

If you want to do this from code, basically you use SET PRINT 
OPTION(destination option; thePDFPath) and print the report. That's all.

HTH
Koen

> Op 8 okt. 2020, om 19:45 heeft stardata.info via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> No, i need to save in PDF format one report from 4D.
> 
> Thanks
> 
> Ferdinando
> 
> Il 08/10/20 17:37, Justin Will ha scritto:
>> Do you just want to print an existing report to a pdf?





Compass bv
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: V18 Closing Method windows and Form windows when switching modes...

[Koen Van Hooreweghe via 4D_Tech]

Hi Lloyd,

How do you make the switch? Is the alt-key involved somewhere in the process? 
Then that may be the culprit.

HTH
Koen

> Op 17 sep. 2020, om 06:08 heeft Lloyd SIgler via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> When going from Design Mode to Test Application and back, v18 is closing any 
> open Method windows and Form windows that were open in Design Mode.
> 
> It’s driving me nuts. Is there a fix ,or am I missing something with this new 
> behavior?




Compass bv
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: ON MOUSE ENTER

[Koen Van Hooreweghe via 4D_Tech]

Hi Ferdinando,

Als Keisuke already indicated, use LISTBOX GET CELL POSITION like this in the 
On Mouse Move event

GET MOUSE($X;$Y;$button)
LISTBOX GET CELL POSITION(*;"list box name";$X;$Y;$column;$row)

In $row, you will get the number of the row number the mouse is currently over.

HTH
Koen

> Op 13 aug. 2020, om 16:17 heeft stardata.info via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> The goal is to know the row number when the mouse arrow is on one row of list 
> box.




Compass bv
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: The pointer is not properly initialized Error

[Koen Van Hooreweghe via 4D_Tech]

Nisha,

If you set a break point in the case of branches, can you see what you get in 
$4 at runtime?

You might need to contact the developer of QPix to get this solved.

Koen

> Op 2 jun. 2020, om 11:36 heeft nisshaa2004 via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> They are correct in the code, looks like while pasting from MAC to the
> screen here I made a mistake. Sorry for that.
> 
> In the actual code, it is
> 
> Case of 
> 
> : ($event=qpx_AcqImageSaved)
> : ($event=qpx_AcqSetupResolution)
> : ($event=qpx_AcqSetupPixelFormat)
> 
> 
> So it conforms to the QPix manual.




Compass bv
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: The pointer is not properly initialized Error

[Koen Van Hooreweghe via 4D_Tech]

Ah, a bit more complex as it is a callback method called from a 
plugin/component. I guess QPix?

Are you sure the event constants are the correct ones?

: ($event=imageSaved)
: ($event=resolution) 
: ($event=pixelFormat) 

I've never used this plugin, but in the online manual I found qpx_AcqImgeSaved, 
qpx_AcqSetupResolution as event kind param constants.

You might be checking invalid events where the eventInfoParam is not the 
expected value.

HTH
KOne

> Op 2 jun. 2020, om 11:08 heeft nisshaa2004 via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> Thanks Koen for the reply
> 
> 
> 
>   $err:=QPx_AcqRunSession
> ($protocol;$deviceName;$options;"IMG_ACQ_LAB_SESSION_HANDLER")
> 
> IMG_ACQ_LAB_SESSION_HANDLER // This is the method that has the error
> 
> 
> QPx_AcqRunSession this method takes in the following parameters.
> 
> Input parameter   acqProtocol LONGINT Acquisition protocol ID
> Input parameter   deviceName  TEXTDevice name
> Input parameter   sessionOptions  LONGINT Acquisition options
> Input parameter   eventHandlerTEXTEvent handler method name
> 
> 
> IMG_ACQ_LAB_SESSION_HANDLER // This is the Event handler method name
> 
> 
> Thanks & Regards,
> Nisha
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 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
> **




Compass bv
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: The pointer is not properly initialized Error

[Koen Van Hooreweghe via 4D_Tech]

Hi,

You don't show us how this method is called. The 4th parameter in the calling 
method is probably not a valid pointer.

Kind regards,
Koen

> Op 2 jun. 2020, om 10:50 heeft nisshaa2004 via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> I am trying to run a code in 4D v16.4 and get The pointer is not properly
> initialized Error from 3 separate lines.




Compass bv
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: question about PROCESS 4D TAGS 4d v13

[Koen Van Hooreweghe via 4D_Tech]

Hi Ernie,

Is there a typo or are you using two arrays? aTxtHeaders1 and aTxtHeaders

If so, you should use the array variable which you use as loop counter as index 
for your arrays too.




HTH
Koen

> Op 22 mei 2020, om 00:47 heeft ernie hilgers via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
>   
>   




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: iNUG Messages — Is it time for it to be more than just 'plain text' ???

[Koen Van Hooreweghe via 4D_Tech]

Hi Chip,

I haven't tested myself, but afak this feature is available in the new 4D 
forum. It is using Discourse (www.discource.org), which offers mailing list 
support.

HTH
Koen

> Op 2 mei 2020, om 07:38 heeft Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> I really prefer everything coming to me (email) vs having to go get it (forum)




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: Can't Access Design Mode in 6.0.6

[Koen Van Hooreweghe via 4D_Tech]

Hi Randy,

Just a wild guess, but could it be possible the current user is being changed 
in the code? Dunno if CHANGE CURRENT USER already existed in v6.0.6.
I saw you can run quick report, can you check if Current user is still the 
Designer?

HTH
Koen

> Op 7 apr. 2020, om 18:13 heeft Randy Kaempen via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I've got an old machine to run it on.  I have the database structure and the 
> developer password.  However, I can't get into design mode.  I am logged in 
> as Designer.  There is an option on their menu that says User Mode.  However, 
> when I select it, the database quits.  If I do option-f, the database quits.  
> If I do option-F4, the database quits.  I have managed to run a procedure and 
> interrupt it with option-click.  I get the dialog with Trace and Edit on it.  
> The buttons are enabled. However, when I click either one, the database quits.
> 
> I thought it might be an authorization issue.  I have license codes from back 
> then, but I don’t see a place to enter them.  Also, I created a brand-new 
> database and it let me access design mode and see the structure.
> 
> I can't figure out why it won't let me into design mode.  Any ideas?
> 




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: Post Key

[Koen Van Hooreweghe via 4D_Tech]

Hi Jody,

You can set the standard action of the button to 'userMode'. This should do the 
trick imho.

Kind regards,
Koen

> Op 19 feb. 2020, om 17:59 heeft Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> I want to let the Administrator / Designer in a compiled database be able to 
> launch the Runtime Explorer without having to remember the keyboard shortcut 
> to do this. 
> 
> The way I was thinking of doing this was a button on screen they click on 
> that would post the keyboard shortcuts for the runtime explorer. For example 
> on the MacOS doing the following:
> 
> If (Is macOS) 
>   POST KEY(-101;Shift key bit+Command key bit)
> End if
> 
> or use
> 
> POST KEY(-101;Shift key Mask+Command key mask)
> 
> This does not seem to work. Where is my thinking wrong?




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: v18 and 4D Write Classic - does it work ?

[Koen Van Hooreweghe via 4D_Tech]

Hi Peter,

4D Write is 32bit only. v18 is 64bit only. v18 cannot load the 4D Write plugin 
and therefore raises the privilege error.

You cannot use 4D Write in v18 at all.

IMHO v17R3 was the last 4D having a 32bit version.

Kind regards,
Koen

> Op 5 feb. 2020, om 15:37 heeft Peter Jakobsson via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> Will legacy 4D Write work in v18 in the meantime or do we need to migrate to 
> 4D Write Pro to even run it ? (When I try it it invokes license privilege 
> errors everywhere).




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: 4D Tools v2003, Mac

[Koen Van Hooreweghe via 4D_Tech]

Hi Pat,

I also sent you a copy in pm. Did your get it?

Kind regards,
Koen

> Op 29 jan. 2020, om 17:04 heeft Uist Macdonald via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> Tried sending you a copy but it bounced. Send me another email.
> 
> Regards
> 
> Uist Macdonald
> 
>> On 29 Jan 2020, at 15:18, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com 
>> > wrote:
>> 
>> Anybody got a copy?
>> 
>> Pat
>> 




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: Document encoding

[Koen Van Hooreweghe via 4D_Tech]

Hi Rudy,

IMHO UTF-8 encoding only makes sense in the context of plain text files 
(character based files like txt, csv, tsv, xml, json, html,...). But it has no 
meaning for binary files (PDF, pictures).
xlsx and docx files are essentially zip archives containing a bunch of xml 
files. For xml files UTF-8 is the default encoding. But you (or you customer) 
should not worry about those.

The real problem arises when trying to import and process plain text files. 
Especially for the high character codes. MacRoman encoding of some characters 
is different than eg Latin-1 and those encodings have a limited range.

Unfortunately, as Lutz also mentions, it is not possible to determine in all 
cases the used character encoding when receiving a text file. The BOM is an 
indication for UTF files, but in my experience rarely used. BOM is not required.

FWIW, BBEdit also guesses what the text file encoding could be. It does a good 
job, but it can be fooled.
Eg. create a new file in BBEdit and set the encoding to Windows Latin-1. Enter 
the text ˧ and save the file. Close it and reopen it in BBEdit. It will now 
say UTF-8 and show a different content.

HTH
Koen

> Op 10 jan. 2020, om 22:58 heeft Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> If, e.g., I look at a pdf file in BBEdit, it says ‘Mac Roman’.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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 64-bit -- error opening datafile on MacOS file server

[Koen Van Hooreweghe via 4D_Tech]

Hi Allan,

I've seen a similar issue when opening a 4D database which resides on a mounted 
disk (macOS, both structure and data on the remote). This is a confirmed bug 
(ACI0099881) in 4D which started from v17R4 (and R5+R6). Unfortunately this bug 
will not get fixed in v17. But I can confirm it is fixed in the v18 beta 
versions.

So, either go back to 4D v17.3 (not R-version) or v17R3 (but miss a few new 
features) or move forward to v18 beta.

Kind regards,
Koen

> Op 4 jan. 2020, om 04:25 heeft Allan Udy via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> We use a couple of very small databases in-house, where the datafile is 
> stored on a file server (MacOS), and various people will periodically access 
> the system and then quit.
> 
> Just upgraded one of these to v17R6 64-bit (from v17R4 32-bit)    at 
> startup a record is written into the datafile and this action immediately 
> throws a - error:  "No more room to save the record."
> 
> If we copy the datafile off the file server onto a local hard disk, the 4D 
> v17R6 64-bit version of the app opens the datafile perfectly fine, with no 
> error.
> 
> It appears that this is a 64-bit problem, as the earlier v17R4 32-bit version 
> works fine, where-as R4 and R5 64-bit also display the same error.
> 
> I've tried with two different client machines (both Macs), and two different 
> file server -- same result.
> 
> Anyone have any suggestions as to what may be going on here?  What am I 
> missing?




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: XML Null reference with DOM Find XML element

[Koen Van Hooreweghe via 4D_Tech]

Hi Piotr,

I have a small method DOM_validRef which basically uses this test:

if(Replace string($ref;"0";"")="")
   $valid:=false
end if

64bit indeed uses 32 zero chars instad of 16, but this code handles both 
situations (and future ones, if we live long enough to make the transiton to 
128bit systems...).

My method also checks if all chars in the XML ref are valid hex chars (0-9 
A-F), but that might be overkill.

Kind regards,
Koen

> Op 17 dec. 2019, om 10:08 heeft Piotr Chabot Stadhouders via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> 4Dv17R6, Windows 64-bit
> What is the best way to test if a XML DOM element is a Null reference?
> Especially when using DOM Find XML element?




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: Removing progress window while printing to PDF a 4D write documents.

[Koen Van Hooreweghe via 4D_Tech]

Hi Luc,

In my code I have:
SET PRINT OPTION(Hide printing progress option;1)

Strangely enough, I can't find this option any more in the v17R6 language 
reference. But I think it is still working.

HTH
Koen

> Op 21 nov. 2019, om 21:06 heeft Luc Devar via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> The progress window saying processing page xx of xx always displays and I do 
> not want to see it.  
> I am sure they must be a simple way to remove this window but unable to make 
> it work.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: Folder path issues

[Koen Van Hooreweghe via 4D_Tech]

Hi Chip,

Just checked v17 and the returned path is correct. But in v15 the / character 
is missing.
I guess the 4D v15 path conversion method is faulty. Because macOS internally 
stores / character in file or folder names as :

Besides of having to live with it, two options:
- change your folder name
- upgrade to v17

Kind regards,
Koen

> Op 25 sep. 2019, om 22:47 heeft Chip Scheide via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I am testing some code. (Mac, 10.11.6 and 4D v15, NON posix file/folder 
> paths)
> as part of the test I select a folder (Select Folder), and then do some 
> actions with/on the resulting path.
> In this specific instance the path I retrieve is:
> Macintosh HD:Users:chip:Desktop:   tblutl_test_results:NEW folder for 
> testing*"\\:
> 
> However the actual folder path is:
> Macintosh HD:Users:chip:Desktop:   tblutl_test_results:NEW folder for 
> testing*"\/:
> 
> Note: 
> - the actual last character of the folder name is a '/'.
> - the OS was/is happy to allow the folder name.
> 
> As you should be able to see the path provided by Select Folder (first 
> path) is incorrect, and as such any attempt to manipulate the folder, 
> its contents etc is met with '... the file or folder path is invalid...'
> 
> Any Idea as to why the Select Folder command is returning an invalid 
> path?
> Is this a bug in v15 I'll have to live with?
> 

**
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: Debug Application Process Window missing toolbar

[Koen Van Hooreweghe via 4D_Tech]

Hi Paul,

There is some 4D prefs file 4ddebugger.json which might contain faulty values. 
I don't know exactly where to find it on Windows, but on Mac its 
home/Library/Application Support/4D/4D Window Bounds 
v17/runtime/[projectForm]/4ddebugger.json.

See also: https://forums.4d.com/Post/EN/16299793/1/16299794

HTH
Koen

> Op 19 sep. 2019, om 04:20 heeft Paul Ringsmuth via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> 4Dv17R5
> Windows 10 under VirtualBox
> 
> The toolbar is missing in the Debug Application Process Window except for a 
> couple of pixels. 
> 
> I can’t find a way to get it back. Any suggestions?
> 
> Paul Ringsmuth
> pringsm...@charter.net 
> 




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: FORMAT NUMBER

[Koen Van Hooreweghe via 4D_Tech]

Hi Ferdinando,

Just tested v16.5 (on Mac, but that should not differ from Windows). IMHO there 
are no changes in number formatting between v16 and v17.
Created a 1 column array based list box on a form. Populated the array with 
some random real numbers.
The column is set to variable type 'Numeric' and number format being:  
###,##0.###;-###,##0.###;

This means, positive non zero numbers format up to 6 digits to the left of the 
decimal point and 3 to the right. Negative non zero numbers have minus sign 
followed by the same format as positive numbers and zero is displayed as blank.
In belgium we use period as thousands separator and comma as decimal point. 
Beware, 4D internally uses (US notation) period for decimal and comma for 
thousands. But at runtime uses the OS number format setting.
There is a compatibility setting for upgraded databases (created before v11)*

Eg: 1234567/1000 will display as 1.234,567 on my OS, but I have to set 
###,##0.### as number format in the property pane.

If you want to see three decimal digits for each number, you must use 
###,##0.000 as number format. This will display 1 as 1,000 or 12/10 as 1,200
If you have larger numbers, add extra # on the left side, eg ###,###,##0.000

HTH
Koen

*4D Design Reference>Database Settings>Compatibility page: "Use period and 
comma as placeholders in numeric formats": starting with v11, 4D uses regional 
system parameters for numeric display formats (see “Number formats” in Display 
formats). 4D automatically replaces the “,” and “.” characters in numeric 
display formats by, respectively, the thousand separator and the decimal 
separator defined in the operating system. The period and comma are thus 
considered as placeholder characters, following the example of 0 or #. In 
previous versions of 4D, numeric display formats do not take the regional 
parameters of the system into account. For example, the “###,##0.00” format is 
a valid format for an American system. However, when it is applied to a numeric 
value displayed on a French or Swiss system, the result is incorrect. 
In converted database, for the sake of compatibility, this new mechanism is not 
activated. To take advantage of it, you must check this option.

> Op 5 aug. 2019, om 23:24 heeft stardata.info via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I need to display a number in an array real displayed in a list box.
> In column settings of the list box, if I do not insert anything in Display 
> number format, the decimal numbers are correctly displayed, but I have 0 
> instead of blank.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: Sending Text Messages From 4D

[Koen Van Hooreweghe via 4D_Tech]

Hi Jim,

You're not sending the headers. You must add the arrays in HTTP Request. That 
might lead into an 400 'bad request' error.

$lHTTPStatus:=HTTP Request(HTTP POST Method;$tURI;$tRequest;tResponse; 
atHeaderNames; atHeaderValues)

HTH
Koen

> Op 5 aug. 2019, om 21:17 heeft Jim Labos - infobase via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> $lHTTPStatus:=HTTP Request(HTTP POST Method;$tURI;$tRequest;tResponse)



—
Koen Van Hooreweghe
—




**
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: PDF Viewer

[Koen Van Hooreweghe via 4D_Tech]

Hi Steve,

IIRC I've had some issues with PDF Viewer plugin when moving to 4D v17 even on 
older macOS than Mojave. Rob Lavaux from pluggers.nl promptly fixed them. You 
should contact him to get your issues solved. I personally do prefer PDF Viewer 
instead of picture fields or web areas (on mac).

Rob might be on holiday right now, but normally he responds pretty quickly. 

HTH
Koen
 
> Op 22 jul. 2019, om 21:48 heeft UKVetDerm via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> Anyone having difficulties with Mac PDF Viewer plugin (2.01) with Mojave and 
> v17 (r4 and r5) 64 bit. Can’t decide whether I have a bad form or there is a 
> more systemic problem.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: POSIX Path Syntax (How to convert from 4D POSIX to Terminal POSXIX?)

[Koen Van Hooreweghe via 4D_Tech]

Hi Jeremy,

Two options:

- surround your path with single quotes. If the path itself includes quotes, 
you will need to escape them.

'/Users/jeremyfrench/Desktop/test_notarize_01/test_notarize_01_Build/Final 
Application/test_notarize_01.app/'

- escape the spaces:

/Users/jeremyfrench/Desktop/test_notarize_01/test_notarize_01_Build/Final\ 
Application/test_notarize_01.app/


HTH
Koen

> Op 24 jun. 2019, om 16:57 heeft Jeremy French via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> How do we resolve POSIX file path syntax between 4D and Mac Terminal?
> 
> This Mac system path has a space in the folder name "Final Application":
> Macintosh 
> HD:Users:jeremyfrench:Desktop:test_notarize_01:test_notarize_01_Build:Final 
> Application:test_notarize_01.app:
> 
> 4D's POSIX shows the space in "Final Application" unescaped:
> /Users/jeremyfrench/Desktop/test_notarize_01/test_notarize_01_Build/Final 
> Application/test_notarize_01.app/




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: Listbox - moving columns - is it possible?

[Koen Van Hooreweghe via 4D_Tech]

Hi Paul,

If must have the headers visible. Then you click and drag the column header to 
move the column. At least on array based listbox.

HTH
Koen

> Op 27 mei 2019, om 11:48 heeft Paul Lovejoy via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I have a listbox with 21 columns and I have to change the order in which the 
> columns are displayed. I have a vague recollection that this is possible but 
> I can’t find any way to do so. I was thinking it would be possible to click 
> on a column, hold down the mouse button and slide it where I want it, like 
> just about any other application would allow. It doesn’t seem to happen for 
> listboxes. I’m using v15.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: 4D View - create spans?

[Koen Van Hooreweghe via 4D_Tech]

Hi Pat,

One trick shown on the World Tour to manipulate 4D View Pro data is to export 
the data to an object, manipulate the object and then import it back to the 
View Pro area.

Creating a span in the first row merging column 1 to 5, can be done as follows:

$vpAreaName:="ViewProArea"

$vpObject:=VP Export to object ($vpAreaName) //get the View data into a 4D 
object

$span:=New object //create our span object
$span.col:=0 //row and column indexes start at 0
$span.colCount:=5
$span.row:=0
$span.rowCount:=1

If (Undefined($vpObject.spreadJS.sheets.Sheet1.spans)) //if there 
are no spans yet in the sheet, this collection will not exist
$vpObject.spreadJS.sheets.Sheet1.spans:=New collection
End if 
$vpObject.spreadJS.sheets.Sheet1.spans.insert(0;$span)

VP IMPORT FROM OBJECT ($vpAreaName;$vpObject) //put it back to the area

One caveat though. The sheet name (Sheet1) is used as object property name. 
Above code will not work if the user has changed the sheet name. I haven't 
looked how to make this 'foolproof'. It might be an implementation mistake as 
the sheet objects have a property 'name' too.

HTH
Koen

> Op 21 mei 2019, om 16:01 heeft Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> I can see how to create cell spans via the user interface, when the toolbar
> is displayed ("merge and center" button) but does anybody know how to do it
> via code?




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: More Engine quesitons

[Koen Van Hooreweghe via 4D_Tech]

Chip,

This is documented in the 4D Design Reference>Finalizing and deploying final 
applicateions>Customizing a stand-alone application icon.

See: 
https://docs.4d.com/4Dv17/4D/17.1/Customizing-a-stand-alone-application-icon.300-4201096.en.html

HTH
Koen

> Op 24 apr. 2019, om 20:17 heeft Compass - Koen Van Hooreweghe via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> Yes. You have to place an icon file next to your structure file having the 
> same name as your .4DB.





Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: More Engine quesitons

[Compass - Koen Van Hooreweghe via 4D_Tech]

Hi Chip,

Yes. You have to place an icon file next to your structure file having the same 
name as your .4DB.

Groeten,
Koen

Verstuurd vanaf mijn iPhone X

> Op 24 apr. 2019 om 20:11 heeft Chip Scheide via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> Custom desktop icon.
> 
> Is there a way to get the icon to 'stick'?
> i.e. apply the icon in such a way that when I rebuild the app I do not 
> have to manually place it.
> 
> Thanks
> Chip
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 
> **
> 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 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

[Koen Van Hooreweghe via 4D_Tech]

Hi David,

Use 'Settings' from the property list. Then in the Print dialog use 
'Preferences' button. You will be able to set orientation. Button 'Advanced...' 
will give you more options (like paper size) depending on the driver.

A bit of a hassle, I agree (and that is why I'm working on mac ;-). I tested in 
32 bits setting a certain form to A5 landscape en then checked in 64 bit, the 
settings were saved.

HTH
Koen

> Op 10 apr. 2019, om 17:16 heeft David Rose via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> 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?




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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

[Koen Van Hooreweghe via 4D_Tech]

Hi David,

AFAIK this is OS behavior difference between 32bit and 64bit. Just try any 
other 32bit or 64bit windows app and print. As far as those apps don't roll out 
their own print dialogs (like Word...)

HTH
Koen

> Op 10 apr. 2019, om 04:31 heeft David Rose via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> 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?



—
Koen Van Hooreweghe
—




**
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: Problems with Microsoft Print to PDF

[Koen Van Hooreweghe via 4D_Tech]

Hi Keith,

Just to confirm I've seen issues with PDF's generated from 4D v17R3 using MS 
PDF driver. This is happening on my Citrix account at a customers site. Acrobat 
Reader says the document contains an error and cannot be displayed correctly. 
If I open it on my Mac using Preview, no problem. But Acrobat Reader DC Mac 
shows the same error message.
The document opens, but only a small part of the 3 page document is displayed. 
Just he header parts are displayed and on page 2 and 3 even some texts of the 
header are missing.

I haven't investigated further yet because I did not get complaints of other 
users. But IIRC this problem I'm seeing started after upgrading from v16 (32bit 
clients) to v17 (using R3 64 bit). Could not reproduce it in my development 
environment.

Kind regards,
Koen

> Op 1 apr. 2019, om 05:10 heeft Keith Goebel via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> Has anyone else encountered this problem and, if so, have you managed to 
> determine what is causing the “bad” pdfs?




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: Printing a PDF document from 4D

[Koen Van Hooreweghe via 4D_Tech]

Hi Julio,

There is another plugin from pluggers.nl which handles viewing and printing of 
pdf documents too: PDFViewer. I have been using it on macOS for years. 
Excellent support from Rob for the rare occasions I needed it.

Kind regards,
Koen

> Op 19 mrt. 2019, om 12:39 heeft Luc Devar via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> I use QPDF plugin from Pluggers Software 
>  > to do this kind of action and 
> many more. 
> Best tools out there to manage PDF documents from 4D.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: Can't get to development mode!

[Koen Van Hooreweghe via 4D_Tech]

Hi Doug,

Perhaps a typo, but you actually need the Developer license to be able to go to 
design mode. the Unlimited Desktop license is the one you need to include if 
you build single user apps.

HTH
Koen

> Op 12 mrt. 2019, om 23:49 heeft Doug Hall via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> Problem is, it doesn't! I checked to make sure I have the Unlimited Desktop
> license installed for the current year.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: Looping and control flow

[Koen Van Hooreweghe via 4D_Tech]

From the top of my head. What about:

something:=true

while(something)
if(not interested)
something:=false
else
process
end if
end while

HTH
Koen

> Op 11 mrt. 2019, om 19:41 heeft Sandor Szatmari via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> Does 4D have the concept of continue like
> 
> 
> while (something)
> 
> 
>if (not interested)
>   continue
> 
> 
>// Process what I'm interested in
> 
> 
> end while




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: PDF as base 64

[Koen Van Hooreweghe via 4D_Tech]

Hi chuck,

Create your PDF as usual (set print option...), then read the pdf file into a 
blob (document to blob), convert the blob to base64 (base64 encode) and finally 
write the resulting text data (or blob if you want) to disk.

HTH
Koen

> Op 4 mrt. 2019, om 20:42 heeft cjmiller--- via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> Hi all environment 4D 16.4. I have a need to create PDF documents as base 64 
> on Mac clients. Has anyone done this?  Any suggestions. 




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: Printing 4D Write to PDF via Windows 10 "Microsoft Print to PDF"

[Koen Van Hooreweghe via 4D_Tech]

Hi Bill,

I think the OPEN/CLOSE PRINTING JOB is not needed and perhaps causing problems 
with 4D Write.

HTH
Koen

> Op 1 mrt. 2019, om 18:01 heeft Bill Hutten via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> It works, in that a PDF is created, with the right $fname, at the right 
> $path. It doesn't work, in that the PDF is 0 bytes in size.
> 
> 
> Anyone have tested code that solves this problem?
> 




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: Build Application “No License is Installed" and ...

[Koen Van Hooreweghe via 4D_Tech]

Hi John,

Did you add/update your new licenses in the "Licenses & Certificate" tab of the 
Build Application dialog?

HTH
Koen

> Op 25 feb. 2019, om 17:07 heeft John J Foster via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I am using my 4D v17 Partner licenses which have been updated this February. 
> So I am current!
> 
> The License Manage reflects both:
> 
> 4D Developer Professional v17 R4 —> February 2020
> 4D Unlimited Desktop 4D v17 R4 - Partner Program
> 
> So looks good.
> 
> Now when I go into the Build Application Dialog -> Application Tab and…
> 
> Select Build stand-alone application
> 
> Point the 4D Volume Desktop Location by navigating to the folder and 
> selecting it.
> 
> The selection of Data Linking mode… doesn’t appear to make any difference.
> 
> What I get is “No License is Installed"




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: Base64 Encoded text

[Koen Van Hooreweghe via 4D_Tech]

Hi Bob,

It is normal the HL7text is longer than the PDF size. As Base64 encoding 
converts a binary file to be sent by a text protocol.
I decoded the starting part of your hl7 record you provided and I get '%PDF-1.4 
%' which is the start of a PDF file. Looks good to me.

For start you could try to copy the pdf part of the hl7 message and paste it 
into an online decoding tool (like www.base64decode.org) to see what you get. 
Maybe there are some trailing characters in the base64 part of the message 
which you need to eliminate?

You could also try the other way and encode the provided PDF file to base64 
using 4D and compare it to its hl7 counterpart. Maybe you can discover some 
differences?

Kind regards,
Koen


> Op 14 feb. 2019, om 06:30 heeft Robert McKeever via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> The health authority has decided to release some results (discharge reports) 
> in PDF form which we receive in HL7 format.
> 
> The line received begins with 
> 'OBX|1|ED|PDF^PDF||^TEXT^PDF^Base64^JVBERi0xLjQKJdP0zOEKM’. 
> 
> I’ve tried 
> 
> $BlobText:=substring([PatientLabResults]HL7Text;36;length([PatientLabResults]HL7Text))
> BASE64 DECODE($BlobText;[PatientLabRequests]PDF_Blob)
> 
> which does not work.
> 
> They were nice enough to include a sample HL7 file and the sample PDF. The 
> size of the PDF is 68,076, while the length of the HL7Text is 85,807.
> 
> So, what do I need to do to turn the encoded text into a PDF?




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: 4D Write Pro Brain Cramp

[Koen Van Hooreweghe via 4D_Tech]

Hi Tom,

I suppose the problem is that you are copying the reference of your 
preference_object WP to [invoices] and not the wp content itself.
This way ST Freeze is also modifying your original WP and in the next run of 
the loop there are no more references to be freezed.

Afterwards your preferences object is probably not being saved, so won't notice 
the [preferences] record was modified.

Could you try changing this line
[Invoice]Invoice_WP:=[Preferences]Preference_Object
to this:
[Invoice]Invoice_WP:=ob copy([Preferences]Preference_Object)

HTH
Koen

> Op 13 feb. 2019, om 18:34 heeft Tom Dillon via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> The first time through, the [Invoice] record has all the correct references 
> resolved. The second time through, even though the fields being referred to 
> have changed, the saved WP object field contains a copy of the same field 
> from the first one.
> 
> Basically this for a selection of [Client] records:
> 
> For ($Ndx;1;Records in selection([Client])
> Create Record ([Invoice]) 
> < load, calc and assign needed stuff >
> [Invoice]Invoice_WP:=[Preferences]Preference_Object
>   ST FREEZE EXPRESSIONS([Invoice]Invoice_WP)
>   SAVE RECORD([Invoice])
>   NEXT RECORD([Client])
> End for 
> 




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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 conundrum in design

[Koen Van Hooreweghe via 4D_Tech]

Hi Chuck,

Is it happening on a line of code which is split up in several lines ('\')?
I've seen this happening a number of times. Mainly quitting and restarting 4D 
is enhough to solve this issue. You might try to remove the slash chars, set a 
breakpoint at the remaining line and remove it right away and then split your 
line again.

HTH
Koen
 
> Op 7 feb. 2019, om 21:39 heeft Chuck Miller via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I have an object method that shows no break points either in the method or 
> when I show break points, yet it continues to stop at a particular line of 
> code and it is annoying. Any ideas out there what it might be.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: How to display read-only input form

[Koen Van Hooreweghe via 4D_Tech]

Hi Jim,

Have you tried MODIFY SELECTION instead of MODIFY RECORD?
Set the table in read only mode, make sure only the requested record is in the 
current selection and then open the record using MODIFY SELECTION. Without the. 
optional * parameters, this command should open it immediately in the input 
form for a one record selection.
If I remember correctly, no lock alert will be shown.

Otherwise you might try to use an error handler to get rid of the alert.

If a field is set to focusable but not enterable, the user can't edit the 
content, but will be able to select and copy.

HTH
Koen

> Op 6 feb. 2019, om 22:31 heeft Jim Crate via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> If I set the table to read only before loading the record, MODIFY RECORD just 
> shows an alert complaining that the record is locked, and doesn’t show the 
> input form. So I set the form fields to be not enterable, but while text can 
> be selected, it can’t be copied. 




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: 4D Write Pro license question

[Koen Van Hooreweghe via 4D_Tech]

Hi Chuck,

IMHO this is not correct.

I recently struggled a lot with 4D View (Pro) licenses. A customer has 40+ 
users on 4D Server (v16), but only a few of them need 4D View. So they bought a 
5 user license. These are my findings :

- if there are no user groups, the licenses are assigned upon login (until the 
number of licenses is exceeded) and freed when the user logs out. Actually 
using the plugin code is not required.

- if there are user groups, it depends...
-- a user who is not in a group will get a license on login
-- if the plugin access is not limited to a group (plugin checkbox not checked 
in any group), all users will get a license (if available)
-- if plugin access is limited to a group (plugin access can be limited to only 
one group!), only users belonging to that group will get a license when logging 
in (which I needed)

Caveats:
- USERS TO BLOB will only store the goups created by Administrator (standard 
behaviour). Eg when you want to restore the settings when updating your db at a 
customers site.
- BLOB TO USERS does not restore the group plugin access (at least not in 
v16.3, haven't tested v17 yet). Bug? I don't know (yet). Maybe USERS TO BLOB 
does not store these settings correctly?

HTH
Koen

> Op 14 jan. 2019, om 02:28 heeft cjmiller--- via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> You. An create a group called 4d write group. It iS the first people who use 
> 4d write code not just logging in



—
Koen Van Hooreweghe
—




**
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: Open a document in compiled: ok, but when with standalone get message: invalid path name

[Koen Van Hooreweghe via 4D_Tech]

Hi Ernie,

Just a wild guess. Could you try without the "*"? Use an empty string or even 
remove the second parameter (it is optional).
$tDocRef:=Open document($DocPath_t;Read mode)

Are you building with the same desktop volume version?
Have you tried compiled against 4D developer (without building stand alone)

HTH
Koen

> Op 10 jan. 2019, om 16:35 heeft ernie hilgers via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> $tDocRef:=Open document($DocPath_t;”*";Read mode)
> 
> this is the point when I get the “file not found” error message. 




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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: Pasting Spreadsheet Data into 4D Records

[Koen Van Hooreweghe via 4D_Tech]

Hi Alan,

You'll probably have to start the 'paste' from a button or menu item and write 
some code.

$data:=Get text from pasteboard //you'll probably get a tab delimted text

If needed, try to find out what delimiters are used
And finally parse the text data and assign to the fields of your desired tables

HTH
Koen


> Op 24 dec. 2018, om 01:47 heeft Alan Tilson via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> Is there a way to copy from a spreadsheet like data source and to paste
> directly into 4d while parsing it into table(s) and fields? I'm using v17
> if that matters.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Proper decoding for document returned via SOAP call?

[Koen Van Hooreweghe via 4D_Tech]

Hi Bob,

PDF documents are binaries, to be able to send them through a text protocol, 
they are encoded.
In your case it is base64 encoded. So you need to decode the data in the 
getObjectFileReturn tag.

If I understand correctly, you ahve the data part in $Value, then use this 
(from the top of my head):

C_BLOB($pdfBlob)
BASE64 DECODE($Value;$pdfBlob)
BLOB TO DOCUMENT($DocName;$pdfBlob)

HTH
Koen

> Op 12 dec. 2018, om 04:07 heeft Bob Miller via 4D_Tech <4d_tech@lists.4d.com 
> > het volgende geschreven:
> 
> http://DefaultNamespace 
> " 
> xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/ 
> " 
> soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/ 
> 
> ">http://schemas.xmlsoap.org/soap/encoding/ 
> " xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance 
> " 
> xsi:type="soapenc:base64Binary">JVBERi0xLjMNCjEgMCBvYmoNCjw8DQovVHlwZSAvUGFnZXMgL0NvdW50IDEgL0tpZHMgWyA4IDAgUiBdCj4+DQplbmRvYmoNCjIgMCBvYmoNCjw8DQovVHlwZSAvQ2F0YWxvZyAvUGFnZXMgMSAwIFIgL091dGxpbmVzIDExIDAgUiAvUGFnZU1vZGUgL1VzZU91dGxpbmVzID4+DQplbmRvYmoNCjMgMCBvYmoNCjw8DQovQ3JlYXRvciAoQWNyb1Bsb3Qgb24gV2luZGDAwMDAwIG4NCjAwMDAwMDQxNzIgMDAwMDAgbg0KMDAwMDA1NDg0MiAwMDAwMCBuDQowMDAwMDU1MDA2IDAwMDAwIG4NCjAwMDAwNTUxMzcgMDAwMDAgbg0KMDAwMDA1NTIyMyAwMDAwMCBuDQp0cmFpbGVyCjw8DQovU2l6ZSAxMiAvSW5mbyAzIDAgUiAvUm9vdCAyIDAgUiAvSUQgWyA8MEVDNTRDNjQ1MUFCOUYyRkU1MDEwNTdDQ0NGMTYyOTg+DQo8MEVDNTRDNjQ1MUFCOUYyRkU1MDEwNTdDQ0NGMTYyOTg+DQpdCj4+DQpzdGFydHhyZWYNCjU1Mjk5DQolJUVPRgo=
> 
> However, when I take the binary and save it to a file, I can't open it 
> with Adobe PDF reader; it says the file is corrupted.
> 
> I'm thinking that I need to call CONVERT FROM TEXT to somehow change the 
> encoding, but I've tried several of the obvious ones (?ISO-8859-1?; 
> "UTF-8", "UTF-16"; "UTF-32"; "US-ASCII") without any luck.
> 
> DOM GET XML ELEMENT VALUE($aNodeRefsArr{1};$Value)  //this contains the 
> payload I want 
> $DocName:="C:\\TEMP\\OUTPUT.PDF"
> TEXT TO DOCUMENT($DocName;$Value;"US-ASCII")`?ISO-8859-1?; "UTF-8", 
> "UTF-16"; "UTF-32"; "US-ASCII" - none create a document that I can open 
> with Acrobat
> 
> Thoughts?

**
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: Compact data file

[Koen Van Hooreweghe via 4D_Tech]

Hi Keith,

Considering this issue. Last week I had to repair a v16 datafile. In the MSC, 
right after the repair I ran a verification. The verification was done on the 
old datafile. The repaired datafile was still in the subfolder 
'...repairing...' instead of on the original location as I would expect.
I did not test yet, but I guess the files are switched when the MSC is closed 
and not when the repair (compact) is finished. And the extra verify disturbed 
this procedure.

Did you do something similar when compacting?

Kind regards,
Koen

> Op 1 dec. 2018, om 21:41 heeft Keith Goebel via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> Using v17HF3 I have found that, after compacting on Win7, the data files are 
> in the opposite place they are supposed to be (i.e. the compacted one is in 
> the “old” folder and the old one is now the current one).




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: SQL TRIM

[Koen Van Hooreweghe via 4D_Tech]

Hi Jim,

You are missing the 'from' clause with a table. 4D does not support sql queries 
without table.

Eg in Oracle I would write: select trim(both from :vtext) from dual into :vtext;
But it seems 4D sql does not support the dual phantom table either.

Koen


> Op 15 nov. 2018, om 15:50 heeft Jim Medlen via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> 
> I am trying to learn to use SQL in 4D.
> 
> I wrote the code below to try a test using the TRIM function.
> 
> I have rewritten this several times but it throws a general parsing error 
> every time.
> 
> C_TEXT(vText)
> vText:=" sql Text!   "
> Begin SQL
> SELECT TRIM(BOTH FROM :VTEXT) INTO :vText ;
> End SQL
> ALERT(vText)
> **
> 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 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: 4D v16.4 Built database won't open in Mojave

[Koen Van Hooreweghe via 4D_Tech]

Hi Walt,

In the past I experienced a similar issue. Seems to be a some kind of 
permissions problem. Could you try to zip your app, transfer the zip to your 
MacBook and unzip it on that machine.

HTH
Koen

> Op 5 nov. 2018, om 02:30 heeft Walt Nelson via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> I have built a stand-alone Application v16.4 database on a Mac OS machine 
> running High Sierra (10.13.6).
> 
> I successfully create an empty datafile and run it on the same High Sierra 
> (10.13.6) machine.
> 
> I transfer the entire stand-alone built database to a laptop running Mojave 
> (10.14).
> 
> When opening that database, I get the following error: ‘You cannot open this 
> database because the data file (or one of its segments) is locked.’ with an 
> OK button.
> 




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: 4d write pro

[Koen Van Hooreweghe via 4D_Tech]

Hi Charles,

WP EXPORT VARIABLE([table]wpDoc; $blob; wk 4wp)

Have not used it myself, but the wk 4wp format is available from v16.

Kind regards,
Koen

> Op 30 okt. 2018, om 20:28 heeft Charles Miller via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> Is there any way
> to store 4d write pro documents in a blob field




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Defining and documenting Objects

[Koen Van Hooreweghe via 4D_Tech]

Hi Tom,

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 are quite fun to work 
with...

HTH
Koen

> Op 10 okt. 2018, om 22:15 heeft Benedict, Tom via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I'm stuck on v13.x, so I haven't had an opportunity to learn much about 4D 
> objects. One thing that I would be interested in is how easy it is to expose 
> data in objects to external non-4D systems. Can I pass an object as a 
> response to a web service call from a .Net app and have the JSON or whatever 
> form the object takes be meaningful? Or does that even make sense?




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: PDF generation on Windows - Latest Thinking

[Koen Van Hooreweghe via 4D_Tech]

Hi Chuck,

Sure it works. We use it with 4D v16 on Windows.

It is mentioned in the language reference: 
http://doc.4d.com/4Dv16/4D/16.4/Integration-of-PDFCreator-driver-under-Windows.300-3978065.en.html
But I think the example has a mistake. The second parameter of the SET PRINT 
OPTION command should be 3 (=PDF) not 2.

I cannot test right away (I'm on Mac), but I saw in my code I put the command 
with 2 in comment and I have this line with 3.

Kind regards,
Koen

> Op 12 sep. 2018, om 16:03 heeft Charles Miller via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> Are you stating this now works on windows 10. that would be great.I will
> have to write code to test for OS on windows, so I can continue to use PD
> creator on older machines
> 




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: PDF generation on Windows - Latest Thinking

[Koen Van Hooreweghe via 4D_Tech]

Hi Peter,

IMHO 4D vs PDFCreator is end of life as recent versions of PDFCreator are not 
supported. We also switched to the native Windows 10 PDF driver.
If you want to store your print documents directly to disk, you must set the 
path (as on macOS or with PDFCreator): SET PRINT OPTION(Destination 
option;3;$path)

HTH
Koen

> Op 12 sep. 2018, om 13:06 heeft Peter Jakobsson via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> For years I used PDF creator to generate PDFs from 4D on Windows 7 - mainly 
> because you didn’t have to type in a document title for every single page in 
> a print run and this could be done from code. My customer has now upgraded to 
> Windows 10 and it’s using the default PDF writer as I didn’t install creator. 
> It works but it asks her to enter a title for each document instead of 
> sending them all to disk directly.
> 
> Is PDF Creator still the preferred option on Windows 10 ?
> 
> Just wanted to see what people were using as their preferred choice.
> 




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Help please - Compiling

[Koen Van Hooreweghe via 4D_Tech]

Hi Chip,

Typo?

$Sze:=Size of array($Handle->)

If ($Size<=12)

$Sze is defined, $Size not.

HTH
Koen

> Op 17 aug. 2018, om 17:18 heeft Chip Scheide via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> $Sze:=Size of array($Handle->)
> 
> If ($Size<=12)




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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 Windows Taskbar Icons with 4D Version Numbers

[Koen Van Hooreweghe via 4D_Tech]

Hi all,

FWIW, on macOS I'm using a slightly different approach. Instead of renaming the 
application I change the icon. Copy/paste in Finder File Info window
I use the actual 4D icons, but add the version and build number and also a 
small indicator for 64bit.

https://www.dropbox.com/s/aqgpc6c785clzsp/4DDock.png?dl=0

Kind regards,
Koen

> Op 16 aug. 2018, om 21:18 heeft Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> On macOS I do something different to get the same effect from the Dock. I 
> rename the applications. So “4D.app” becomes “4D v17.0 HF1.app”. Then when 
> you hover over the icon in the doc you see the version info instead of just 
> “4D". 
> 
> I didn’t mention this before because I assumed all the macOS developers 
> already knew, but maybe not. So here it is for completeness. 




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: v13 - Record to Blob?

[Koen Van Hooreweghe via 4D_Tech]

Hi Chip,

No native command as you might have learned from the answers on your post.
Not too difficult to implement yourself. Below is what I've been using for a 
long time.
I just noticed that I did not delete the intermediate disk document, but if 
untouched, the files in the temporary folder are automatically removed by the 
OS after three days (at least on macOS).

HTH
Koen

C_POINTER($1;$tablePtr)
C_BLOB($0)

$tablePtr:=$1

C_TEXT($path)

If (Records in selection($tablePtr->)#0)
$path:=Temporary folder+Generate UUID
SET CHANNEL(10;$path)
SEND RECORD($tablePtr->)
SET CHANNEL(11)

DOCUMENT TO BLOB($path;$0)

DELETE DOCUMENT($path) //added upon sharing code
Else 
TRACE
End if 


> Op 30 jul. 2018, om 20:48 heeft Chip Scheide via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I do not see a command that allows this action (directly)
> am I missing something, or do I need to write something?




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: v13 - Konstant problem

[Koen Van Hooreweghe via 4D_Tech]

Hi Chip,

Just a wild guess, you don't have by accident a field or method with the same 
name? Is your constant correctly styled in the method editor?
Is your constant typed as longint in 4D Pop? Or as auto?

HTH
Koen

> Op 26 jun. 2018, om 00:14 heeft Chip Scheide via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> The Konstant tokenizes, and in the debugger shows as value 2 (not "2").
> When I am in the called method (utl_menu_Set_Menu_Bar) I am getting a 
> run time error
> "no menu with that number"
> 
> examining the value of $1, and $Menu I find the value is 0 (zero) -- 
> see code below




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: XSLT APPLY TRANSFORMATION Replacement

[Koen Van Hooreweghe via 4D_Tech]

Hi Doug,

Al always, the Miyako well full of plugin magic: 
https://github.com/miyako/4d-plugin-xslt

Kind regards,
Koen

> Op 22 jun. 2018, om 10:04 heeft Douglas Cryer via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I have a client who has just hit a problem with a deprecated command _o_XSLT 
> APPLY TRANSFORMATION
> 
> Seems to be two issues.  One the command is deprecated and two the command 
> returns a message that it cannot be executed on server.
> 
> Does anybody have a viable direct replacement for this command they would 
> care to share.  It is not a command I have ever used or know much about so I 
> am looking for as quick a fix as possible.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Error on HTTP request on v16B6

[Koen Van Hooreweghe via 4D_Tech]

Hi David,

If you have access to the 4D forums, check out: 
http://forums.4d.com/Post//24265962/1/

You could change the TLS minimum version just before your http request call:  
SET DATABASE PARAMETER(Min TLS version;TLSv1_1)
Its worth a try, but for me it did not work.

There seems to be a bug in 4D v16R6 (and v17), which makes certain https sites 
(like https://www.google.com) unreachable from within 4D and only happens in 
certain situations. But I don't have details.

I've been hit by this issue a few weeks ago. I recently did a new test and 
suddenly all was working fine again. No changes in my network config. ISP?.

My findings are:
- macOS (two different versions 10.11.x and 10.13.x) on two different machines 
(iMac MacBook Air) in the same network
- 4D v 16R6 and v17ß
- rebooting machine did not help
- curl from terminal was OK
- 4D Windows in Parallels on the iMac was also working fine
- MacBook in different network was working fine again
- iMac connected through iPhone G4 hotspot was working fine too

4D Tech assistance confirmed the issue was reproduced by QA and is under study 
by Engineering.
Lets hope they find a quick fix.

HTH
Koen

> Op 21 jun. 2018, om 11:00 heeft David Samson via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> This is an urgent issue since it is holding up card payments.
> 
> We are getting the error below on executing HTTP request to a payment
> gateway. They assure me they are on TLS1.2.
> 
> This was after un upgrade from 4D v16.3 to v16R6 all Windows and 64bit
> server.
> 
> Error when executing the method "SagePay_PaymentRequest" at line number 131
> 
> Error #30
> 




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: MySql login problem

[Koen Van Hooreweghe via 4D_Tech]

Hi Pat,

Could there be an access hosts filtering setup up on the MySql database?
Maybe a change in the customers WAN ip address causes the access denial?

Just a thought.

Kind regards,
Koen

> Op 15 jun. 2018, om 20:57 heeft Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> Got a client who uploads data from their CatBase (4D) database to a MySql
> db on their web server.
> This has been working just fine since they went live with it a few weeks
> ago.
> Suddenly they are getting a 1045 Access Denied message when they try to
> connect to it. Of course it works just fine for me :) I've checked that
> they have all the correct credentials.
> 




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Delay process bug

[Koen Van Hooreweghe via 4D_Tech]

Hi Jim,

Is there somehow PAUSE PROCESS/RESUME PROCESS involved?

I don't know if this has something to do with our issue, but I'd like to share 
a change in behavior (bug?) between v15 (and older) and v16 (and later).
Also struggling with a process not waking up after the delay time, I found 
pause process/resume process on a delayed process does not work as I would 
expect in 4D v16 and later.
Following scenario:

A process is running and is delayed for eg 1 minute. If the process is paused 
and resumed within that minute, the process won't wake up. Neiter immediately, 
neither after the delay time. Tested on Mac (v16 and 17 32/64). Another call to 
RESUME PROCESS will wake it immediately, another DELAY PROCESS will wake it 
after the new delay time.

This behavior is different in v15. This is what I do and what I see in the 
runtime explorer:
- start process: Executing
- delay process (3600 ticks): Delayed
- pause process (within the delay time): Delayed
- resume process (within the delay time): Executing

V16
- start process: Executing
- delay process (3600 ticks): Delayed
- pause process (within the delay time): Delayed
- resume process (within the delay time): Paused (!)

- resume process or delay process (0 ticks): Executing

I don't know what the standard behavior should be, but above is what I 
discovered. The work around is rather easy: when you want to resume a process, 
check if its status is paused or delayed. If paused: resume, if delayed: 
delay(0). Or don't use resume, but always use delay(0). Because a delayed or 
paused process will always wake up on delay(0).

HTH
Koen

> Op 12 jun. 2018, om 21:43 heeft Jim Crate via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> Our server (macOS 10.11, 4D 16.3 HF3 64-bit) hit this bug again last week 
> after being up for about 22 days. There are 2 separate processes that run 
> periodically, both at the same time stopped waking from DELAY PROCESS. The 
> Server window also was not showing the 4D username in the user list, although 
> IP, machine name, and login date/time were displayed.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Pointer to field using field name

[Koen Van Hooreweghe via 4D_Tech]

Hi Alan,

If you have the table number, you can loop over the fields of that table and 
compare the name to the given name to get the field number and thus the field 
pointer.

Something like:

//$foundtable is the table number
//if pointer given, $foundtable := Table($tablepointer)

For ($i;1;Get last field number($foundtable))
If (Is field number valid($foundtable;$i))
If ($fieldname=Field name($foundtable;$i))
$foundfield:=$i//found it
$i:=Get last field number($foundtable)+1//jump out of 
loop
End if 
End if 
End for 

$ptr:=Field($foundtable;$foundfield)//get the pointer

HTH
Koen

> Op 17 mei 2018, om 18:19 heeft Alan Tilson via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> Is it possible to extract a pointer to a field from the table number or
> pointer and the field name?
> 
> I'm loading a field using EXECUTE FORMULA and building the
> [tablename]fieldname into the formula, which serves my purposes but seems
> rather awkward!
> 

**
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: Macro to check that local variables are declared in a method?

[Koen Van Hooreweghe via 4D_Tech]

Hi Bob,

Take a look at 4D Pop. There is such a thing in dhe 4D Pop macros part.

HTH
Koen

> Op 27 apr. 2018, om 17:54 heeft Bob Miller via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> Has anyone created a macro to check a method to make sure all its local 
> variables are declared?
> 




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Web Area display PDF

[Koen Van Hooreweghe via 4D_Tech]

Hi John,

If you keep the pdf way, also check out the excellent PDFViewer plugin from 
pluggers.nl . I have been using this on Mac for a long 
time already. No Windows experience.

HTH
Koen

> Op 21 apr. 2018, om 01:04 heeft John Baughman via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> Maybe I need to move away from the Web Area. What I have is a complex form 
> with 6 header sections. To create the document for display in the web area, I 
> am building the report with these headers using Print form in multi level For 
> loops and printing it to a pdf document on disk.
> 
> The only reason I need the document is to display it in the 4D web ares. This 
> was working when I first created it over a year ago. The report itself is 
> rarely used. After moving to v15, or perhaps earlier it stopped working and 
> no-one told me about it. Now it has become an issue
> 
> Is there another way to do this? In other words is there a way to build the 
> report for display direct;y in 4D?




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Downloading files via FTP

[Koen Van Hooreweghe via 4D_Tech]

Hi Keisuke,

I think Stephanie Tirtiat did a very nice job creating the bug report following 
my TAOW case and made the regression part pretty clear (see details below). But 
the most frustrating part is that it took 4D engineering more than 9 months to 
provide a work around. Bug report was created on june first 2017, I got the 
work around info on march 8th 2018. And even then there was still mentioned 
that the engineering was working on a fix…
Three weeks later the bug was marked as ‘standard behavior’. I don’t understand 
why one keeps telling nothing has changed.

Agreed, I do have a valid work around and the bug only causes trouble in a very 
specific situation. Agreed it won’t be fixed. But this whole story took me lots 
of time to investigate, reproduce, isolate, create demo db, report, follow up 
and makes me (yet again) wonder why I went through all this trouble.

Kind regards,
Koen

-
Bug report submitted:
-

ACI0096897 : [135969] FTP_receive error 10048 or 10049 with a specific FTP 
server

-
CONTEXT:
-
Systems or/and 4D versions or/and hardware where the bug happens:
   - Windows 7
   - MacOSX 10.12.4
   - v15.3 public, v15.3 HF1 (MacOSX only)
   - v15.4 build 212262
   - v15R5 public
   - v16.1 build 212261
   - v16.0, 16.1 public
   - v16R3 build 212310 (MacOSX only)
   - Main build 212307 (MacOSX only)

Systems or/and 4D versions or/and hardware where the bug doesn't happen:
   - Windows 7 with v15.3 public, v15.3 HF1, v16R3 build 212310, Main build 
212307

-
SUMMARY
-

Since v15.4 FTP_receive returns error 10048 with a specific FTP Server while it 
was ok with v15.3 (on Windows).

There is a regression between version 15.3 and v15.4 for a certain ftp server.
I have only been able to reproduce this problem on one particular ftp server. 
As this is an ftp server of an other company I don't have details on which kind 
of server it is.
In 4DIC v15.3 (206770) FTP_receive works as expected, but with v15.4 (211153) 
an error 10048 or 10049 is returned. The same issue happens on v16.1/v16R3

There is also no problem when using a vanilla FTP Client application (like 
Cyberduck) or OSX command line client.


NOTE:
A test database has been provided with credentials for 4D. It is a test 
account, but nevertheless this info is confidential and should be handled with 
caution.

> Op 22 apr. 2018, om 00:59 heeft Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I would encourage you to make your case for regression on TAOW.
> I did not see "use an old build" being suggested as a workaround,
> which might mean that the regression aspect has been overlooked by 
> engineering.

**
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: Downloading files via FTP

[Koen Van Hooreweghe via 4D_Tech]

Hi Keisuke,

Nope, no different cases. It is that very bug report ACI0096897.

This bug report was created following my TAOW report. The issue was confirmed 
to be reproduced with v15.4 and it was OK with v15.3. 

Precisions:
on MaxOSX 10.12.4 I get the error with both 15.3 (public and HF1) and 15.4 
(212262).
on Windows 7 I get the error with 4D v15.4 (212262).

7 months later I even got a message there was a fix done (which imho means 4D 
engineering did aknowledge it as a bug at that time), but this fix was not 
validated by QA. And another 3 months later the bug was set as standard 
behavior and I got some details and a work around.

The problem also appears only on certain ftp servers, but the one I need to 
connect to is not under my control and I don’t know what they are using. The 
welcome message says the remote system type is unix.

Since the date I was hit by this issue (when upgrading to v15.4) I have 
successfully kept using an older version of the 4D Internet Commands with the 
newer 4D versions. All is still working fine! But when switching to a later 
version of the plugin, the errors appear. Something has been changed in between 
those two versions.

To be 1000% sure, I just tested once more while writing this message.

On Mac 10.11.6. 4D version 15.5 build 218240. 4D Internet Commands version 15.3 
build 206770.
FTP login, change dir, get dir list, fetch first file. No problem, file 
received.

Shut down database, change 4D Internet Commands to build 208269 (version number 
is 15.4). Same Mac, same OS, same ftp server, same 4D version, same database, 
just another plugin version: error 10049 returned by FTP_Receive command, no 
file retreived. QED.

Kind regards,
Koen


> Op 21 apr. 2018, om 21:49 heeft Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> it is possible that we are referring to different cases.
> 
> ACI0096897, which has been classified as "standard behaviour",
> is about Internet Commands issuing a specific FTP command,
> and a specific FTP server responding to that command with an error .

**
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: Downloading files via FTP

[Koen Van Hooreweghe via 4D_Tech]

Hi Keisuke,

If something is working fine (for years and different 4D versions) and it 
doesn’t work any more in a new version (while the old version is still OK). 
Isn’t that called a bug or regression?

Unfortunately it took engineering more then 9 months to provide a valid work 
around. Fortunately I can live with that work around.

If it has to be fixed probably depends on how many other people are having this 
issue. I guess I might be the only one until now. Nevertheless, it is still a 
bug.

Kind regards,
Koen

> Op 21 apr. 2018, om 00:52 heeft Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> my understanding is that it is "standard behaviour",
> in that the behaviour is expected according to how 4D Internet Commands was 
> designed.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Downloading files via FTP

[Koen Van Hooreweghe via 4D_Tech]

Hi Pat,

Could you try to navigate to the right directory on the ftp server and then 
call FTP_Receive with only the file name in the filepath.

Something like:

$hostpath without trailing /, like public_html/Anderson/uploads

FTP_ChangeDir(vFTP_ID;$hostpath)

FTP_Receive(vTTP_ID; $atDldFileNames{$i} ;$localFilePath;1)

HTH
Koen

> Op 20 apr. 2018, om 14:39 heeft Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> $localFilePath:=$localPath+$atDldFileNames{$i} // eg: "Macintosh
> HD:Users:patbensky:clients:Anderson
> Vacations:images:10--MedicineTrailSnow.jpg"
> 
> $filepath:=$hostpath+"/"+$atDldFileNames{$i} // eg:
> public_html/Anderson/uploads/10--MedicineTrailSnow.jpg
> 




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Downloading files via FTP

[Koen Van Hooreweghe via 4D_Tech]

Hi Pat,

This might be related to a bug I discovered about a year ago. Started from 
v15.4 and also happens in v16.

No fix yet, but the culprit is according to 4D engineering the 7th (times) 
parameter in thE FTP_GetDirList command. If you don’t need the modification 
times, leave out this parameter and try again.

This seems to be an issue with certain ftp servers. 4D sent me some details I’m 
willing to share, but let’s see first if it is the same issue.

HTH
Koen

> Op 20 apr. 2018, om 14:39 heeft Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> $error:=*FTP_GetDirList *(vFTP_ID;$hostpath;$atDldFileNames;$aiDldFileSizes;
> $aiDldFileKinds;$adDldFileDates;$aiDldFileTimes)
> 
> // $err is always -1 or 10060 (file not found)
> 
> 



Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Web Area display PDF

[Koen Van Hooreweghe via 4D_Tech]

Hi John,

If I remember correctly there used to be an issue with the Acrobat plugin and 
Web areas. This might be old info and the problem might be solved, but maybe 
its worth to give it a try. Remove the AdobePDFViewer plugin in the Interinet 
Plug-Ins folder of one of the Library folders (system or user).

HTH
Koen

> Op 20 apr. 2018, om 10:27 heeft John Baughman via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> 1. What am I doing wrong or missing?




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: v13 - Custom Constants & 4D Pop

[Koen Van Hooreweghe via 4D_Tech]

Hi Chip,

The User Constants.xlf file is located inside your database package in the 
Resources folder.
You can indeed move this file to other databases, just like any other 
‘Resources' file. Translation xlf files inside language (.lproj) directories or 
images.

HTH
Koen

> Op 11 apr. 2018, om 19:19 heeft Chip Scheide via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> 1 - where does 4D pop put the cliff file for custom constants? (Mac)
> 2 - can I move this file around (i.e. to other database/systems)?




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Zip file with password...?

[Koen Van Hooreweghe via 4D_Tech]

Hi Robert,

I had to investigate a similar request a while ago. As far as I know, ditto can 
only extract password encrypted zip archives, not create them.

But you might try with the zip command (as Chip also mentioned):

$command:="zip -r --encrypt --password "+$mypassword+" "+$ZipFile+$SourceFile

Beware the source en destination paths are the other way around as in the ditto 
command. Add double quotes where needed.

HTH
Koen

> Op 9 apr. 2018, om 23:32 heeft Robert ListMail via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> LAUNCH EXTERNAL PROCESS("ditto -c -k -X --norsrc "+Char(Double 
> quote)+$SourceFile+Char(Double quote)+" "+Char(Double 
> quote)+$ZipFile+Char(Double quote);$in;$out;$err)




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Signed emails to the list?

[Koen Van Hooreweghe via 4D_Tech]

Hi Tim,

I think text signatures used to work, but not graphical ones.

HTH
Koen

> Op 29 mrt. 2018, om 18:36 heeft Timothy Penner via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I don't think that sending signed emails to the iNUG has ever worked... 
> However, I just made a small modification to the list settings that may start 
> to allow it to work;  would you like to retry sending a signed message?




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Test 4D Server using 4D Developer Professional license

[Koen Van Hooreweghe via 4D_Tech]

Hi Jim,

4D sales people should correct me if I’m wrong. But AFAIK a 4D Develop license 
does not include a 4D Server license. If you have a partner contract (Silver, 
Gold), you will get a 4D Developer license as well as a separate 2-user 4D 
Server license for testing purposes.

Kind regards,
Koen

> Op 22 mrt. 2018, om 15:00 heeft Jim Crate via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> I thought 4D Developer Professional included a 2-user 4D Server license so we 
> could test using 4D Server without having to run a separate instance on the 
> production server. However, when I launch 4D Server, it asks for activation. 
> It appears to accept my 4D Developer Professional license but then does not 
> open a structure. If I relaunch 4D Server it asks to be activated again. Will 
> Server no longer run on a developer license? If so, this should be 
> reconsidered. I’d really prefer not to have to debug On Server Shutdown on 
> the production server.
> 
> 4D 16.3 on macOS 10.13.





Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: What's the easiest way to edit an existing constants file?

[Koen Van Hooreweghe via 4D_Tech]

Hi Dave,

Is there a reason why you cannot edit your existing constants file using the 
same 4D Pop component?

Kind regards,
Koen

> Op 8 mrt. 2018, om 00:31 heeft Dave Nasralla via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I found the 4DPop_Constant_Editor for creating a new constants file.
> How do I edit one that already exists? I'd rather not use a text
> editor. (I looked at a custom constants .xlf file and the syntax did
> not seem overly obvious to me.)




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Import from Excel

[Koen Van Hooreweghe via 4D_Tech]

Hi Ferdinando,

Export from Excel to text file (comma delimited, tab delimited). And then use 
the 4D import tool or write your own code (receive packet,…)

HTH
Koen
 
> Op 7 mrt. 2018, om 11:06 heeft stardata.info via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I use 4D V15 or V16 someone know how i can to import from excel?




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Stored procedures not waking up?

[Koen Van Hooreweghe via 4D_Tech]

Hi Keith,

Last week I discovered a possibly related issue with processes not waking up.

I have a process, p1 which runs in a loop, executes some code and delays itself 
for a certain time.

code:
//Method1
<>abort:=False
<>p1:=Current process
$delay:=30*60  //beep every 30 seconds
Repeat 
BEEP
DELAY PROCESS(<>p1;$delay)
Until (<>abort)

Just start Method1 as a new process and open the runtime explorer to watch the 
status.

If another method pauses p1 and resumes it within the remaining delay time, the 
process p1 status goes from delayed to paused. This way p1 stays paused until 
it gets a (second) resume from somewhere else.

Eg:

PAUSE PROCESS(<>p1)
RESUME PROCESS(<>p1)
TRACE
<>abort:=True

If this code is run (pause immediately followed by resume) while the status of 
p1 is delayed, the process will stay in status delay until the delay time has 
passed and then change to paused.

This worked fine in v15. I don’t know if this is actually a bug, but here is a 
change in behavior between v15 and v16.
In v15, when running pause and resume, the (delayes/paused) process continues 
immediately (beeps) and then waits again in the next delay.

Its like in v16 resume process does not work correctly when a delayed process 
is paused.
In my project I found a work around, I did not report a bug.

HTH
Koen
 
> Op 5 feb. 2018, om 09:15 heeft Keith Goebel via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> For some time, on this list, there has been talk about a v16 problem where, 
> periodically, stored procedures that have been paused will not wake up. The 
> reports I’ve seen have indicated there is no way to duplicate the problem on 
> demand.
> 
> We are currently in 4D v15.2 and want to move to v16 , but the thought of 
> this happening to us is so scary that we have held off, waiting for 4D to fix 
> it.
> Today I was informed that there is no 4D registered bug for this problem.
> I was amazed, and am now wondering if we have been remiss in not upgrading to 
> v16.3.
> 
> All thoughts on this will be gratefully received.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: localisation (again)

[Koen Van Hooreweghe via 4D_Tech]

Hi Peter,

FWIW I just tested this on my belgian localized OSX system (using decimal 
comma) and it is working as expected.

Kind regards,
Koen

> Op 13 dec. 2017, om 12:45 heeft Peter Mew via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> The string looks like "12345.12345" and the Conversion looks like
> 
> C_REAL($Number)
> C_TEXT($NumString)
> $NumString:-"12345.12345"
> $Number:=Num($NumString;".")
> 
> On a UK system $Number = 12345.12345
> On a German system $Number = 12345
> 
> any ideas would be very welcome
> Im considering using replace string on $numString to replace "." with the
> local separator, in this case ","





Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: HTTP Request PATCH

[Koen Van Hooreweghe via 4D_Tech]

Hi Doug,

There is no PATCH constant defined in 4D, but you can use “PATCH” as string for 
http method as the first parameter:
HTTP Request(“PATCH”;$url;…)

The other constants are just strings for the other method keywords: GET, 
POST,...

HTH
Koen

> Op 22 nov. 2017, om 11:15 heeft Douglas Cryer via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> But there is no PATCH method in 4D.  I tried using both PUT and POST and both 
> return errors.  At this point I do not know if this is a 4D limitation or 
> something to do with the body I am sending.  I just get back a 500 error: 
> with the message:
> 



—
Koen Van Hooreweghe
—



**
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: Debug window messed up

[Koen Van Hooreweghe via 4D_Tech]

Hi John,

That’s weird. Which 4D, which platform?
I tested Vincents trick on Mac in 4D v15.5. My own method color settings 
persisted.

Koen

> Op 14 nov. 2017, om 10:42 heeft John Baughman via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> If you do it with a method with a break point or TRACE, the method window 
> preferences are reset as well. When I tried this method I lost all of my 
> color settings for Method windows. Pain in the butt resetting them back. Not 
> good.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Debug window messed up

[Koen Van Hooreweghe via 4D_Tech]

But that seems to be a ‘hard reset’, the saved expressions are also gone.

Koen

> Op 13 nov. 2017, om 17:55 heeft Vincent de Lachaux via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> Create a method with just one line : TRACE
> 
> Run the method with the shift key down will restore the debug window.





Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Method to put a c-obj (or JSON) into a hierarchical list

[Koen Van Hooreweghe via 4D_Tech]

Hi Tim,

I’ve been bitten by this a while ago. There is a difference in behavior 
interpreted and compiled. Eg following piece of code:

 1 C_OBJECT($obj)
 2 C_TEXT($text)
 3 C_LONGINT($long)
 4
 5 OB SET($obj;"property";"value”)
 6
 7 $text:=OB Get($obj;"nonexistent")
 8 $text:=OB Get($obj;"nonexistent";Is text)
 9
10 $long:=OB Get($obj;"nonexistent")
11 $long:=OB Get($obj;"nonexistent";Is longint)
12
13 ON ERR CALL("Errorhandler")
14 $long:=OB Get($obj;"nonexistent")
15 $long:=OB Get($obj;"nonexistent";Is longint)
16 ON ERR CALL(“”)

Interpreted: no error on lines 7 and 8, error on line 10 (54 - Argument types 
are incompatible)
no error on line 14, but the error handler method wil be executed

Compiled: no error on lines 7 and 8, error on line 10 (-20007 Attempting to 
retype by using a pointer)
On line 14, the error handler is not executed, but 4D displays error -20007 
(Attempting to retype by using a pointer)

I would advice to always use the typing parameter (or test using OB is defined)

HTH
Koen



> Op 30 okt. 2017, om 20:20 heeft Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> I did not know that if you include the type in OB GET and the property does 
> not exist in the object you don’t get an error.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Method to put a c-obj (or JSON) into a hierarchical list

[Koen Van Hooreweghe via 4D_Tech]

Hi Kirk,

Thanks for the info. I also think this is not a huge task to get the changed 
data back into 4D, but or the time being I don’t need this feature. So I 
haven’t tried it yet.

Kind regards,
Koen

> Op 30 okt. 2017, om 16:50 heeft Kirk Brooks via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I wouldn't think it would be very difficult to get the data back into 4D.
> You could 'push' it with js using the 4D callback approach Tim Penner
> writes about here: http://kb.4d.com/assetid=77177 
> . I've really found that
> useful.



—
Koen Van Hooreweghe
—



**
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: Method to put a c-obj (or JSON) into a hierarchical list

[Koen Van Hooreweghe via 4D_Tech]

Hi Kirk,

Same idea as Jeff. But I'm using jsoneditor 
(https://github.com/josdejong/jsoneditor 
) in a web area to display objects.

Its an editor, but I have only used it to display an objects content. Haven’t 
tried to get the modified data back to 4D.

HTH
Koen

> Op 29 okt. 2017, om 22:26 heeft Kirk Brooks via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> Just display a c-obj in a hierarchical list. I want to mimic the way the
> debugger shows c-objects.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Tip: Exporting to a target folder in a package

[Koen Van Hooreweghe via 4D_Tech]

Hi Peter,

Select folder allows you to navigate into a package if you add the Package open 
constant as ‘options’, third parameter.
Same for Select document fourth parameter.

HTH
Koen

> Op 24 okt. 2017, om 12:29 heeft Peter Jakobsson via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> Unfortunately, if you use 4D’s desktop navigation commands like “Create 
> Document(“”)” or Select Folder and the like, to allow the user (me !) to 
> locate the target folder for the export, it doesn’t let you navigate inside a 
> package (which is where all my destination folders are since they are in the 
> Resource folder for the structure).
> 





Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: FORM SET OUTPUT -> project form

[Koen Van Hooreweghe via 4D_Tech]

Hi Pat,

FWIW, to preset the PRINT SETTINGS, you should use PAGE 
SETUP(“projectformname’).

HTH
Koen

> Op 17 okt. 2017, om 14:27 heeft Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> This was in a database that was updated from a previous version of 4D. I
> think that previously you called FORM SET OUTPUT to specify the default
> settings for the PRINT SETTINGS dialog - e.g. page orientation. But this
> isn't necessary any more.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: FORM SET OUTPUT -> project form

[Koen Van Hooreweghe via 4D_Tech]

Hi Pat,

Why would you want to do that?
FORM SET OUTPUT sets the current form for a table. If you don’t pass a table, 
the command takes the default table, but the form must belong to that table.

HTH
Koen

> Op 16 okt. 2017, om 12:39 heeft Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> Using v14:
> 
> I get an error with
> 
> *FORM SET OUTPUT*("ReportHeaderLandscape")
> 
> ​"There is no table to apply the command to"
> 
> So how do you set the output form for a project form?
> 
> Pat
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 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
> **

**
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: Import from RTF

[Koen Van Hooreweghe via 4D_Tech]

Hi Ferdinando,

Open it in 4D Write. 

HTH
Koen

> Op 9 okt. 2017, om 17:41 heeft stardata.info via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I use 4D V15 on windows and i need to import from an RTF file.
> 
> Is possible to do using 4D?

**
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: Post Key command not working in converted 4Dv16 database

[Koen Van Hooreweghe via 4D_Tech]

Hi Ken,

Any other buttons on the form mistakingly having the same shortcut?
I think 4D is using the object level to determine which button actually gets 
clicked.

Koen

> Op 9 okt. 2017, om 15:41 heeft Ken Daniel via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> Koen & Steve, thanks for the tip, but in this case I am using POST
> KEY(Character code(".");Command key mask) and had the shortcut of Ctrl .
> assigned to a button. It only fails to work in this one converted database.
> I've converted another database to v16 for a different application and it
> works fine. I've compared the two databases and can't discern any
> difference. In another test, if I execute POST KEY (Character Code("a")), I
> can see it populate a variable field with the letter "a", but it just won't
> execute the code assigned to the button with that shortcut. Ken




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Post Key command not working in converted 4Dv16 database

[Koen Van Hooreweghe via 4D_Tech]

Hi Ken,

What particular shortcut are you using?
Also check the case of the character you are using, as Stephen pointed out. In 
v14 I discovered a bug when running the command POST KEY(Character 
code("A");Command key mask). This was fine in v13 and earlier, but crashes v14, 
v15 and v16.
My report got bug number ACI0093238 in july 2015, but as I just tested in v16.2 
it has not been fixed yet.

On the other hand the code should be: POST KEY(Character code(“a");Command key 
mask), which works fine in v14 and later.

IIRC in compiled mode it seemed to be working, but 4D would crash a bit later.

Kind regards,
Koen

> Op 8 okt. 2017, om 15:21 heeft Ken Daniel via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> All, I'm having a problem with the Post Key command not working in a
> database converted from 4Dv14 to v16. Post Key works fine in 4Dv14, and
> works in 4Dv15 and even in a newly created database in v16, but not in my
> converted database. I've tried resetting the Preferences and Database
> Settings to Factory Settings and changing event actions, but nothing has
> worked. Anyone have any suggestions as to what the problem may be? Thanks,




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Number format

[Koen Van Hooreweghe via 4D_Tech]

Space is not needed. But comma and point make a difference in US of EU notation.

Koen

> Op 4 okt. 2017, om 16:24 heeft Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> That's the way I've always been able to make it work - with the space for
> the zero condition.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Number format

[Koen Van Hooreweghe via 4D_Tech]

> Op 4 okt. 2017, om 14:15 heeft stardata.info via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I know this and i try, but not work.
> This format not display the value: 0,85

> ###,##0;-###,##0;

Ferdinando,

This depends on your regional settings and the 4D compatibility settings.
From one of the recent 4D versions (v13 and higher) uses by default US 
notation, but converts automatically to display in your regional settings.

The provided format is imho a us format for displaying whole positive and 
negative numbers up to one hundred thousand. No zeroes.

You must add placeholders for the decimals. Eg: ###,###0.00;-###,##0.00; or 
###,##0.##;-###,##0.##; if you don't want to see 100,00 but 100.

In full European notation you might need to switch dot and comma: 
###.###0,00;-###.##0,00

See: design reference chapter filters and formats for more info 
(http://doc.4d.com/4Dv15/4D/15.4/Filter-and-format-codes.300-3285353.en.html)

HTH
Koen



Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: Server Process "Frozen"-ish

[Koen Van Hooreweghe via 4D_Tech]

Dani,

We’ve had the same problem. After switching from v15 to v16 (both 64bit) the 
server crashed regularly upon creation of PDF documents with PDF Creator.
We planned to move the batch generation of those pdf docs to a separate client, 
but forgot to change some settings causing some types of docs still being 
generated on the server.
This is a W10 server.

On another site running the same app, but using W2008 no issues reported so far 
(running for some weeks).

Did not investigate further because the client is running fine and we plan to 
move away from PDF Creator.

Kind regards,
Koen

> Op 11 sep. 2017, om 15:32 heeft Dani Beaubien via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> We have run into issues where the server is running on windows 64bit and it 
> is producing PDFs using PDF Creator directly. Our solution was to move away 
> from doing that and using php and FPDF to create the PDFs instead.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: 4D v16.2 false record locks

[Koen Van Hooreweghe via 4D_Tech]

In the case I mentioned, there were no triggers involved. No fancy stuff 
either. Just a record which is being automatically locked because it was opened 
in an input form.
But I don’t know how the user left the building…

Koen

> Op 19 sep. 2017, om 22:21 heeft Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> This is a great point. I wonder if any of the users reporting this problem 
> have triggers that are doing some “fancy stuff” that could be causing this. 




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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: v13.6 - 2 servers same network, how to make it work

[Koen Van Hooreweghe via 4D_Tech]

Hi Alan

First of all, if the 2 servers are on the same network but on a different 
machine, there is no need to change the publication ports. Those 2 machines 
will have different IP addresses and you will see both in the 4D connection 
dialog. Changing ports is only needed if you run 2 4D servers on the same 
machine. I suppose this is what you want?

4D Server needs only 2 ports for normal C/S operation. The Application port 
(19813 default) and the 4DDB Server port. The latter always being the 
application server port + 1 (thus default 19814). If you change the application 
port to eg 20005, the 4DDB will run on 20006.

If you use the SQL server (default 19812) on both apps, you might need to set 
this too.

There are of course other ports: http, https which you might need to change if 
running the webserver on two different 4D servers on the same machine.

There is one issue on changing the publication ports. The 4D server not running 
on its default port will not be automatically visible in the connection dialog.

HTH
Koen

> Op 19 sep. 2017, om 17:57 heeft Alan Tilson via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I see where to change 2 port numbers but not 3.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
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
**