Re: PDF Creation

[Two Way Communications via 4D_Tech]

Actually, Windows10 also has a built-in PDF printer driver

Regards,

Rudy Mortier
Two Way Communications bv 




> On 9 Oct 2020, at 09:05, Koen Van Hooreweghe via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 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
> **

**
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 Friday Happy Hour on ZOOM

[Two Way Communications via 4D_Tech]

Hi guys,

I saw it too late … but I think this is a great idea! when is the next Happy 
Hour?


Regards,

Rudy Mortier
Two Way Communications bv 




> On 23 Apr 2020, at 21:53, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I know. It is hard to plan a party in so many time zones.
> 
> On Thu, Apr 23, 2020 at 12:41 PM Wayne Stewart via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> 8AM for me.
>> 
>> “I exercise strong self control. *I never drink anything stronger than
>> gin* before
>> breakfast.”
>> 
>> W. C. Fields
>> 
>> 
>> On Fri, 24 Apr 2020 at 04:37, Kirk Brooks via 4D_Tech <
>> 4d_tech@lists.4d.com>
>> wrote:
>> 
>>> Hey folks,
>>> 
>>> I’m hosting a 4D Friday Happy Hour tomorrow on ZOOM:
>>> https://zoom.us/j/91959066132
>>> 
>>> Starts at 3PM PDT (7 EDT) and will go until I fall asleep or everyone
>>> leaves.
>>> 
>>> It’s not as good as hanging out together at the Summit but let’s share
>> what
>>> we’re drinking, say hello, laugh at some not-very-funny stories and enjoy
>>> each other’s company.
>>> 
>>> If it works we can figure out how to do it again.
>>> 
>>> --
>>> Kirk Brooks
>>> San Francisco, CA
>>> ==
>>> **
>>> 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
>>> **
>> 
>> --
>> 
>> Regards,
>> 
>> Wayne
>> **
>> 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
>> **
> 
> 
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ==
> **
> 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)
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: HMAC SHA256 in native 4D code

[Two Way Communications via 4D_Tech]

Hi Bruno,

Thank you very much.
This does in fact generate the correct JWT.

I did check where the differences are,  comparing to my code:
Apparently, when using the php function ‘hash_hmac’, or when using Openssl 
through LEP, I get another signature than the one I get from your component.

I am not sure why that is, since the input is exactly the same. 

Anyway, a big thanks. I spent hours trying to generate the JWT with the php / 
openssl and couldn’t figure it out.


Can anyone explain why the results are different? Because I would really like 
to know.


Regards,

Rudy Mortier
Two Way Communications bvba 



> On 21 Mar 2020, at 08:49, Bruno LEGAY via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Ruby,
> 
> I sent you a component which does HMAC 256 and JWT object signing.
> It is all native.
> 
> Lets us know if it works.
> 
> Bruno LEGAY
> A Consulting
> 
> **
> 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: HMAC SHA256 in native 4D code?

[Two Way Communications via 4D_Tech]

I did use PHP execute, then did a Base64 encode on it, and then cleaned ‘+’, 
‘/‘ and ‘=‘.

Still got an invalid signature. 

With the ’True’ parameter, the php function returns binary; often this is empty.
With the parameter set to false, you get what they call ‘lowercase hexies’. No 
clue at all what that means.

The signature is still invalid according to jwt.org 

I will give Miyako’s plugin a try, although I would have preferred to avoid 
plugins.



> On 20 Mar 2020, at 18:10, JBellos via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Hi, 
> 
> I had to spend some time looking into this recently myself. You have two
> options:
> 
> 1 - K. Miyako has a plugin - CommonCrypto. Easy to use.
>   $signature:=HMACSHA256 ($keyData;$stringData;Crypto BASE64)
> 
> 2 - Use PHP execute, but then encode the result (assuming you need to)
> php way if we ever need it - do not delete
> $phpOK:=PHP
> Execute("";"hash_hmac";$sigBlob;"sha256";$stringToSign;$key;True)
> BASE64 ENCODE($sigBlob)
> $signature:=Convert to text($sigBlob;"utf-8")
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 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: HMAC SHA256 in native 4D code?

[Two Way Communications via 4D_Tech]

Hi Spencer,

I have been looking at it, but it does not do what I want to do.

I need to construct a JSON Web Token (JWT)

For that, I need to encrypt a string with a secret key, to obtain the encrypted 
token.
As far as I can see there is no parameter in ‘Generate Digest' to do so.

I tried to use:

PHP 
Execute(“";"hash_hmac";$HMACSHA256;"sha256";($base64UrlHeader+"."+$base64UrlPayload);$key)

but the signature that is being returned does not work with JWT.

I tested it on jwt.io , and it returns ‘invalid’.

So I am looking for other ways to generate this HMAC SHA256


Regards,

Rudy Mortier
Two Way Communications bvba 



> On 20 Mar 2020, at 17:18, Spencer Hinsdale  wrote:
> 
> Does this help?
> 
> https://doc.4d.com/4Dv17/4D/17.4/Generate-digest.301-4882385.en.html
> 
> 
> On 3/20/20, 9:15 AM, "4D_Tech on behalf of Rudy Mortier via 4D_Tech" 
> <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:
> 
>Hi Bruno,
> 
>I was looking in nabble to find a solution for generating HMAC-SHA256 keys.
> 
> 

**
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: Citrix Playbook

[Two Way Communications via 4D_Tech]

Hi Dougie,

My customers run on Citrix on a daily basis.

No such errors, ever.

Regarding the error message, it may be of help to let the Citrix people know 
that 4D is using multiple ports: by default 19812 and 19813, and then 19815 or 
so for SQL server.
You can see on 4D server which ports are actually being used, and you can set 
them to other values.

Hope this helps.

Just curious: how fast (or slow) is the direct client connection in comparison 
to the Citrix 4D client connection?


Regards,

Rudy Mortier
Two Way Communications bvba 



> On 13 Jan 2020, at 13:38, Douglas Cryer via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi folks,
> 
> Most of our clients connect to their databases over the internet directly 
> with 4D in client server mode.  We have one client where they have an company 
> running their IT and do everything via a Citrix connection.  They have been 
> having on-going issues with the connection dropping and causing fairly random 
> 4D errors on the client.   The latest is "Only one usage of each socket 
> address (protocol/network address/port) is usually permitted."
> 
> Some of their people have used the system in direct connection mode for days 
> and do not experience these disconnects.  So we suspect it is an issue with 
> the Citrix setup or the network connection from the Citrix server and the 4D 
> Server.
> 
> We do not know Citrix in any detail nor do we have access to their Citrix 
> Server.  The IT company has no experience of 4D and are blaming it for the 
> issues.
> 
> Does anyone have a Citrix playbook that we could read and pass on to them in 
> order to establish a more sensible dialog.
> 
> Regards,  Dougie
> 
> 
> telekinetix Limited- J. Douglas Cryer
> Phone : 01234 761759  Mobile : 07973 675 218
> 2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
> Email : jdcr...@telekinetix.com  Web : http://www.telekinetix.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
> **

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

[Two Way Communications via 4D_Tech]

Thanks for the insights guys.

I was already suspicious about the whole requirement, because I had a feeling 
this was not correct.

After discussing again with the customer, it became clear that there was an 
error in communication. 
It’s the old dutch / French thing in Belgium, especially if one uses English as 
a way of understanding each other ;-)

Their firewall is set to receive UTF-8 only, but that doesn’t mean that we 
can’t send files that are encoded differently, as long as they are correctly 
embedded in a multiform/data HTTP request.
So I just needed to correctly state everything in the multiform data that is 
being passed to their API…


Regards,

Rudy Mortier
Two Way Communications bvba 



> On 14 Jan 2020, at 04:59, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> alternative solutions for guessing plain text encoding
> 
> https://opensource.google/projects/ced
> 
> also
> 
> https://github.com/miyako/4d-plugin-text-convert
> 
> 
> $err:=CP Get good encodings ($euc;$codepages)
> 
> 
> $err:=ICU Get good encodings ($euc;$encodings;$languages;$confidences)
> 
> but I agree with Koen, to request UTF-8 “encoding” for PDF seems like a 
> misunderstanding by the end user.
> 
> I know Adobe Acrobat phrases it that way
> 
> https://helpx.adobe.com/acrobat/using/file-format-options-pdf-export.html
> 
> but in reality, PDF has an embedded font mapping system for rendering,
> which makes “text encoding” kind of irrelevant for rendering.
> you might have seen PDF that display fine but copy and paste or searching is 
> garbage.
> I think that it the scenario the user want’t to avoid.
> 
> 2020/01/14 2:35、Koen Van Hooreweghe via 4D_Tech 
> <4d_tech@lists.4d.com>のメール:
> FWIW, BBEdit also guesses what the text file encoding could be. It does a 
> good job, but it can be fooled.
> 
> 
> 
> **
> 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
**

Document encoding

[Two Way Communications via 4D_Tech]

Hi All,

An important customer of mine has requested that all documents, sent to him, 
are UTF-8 encoded.
This concerns PDF files, text files, Word, Excel, picture files.

I did some tests, but can’t figure out how to do that.

If, e.g., I look at a pdf file in BBEdit, it says ‘Mac Roman’.

Then I tried to open that file in 4D (v17, UTF-8) with document to blob
then:

DOCUMENT TO BLOB(document;$blob)
$DocBlobtxt:=Convert to text(blob;2027)  // 2027 = MacOS Roman  
TEXT TO BLOB($DocBlobtxt;$docblobUTF8;UTF8 text without length)

It seems to do that correctly, but then, this file cannot be opened in preview 
( Opens, but content is blanc)

The other thing is that I need to know the encoding of the file before using 
‘Convert to text’. That is not always possible.

Is this request feasible to start with?

Any ideas how to accomplish that?   


Regards,

Rudy Mortier
Two Way Communications bvba 



**
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: The future of output forms

[Two Way Communications via 4D_Tech]

Hi John,

That is a very clever solution!

Thanks, I wouldn’t have thought of that!


Rudy Mortier
Two Way Communications bvba 



> On 10 Dec 2019, at 03:04, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> 
> 
>> On Dec 9, 2019, at 4:34 PM, Two Way Communications via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> But this brings me to this question: Will output forms keep being supported 
>> by 4D?
> 
> I doubt they will be depreciated. The same implementation model is used for 
> print forms, and it would not make sense to break something that big with 
> nothing to replace it.
> 
>> 
>> What if I switch to ORDA? From what I see, output forms will not work with 
>> ORDA. (Anybody from 4D: what is 4D’s view on this?)
> 
> With some work, you could make output forms work with ORDA. Just create a 
> single field table and generate a selection the same size as your ORDA entity 
> selection. You can then use Selected record number (or Displayed line number) 
> to load entities.
> 
> John DeSoi, Ph.D.
> 
> **
> 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
**

The future of output forms

[Two Way Communications via 4D_Tech]

Hi Guys,

Like many of you, I have stopped using output forms to display selections of 
records, using listboxes  in stead.

But lately, I have started to use them again. 

Why, you might ask.

Well, quite a number of customers are using laptop/tablet devices. More often 
than not, they will use the touch screen in stead of the mouse.
In this case, the standard height of the listbox rows is to small to 
comfortable select, or double-tab, a single  row.
Another example is on the work floor: touch screen are used to process there 
actions.

I could double or triple the row height, but still, I will not be able to 
design the output like I would design an output form, especially if I also want 
some graphics in it.

The possibilities with output forms are far more flexible. I can put whatever I 
like in the form.

But this brings me to this question: Will output forms keep being supported by 
4D?

What if I switch to ORDA? From what I see, output forms will not work with 
ORDA. (Anybody from 4D: what is 4D’s view on this?)

What is this community’s preference?


Regards,

Rudy Mortier
Two Way Communications
**
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
**

Debug log analyzer v14

[Two Way Communications via 4D_Tech]

Has anybody used the newest Debug log analyzer?


It seems to me that there are some bugs in it.

e.g., when I get the list of ’top’ calls, it lists a specific method as being 
called 22 times in a selected process.

If I than look at all the operations for that process, which is another tab, 
and there, the method occurs in only 3 occasions…


Regards,

Rudy Mortier
Two Way Communications bvba 



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

Object get title and cliff

[Two Way Communications via 4D_Tech]

In my application, all forms are designed to display their content in 2 
languages.

Therefore, I use xliff in static text objects that I use as labels, e.g.  in 
the ’title’ of the static text object, I put ‘:xliff:settings_00/01’

But in some forms, not all the text objects have :xliff: references, but just 
plain text, i.e. “Cancel’ or ‘Validate’

To detect for which forms and for which objects this is the case, I use FORM 
GET OBJECTS  and OBJECT GET TITLE to see if they contain ‘xliff’ or not.
That way, I get a list of text object that need to be changed to an xliff 
reference.

Prior to v17, OBJECT GET TITLE returned the string ‘:xliff:settings_00/01’ if 
the xliff reference was in place, or ‘Validate’, if there was no xliff 
reference, but just plain text.

But now, in v17, OBJECT GET TITLE returns the value of the xliff reference 
(‘Validate’), and no longer ‘:xliff:settings_00/01’

So it’s impossible to differentiate the objects that do not have an xliff 
reference versus those who do.


Is there a way to solve this?


Regards,

Rudy Mortier
Two Way Communications bvba 



**
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 Server Hosting - The Future ?

[Two Way Communications via 4D_Tech]

Hi Kirk,

Very interesting.

Here are my experiences on running a 4D v17R5 server, client on Mac and windows:

If you remember my presentation on the 2018 summit (with the SVG charts for 
temperature mapping), that is the one running on it.

First setup: t2.micro on AWS, smallest possible and free ;-)
Pros:
Very reliable
good for prototyping
handling: quite ok, which has surprised me since it has only 1GB RAM ( ! )
Selection to array / array to selection: tested with + 100.000 records, not to 
bad (seconds rather than minutes)
Lists are displayed in listboxes, using fields. Display is rather immediate.
Detail forms load within 2 to 10 seconds, depending on how many queries in it

Cons:
bandwidth not always sufficient, which drops handling to a crawl, and also 
causes big delays when accessing the instance with RDP

2nd setup: m5.large, 8GB RAM, 2 cores. 160$/month
Pros:
Very reliable
much better handling due to guaranteed bandwidth
a *lot* faster than the t2.micro, very workable

I also put 2 RDP users on it, because the server license includes 2 CALS. Works 
even better, even on a Mac!

I studied what it would take to have more RDP users, but there, I get lost a 
little bit.
From what I understood, I would need an RDP gateway, so another AWS instance, 
and then buy additional CALS for RDP.
That sounds quite expensive…

The other thing I tried recently is S3, because one of my applications manages 
a lot (+ 1,000,000) of documents.

There is a 4Dsummit example that manages all the S3 stuff: very impressive!
Storing and retrieving documents has never been so easy and fast. Cost is 
affordable (by EU standards ;-) )

I would love to here other AWS experiences.

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 13 Oct 2019, at 00:51, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hey Rudy,
> I made a post yesterday on the thread about preemptive processes and how it
> works on VM. Ping me if you can't find it. You may find it useful because I
> posted some actual data from running a demo you can download. I ran it on
> my laptop and an AWS instance. The general specs of the AWS instance are
> there too. It shows the sort of differences I've been seeing. It seems the
> issue with AWS is partly the sheer horsepower you sign up for in terms of
> cores and such but equally important is the amount of bandwidth you commit
> to. Impacts the performance and cost quickly.
> 
> I'm hoping someone with more expertise in this might join the conversation.
> (Balinder? you out there?) It's almost good for directly connecting. I
> think if you are running 4D to power a web server it's quite good. Also, I
> think if you deploy there optimizations you can make in code to
> accommodate the network will become apparent. I quickly saw that places
> where I move data from the server to the client and manipulate it on the
> client are very speedy. ORDA is probably going to help with that. I'm also
> curious if you can set up a situation that cost effective where you run an
> instance for the server and then some others to support clients using RDP
> or the like.
> 
> It is certainly appealing.
> 
> On Sat, Oct 12, 2019 at 2:28 PM Two Way Communications via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Hi Kirk,
>> 
>> I am very interested on your progress with AWS. Can you tell me a little
>> bit more about the kind of 4D DB you are running on it?
>> Are you running client/server or using SQL? Do you notice speed
>> differences between ORDA / Classic 4D?
>> 
>> 
>> I’m asking because I am currently using AWS myself. The response is quite
>> ok, but still way slower than LAN client server.
>> I am thinking of putting more 4D databases on AWS.
>> 
>> 
>> Regards,
>> 
>> Rudy Mortier
>> Two Way Communications bvba
>> 
>> 
>> 
>>> On 10 Oct 2019, at 17:09, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com>
>> wrote:
>>> 
>>> Peter,
>>> I am in the process of moving a database from our own hardware to and AWS
>>> instance. It's true that the most expensive part of setting it up, at
>> this
>>> point, is getting the appropriate amount of band width and throughput
>> speed.
>>> 
>>> The other thing about VM vs metal is the whole pre-emptive process
>>> benefit basically goes away. Thomas Maul has shown this at the Summit.
>>> Having n+ virtual cores doesn't do anything to actually increase
>> processing
>>> speed because the VM is running on whatever is allocated to it.
>>> Theoretically you could have a VM with 4 cores running an instance with
>> 32
>>> cores. So preemptive threading is looking to be mainly a benefit for
>>> compan

Re: 4D Server Hosting - The Future ?

[Two Way Communications via 4D_Tech]

Hi Kirk,

I am very interested on your progress with AWS. Can you tell me a little bit 
more about the kind of 4D DB you are running on it?
Are you running client/server or using SQL? Do you notice speed differences 
between ORDA / Classic 4D?


I’m asking because I am currently using AWS myself. The response is quite ok, 
but still way slower than LAN client server.
I am thinking of putting more 4D databases on AWS.


Regards,

Rudy Mortier
Two Way Communications bvba 



> On 10 Oct 2019, at 17:09, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Peter,
> I am in the process of moving a database from our own hardware to and AWS
> instance. It's true that the most expensive part of setting it up, at this
> point, is getting the appropriate amount of band width and throughput speed.
> 
> The other thing about VM vs metal is the whole pre-emptive process
> benefit basically goes away. Thomas Maul has shown this at the Summit.
> Having n+ virtual cores doesn't do anything to actually increase processing
> speed because the VM is running on whatever is allocated to it.
> Theoretically you could have a VM with 4 cores running an instance with 32
> cores. So preemptive threading is looking to be mainly a benefit for
> companies that run their own hardware and for desktop apps.
> 
> On Thu, Oct 10, 2019 at 5:25 AM Peter Jakobsson via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Hi !
>> 
>> I just finished a 1.5 hour phonecall with a support services manager at
>> the technical services company who supply one of my customers with all
>> their hardware/software/maintenance services.
>> 
>> He basically brought me up to date on “how things work” today which is
>> essentially that everything to do with platforms is now virtualised to
>> allow them to ‘tune’ resources to demand in realtime and provide seamless,
>> no downtime backup. Basically, my 4d Server is now a “cloud service”
>> without me even being aware of it, it’s just that the hardware involved
>> happens to be located on the preises.
>> 
>> In particular we discussed backup configurations for 4D server and this
>> was interesting because, while I requested independent drives for logfile
>> (“journal”) and datafile purposes, he essentially told me to just stick
>> everything on the same drive because it was virtual anyway and had multiple
>> redundancy protection via raid, 15-minute snapshotting etc. He offered to
>> “create” a C: and a D: drive to make me feel better, but pointed out that
>> they’re not much more independent than 2 folders would have been.
>> 
>> CONCLUSON
>> I now realise that the “WAN” / “LAN” distinction is disappearing. He said
>> the only reason the “cloud” solution wasn’t hosted off-site was that they
>> had measured the bandwidth that the customer used and calculated that the
>> cost would be astronomical if it was on AWS or something like that, but in
>> all other respects it was a cloud solution.
>> 
>> I was wondering, how do other major 4D server deployers optimise their
>> deployment strategies to take advantage of this ? It seems a great thing
>> that we are being “floated out to the cloud” without actually having to do
>> extra significant work, but what about things like the backup strategy ? I
>> don’t really like the idea that the log file has the same redundancy system
>> as the main datafile because the whole idea is that the corruption doesn’t
>> get replicated (which is what a RAID system does) and it’s independent at
>> the logical level.
>> 
>> We seem one step away from being able to supply server solutions where
>> “our” customer doesn’t have to host the database server on premises. Is
>> anybody doing this at an advanced level ? (e.g. connecting with 4D client
>> native to a 4D server that’s 3rd-party hosted).
>> 
>> Regards
>> 
>> Peter
>> 
>> **
>> 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
>> **
> 
> 
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> What can be said, can be said clearly,
> and what you can’t say, you should shut up about
> 
> *Wittgenstein and the Computer *
> **
> 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: My 4D Experience Blog

[Two Way Communications via 4D_Tech]

Hi Gabriel,

Very interesting! Thanks!

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 8 Aug 2019, at 15:32, GI - AJAR via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Hi Everyone,
> 
> I would like to share with you my blog about my experience with this great 
> development tool (for those who didn’t see it yet).
> 
> I write my ideas, and experiences I can have within my company AJAR SA as a 
> consultant, first level support and 4D developer.
> 
> I wish to write more posts but it can be time consuming and time is always 
> missing. I have a growing list of stuff I would like to write on it, mainly 
> based on trying to explain how 4D work in deep. Let me know if you have any 
> ideas on how to improve my blog.
> 
> As a small gift for the readers, I have put a small spoil of what coming next 
> in the AJ Suite components. I’m sure it will be well appreciated in the 4D 
> community.
> 
> Here is the link : https://www.my4dexperience.com 
> 
> 
> Thanks for your attention.
> 
> Best Regards,
> 
> Gabriel Inzirillo
> — 
> 4D Developer
> AJAR S.A.
> —
> https://ch-fr.4d.com/ 
> https://www.my4dexperience.com
> twitter: ajar_info
> Tél : +41 (0)32 3422684
> 
> **
> 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: 4DWrite Pro <-> 4DWrite Classic Cross Reference

[Two Way Communications via 4D_Tech]

Hi Tom,

I am facing the same challenge.

I am afraid there is no cross-reference documentation at this moment. I am 
planning on going through the classic 4D Write code line by line and see what 
needs to be done.
It’s not only the code: there is also the paradigm shift to object oriented… 
only translating the lines will not work.


Regards,

Rudy Mortier
Two Way Communications bvba 



> On 24 Jun 2019, at 20:18, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I’ve started a project to convert a large library of 4D Write Classic code to 
> 4D Write Pro.
> 
> I’ve read the various tech notes and blogs about 4DWrite Pro, along with the 
> official 4D documentation, but I have a very hard time keeping track of it 
> all. Some commands are now in the Styled Text theme, others are in WP SET 
> ATTRIBUTES within 4DWritePro and yet others are in the Objects (Forms) and 
> Objects (Language) themes. 
> 
> Is there any documentation which cross references the 4DWrite Classic 
> commands to 4DWritePro? 
> 
> Thanks,
> 
> Tom Benedict
> **
> 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: How can a line of code be separated into multiple lines?

[Two Way Communications via 4D_Tech]

Actually,

‘Selection to array’, ‘Array to selection’ and other commands like Query also 
supports a ‘;*) at the end.

Regards,

Rudy Mortier




> On 19 May 2019, at 06:55, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> selection to array([table]field1;$Array1;\
> [table]field2;$Array2;\
> [table]field3;$Array3;\
> [table]field4;$Array4)
> 
> you use the \ character -- but you need to be careful where you use it.
> you need to use it between 'operators'.
> after a math operation (+-/*), after a semicolon (is generally the easiest),
> 
> you can not use the \ character  before any of the above operators,, or 
> command name
> $sum := $a + $b \
> + $c + $d
> selection\
> to array
> nor can you split a field reference, nor can you split a variable
> [table]\
> field
> $my_var\
> table
> 
> 
> 
>> I know this is done, but I have never used it and cannot find the 
>> answer myself:
>> 
>> How can a line of code be separated into two, and still be 
>> interpreted by 4D as one line?
>> 
>> ex. (obviously not practical)
>> 
>> $all:=$1
>> +$2
>> +$3
>> 
>> equivalent:   ($all:=$1+$2+$3
>> 
>> 
>> thanks,
>> Chris
>> **
>> 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
>> **
> 
> Hell is other people 
> Jean-Paul Sartre
> **
> 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
**

Log integration issue in mirror database

[Two Way Communications via 4D_Tech]

Hi guys,

Has anyone encountered this problem?

Windows server 2008 R2, 4D server v15.4

A customer has this mirror setup, where code in the mirror database integrates 
log files coming from the master database.

The master database writes the log file every 5 minutes to a shared folder on a 
file server.
The mirror database reads the log file as soon as it is complete and integrates 
it. The code only starts reading when the log file has been saved completely by 
the master database.

There are no data operations in the mirror database. It is, however, being 
accesses frequently through SQL (read only).

This setup has been running for months without a problem.

Now, in 1 week time, 3 similar errors occured:

Error -1: 1282 (dbmg): Cannot find any record with that primary key in table xxx
Error -1: 1277 (dbmg): The database journal integration failed at entry #306 
(operation id 113410570).
Error -1: 1186 (dbmg): Log file cannot be integrated into database 

The error mentions a different table each of the 3 times it happened.

To fix this, I delete the mirror database, make a new backup on the master, 
restore the backup on the mirror, and integrate the log files that have been 
created in the mean time.


What can be the cause of this? Indexes? Issues with the data file?


Regards,

Rudy Mortier



**
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 mail in 4D v11 on Mac

[Two Way Communications via 4D_Tech]

I was afraid this would be the answer.

I hope this customer is now convinced he has to upgrade ;-)


Regards,

Rudy Mortier
Two Way Communications bvba 



> On 14 May 2019, at 01:03, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> that won't work.
> 
> besides, STARTTLS is not just about starting with the 587 port instead of 25.
> 
> a transition to TLS must follow.
> 
> not possible in v11 Internet Commands unless you implement SMTP using 
> low-level TCP commands.
> 
> 2019/05/14 7:05、Tom Dillon via 4D_Tech 
> <4d_tech@lists.4d.com>のメール:
> Is it possible to pass the port with a ":587" added to the host?
> 
> 
> 
> **
> 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
**

Sending mail in 4D v11 on Mac

[Two Way Communications via 4D_Tech]

Hi guys,

This is a mystery to me.

I use a simple peace of code to send an e-mail message. This code works 
perfectly in v15 and higher.

$vError:=SMTP_Charset (1;1)
$vError:=SMTP_SetPrefs (1;1;0)
$result:=IT_SetPort (12;587)
$result:=SMTP_New ($smtp_id)
$result:=SMTP_Host ($smtp_id;[Settings]EMA_smtp)
$result:=SMTP_From ($smtp_id;[Settings]EMA_adres)
$result:=SMTP_To ($smtp_id;[Settings]EMA_adres;0)
$result:=SMTP_Subject ($smtp_id;$EMAsubject)
$result:=SMTP_Body ($smtp_id;$EMABody)
$result:=SMTP_Auth ($Smtp_id;[Settings]EMA_login;[Settings]EMA_paswoord;0)  
//0=highest available, 1=plain, 2=LOGIN, 3=CRAM-MD5
$result:=SMTP_Send ($Smtp_id)

However, a customer of mine who still uses 4D v11 (yes, I know…) is running the 
same code, but gets an error 10113 (Error with Authentication)

Any idea how I can get this to work in v11?


Regards,

Rudy Mortier


> On 13 May 2019, at 15:59, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> you could set the highlight row, 
> then do whatever,
> then set the scroll position back
> and (if needed) un set the highlight row
> 
> Chip
> On Sat, 11 May 2019 10:06:22 -0400, Alan Tilson via 4D_Tech wrote:
>> Hello again,
>> What I meant if it wasn't clear is can I get this to work with an Output
>> Form showing a list of records?
>> Thanks!
>> Alan
>> 
>> On Fri, May 10, 2019 at 5:31 PM Alan Tilson > > wrote:
>> 
>>> If I have selected a record HIGHLIGHT RECORDS works fine, but often I
>>> haven't.
>>> Alan
>>> 
>>> On Fri, May 10, 2019 at 5:30 PM Alan Tilson >> > wrote:
>>> 
 Hello out there,
 I cannot get OBJECT GET SCROLL POSITION to work with a list form.
 OBJECT GET SCROLL POSITION([table]field;scrollPosition) leaves
 scrollPosition at zero, wherever I have scrolled.
 Thanks!
 Alan
 
 On Tue, Jun 12, 2018 at 6:31 PM Richard Wright via 4D_Tech <
 4d_tech@lists.4d.com > wrote:
 
> Thanks, Miyako, that works!
> 
> 
>> From: Keisuke Miyako > >
>> To: 4D iNug Technical <4d_tech@lists.4d.com 
>> >
>> Subject: Re: Scroll position of display-type subform
>> Message-ID: <30f1fc18-68d9-4b1b-9413-aba4d7db5...@4d.com 
>> >
>> Content-Type: text/plain; charset="utf-8"
>> 
>> haven't tried,
>> but I wonder if CONVERT COORDINATES would be smart enough to take into
> account the scrolled amount of a detail subform.
>> 
>> 
> http://doc.4d.com/4Dv16/4D/16.3/CONVERT-COORDINATES.301-3651760.en.html 
> 
>> 
>>> 2018/06/12 7:37、Richard Wright via 4D_Tech <4d_tech@lists.4d.com>
> のメール：
>>> I need to get the position of an object on a display-type subform in
> global coordinates and the subform may be scrolled.
>> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
 
 
>> **
>> 4D 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 
>> 
>> **
> ---
> 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 
> 
> **



Met vriendelijke groeten,

Rudy Mortier
Two Way Communications bvba 



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

Runtime error ST GET OPTIONS

[Two Way Communications via 4D_Tech]

Hi,

I am running into a problem when running compiled. In interpreted mode, the 
code works just fine.

This is 4D v17R2 on MacOS High Sierra. I am trying to get the content type from 
a cell of a table in a 4D Write PRO area.


$cellrange:=WP Create range($CellObj;wk start text;wk end text) 

ST GET OPTIONS($cellrange;ST Expressions display mode;$option)
a4TBL_cellContentType{$i}:=ST Get content 
type($cellrange;$cellrange.start;$cellrange.start)

On the 3rd line, I get this error: (but only when compiled)

’The pointer is not properly initialized’

- a4TBL_cellContentType is a longint array (14 elements in this case)
- $i =1
- $cellrange is typed as c_object
- $cellrange.start =114

Any ideas on how to make this work?


Regards,

Rudy Mortier
Two Way Communications bvba 




**
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: Distinct Values on Composite Index

[Two Way Communications via 4D_Tech]

Hi,

I am running into a problem when running compiled. In interpreted mode, the 
code works just fine.

This is 4D v17R2 on MacOS High Sierra. I am trying to get the content type from 
a cell of a table in a 4D Write PRO area.


$cellrange:=WP Create range($CellObj;wk start text;wk end text) 

ST GET OPTIONS($cellrange;ST Expressions display mode;$option)
a4TBL_cellContentType{$i}:=ST Get content 
type($cellrange;$cellrange.start;$cellrange.start)

On the 3rd line, I get this error: (but only when compiled)

’The pointer is not properly initialized’

- a4TBL_cellContentType is a longint array (14 elements in this case)
- $i =1
- $cellrange is typed as c_object
- $cellrange.start =114

Any ideas on how to make this work?


Regards,

Rudy Mortier
Two Way Communications bvba 




**
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: Anybody running v17 server on Windows 2008r2?

[Two Way Communications via 4D_Tech]

I am running 4D server v17R2 on Windows Server 2016, on a minimal Amazon Tmicro 
server. (lowest config available)

I must say it performs flawlessly, despite only having 1GB of memory (!) and an 
AMD64 processor…
Response is quite fast, too. Amazing!

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 29 Nov 2018, at 15:00, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> And if so, do you have any problems with it?
> 
> Thanks
> 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)
> 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: LAUNCH EXTERNAL PROCESS, v15, on MacOS Mojave

[Two Way Communications via 4D_Tech]

Hi Keisuke,

Yes, I could. But sometimes it concerns excel or word documents, so that 
wouldn’t work, at least not on a Mac. Or am I wrong?

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 20 Nov 2018, at 05:54, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> could you not simply do
> 
> OPEN URL ($path)  //default app
> 
> OPEN URL ($path;"Preview") //specified app
> 
> http://doc.4d.com/4Dv15/4D/15.6/OPEN-URL.301-3817577.en.html
> 
> 2018/11/19 22:56、Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール:
> 
> The syntax I use is:
> 
> LAUNCH EXTERNAL PROCESS($command;$IN;$OUT;$ERROR)
> 
> where:
> 
> $command = “open 
> /Applications//Xpert_PRO/XPP_DOSSIER_FOLDER/DOS_Le18000142/MyPDFdocument.pdf”
> $IN = “”
> $OUT = “”
> $ERROR = “”
> 
> 
> 
> **
> 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
**

LAUNCH EXTERNAL PROCESS, v15, on MacOS Mojave

[Two Way Communications via 4D_Tech]

A customer of mine recently upgraded his MacBook Pro to MacOS Mojave.

He is running a stand-alone 4D app, compiled with 4D v15.4. This app has been 
installed in the ‘Applications’ folder, which is not inside the 
/Users/Username/ folder, but in Macintosh HD/Applications.

Now, in the application, I allow the user to open documents (pdf, .docx, .jpg 
etc) using the document's native application.
In order to do that, I use LAUNCH EXTERNAL PROCESS.

This worked perfectly until now. Now, In Mojave, it takes at least 30 seconds 
to open a pdf document. (in High Sierra, this was < 1 second)

The syntax I use is:

LAUNCH EXTERNAL PROCESS($command;$IN;$OUT;$ERROR)

where:

$command = “open 
/Applications//Xpert_PRO/XPP_DOSSIER_FOLDER/DOS_Le18000142/MyPDFdocument.pdf”
$IN = “”
$OUT = “”
$ERROR = “”

Has anyone else experienced this? Do I need to change the command in LEP?
Would it help if my customer moves the app to the folder ‘/Users / UserName / 
Applications’ ?

Since I don’t have Mojave installed on my Mac yet, I can’t actually test it. In 
fact, I don’t want to upgrade yet because I need to support 4D v15…


Regards,

Rudy Mortier
Two Way Communications bvba 

**
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: I've updated sideORDA

[Two Way Communications via 4D_Tech]

Hi Kirk,

Thank you so much for this wonderful contribution.

I have been using ORDA and collections, but I struggled with it.
Your presentation gave me so many useful insights and ideas!

It’s people like you the really make a difference in the 4D community.

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 17 Nov 2018, at 19:57, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> A few folks have asked me to update sideORDA
>  to include the examples I showed
> in my 4D Method presentation
> .
> I've done that so feel free to take a look.
> 
> sideORDA is a learning project I made to explore how to use the new tools
> in v17. At this point there are a number of examples and general noodling
> around with figuring out how to do things with ORDA I'm accustomed to doing
> in classic 4D. This is not a finished project - it's more like a sketch pad
> with random ideas.
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *We go vote - they go home*
> **
> 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: Longing IDs or UUIDs as primary key?

[Two Way Communications via 4D_Tech]

Thanks to all of you for the valuable insights. Seems I’ve got some work to do 
;-)

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 24 Oct 2018, at 19:17, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> No it is just painful let’s assume for some reason record in a many table 
> where assigns to wrong main table which would you rather type in to fix 
> 145764 or a 32 character UUID
> In my opinion the journal aspect should have been hidden by 4D and the UUID 
> field should have been there but hidden
> 
> 
> Regards
> 
> Chuck
> 
> Sent from my iPhone
> 
>> On Oct 24, 2018, at 11:59 AM, Keith Culotta via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> RE: never use them to link between tables
>> 
>> Is using them to link between tables (establish 4D Relations, correct?) a 
>> hazardous practice? 
>> 
>> Thanks,
>> Keith - CDI
>> 
>>> On Oct 24, 2018, at 10:49 AM, Charles Miller via 4D_Tech 
>>> <4d_tech@lists.4d.com> wrote:
>>> 
>>> Rudy
>>> 
>>> For me this always choose UUID for primary key and never use them to link
>>> between tables. The overhead from space is not so great Andy I never want
>>> to type in uuid to find related records etc
>>> 
>>> Regards
>>> 
>>> Chuck
>>> 
>>> On Wed, Oct 24, 2018 at 10:52 AM Two Way Communications via 4D_Tech <
>>> 4d_tech@lists.4d.com> wrote:
>>> 
>>>> I have an application with a big database file ( + 60 GB), with 128
>>>> tables. (4D v17)
>>>> 
>>>> All id fields and foreign keys are of type longint.
>>>> 
>>>> Now, for replication and sharing purposes, I would like to change the type
>>>> to UID.
>>>> 
>>>> The process seems quite cumbersome: to start, I need to remove the
>>>> ‘primary key’ flag from all the ID fields, then I need to add UID fields to
>>>> every table,
>>>> change the foreign keys as well, and use apply formula to make sure the
>>>> relations are intact. I am a bit worried that this will have a major impact
>>>> on the size of the data file.
>>>> 
>>>> Furthermore, I need to automate the whole process so the upgrade works
>>>> flawlessly at the customers site.
>>>> 
>>>> Has anyone ever done this?
>>>> Any tips?
>>>> 
>>>> Regards,
>>>> 
>>>> Rudy Mortier
>>>> Two Way Communications bvba
>>>> 
>>>> 
>> 
>> **
>> 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
> **

**
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: Longing IDs or UUIDs as primary key?

[Two Way Communications via 4D_Tech]

It’s a setting in the properties of the listbox column


Rudy Mortier
Two Way Communications bvba 


> On 25 Oct 2018, at 04:47, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> how do you do this?
> 
> 
>> In 4D list boxes, a column can be set up to show an ellipsis in the 
>> middle of a string (instead of the end) when a column is too small. 
>> This is perfect for UUID columns. Just make them wide enough to only 
>> show the first and last 3 characters. Just as easy as a longint, 
>> really.
> 
> Hell is other people 
> Jean-Paul Sartre
> **
> 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: Longing IDs or UUIDs as primary key?

[Two Way Communications via 4D_Tech]

To be clearer on the purpose:

There are many customers who use my application.

What I want to achieve is that they can ’share’ data. In order to do that, I 
really do need a UUID, because I intend to exchange the records (and related 
records) between their individual databases.
Obviously this will never work with LONGINT ids and foreign keys …

Another example is replication. My users, most of the time, are working 
client-server. But often, they need a part of the datafile as a local database 
on their laptop, so I need to replicate at least a part of 
the data into a stand-alone database. Then, if they add records to the local 
database, I want to replicate that new information back to the server database.

The only way this would be possible is to change all the LONGINT ids to UUID, 
and also the foreign keys ….

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 24 Oct 2018, at 18:16, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> it is more of a situation of:
> - Do I **really** want to type a UUID to try to follow/check on  
> related records when something goes pear-shaped?
> - Do I want my admin(s) to have to type a UUID to try to chase related 
> records?
> - Do I want to have to work with UUIDs, other then knowing that they 
> exist and are inplace as requested/required?
> 
> 
> On Wed, 24 Oct 2018 10:59:48 -0500, Keith Culotta via 4D_Tech wrote:
>> RE: never use them to link between tables
>> 
>> Is using them to link between tables (establish 4D Relations, 
>> correct?) a hazardous practice? 
>> 
>> Thanks,
>> Keith - CDI
>> 
>>> On Oct 24, 2018, at 10:49 AM, Charles Miller via 4D_Tech 
>>> <4d_tech@lists.4d.com> wrote:
>>> 
>>> Rudy
>>> 
>>> For me this always choose UUID for primary key and never use them to link
>>> between tables. The overhead from space is not so great Andy I never want
>>> to type in uuid to find related records etc
>>> 
>>> Regards
>>> 
>>> Chuck
>>> 
>>> On Wed, Oct 24, 2018 at 10:52 AM Two Way Communications via 4D_Tech <
>>> 4d_tech@lists.4d.com> wrote:
>>> 
>>>> I have an application with a big database file ( + 60 GB), with 128
>>>> tables. (4D v17)
>>>> 
>>>> All id fields and foreign keys are of type longint.
>>>> 
>>>> Now, for replication and sharing purposes, I would like to change the type
>>>> to UID.
>>>> 
>>>> The process seems quite cumbersome: to start, I need to remove the
>>>> ‘primary key’ flag from all the ID fields, then I need to add UID 
>>>> fields to
>>>> every table,
>>>> change the foreign keys as well, and use apply formula to make sure the
>>>> relations are intact. I am a bit worried that this will have a 
>>>> major impact
>>>> on the size of the data file.
>>>> 
>>>> Furthermore, I need to automate the whole process so the upgrade works
>>>> flawlessly at the customers site.
>>>> 
>>>> Has anyone ever done this?
>>>> Any tips?
>>>> 
>>>> Regards,
>>>> 
>>>> Rudy Mortier
>>>> Two Way Communications bvba
>>>> 
>>>> 
>> 
>> **
>> 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
>> **
> ---
> 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: Icon & Picture Button Sources...

[Two Way Communications via 4D_Tech]

Actually, I prefer to roll my own.

I start by googling ‘ icons’, i.e. ‘validate icons’, 'customer icons' 
….

Then I copy the picture I like into Pixelmator. I put 4 identical pictures in a 
row, same size. Then I tweak them for the 4 states: normal, hovered over, 
clicked , and disabled.

Finally, I export the image as a .png file (for transparency purposes) and put 
it in the resources folder, so I can use them with picture buttons.

This results are nice transparent buttons that change when you move the mouse 
over it, or click it.


Regards,

Rudy Mortier
Two Way Communications bvba 



> On 24 Oct 2018, at 15:28, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Here's a simple example inspired by the 4d-component-generate-icon.
> 
> //-
> $width:=3
> $opacity:=80
> $rw:=40
> 
> $color:="black"  // normal
> $svg:=SVG_New (58;58)
> $ref:=SVG_New_rect ($svg;9;9;$rw;$rw;2;2;$color;"white";$width)
> SVG_SET_OPACITY ($ref;0;$opacity)
> $normal:=SVG_Export_to_picture ($svg)
> SVG_CLEAR ($svg)
> 
> $color:="green"  // click
> $svg:=SVG_New (58;58)
> $ref:=SVG_New_rect ($svg;9;9;$rw;$rw;2;2;$color;"white";$width)
> SVG_SET_OPACITY ($ref;0;$opacity)
> $click:=SVG_Export_to_picture ($svg)
> SVG_CLEAR ($svg)
> 
> $color:="deepskyblue"  // hover
> $svg:=SVG_New (58;58)
> $ref:=SVG_New_rect ($svg;9;9;$rw;$rw;2;2;$color;"white";$width)
> SVG_SET_OPACITY ($ref;0;$opacity)
> $hover:=SVG_Export_to_picture ($svg)
> SVG_CLEAR ($svg)
> 
> $color:="silver"  // disable
> $svg:=SVG_New (58;58)
> $ref:=SVG_New_rect ($svg;9;9;$rw;$rw;2;2;$color;"white";$width)
> SVG_SET_OPACITY ($ref;0;$opacity)
> $disabled:=SVG_Export_to_picture ($svg)
> SVG_CLEAR ($svg)
> 
> 
> $pict:=$normal/$click/$hover/$disabled  // this creates the "4 state" picture!
> 
> TRANSFORM PICTURE($pict;Scale;0.66;0.66)  // size to fit
> CONVERT PICTURE($pict;".png")// allows pasting into Preview
> 
> $0:=$pict
> 
> // SET PICTURE TO PASTEBOARD($pict)
> // SVGTool_SHOW_IN_VIEWER ($svg)
> 
> //-
> 
> Keith -CDI
> 
>> On Oct 23, 2018, at 6:47 PM, Robert ListMail via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Hi Tim thanks for the reminder. I recall liking your interface design. So, 
>> are you using the various button states where 4D has the ability to swap the 
>> images during different states such as “rollover”? If so, did you have to 
>> create two or three different versions of each icon for matrix of images…?
>> 
>> Thanks,
>> 
>> Rob
>> 
>>> On Oct 23, 2018, at 2:04 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> 
>>> wrote:
>>> 
>>> https://glyphlab.com 
>>> 
>>> You have to pay money, but for me it was worth it as I paid once and got a 
>>> library of high quality images I’ve been using for years in all my 
>>> projects.  For me, well worth the one time price.
>>> 
>>> Tim
>> 
>> **
>> 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
> **

**
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: Using listbox as output form replacement

[Two Way Communications via 4D_Tech]

Hi Jim,

No, this will not work in user mode. To use a listbox in that way (generic), 
you need to put it in an input form, to start with. You can only use it by 
programming, using DIALOG.

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 24 Oct 2018, at 02:13, Jim Crate via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> I have a form with a selection-based listbox which I use as an output form. 
> In runtime mode, you just use DIALOG instead of DISPLAY SELECTION. If I set 
> that form as the output form, it doesn’t work in User mode, it just says 
> “There is no form selected to display the records of: [My_Table]”. Is there a 
> way to get this to work in User mode? 
> 
> Jim Crate
> 
> **
> 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
**

Longing IDs or UUIDs as primary key?

[Two Way Communications via 4D_Tech]

I have an application with a big database file ( + 60 GB), with 128 tables. (4D 
v17)

All id fields and foreign keys are of type longint. 

Now, for replication and sharing purposes, I would like to change the type to 
UID.

The process seems quite cumbersome: to start, I need to remove the ‘primary 
key’ flag from all the ID fields, then I need to add UID fields to every table, 
change the foreign keys as well, and use apply formula to make sure the 
relations are intact. I am a bit worried that this will have a major impact on 
the size of the data file.

Furthermore, I need to automate the whole process so the upgrade works 
flawlessly at the customers site.

Has anyone ever done this?
Any tips?

Regards,

Rudy Mortier
Two Way Communications bvba 

**
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: Write Pro: Creating headers/footers

[Two Way Communications via 4D_Tech]

Hi Pat,

I discovered this by accident: you need to double click in the header or footer 
area, when in ‘Page’ mode…. practically, this means, as high or as low as you 
can on the 4D Write Pro page.

Rudy Mortier
Two Way Communications bvba 



> On 6 Oct 2018, at 00:59, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> If I create a new WP document from scratch, is there any way to add a
> header or footer to the document? Or do I have to start with a template
> that has a header/footer and modify it?
> 
> 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)
> 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: Creating a form object to use as dynamic form

[Two Way Communications via 4D_Tech]

Thanks Jody.

4D's progress is actually quite stunning this last few years.

The downside is that, at least here in Belgium, it is hard to get the required 
training in order to master all of that. So, I get stuck quite a lot lately 
with ORDA, 4D Write pRo, 4D for iOS and all the other new stuff.
Reading the docs and looking at the examples only get you so far…

But I’m sure we will get there in the end.

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 24 Sep 2018, at 16:57, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Sorry Rudy, not an answer to your question, but topical I think.
> 
> Being able to create a sophisticated form via code is a fantastic feature. It 
> is like the coding I did back in 1982/1983. Back when I first got my hands on 
> my own copy of 4D version 2.0.10  the Graphical form editor was such a 
> liberating way of creating forms, compared to the way I needed to do it in 
> Pascal.
> 
> This really is a great feature, but my hope is that this is just a necessary 
> 1st step to being able to create a form using the normal 4D Form Editor, Form 
> Method, Object Methods and then be able to save them as ‘text’ that can then 
> be sent to clients.
> 
> We have often had the need to send multiple forms to different clients for 
> them to run.  Then the client needs / forced to (by regulations) have a new 
> version of the form. That is great, but they still have lots of data that 
> they collect via the old form and need to be able to display that data in the 
> form they used at the time. 
> 
> In the last major application we did, we have ~ 10,000 forms with each client 
> having about 150 of them. Each client though would have a different set of 
> forms. When 4D announced this feature I hoped that it will lead to fulfilling 
> this need. Then as 4D developers we can provide a rich, consistent interface 
> within the product rather than having to resort to forms in WebAreas, PDFs, 
> etc. This will help us 4D developers stick within our expertise of 4D and be 
> more productive.
> 
> Jody Bevan
> Argus Development Inc.
> 
> 
>> On Sep 24, 2018, at 8:44 AM, Two Way Communications via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> I can’t figure out how to do this … 
>> 
>> Using a dynamic form, I am trying to build a generic list of records to 
>> display to the user and to allow him to select 1 record.
>> 
>> I used the example from the tech note on how to create a dynamic form that 
>> shows a listbox.
>> 
>> To build this $form object variable, the commands New object and others are 
>> used.
>> 
>> This listbox object is added to the $page object in the $form object, which 
>> will be used in the DIALOG command.
>> 
>> 
>> $obj:=New object("type";"listbox";"listboxType";"collection";\ 
>> "dataSource";$colName;"left";0;"top";0;"width";$width+15;"height";$height)
>> 
>> 
>> 
>> $page:=New object("objects";New object("myListBox";$obj)) $form:=New 
>> object(“pages";New collection(Null;$page))
>> 
>> $form:=New object("windowTitle";"Select a 
>> Map:";"windowMinWidth";500;"windowMinHeight";300;"pages";New 
>> collection(Null;$page))   
>> 
>> Now, this dynamic form only shows a listbox, and I want to add a button to 
>> the form. I assume this button object has to be added to the ‘Objects’ 
>> object in $page.
>> 
>> But, how do I do that? I tried object arrays and collections, but neither of 
>> them produces the correct result. 
>> 
>> 
>> Secondly, the listbox displays an entity selection. How do I get the row 
>> number that has been selected?
>> 
>> 
>> 
>> Regards,
>> 
>> Rudy Mortier
>> Two Way Communications bvba 
>> 
> 
> **
> 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
**

Creating a form object to use as dynamic form

[Two Way Communications via 4D_Tech]

I can’t figure out how to do this … 

Using a dynamic form, I am trying to build a generic list of records to display 
to the user and to allow him to select 1 record.

I used the example from the tech note on how to create a dynamic form that 
shows a listbox.

To build this $form object variable, the commands New object and others are 
used.

This listbox object is added to the $page object in the $form object, which 
will be used in the DIALOG command.


$obj:=New object("type";"listbox";"listboxType";"collection";\ 
"dataSource";$colName;"left";0;"top";0;"width";$width+15;"height";$height)



$page:=New object("objects";New object("myListBox";$obj)) $form:=New 
object(“pages";New collection(Null;$page))

$form:=New object("windowTitle";"Select a 
Map:";"windowMinWidth";500;"windowMinHeight";300;"pages";New 
collection(Null;$page))  

Now, this dynamic form only shows a listbox, and I want to add a button to the 
form. I assume this button object has to be added to the ‘Objects’ object in 
$page.

But, how do I do that? I tried object arrays and collections, but neither of 
them produces the correct result. 


Secondly, the listbox displays an entity selection. How do I get the row number 
that has been selected?



Regards,

Rudy Mortier
Two Way Communications bvba 



**
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 for iOS: anyone?

[Two Way Communications via 4D_Tech]

Thanks guys,

I have been looking at the forum before but somehow I failed to find this topic.


Rudy Mortier
Two Way Communications bvba 



> On 11 Sep 2018, at 09:28, Vincent de Lachaux via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
>> 
> 
> 
> On 10 Sep 2018, at 20:18, Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
>> 
>> Is there any place we can get some help?
> 
> Hi Rudy
> 
> There is a dedicated forum here: 
> http://forums.4d.com/List_Message/EN:0/1/1/1/1/1/14234613/0/0/25105655/-1/0/0/0/0/0/0/0/
> 
> Feel free to post we are listening
> 
> Regards
> 
> David Azancot (product owner)
> Eric Marchand (swift developer)
> Vincent de Lachaux (4D developper)
> **
> 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 for iOS: anyone?

[Two Way Communications via 4D_Tech]

Hi Tim,

Thanks a lot for the feedback.

I did go back and edit the templates and fields, so that might be the problem.

About the selection of data that is downloaded: wouldn’t it be possible to 
control that in the ‘On mobile authentication method’?


Regards,

Rudy Mortier
Two Way Communications bvba 



> On 10 Sep 2018, at 21:20, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> On Sep 10, 2018, at 2:00 PM, Rudy Mortier wrote:
> 
>> Has anyone tried 4D for iOS?
>> 
>> How are the results?
>> 
>> I have tried with a simple database and tried to publish 3 tables. The form 
>> templates seem to not always display the correct data.
>> 
>> In the test environment, It doesn’t download the data for all 3 tables: 
>> sometimes only one, sometimes 2. And there is not a lot of records in the 
>> tables.
>> 
>> Is there any place we can get some help?
> 
> I did a quick conversion of a database to v17 R2 and created a simple iOS 
> application. It worked almost flawlessly (see below problems). Go through the 
> wizard to define the tables and fields to use and the list and detail forms 
> to use. Then click the build button and wait maybe 90 seconds and the iPhone 
> Simulator program launched and there was my working iOS application. Very 
> impressive… when it worked.
> 
> Of course the capabilities of the first version are severely limited. Limited 
> configurability of the detail and list forms. You get many templates but you 
> can just select what fields to display and in what order and that’s about it. 
> 
> Also it is just read only. It downloads all records from the tables you 
> included to the iPhone and you can then do simple searching on a key field 
> and view the information. That’s it. No filtering of what records to 
> download. No updating or editing of the data. When you want to refresh the 
> data you go to a settings area in the iOS application and click a refresh 
> button to re-download all the data from a 4D Server that has the 4D Mobile 
> feature turned on. 
> 
> So applications created with this first version are of limited use in the 
> “real world”. Of course this is just the first version released in v17 R2. So 
> I would expect R3 to add many more capabilities and fix a lot of bugs. 
> Hopefully by v17 R5 it will be “fully functional” with the ability to edit 
> data, recreate new records, automatically sync the data back to 4D Server and 
> provide more widgets on the forms. 
> 
> I didn’t have the problem you experienced… once I got a project completed. It 
> downloaded all the data from all the tables in my application and it 
> displayed the data as expected. 
> 
> So maybe your 4D for iOS template or definition file got corrupted somehow 
> during your development of it. I know that I had to start over 3 times. I’d 
> get started, then change my mind and try to go back in the wizard and edit 
> and change the template or fields and couldn’t get it to work. So I’d trash 
> it and start again from scratch. By the third time I was able to go straight 
> through the process to the end and it worked. 
> 
> It’s definitely not ready for prime time at this point, but again it’s not 
> really intended to be. I’d consider it v0.9 version. I wouldn’t even call it 
> 1.0 yet. I’m reserving judgment until v17 R5 to see what it’s like then. 
> Remember at 4D Summit they said 4D for iOS was really a v18 feature. So 
> expect it to be ready for prime time by then. Now it is just something to 
> play with… in my opinion.
> 
> Tim
> 
> *
> Tim Nevels
> Innovative Solutions
> 785-749-3444
> timnev...@mac.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
> **

**
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 for iOS: anyone?

[Two Way Communications via 4D_Tech]

Has anyone tried 4D for iOS?

How are the results?

I have tried with a simple database and tried to publish 3 tables. The form 
templates seem to not always display the correct data.

In the test environment, It doesn’t download the data for all 3 tables: 
sometimes only one, sometimes 2. And there is not a lot of records in the 
tables.

Is there any place we can get some help?


Regards,

Rudy Mortier
**
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: ORDA - updating data in listboxes

[Two Way Communications via 4D_Tech]

Looking on the bright side, this will elude you only ONCE ;-)

Rudy Mortier
Two Way Communications bvba 



> On 13 Aug 2018, at 00:13, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> This makes me wonder why REDRAW can't do this internally instead of adding 
> yet another microscopic difference between listbox types that will continue 
> to elude even the most experienced 4D developers. At the very least, the 
> REDRAW documentation should be updated to say that this command does not work 
> for collection/ORDA list boxes and explain what you are supposed to do 
> instead.
> 
> John DeSoi, Ph.D.
> 
> 
> 
>> On Aug 12, 2018, at 2:05 PM, Spencer Hinsdale via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> is this relevant?
>> 
>> http://kb.4d.com/resources/inug?msgid=GmailId164f73d107b663e7 
>> 
>> 
> 
> **
> 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: Double-click event on a hierarchical listbox not working

[Two Way Communications via 4D_Tech]

Hi Pat,

I am running High Sierra also. (10.13.6)
No issues here.

If there is a case of (form event) in your code, I would put the ‘On double 
clicked’ before the ‘on Clicked’)
In the past this has bitten me a few times where it would first go into the ‘On 
clicked’ and never do the ‘On double clicked’

Also: disable ‘movable rows’.

About the debugger: place the trace bullet as late as possible, because it 
might mislead you

I can’t explain the ‘On drop’ occurring, however….


Rudy Mortier
Two Way Communications bvba 



> On 2 Aug 2018, at 00:04, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Using v17r2
> All of a sudden I am finding that a double-click on an element in a
> hierarchical listbox doesn't work. Well occasionally it does but mostly,
> not. If I repeatedly double-click, eventually it will work.
> Bizarrely, if I put a trace on the object method it says that the form
> event was On Drop!
> If I disable the On Drop event, it registers a double-click as a click.
> If I disable On clicked, it registers a click or double-click as On Drop
> (even though the On Drop event is disabled).
> This morning I upgraded my Mac to High Sierra. I wonder if that has
> something to do with it? Anybody else experienced this?
> 
> 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)
> 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: Adding elements to a listbox containing a collection

[Two Way Communications via 4D_Tech]

Thx Keisuke.

I am still getting to grips with the whole new paradigm that is objects, 
collections and ORDA.
The amount of information is elaborate, and often in different places.

So insights like this are really helpful.

Good thing we have the NUG ;-)

BTW, collections and ORDA are so cool! 


Rudy Mortier
Two Way Communications bvba 



> On 1 Aug 2018, at 22:44, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> that's right, you have to "touch" the data source object to signal that it is 
> dirty and has to be redrawn.
> 
> so, even though
> 
> col.push()
> 
> adds an element to the collection,
> in this context (listbox on form),
> you have to assign the variable to itself:
> 
> col:=col.push()
> 
> 2018/08/02 5:24、Christian Sakowski via 4D_Tech 
> <4d_tech@lists.4d.com>のメール:
> Form.cColl:=Form.cColl
> 
> 
> 
> **
> 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
**

Adding elements to a listbox containing a collection

[Two Way Communications via 4D_Tech]

I guess I must be overlooking the obvious here …
I searched the documentation, the NUG, the Blog but could not find an answer, 
so maybe somebody can help me out.

I have a collection that is being displayed inside a listbox. So far so good. 
No issues. I can select the rows and I can edit the cell contents.

Now, I want to add a row, and enter values.

Here’s where it goes wrong. I cannot get the row to display, let alone edit it.

Since ‘LISTBOX INSERT ROWS’ only works with arrays, I tried cColl.push, which 
actually adds an element to the collection (I verified in the debugger)
But the row is not added to the listbox, no matter what I try (i.e. 
REDRAW(Listbox))

The next challenge will be to delete an element …

Has anybody done this successfully?


Rudy Mortier
Two Way Communications bvba 


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

[Two Way Communications via 4D_Tech]

It’s fairly easy to write a method that loops through all the fields of the 
record and puts them into a blob. (variable to blob)

Then, on the other end, use same method but ‘BLOB to variable’

Works really well.


Rudy Mortier
Two Way Communications bvba 



> On 31 Jul 2018, at 16:11, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 
> I considered this approach -
> but the need is for data passing between processes, so writing to disk 
> is not really 'efficient'.
> 
> I went/am going with a simple convert it all to text approach.  The 
> data will not need to deal with blobs, or pictures so this will do for 
> now.
> 
> 
> 
> On Tue, 31 Jul 2018 09:54:44 +0200, Koen Van Hooreweghe via 4D_Tech 
> wrote:
>> 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
>> **
> ---
> 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: Confused about ORDA

[Two Way Communications via 4D_Tech]

Thanks Lahav,

This does put it more into perspective.

I actually was trying to find out which way to go to optimize the speed as much 
as possible.

And although a difference of 150 ms does sound ridiculous, I assume that with 
more data, and used repetitively in loops, it will be a substantial difference.

Rudy Mortier
Two Way Communications bvba 



> On 30 Jul 2018, at 06:37, lists via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Rudy,
> 
> I think part of the reason might be that with ORDA you actually have the data 
> loaded and ready to use in the resulting collection, where as with QUERY you 
> have a selection of records, but to use any of the data you still need to 
> load it somehow.
> 
> Also, using QUERY, regardless of speed, allow you access to one selection of 
> records only, where as with ORDA, you can just execute the same query with 
> different parameters in to a different collection and have as many different 
> selection of records at the same time.
> 
> I would think that a real test should be a complete task rather than one 
> isolated part, and then make a decision as to which option makes more sense 
> for that given task.
> 
> Regards,
> 
> Lahav
> 
> -Original Message-----
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Two Way 
> Communications via 4D_Tech
> Sent: Sunday, July 29, 2018 5:47 AM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Two Way Communications 
> Subject: Confused about ORDA
> 
> I am a bit confused… isn’t ORDA supposed to be faster than traditional 
> queries?
> 
> I did a test with a table containing 120,000 records. The query is on 4 
> indexed fields and returns 54,000 records.
> 
> Doing the query with ORDA takes 175 milliseconds.
> Doing the query with QUERY takes 4 milliseconds.
> 
> Why??
> 
> ORDA:
> $oQRYoption:=New object("queryPlan";False;"queryPath";False)  
> 
> $oTLD:=ds.T_Loggers_data.query("TLR.FK_REAP =:1 AND TLD_timestamp >=:2 AND 
> TLD_timestamp <=:3 AND Excluded 
> =:4";[REAP_sections]FK_REAP;$TSsectionStart;$TSsectionEnd;False;$oQRYoption)  
>  
>   
> 
> Traditional:
> QUERY([T_Loggers_data];[T_loggers_readings]FK_REAP=[REAP_sections]FK_REAP;*)  
> 
> QUERY([T_Loggers_data];[T_Loggers_data]TLD_timestamp>=$TSsectionStart;*)
> QUERY([T_Loggers_data];[T_Loggers_data]TLD_timestamp<=$TSsectionEnd;*)
> QUERY([T_Loggers_data];[T_loggers_readings]Excluded=False)
> 
>   
> Rudy Mortier
> Two Way Communications bvba 
> 
> **
> 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
> **

**
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: Confused about ORDA

[Two Way Communications via 4D_Tech]

Exactly, the ‘&’ is not mandatory. Both queries return the same result.


Rudy Mortier
Two Way Communications bvba 



> On 29 Jul 2018, at 22:23, Douglas von Roeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Bob:
> 
> I think that's a shortcut from many years ago so it's an implicit "&".
> 
> --
> Douglas von Roeder
> 949-336-2902
> 
> 
> On Sun, Jul 29, 2018 at 1:12 PM Robert McKeever via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Either they have changed the way QUERY works, or you are missing …&;…
>> after the first semi-colon on lines 2, 3, and 4 of the QUERY. So, it looks
>> like you are really simply searching for just the last line. Probably would
>> be quicker.
>> 
>>> On Jul 29, 2018, at 4:47 AM, Two Way Communications via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>> 
>>> I am a bit confused… isn’t ORDA supposed to be faster than traditional
>> queries?
>>> 
>>> I did a test with a table containing 120,000 records. The query is on 4
>> indexed fields and returns 54,000 records.
>>> 
>>> Doing the query with ORDA takes 175 milliseconds.
>>> Doing the query with QUERY takes 4 milliseconds.
>>> 
>>> Why??
>>> 
>>> ORDA:
>>> $oQRYoption:=New object("queryPlan";False;"queryPath";False)
>> 
>>> $oTLD:=ds.T_Loggers_data.query("TLR.FK_REAP =:1 AND TLD_timestamp >=:2
>> AND TLD_timestamp <=:3 AND Excluded
>> =:4";[REAP_sections]FK_REAP;$TSsectionStart;$TSsectionEnd;False;$oQRYoption)
>> 
>>> 
>>> 
>>> Traditional:
>>> 
>> QUERY([T_Loggers_data];[T_loggers_readings]FK_REAP=[REAP_sections]FK_REAP;*)
>> 
>>> QUERY([T_Loggers_data];[T_Loggers_data]TLD_timestamp>=$TSsectionStart;*)
>>> QUERY([T_Loggers_data];[T_Loggers_data]TLD_timestamp<=$TSsectionEnd;*)
>>> QUERY([T_Loggers_data];[T_loggers_readings]Excluded=False)
>>> 
>>> 
>>> Rudy Mortier
>>> Two Way Communications bvba
>>> 
>>> **
>>> 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
>>> **
>> 
>> _
>> Bob McKeever  http://www.mswl.com <
>> http://www.mswl.com/>
>> McKeever's Software Wizardry
>> Port Coquitlam, B.C.
>> bobmckee...@mac.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
>> **
> **
> 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
**

Confused about ORDA

[Two Way Communications via 4D_Tech]

I am a bit confused… isn’t ORDA supposed to be faster than traditional queries?

I did a test with a table containing 120,000 records. The query is on 4 indexed 
fields and returns 54,000 records.

Doing the query with ORDA takes 175 milliseconds.
Doing the query with QUERY takes 4 milliseconds.

Why??

ORDA:
$oQRYoption:=New object("queryPlan";False;"queryPath";False)

$oTLD:=ds.T_Loggers_data.query("TLR.FK_REAP =:1 AND TLD_timestamp >=:2 AND 
TLD_timestamp <=:3 AND Excluded 
=:4";[REAP_sections]FK_REAP;$TSsectionStart;$TSsectionEnd;False;$oQRYoption)
 


Traditional:
QUERY([T_Loggers_data];[T_loggers_readings]FK_REAP=[REAP_sections]FK_REAP;*)

QUERY([T_Loggers_data];[T_Loggers_data]TLD_timestamp>=$TSsectionStart;*)
QUERY([T_Loggers_data];[T_Loggers_data]TLD_timestamp<=$TSsectionEnd;*)
QUERY([T_Loggers_data];[T_loggers_readings]Excluded=False)


Rudy Mortier
Two Way Communications bvba 

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

[Two Way Communications via 4D_Tech]

Dammit! I read that, but had totally forgotten about it…

In the documentation, the error is even mentioned: ## ERROR # 48! 

Strangely, when you search the on line documentation for ## ERROR # 48, it 
doesn’t find it …

Thanks Keisuke, you saved my day (again ;-))


Rudy Mortier
Two Way Communications bvba 



> On 17 Jul 2018, at 22:16, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> did you explicitly call SET ALLOWED METHODS?
> 
> http://cdn.doc.4d.com/4Dv16R6/4D/16-R6/SET-ALLOWED-METHODS.301-3548364.en.html
> 
> http://cdn.doc.4d.com/4Dv16R6/4D/16-R6/Filter-expressions-contained-in-a-4D-Write-Pro-document.300-3605842.en.html
> 
> 2018/07/17 20:36、Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール:
> I inserted an expression in a 4D Write PRO area, and the expression is 
> actually a method returning a text in $0:
> 4WRPRO_INSERT(“test”)
> Any ideas why it is not working in 4D Write PRO?
> 
> 
> 
> **
> 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
**

4D Write Pro range / elements

[Two Way Communications via 4D_Tech]

I have a 4WR PRO area on a form. It is associated with the field 
[_10_Report_templates]Template_WRPRO.

I added 2 tables in it.

I wrote a table editor, so the attributes of a table can be changed after it 
has been created.
For that to work, I need to get the table object in order to change it.

When I put the cursor inside one of the tables, I can get the selection and 
then the table object that the cursor is in.

$range:=WP Get selection([_10_Report_templates]Template_WRPRO)  
cTBLelements:=WP Get elements($range;wk type table)

cTBLelements[0] will have the table object.


This used to work until now… (4D v17, MacOS High Sierra)
Now, it either returns an empty object or always the first table, no matter 
where the cursor is.

Did anybody have the same experience?

Overal, I have the impression that the start/end of a range is not always 
correct…



Rudy Mortier
Two Way Communications bvba 



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

4D Write PRO expressions

[Two Way Communications via 4D_Tech]

I inserted an expression in a 4D Write PRO area, and the expression is actually 
a method returning a text in $0:

4WRPRO_INSERT(“test”)

However, when showing the values in stead of the references in the 4D Write PRO 
area, the value always shows ‘## ERROR # 48’

When I execute the method inside another method:

$result:=4WRPRO_INSERT(“test”)

the result is shown correctly, also when using ‘Execute formula’, so the method 
works.

I’ ve tried to debug the method, but the debugger doesn’t show when using it 
inside the 4D Write PRO area, like the method is not even called…


Any ideas why it is not working in 4D Write PRO?


Rudy Mortier
Two Way Communications bvba 


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

Re: 4D Write PRO: editing a table / collections

[Two Way Communications via 4D_Tech]

Achim, have you tried this yourself? 

I think it is not possible in 4D Write PRO v17 to select 1 or more cells in a 
table and then be able to get the cells reference by code.

Just follow this scenario:

- the user creates a table in 4D Write PRO (by clicking a button containing the 
code WP Insert Table)
- Basically, the developer provides a dialog to ask for the number of columns 
and rows, and eventually column width, background color etc.
- the table will be created in the 4D Write PRO document, where the user can 
add content.

Now, the user wants to change attributes of the cells, or columns. i.e. width, 
color, borders. In order to do that (in code), the developer needs to know 
which cells have been selected.

In the table, the user can select 1 or more cells, but here’s the problem: how 
to find out which cell(s) have been selected?

WP get selection will return an object with a ’start’, ‘end’ and ’type’ 
attribute. Type is always = 0, start and end e.g. 32,40 do not give any clue as 
to which cell is selected.
Interestingly, WP Create table range returns exactly the same result, but type 
= 4

‘WP Get position': nothing that can be used: While the user has selected cells 
1 and 2, we get this result:
‘column’ = 1
‘line’ = 3
‘page’ = 1
‘position’ =1

'WP GET ELEMENTS' will return a collection, where the table object can indeed 
be found, but still no information about which cell or cells are selected.
‘WP Table Get Cells' will create a new range containing the specified cells, 
but NOT provide information about which cells are actually selected.


Rudy Mortier
Two Way Communications bvba 



> On 11 Jul 2018, at 19:16, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> a table reference can be obtained from
> 
> WP Create table range
> http://doc.4d.com/4Dv17/4D/17/WP-Create-table-range.301-3703205.en.html
> 
> WP Get elements
> http://doc.4d.com/4Dv17/4D/17/WP-Get-elements.301-3703212.en.html
> 
> or
> 
> WP Get element by ID
> http://doc.4d.com/4Dv17/4D/17/WP-Get-element-by-ID.301-3703233.en.html
> 
> in v16/R, I believe it is only be possible to obtain such a reference
> immediately following creation (WP Insert table)
> 
> ---
> 
> the way I understand it is that a write pro document is a combination of 
> range (of text) and other objects that do not fit in any particular range (of 
> text). such objects are also referred to as a "range object" in the language 
> (table, row, column, anchored picture, etc)
> 
> http://doc.4d.com/4Dv17/4D/17/Accessing-document-contents-by-programming.300-3726304.en.html#3507530
> 
> commands such as WP SELECT work on range of text.
> 
> some commands like WP Get selection works on a range of text or a "range 
> object".
> (result.type tells which)
> 
> 2018/07/12 0:57、Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>> のメール：
> So, what if the user has created a table (through a method), and now want to 
> select a cell in that table and change it’s background color, or it’s width?
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: 4D Write PRO: editing a table / collections

[Two Way Communications via 4D_Tech]

So, what if the user has created a table (through a method), and now want to 
select a cell in that table and change it’s background color, or it’s width?

How can we do that?


Rudy Mortier
Two Way Communications bvba 



> On 11 Jul 2018, at 17:05, Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Thanks Achim. But what if the cell is not selected, and I want to fill the 
> cells by programming?
> 
> 
> 
> Rudy Mortier
> Two Way Communications bvba 
> 
> 
> 
>> On 11 Jul 2018, at 17:00, Achim Peschke via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> I do it this way:
>> 
>> Cursor is in the cell or text is selected in the cell or cell is selected. I 
>> get the selection using WP Get selection. The I call WP SET TEXT with the 
>> selection range, give the new text and set parameters 3 and 4 accordingly.
>> 
>> Achim
>> 
>> 
>> 
>> 
>> -Ursprüngliche Nachricht-
>> Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Two Way 
>> Communications via 4D_Tech
>> Gesendet: Mittwoch, 11. Juli 2018 16:37
>> An: 4D iNug Technical <4d_tech@lists.4d.com>
>> Cc: Two Way Communications 
>> Betreff: Re: 4D Write PRO: editing a table / collections
>> 
>> Thanks Achim!
>> 
>> Can I also set a text value or a reference in a specific table cell?
>> 
>> I tried:
>> 
>> $CellObj:=WP Table get cells(a$TableObj;colNr;rowNr)
>> WP SET TEXT($CellObj;”test”;wk replace;wk include in range)
>> 
>> but I get an error. When I try ST SET TEXT, the text is placed on top of the 
>> 4D Write document.
>> 
>> 
>> 
>> Rudy Mortier
>> Two Way Communications bvba
>> 
>> 
>> 
>>> On 11 Jul 2018, at 13:59, Achim Peschke via 4D_Tech <4d_tech@lists.4d.com> 
>>> wrote:
>>> 
>>> Do it simply. If the cursor is in a table, WP Get selection. With this 
>>> range WP Get elements(range; 4). Working this way you get the table and its 
>>> id as object in a collection. If the selection spans over more than 1 
>>> table, the collection contains an element for every table contained in the 
>>> selection.
>>> 
>>> Achim
>>> 
>>> 
>>> 
>>> 
>>> -Ursprüngliche Nachricht-
>>> Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Two
>>> Way Communications via 4D_Tech
>>> Gesendet: Mittwoch, 11. Juli 2018 12:21
>>> An: 4D iNug Technical <4d_tech@lists.4d.com>
>>> Cc: Two Way Communications 
>>> Betreff: Re: 4D Write PRO: editing a table / collections
>>> 
>>> In v17, we can now get the element id’s, and also select the table objects 
>>> in a document, so that is definitely an improvement.
>>> 
>>> But, in case there is more than 1 table in the document,  I fail to get a 
>>> reference for the table where the cursor is in… has anyone figured out how 
>>> to do that?
>>> 
>>> How cool would that be ;-)
>>> 
>>> Rudy Mortier
>>> Two Way Communications bvba
>>> 
>>> 
>>> 
>>>> On 11 Jul 2018, at 00:30, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> 
>>>> wrote:
>>>> 
>>>> Try putting the collection in a c_object and store the c_object in an
>>>> c_object field, or put the collection directly into the c_object
>>>> field
>>>> 
>>>> I am assuming that $tableObj is the object reference to the table. If 
>>>> tables are anything like images, your plan might not work. Each time a 
>>>> document is opened any images in the document gets a new object reference. 
>>>> If that is the case with tables, your stored references will not work.
>>>> 
>>>> John
>>>> 
>>>> 
>>>> 
>>>> John Baughman
>>>> 1331 Auwaiku Street
>>>> Kailua, Hawaii  96734
>>>> (808) 262-0328
>>>> john...@hawaii.rr.com
>>>> 
>>>>> On Jul 10, 2018, at 11:45 AM, Two Way Communications via 4D_Tech 
>>>>> <4d_tech@lists.4d.com> wrote:
>>>>> 
>>>>> I love the concept of tables in 4D Write Pro.
>>>>> 
>>>>> You can only add or change them by code, which is fine by me for the  
>>>>> moment.
>>>>> But what to do if a table has been created, and, in the 4D Write Pro 
>>>>> document, you would

Re: 4D Write PRO: editing a table / collections

[Two Way Communications via 4D_Tech]

Thanks Achim. But what if the cell is not selected, and I want to fill the 
cells by programming?



Rudy Mortier
Two Way Communications bvba 



> On 11 Jul 2018, at 17:00, Achim Peschke via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I do it this way:
> 
> Cursor is in the cell or text is selected in the cell or cell is selected. I 
> get the selection using WP Get selection. The I call WP SET TEXT with the 
> selection range, give the new text and set parameters 3 and 4 accordingly.
> 
> Achim
> 
> 
> 
> 
> -Ursprüngliche Nachricht-
> Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Two Way 
> Communications via 4D_Tech
> Gesendet: Mittwoch, 11. Juli 2018 16:37
> An: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Two Way Communications 
> Betreff: Re: 4D Write PRO: editing a table / collections
> 
> Thanks Achim!
> 
> Can I also set a text value or a reference in a specific table cell?
> 
> I tried:
> 
> $CellObj:=WP Table get cells(a$TableObj;colNr;rowNr)
> WP SET TEXT($CellObj;”test”;wk replace;wk include in range)
> 
> but I get an error. When I try ST SET TEXT, the text is placed on top of the 
> 4D Write document.
> 
> 
> 
> Rudy Mortier
> Two Way Communications bvba
> 
> 
> 
>> On 11 Jul 2018, at 13:59, Achim Peschke via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> Do it simply. If the cursor is in a table, WP Get selection. With this range 
>> WP Get elements(range; 4). Working this way you get the table and its id as 
>> object in a collection. If the selection spans over more than 1 table, the 
>> collection contains an element for every table contained in the selection.
>> 
>> Achim
>> 
>> 
>> 
>> 
>> -Ursprüngliche Nachricht-
>> Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Two
>> Way Communications via 4D_Tech
>> Gesendet: Mittwoch, 11. Juli 2018 12:21
>> An: 4D iNug Technical <4d_tech@lists.4d.com>
>> Cc: Two Way Communications 
>> Betreff: Re: 4D Write PRO: editing a table / collections
>> 
>> In v17, we can now get the element id’s, and also select the table objects 
>> in a document, so that is definitely an improvement.
>> 
>> But, in case there is more than 1 table in the document,  I fail to get a 
>> reference for the table where the cursor is in… has anyone figured out how 
>> to do that?
>> 
>> How cool would that be ;-)
>> 
>> Rudy Mortier
>> Two Way Communications bvba
>> 
>> 
>> 
>>> On 11 Jul 2018, at 00:30, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> 
>>> wrote:
>>> 
>>> Try putting the collection in a c_object and store the c_object in an
>>> c_object field, or put the collection directly into the c_object
>>> field
>>> 
>>> I am assuming that $tableObj is the object reference to the table. If 
>>> tables are anything like images, your plan might not work. Each time a 
>>> document is opened any images in the document gets a new object reference. 
>>> If that is the case with tables, your stored references will not work.
>>> 
>>> John
>>> 
>>> 
>>> 
>>> John Baughman
>>> 1331 Auwaiku Street
>>> Kailua, Hawaii  96734
>>> (808) 262-0328
>>> john...@hawaii.rr.com
>>> 
>>>> On Jul 10, 2018, at 11:45 AM, Two Way Communications via 4D_Tech 
>>>> <4d_tech@lists.4d.com> wrote:
>>>> 
>>>> I love the concept of tables in 4D Write Pro.
>>>> 
>>>> You can only add or change them by code, which is fine by me for the  
>>>> moment.
>>>> But what to do if a table has been created, and, in the 4D Write Pro 
>>>> document, you would want to add a column, or a row? Or change the width, 
>>>> the borders etc?
>>>> 
>>>> Apparently there is no way to select the table object. I have tried WP Get 
>>>> selection, but that doesn’t work for tables. Or maybe I am missing 
>>>> something.
>>>> 
>>>> I found out that I can select the table again (in code) using WP
>>>> SELECT($tableObj). So, as soon as I have created the table in code, I copy 
>>>> the table object in a collection. (Yes, I am using deep copy) I do that 
>>>> for every table created in the 4D Write Pro document.
>>>> When I save the record, I put the collection variable in a blob (VARIABLE 
>>>> TO BLOB), so I can retrieve the objects again.
>>>>

Re: 4D Write PRO: editing a table / collections

[Two Way Communications via 4D_Tech]

Thanks Achim!

Can I also set a text value or a reference in a specific table cell?

I tried:

$CellObj:=WP Table get cells(a$TableObj;colNr;rowNr)
WP SET TEXT($CellObj;”test”;wk replace;wk include in range)

but I get an error. When I try ST SET TEXT, the text is placed on top of the 4D 
Write document.



Rudy Mortier
Two Way Communications bvba 



> On 11 Jul 2018, at 13:59, Achim Peschke via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Do it simply. If the cursor is in a table, WP Get selection. With this range 
> WP Get elements(range; 4). Working this way you get the table and its id as 
> object in a collection. If the selection spans over more than 1 table, the 
> collection contains an element for every table contained in the selection.
> 
> Achim
> 
> 
> 
> 
> -Ursprüngliche Nachricht-
> Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Two Way 
> Communications via 4D_Tech
> Gesendet: Mittwoch, 11. Juli 2018 12:21
> An: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Two Way Communications 
> Betreff: Re: 4D Write PRO: editing a table / collections
> 
> In v17, we can now get the element id’s, and also select the table objects in 
> a document, so that is definitely an improvement.
> 
> But, in case there is more than 1 table in the document,  I fail to get a 
> reference for the table where the cursor is in… has anyone figured out how to 
> do that?
> 
> How cool would that be ;-)
> 
> Rudy Mortier
> Two Way Communications bvba
> 
> 
> 
>> On 11 Jul 2018, at 00:30, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> Try putting the collection in a c_object and store the c_object in an
>> c_object field, or put the collection directly into the c_object
>> field
>> 
>> I am assuming that $tableObj is the object reference to the table. If tables 
>> are anything like images, your plan might not work. Each time a document is 
>> opened any images in the document gets a new object reference. If that is 
>> the case with tables, your stored references will not work.
>> 
>> John
>> 
>> 
>> 
>> John Baughman
>> 1331 Auwaiku Street
>> Kailua, Hawaii  96734
>> (808) 262-0328
>> john...@hawaii.rr.com
>> 
>>> On Jul 10, 2018, at 11:45 AM, Two Way Communications via 4D_Tech 
>>> <4d_tech@lists.4d.com> wrote:
>>> 
>>> I love the concept of tables in 4D Write Pro.
>>> 
>>> You can only add or change them by code, which is fine by me for the  
>>> moment.
>>> But what to do if a table has been created, and, in the 4D Write Pro 
>>> document, you would want to add a column, or a row? Or change the width, 
>>> the borders etc?
>>> 
>>> Apparently there is no way to select the table object. I have tried WP Get 
>>> selection, but that doesn’t work for tables. Or maybe I am missing 
>>> something.
>>> 
>>> I found out that I can select the table again (in code) using WP
>>> SELECT($tableObj). So, as soon as I have created the table in code, I copy 
>>> the table object in a collection. (Yes, I am using deep copy) I do that for 
>>> every table created in the 4D Write Pro document.
>>> When I save the record, I put the collection variable in a blob (VARIABLE 
>>> TO BLOB), so I can retrieve the objects again.
>>> 
>>> When I open the record, I read the collection from the blob (BLOB TO 
>>> VARIABLE), but OK returns 0, and the collection variable stays empty.
>>> 
>>> Here’s the code:
>>> 
>>> C_COLLECTION(c4WRTableCollections)
>>> c4WRTableCollections:=New collection
>>> BLOB TO
>>> VARIABLE([_10_Report_templates]Blob_4WR_tbls;c4WRTableCollections)
>>> 
>>> 
>>> 
>>> Any idea why it’s doing that, and how one could create a table in a 4D 
>>> Writw PRO document, save it, open it again, and edit the table?
>>> 
>>> 
>>> 
>>> Regards,
>>> 
>>> Rudy Mortier
>>> Two Way Communications bvba
>>> 
>>> 
>>> *
>>> *
>>> 4D Internet Users Group (4D iNUG)
>>> FAQ:  http://lists.4d.com/faqnug.html
>>> Archive:  http://lists.4d.com/archives.html
>>> Options: https://lists.4d.com/mailman/options/4d_tech
>>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>>> **

Re: 4D Write PRO: editing a table / collections

[Two Way Communications via 4D_Tech]

In v17, we can now get the element id’s, and also select the table objects in a 
document, so that is definitely an improvement.

But, in case there is more than 1 table in the document,  I fail to get a 
reference for the table where the cursor is in… has anyone figured out how to 
do that?

How cool would that be ;-)

Rudy Mortier
Two Way Communications bvba 



> On 11 Jul 2018, at 00:30, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Try putting the collection in a c_object and store the c_object in an 
> c_object field, or put the collection directly into the c_object  field
> 
> I am assuming that $tableObj is the object reference to the table. If tables 
> are anything like images, your plan might not work. Each time a document is 
> opened any images in the document gets a new object reference. If that is the 
> case with tables, your stored references will not work.
> 
> John
> 
> 
> 
> John Baughman
> 1331 Auwaiku Street
> Kailua, Hawaii  96734
> (808) 262-0328
> john...@hawaii.rr.com
> 
>> On Jul 10, 2018, at 11:45 AM, Two Way Communications via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> I love the concept of tables in 4D Write Pro.
>> 
>> You can only add or change them by code, which is fine by me for the  moment.
>> But what to do if a table has been created, and, in the 4D Write Pro 
>> document, you would want to add a column, or a row? Or change the width, the 
>> borders etc?
>> 
>> Apparently there is no way to select the table object. I have tried WP Get 
>> selection, but that doesn’t work for tables. Or maybe I am missing something.
>> 
>> I found out that I can select the table again (in code) using WP 
>> SELECT($tableObj). So, as soon as I have created the table in code, I copy 
>> the table object in a collection. (Yes, I am using deep copy)
>> I do that for every table created in the 4D Write Pro document.
>> When I save the record, I put the collection variable in a blob (VARIABLE TO 
>> BLOB), so I can retrieve the objects again.
>> 
>> When I open the record, I read the collection from the blob (BLOB TO 
>> VARIABLE), but OK returns 0, and the collection variable stays empty.
>> 
>> Here’s the code:
>> 
>> C_COLLECTION(c4WRTableCollections)   
>> c4WRTableCollections:=New collection
>> BLOB TO VARIABLE([_10_Report_templates]Blob_4WR_tbls;c4WRTableCollections)
>>  
>> 
>>  
>> Any idea why it’s doing that, and how one could create a table in a 4D Writw 
>> PRO document, save it, open it again, and edit the table?
>> 
>> 
>> 
>> Regards,
>> 
>> Rudy Mortier
>> Two Way Communications bvba 
>> 
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: 4D Write PRO: editing a table / collections

[Two Way Communications via 4D_Tech]

You’re right, John.

When I re-open the document, the table has another reference, and WP SELECT 
doesn’t work anymore…

Is there any other way to get the object reference for a table in a 4D Write 
PRO document?

WP Get selection doesn’t seem to work for table objects: 

$WPRange:=WP Get selection([_10_Report_templates]Template_WRPRO)
WP GET ATTRIBUTES($WPRange;wk start;Start)
WP GET ATTRIBUTES($WPRange;wk end;$end)
WP GET ATTRIBUTES($WPRange;wk type;$type)
WP GET ATTRIBUTES($WPRange;wk table id;$tblid)

wk type always returns 0, and an error is returned when getting the wk table id 
… no matter what I select in the document.


Rudy Mortier
Two Way Communications bvba 



> On 11 Jul 2018, at 00:30, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Try putting the collection in a c_object and store the c_object in an 
> c_object field, or put the collection directly into the c_object  field
> 
> I am assuming that $tableObj is the object reference to the table. If tables 
> are anything like images, your plan might not work. Each time a document is 
> opened any images in the document gets a new object reference. If that is the 
> case with tables, your stored references will not work.
> 
> John
> 
> 
> 
> John Baughman
> 1331 Auwaiku Street
> Kailua, Hawaii  96734
> (808) 262-0328
> john...@hawaii.rr.com
> 
>> On Jul 10, 2018, at 11:45 AM, Two Way Communications via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> I love the concept of tables in 4D Write Pro.
>> 
>> You can only add or change them by code, which is fine by me for the  moment.
>> But what to do if a table has been created, and, in the 4D Write Pro 
>> document, you would want to add a column, or a row? Or change the width, the 
>> borders etc?
>> 
>> Apparently there is no way to select the table object. I have tried WP Get 
>> selection, but that doesn’t work for tables. Or maybe I am missing something.
>> 
>> I found out that I can select the table again (in code) using WP 
>> SELECT($tableObj). So, as soon as I have created the table in code, I copy 
>> the table object in a collection. (Yes, I am using deep copy)
>> I do that for every table created in the 4D Write Pro document.
>> When I save the record, I put the collection variable in a blob (VARIABLE TO 
>> BLOB), so I can retrieve the objects again.
>> 
>> When I open the record, I read the collection from the blob (BLOB TO 
>> VARIABLE), but OK returns 0, and the collection variable stays empty.
>> 
>> Here’s the code:
>> 
>> C_COLLECTION(c4WRTableCollections)   
>> c4WRTableCollections:=New collection
>> BLOB TO VARIABLE([_10_Report_templates]Blob_4WR_tbls;c4WRTableCollections)
>>  
>> 
>>  
>> Any idea why it’s doing that, and how one could create a table in a 4D Writw 
>> PRO document, save it, open it again, and edit the table?
>> 
>> 
>> 
>> Regards,
>> 
>> Rudy Mortier
>> Two Way Communications bvba 
>> 
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

4D Write PRO: editing a table / collections

[Two Way Communications via 4D_Tech]

I love the concept of tables in 4D Write Pro.

You can only add or change them by code, which is fine by me for the  moment.
But what to do if a table has been created, and, in the 4D Write Pro document, 
you would want to add a column, or a row? Or change the width, the borders etc?

Apparently there is no way to select the table object. I have tried WP Get 
selection, but that doesn’t work for tables. Or maybe I am missing something.

I found out that I can select the table again (in code) using WP 
SELECT($tableObj). So, as soon as I have created the table in code, I copy the 
table object in a collection. (Yes, I am using deep copy)
I do that for every table created in the 4D Write Pro document.
When I save the record, I put the collection variable in a blob (VARIABLE TO 
BLOB), so I can retrieve the objects again.

When I open the record, I read the collection from the blob (BLOB TO VARIABLE), 
but OK returns 0, and the collection variable stays empty.

Here’s the code:

C_COLLECTION(c4WRTableCollections)  
c4WRTableCollections:=New collection
BLOB TO VARIABLE([_10_Report_templates]Blob_4WR_tbls;c4WRTableCollections)



Any idea why it’s doing that, and how one could create a table in a 4D Writw 
PRO document, save it, open it again, and edit the table?



Regards,

Rudy Mortier
Two Way Communications bvba 


**
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: Remote access to 4D Server.

[Two Way Communications via 4D_Tech]

Another solution is to use Citrix. A number of my customers work this way from 
home, and run 4D client this way, day-in, day-out.

It does require you to set up a Citrix server and to buy Citrix licenses, so 
this is maybe not what you are looking for.

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 28 Jun 2018, at 11:45, Robert ListMail via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I’ve got a new database in the requirements gathering stage that will require 
> users to work with, mostly enter data, while at another location via WiFi 
> connection. I suppose the could connect in one of the following ways:
> -vpn to office and use 4D client. 
> -4D client over internet if the three required firewall holes can be 
> accommodated. 
> -web client access. The required portion required for the remote session 
> is available via standard browser. 
> -4D Mobile, is anyone really using this? :)
> -something else?
> 
> So, which connectivity method have you depended upon for your projects? If 
> you have web clients, how is that architected, which approach? 
> 
> Thanks,
> 
> Robert
> 
> Sent from my iPhone
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D 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: 4Dv16R6: Object on form still active when another object is on top

[Two Way Communications via 4D_Tech]

Hi Kirk,
Yes, of course. But I wanted to still show the underlying object with a 
‘dimmed’ look. (I like beautiful interfaces ;-) )
But this is a change in comparison to older versions, no? Because clicks are 
received by the underlying objects, which was not the case in older versions.

Anyway, with a fresh mind, I also added an invisible button on top op the 
objects, who’s visibility is set to true when I want to ‘dim’ the underlying 
objects, and that seems to do the trick.


Regards,

Rudy Mortier
Two Way Communications bvba 



> On 28 Jun 2018, at 13:04, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Rudy,
> If the 'covered' object is tabable simply placing another object on top of
> it won't stop entry, it just makes it less apparent what's going on.
> 
> Instead of changing the visibility of the cover object why not just make
> the enterable object itself invisible? This does make it non-enterable but
> it's still available to the form methods.
> 
> On Thu, Jun 28, 2018 at 2:08 AM Two Way Communications via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Has anyone else noticed this?
>> 
>> I have a form that shows enterable variables, popups, picture buttons and
>> rulers.
>> 
>> In some cases I want to disable these objects. I put a rectangle object on
>> top of it, and set this object’s visibility to ’true’.
>> I use a .png file that is semi-transparent, so the underlying objects look
>> dimmed.
>> 
>> However, when I click on them, they still react as if the object above was
>> not there. Popups work, variables can be entered, rulers change value.
>> 
>> Is this by design or merely a flaw?
>> 
>> 
>> 
>> Kind regards,
>> 
>> Rudy Mortier
>> Two Way Communications bvba
>> 
>> 
>> **
>> 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
>> **
> 
> 
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *We go vote - they go home*
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D 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: Remote access to 4D Server.

[Two Way Communications via 4D_Tech]

Hi Robert,

I recently did a test over internet using 4D client.
I have set up a virtual Windows machine on Amazon, the smallest configuration 
possible. This server runs Windows 10, and has 1GB (!) of memory, 30 GB storage.

I have configured and installed 4D server v16R6 on it, using Remote Desktop. 
The response via Remote Desktop is very, very slow, but once 4D server has 
started, you can leave it alone.

The speed, when connecting with 4D client, is actually quite decent, and i 
assume that, if the amazon server is upgraded to a faster processor, more 
cores, more memory and more bandwidth, the speed will be quit good.

Web client access and 4D Mobile will involve a lot more coding, and might be 
harder to do, depending on your skills with HTML, javascript, Wakanda etc.


Regards,

Rudy Mortier
Two Way Communications bvba 



> On 28 Jun 2018, at 11:45, Robert ListMail via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I’ve got a new database in the requirements gathering stage that will require 
> users to work with, mostly enter data, while at another location via WiFi 
> connection. I suppose the could connect in one of the following ways:
> -vpn to office and use 4D client. 
> -4D client over internet if the three required firewall holes can be 
> accommodated. 
> -web client access. The required portion required for the remote session 
> is available via standard browser. 
> -4D Mobile, is anyone really using this? :)
> -something else?
> 
> So, which connectivity method have you depended upon for your projects? If 
> you have web clients, how is that architected, which approach? 
> 
> Thanks,
> 
> Robert
> 
> Sent from my iPhone
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

4Dv16R6: Object on form still active when another object is on top

[Two Way Communications via 4D_Tech]

Has anyone else noticed this?

I have a form that shows enterable variables, popups, picture buttons and 
rulers.

In some cases I want to disable these objects. I put a rectangle object on top 
of it, and set this object’s visibility to ’true’.
I use a .png file that is semi-transparent, so the underlying objects look 
dimmed.

However, when I click on them, they still react as if the object above was not 
there. Popups work, variables can be entered, rulers change value.

Is this by design or merely a flaw?



Kind regards,

Rudy Mortier
Two Way Communications bvba 


**
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: Comparing all methods in structures

[Two Way Communications via 4D_Tech]

Hi Jeremy,

What I do is to export all methods and forms in text files, using the commands 
available in ‘Design Object Access’.

Then I use Text Wrangler (BBEdit will also do this) to compare the text files.

It will list all the differences. Great tool!

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 15 Jun 2018, at 19:15, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I have two structures, which contain quite a few methods. One has been edited 
> a bit but due to a slapdash approach to record-keeping, I can’t easily 
> establish which methods have been edited. Is there an easy way to compare the 
> methods in the two structures?
> 
> I suppose running a small method, in each structure, which exports all the 
> methods into a folder and then using something like BBEdit to do the 
> comparison would work, but has anyone had to do this and come up with 
> something better?
> 
> Jeremy
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D 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: Musing on creating PDFs in 4D

[Two Way Communications via 4D_Tech]

Hi Kirk,

Are you using the QPDF plugin from pluggers? If so, which version, QPDF plugin 
light or Pro?


Regards,

Rudy Mortier
Two Way Communications bvba 



> On 14 Jun 2018, at 22:48, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> John,
> Using QPDF is much like using PRINT FORM. The plugin commands allow you to
> precisely control where on the page something (text, line, image) will
> appear. Unlike PRINT FORM you can add to existing pages. This greatly
> simplifies, for instance, adding page numbers in the form of "Page x of y".
> You can traverse back and forth through your pages if necessary.
> 
> QPDF allows me to use templates. These can be pre-formatted PDFs or I can
> build one on the fly. My usual workflow in a method is to create the
> document and set the meta data (author, date, subject, etc. - stuff I don't
> think you can do at all when creating PDFs via print engines). Then I'll
> make the page template with things like the report header and footer info.
> Then I basically run down the page adding material just like I would with
> PRINT FORM. I like to make my methods that add material to the page
> functions that return the last y value. Coupled with a method to check for
> available space and handle page breaks it works well.
> 
> I may get around to locating these methods in a component for ease of reuse
> as I think about.
> 
> A few other things I can do with the plugin are include existing PDFs. This
> didn't seem like an incredibly useful feature at first but it is. In the
> case of sales quotes some salesmen like to include cut sheets, drawings or
> brochures from the vendor with their bid. Another use is creating or
> reading PDF forms. If you have a PDF form you must populate but the form is
> really just a scan of something you can still place text in the appropriate
> locations on the page. It's a pain but you only have to do it once.
> 
> Another benefit I don't believe is available any other way is adding
> bookmarks and internal references. Bookmarks are what you see in the
> sidebar and allow you to navigate large documents. Internal references are
> like anchors on a web page and work the same way.
> 
> Don't get me wrong, I have not abandoned traditional print forms by any
> means. It takes some effort to build a PDF form in code for anything beyond
> very simple needs. It's not the right solution for everything. But for
> certain types of documents I'm finding working with it a very deep breath
> of fresh air.
> 
> On Thu, Jun 14, 2018 at 11:07 AM JOHN BAUGHMAN via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Interesting. I have never had a situation where I did not have a
>> relatively  good idea of what a document will look like such that I
>> couldn't create 1 or more variable populated forms to cover all the
>> possibilities.
>> 
>> 
>> John Baughman
>> 1331 Auwaiku Street
>> Kailua, Hawaii  96734
>> (808) 262-0328
>> john...@hawaii.rr.com
>> 
>>> On Jun 14, 2018, at 7:14 AM, Kirk Brooks via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>> 
>>> John,
>>> Yes. No 4D form printing at all.
>>> 
>>> On Thu, Jun 14, 2018 at 10:14 AM JOHN BAUGHMAN via 4D_Tech <
>>> 4d_tech@lists.4d.com> wrote:
>>> 
 Kirk, are you talking about creating the pdf strictly in code?
 
 Otherwise, as Pat pointed out 4D Write Pro can be used, as can 4D forms…
 
 SET PRINT OPTION(Destination option;3;$FolderPath+"MyTest.pdf")
 OPEN PRINTING JOB
 Print form("MyTest4DForm";Form header)
 CLOSE PRINTING JOB
 
 PDFs from 4D forms using this methodology works both on the client and
>> on
 the server.
 
 
 John Baughman
 1331 Auwaiku Street
 Kailua, Hawaii  96734
 (808) 262-0328
 john...@hawaii.rr.com
 
> On Jun 14, 2018, at 5:37 AM, Pat Bensky via 4D_Tech <
 4d_tech@lists.4d.com> wrote:
> 
> Another option, which may or may not be suitable depending on the
 project,
> is to build the document with 4DWrite Pro and then simply set the print
> option and print it:
> 
> *SET PRINT OPTION*(Orientation option;iPrintOption) // landscape or
 portrait
> 
> *SET PRINT OPTION*(Destination option;3;$pathname)  // PDF
> 
> *WP USE PAGE SETUP*(oWPdoc)
> 
> *WP PRINT*(oWPdoc)
> 
> *SHOW ON DISK*($pathname)
> 
> This will require you to learn how to program Write Pro, but I think
>> that
> will be a bit simpler than learning how to create PDFs, it won't cost
>> you
> any extra, and those skills might come in handy for other 4D projects
>> :)
> 
> Pat
> 
> On Thu, 14 Jun 2018 at 16:22, Kirk Brooks via 4D_Tech <
 4d_tech@lists.4d.com>
> wrote:
> 
>> I just chimed in on a conversation on the forums about using PDF
>> Creator
>> . In this
 case
>> the OP was asking about making it work on the server. I'm sure anyone
 who
>> tried to 

Re: Objects without Stylesheets suddenly displayed as Wingdings!

[Two Way Communications via 4D_Tech]

Hi Cheryl,

I’m afraid there is no solution outside 4D.

But there is e recent tip in the knowledgebase on how to find these objects.

And if they can be located, I suppose that the font can be set for thos objects.

This way you could write code to address the issues.


Regards,

Rudy Mortier
Two Way Communications bvba 



> On 13 Jun 2018, at 20:57, Cheryl Michels via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> A recent Windows update (Windows 10, version 1803) has resulted in at least 
> two of our customer sites reporting that certain form objects are now 
> displaying as Wingdings.  When I look at these objects, I note that the 
> developer did not assign a style sheet to them.  Against our SOP, but that is 
> a different story.  So, using Form Introspection, I have discovered over 
> 14,000 objects without stylesheets.  Not a trivial task to set them all.
> 
> Has anyone else run into this problem?  Is there something I can do globally 
> that I'm not thinking of?  Is there something that is causing it to select 
> Wingdings that I can undo?
> 
> Cheryl Michels
> President and System Architect
> che...@freezerworks.com
> (425) 673-1974
> www.freezerworks.com
> Dataworks Development, Inc.
> Providing secure and configurable data management solutions for research and 
> clinical labs since 1987.
> [Description: 
> cid:image003.png@01D3FCEC.D2F77330]
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D 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: 15.5 The database cannot be published

[Two Way Communications via 4D_Tech]

Hi Kirk,

I asked my customer… he was going to check.

Do you mean on the same machine or in the entire LAN?


Regards,

Rudy


> On 28 May 2018, at 17:06, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Rudy,
> Check to see if there is another web server running  and using the same
> port.
> 
> On Mon, May 28, 2018 at 4:40 AM Rudy.Mortier--- via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Hi Doug,
>> 
>> I am having the same problem. Where can I find the Active4D thread?
>> 
>> Regards,
>> 
>> Rudy
>> 
>> 
>> Never mind. I just saw the Active4D thread that most likely will fix this.
>> 
>> 
>> 
>> On Thu, Oct 26, 2017 at 9:21 AM, Doug Hall  wrote:
>> 
>>> After updating to 15.5, I'm getting this error on my Mac web client: "The
>>> database cannot be published. (:Users::
>>> Library:Caches:4D:<4DCacheFolder>)."
>>> 
>>> Any idea what might be causing this? I removed the cache folder, so that
>>> it would recreate it, but it gives the same error.
>>> 
>>> Thanks,
>>> Doug
>>> 
>> **
>> 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
>> **
>> 
>> Quoted from:
>> 
>> http://4d.1045681.n5.nabble.com/15-5-The-database-cannot-be-published-tp5754999p5755001.html
>> 
>> 
>> _
>> Sent from http://4d.1045681.n5.nabble.com
>> 
>> **
>> 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
>> **
> 
> 
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *We go vote - they go home*
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D 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: Preventing Return and Enter from Closing a Dialog

[Two Way Communications via 4D_Tech]

Hi,

Check under the ‘Edit’ menu: ‘Database settings’
Then select the ‘Interface’ tab

In the middle of the window, you will see the shortcuts that are being used for 
accepting and canceling input forms.

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 20 May 2018, at 22:06, Sannyasin Siddhanathaswami via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Aloha,
> 
> I'm playing with the "proper" way to open up a form. Here's what I have:
>Open form window([ARInvoice_Payments];"Invoice_Payment_List";Plain form 
> window;On the left;Vertically centered)
>DIALOG([ARInvoice_Payments];"Invoice_Payment_List")
> 
> It works fine, but if a user presses "Enter" the window closes. I actually 
> want "Return" and "Enter" to activate a search button. But that doesn't 
> happen either.
> 
> If I make the search button the search button, the default button, that traps 
> the "Return" key from closing the window.
> 
> An invisible button to trap the "Enter" key doesn't work.
> Assigning a shortcut of "Enter" to my search button doesn't work
> 
> Am I missing something simple?
> 
> 
> 
> Sannyasin Siddhanathaswami
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D 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: First experiments with 4D View PRO

[Two Way Communications via 4D_Tech]

Keisuke,

With all due respect, I will stay with the listbox for the time being. Clearly, 
4D View Pro is not ready yet to be used.

I can’t see any benefit at all by trying to figure out the json schema.

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 17 May 2018, at 22:44, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> a 4D View Pro document is stored in an object.
> 
> http://doc.4d.com/4Dv16R6/4D/16-R6/Handling-4D-View-Pro-areas.300-3631583.en.html
> 
> schema: /Applications/4D/4D v17/4D.app/Contents/Components/4D 
> ViewPro.4dbase/Resources/4DViewSchema.json
> 
> you can use regular OB commands or object notation to programatically create 
> the document
> 
> http://doc.4d.com/4Dv16R6/4D/16-R6/VP-IMPORT-FROM-OBJECT.301-3631582.en.html
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D 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: First experiments with 4D View PRO

[Two Way Communications via 4D_Tech]

Hi Keisuke,

Thanks for elaborating on this.

However, I can’t imagine that the only purpose is to open 4D View files, and I 
am sure that additional functionality will be added in future versions. (at 
least, that’s what we’ve been told at the summit)

It’s just that, at this point, the 4D View Pro spreadsheet is kind of useless 
if one can’t master the Javascript code to add rows or columns, or import or 
export to excel, .csv etc.
I have looked at the Spread.js documentation, and couldn’t find any examples on 
how to import or export. I don’t have that much experience with Javascript, 
like most of the 4D developers.

It would be useful to be able to manipulate the rows, columns and cells and 
fill them with data from 4D arrays or tables, no?

Maybe I am just to impatient to use this great new feature…

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 17 May 2018, at 16:19, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 4D has studied how the classic 4D View plugin has beeb used in various 
> applications,
> and found that there were essentially two distinct usages; "as a list" and 
> "as a spreadsheet".
> 
> based on that understanding,
> two different paths have been defined to carry on the 4D View legacy:
> 
> 1. a set of privileged features for the listbox object (variable line height, 
> embedded controls, etc) and
> 2. a modern spreadsheet application with the capability to open existing 4D 
> View documents.
> 
> the 2 are completely unrelated features,
> except for the fact that they both require 4D View licenses to unlock.
> you could say that 4D View has been split into 2 products.
> 
> to use the new 4D View area which is a spreadsheet,
> you would typically import existing 4D View documents, or
> create new document via the UI and store them as a object or export in Excel 
> format.
> 
> it does not replace the list type 4D View Pro features,
> rather, the 2 features compliments each other.
> 
>> 2018/05/17 18:10、Two Way Communications via 4D_Tech <4d_tech@lists.4d.com> 
>> のメール：
>> Has anyone played around with 4D View Pro already?
>> I tried to put object arrays into the 4D View Pro area, like it was a 
>> listbox.
>> And although it does work with a listbox (4D v16R6), the 4D View Pro area 
>> stays empty.
>> Any idea how to even add columns and rows in 4D View Pro?
>> I guess one could use javascript, but how do you get javascript to access 
>> the object arrays and put the contents into 4D View Pro?
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

First experiments with 4D View PRO

[Two Way Communications via 4D_Tech]

Has anyone played around with 4D View Pro already?

I tried to put object arrays into the 4D View Pro area, like it was a listbox.

And although it does work with a listbox (4D v16R6), the 4D View Pro area stays 
empty.

Any idea how to even add columns and rows in 4D View Pro?

I guess one could use javascript, but how do you get javascript to access the 
object arrays and put the contents into 4D View Pro?


Regards,

Rudy Mortier
Two Way Communications bvba 


**
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: setting up mirror

[Two Way Communications via 4D_Tech]

I do not backup the master database.

The incremental log files are indeed numbered Datafile[0004-0034].journal, so 
no need in changing their names.

What I do, is set up the mirror to do the automatic backup, but without a log 
file. Whenever there is an issue with the master database, you can restore the 
backup of the mirror database and integrate all the incremental log files that 
have been generated after the last backup.

This setup is simple. but very effective.

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 15 May 2018, at 23:16, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I assume that means you rename the .journal file to something like
> DataFileXX.journal, where X is nex number in line
> 
> or DataFile.X where extension is next number in line
> 
> or better yet DataFileMMDDHHMMSS.journal. That way unless run more than
> once per second you will always get a unique name.
> 
> Also  when creating second text file to show that copy is complete. Are you
> creating one file for each journal that is there so gthat if for some
> reason, the integrate does not happen More than one file can be handled at
> a time
> 
> 
> On Tue, May 15, 2018 at 5:08 PM, Benedict, Tom 
> wrote:
> 
>> 
>> 
>>> Thanks for your update. I assume you have a process on mirror that runs
>> and delays
>> 
>>> itself for x amount of time. What happens if you try and create a second
>> log but
>> 
>>> first has not been integrated. What do you do? Would you mind sharing
>> code.
>> 
>>> I know it should be pretty simple, but I always would prefer not to
>> re-invent the
>> 
>>> wheel. If so, can you email me privately.
>> 
>> 
>> 
>> We serialize the segmented log files. That decouples the segmentation flow
>> from the integration flow. We can take the mirror offline for a period of
>> time, then bring it back up and it automatically catches up. It also makes
>> it easy to multiple, redundant mirrors. We have 3 in our Production system.
>> It also allows us to rebuild a data file from a specific starting point
>> from logs.
>> 
>> 
>> 
>> Tom Benedict
>> 
>> Optum Inc
>> 
>> 
>> 
>> 
>> This e-mail, including attachments, may include confidential and/or
>> proprietary information, and may be used only by the person or entity
>> to which it is addressed. If the reader of this e-mail is not the intended
>> recipient or his or her authorized agent, the reader is hereby notified
>> that any dissemination, distribution or copying of this e-mail is
>> prohibited. If you have received this e-mail in error, please notify the
>> sender by replying to this message and delete this e-mail immediately.
>> 
> 
> 
> 
> -- 
> -
> Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
> Informed Solutions, Inc.
> Brookline, MA 02446 USA Registered 4D Developer
>   Providers of 4D, Sybase & SQL Server connectivity
>  http://www.informed-solutions.com
> -
> This message and any attached documents contain information which may be
> confidential, subject to privilege or exempt from disclosure under
> applicable law.  These materials are intended only for the use of the
> intended recipient. If you are not the intended recipient of this
> transmission, you are hereby notified that any distribution, disclosure,
> printing, copying, storage, modification or the taking of any action in
> reliance upon this transmission is strictly prohibited.  Delivery of this
> message to any person other than the intended recipient shall not
> compromise or waive such confidentiality, privilege or exemption
> from disclosure as to this communication.
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D 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: setting up mirror

[Two Way Communications via 4D_Tech]

Hi chuck,

I have been using option 1 for years now.
With 4D server version 13.x, I needed to intervene on a regular basis to fix 
errors with the log files.

With 4D server version 15.x, this is solid as a rock. No interventions in the 
last 6 months.

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 14 May 2018, at 21:08, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 
> I am finalizing code to set up a mirror and then an emergency server. 
> 
> I have two trains of thought, both of which use a shared folder to move the 
> log file into
> Option 1 Create a second text file after the journal has been copied and on 
> the mirror, have a process that runs every x minutes looking for both that 
> file ad the journal. When it finds both, it integrates journal and moves it 
> to an integrated directory and then deletes the text file
> 
> 2. After copy of journal, use an FN call in sql to launch an integrate 
> process on the mirror.
> 
> Any ideas which people would use more and feel more sure with. We will NOT be 
> using soap or HTTPS to do this
> 
> 
> Thanks and regards
> 
> 
> Chuck
> 
> Chuck Miller Voice: (617) 739-0306
> Informed Solutions, Inc. Fax: (617) 232-1064   
> mailto:cjmillerinformed-solutions.com 
> Brookline, MA 02446 USA Registered 4D Developer
>   Providers of 4D and Sybase connectivity
>  http://www.informed-solutions.com  
> 
> This message and any attached documents contain information which may be 
> confidential, subject to privilege or exempt from disclosure under applicable 
> law.  These materials are intended only for the use of the intended 
> recipient. If you are not the intended recipient of this transmission, you 
> are hereby notified that any distribution, disclosure, printing, copying, 
> storage, modification or the taking of any action in reliance upon this 
> transmission is strictly prohibited.  Delivery of this message to any person 
> other than the intended recipient shall not compromise or waive such 
> confidentiality, privilege or exemption from disclosure as to this 
> communication. 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D 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: EC2 server on Amazon AWS

[Two Way Communications via 4D_Tech]

Thanks, Spencer.

I added the ports to the Firewall and now it works.

I am a Mac user, and not that familiar with the Windows Firewall.

Just curious: do you connect on a daily basis with 4D client? How many users? 
What would you suggest to be the minimal configuration on AWS (RAM, cores) for 
it to run fast enough?

Regards,

Rudy Mortier
0475 440 633


Met vriendelijke groeten,

Rudy Mortier
Two Way Communications bvba 



> On 11 May 2018, at 16:40, Spencer Hinsdale via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 
> Hi Rudy,
> 
> 1) you need the public IP from your dashboard.  this may not be the IP that 
> 4d server appears to be listening to
> 
> 2) you need allow access from your dashboard by going to Security Groups and 
> adding your Ports (19812 - 19814)
> 
> 3)  you need to configure Windows Advance Firewall
> 
> 
> https://www.bigbusiness.com/solutions/6779
> 
>> On May 11, 2018, at 7:21 AM, Two Way Communications via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Hi,
>> 
>> Has anyone succeeded in setting up a 4D server on a virtual Windows server 
>> on AWS?
>> 
>> I have set up the server (free version), installed 4D server 416R6, added 
>> the licenses and launched the 4D database.
>> Additionally I configured the ports on the AWS server to also listen to the 
>> TCP and UDP addresses.
>> 
>> However, there is no way I can connect to it from a 4D client on my machine, 
>> Neither on the public address provided, nor the private IP address.
>> I tried with the public address, and even tried with appending :19813 as a 
>> port after the IP address.
>> 
>> Any tips will be greatly appreciated.
>> 
>> 
>> Regards,
>> 
>> Rudy Mortier
>> Two Way Communications bvba 
>> 
>> 
>> 
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

EC2 server on Amazon AWS

[Two Way Communications via 4D_Tech]

Hi,

Has anyone succeeded in setting up a 4D server on a virtual Windows server on 
AWS?

I have set up the server (free version), installed 4D server 416R6, added the 
licenses and launched the 4D database.
Additionally I configured the ports on the AWS server to also listen to the TCP 
and UDP addresses.

However, there is no way I can connect to it from a 4D client on my machine, 
Neither on the public address provided, nor the private IP address.
I tried with the public address, and even tried with appending :19813 as a port 
after the IP address.

Any tips will be greatly appreciated.


Regards,

Rudy Mortier
Two Way Communications bvba 




**
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 data in 4D format using XML

[Two Way Communications via 4D_Tech]

Hi Keisuke,

The link you have provided, unfortunately, is in Japanese ;-)

Are we talking about the same command? Because in the v16R6 documentation, it 
says:

If you pass an empty string to fileName 
<http://doc.4d.com/4Dv16R6/4D/16-R6/IMPORT-DATA.301-3548317.en.html#>, IMPORT 
DATA displays the standard save file dialog box, allowing the user to define 
the name, type, and location of the import file. Once the dialog box has been 
accepted, the Document system variable contains the access path and the name of 
the file. If the user clicks Cancel, the execution of the command is stopped 
and the OK system variable is set to 0.

Turns out this is a bug in the 64bit versions of 4D (I have tested with 4D 
v16R5 and v16R6). It DOES work in 32bit versions; I have tested with 15.5.

The workaround is:

$doc:=Open document("") 
If (ok=1)
CLOSE DOCUMENT($doc)
IMPORT DATA(document;$ref)
End if 


Regards,

Rudy Mortier
Two Way Communications bvba 



> On 1 May 2018, at 00:47, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> the docs reads:
> 
> When you pass this parameter, the import is carried out directly, without any 
> user intervention (unless you use the * option, see below).
> 
> http://doc.4d.com/4Dv16R6/4D/16-R6.1660/Not-for-32-bit-versions_3546700.999-857020.ja.html
> 
>> 2018/04/29 20:39、Two Way Communications via 4D_Tech <4d_tech@lists.4d.com> 
>> のメール：
>> However, If I use it in 4D v16R5,  the ‘Import Data’ command does not open 
>> the file dialog, but returns ok=0?
>> Has anything changed?
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D 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: Testing for Null is superior to OB is defined

[Two Way Communications via 4D_Tech]

Thanks Kirk, that really puts things in perspective!

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 29 Apr 2018, at 19:56, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> This is one of those cases where a long time 4D programmer (me) noticed my
> long time approach to coding needed a refresh to take advantage of new
> tools. New tools require new techniques.
> 
> From the start 4D has managed variables so they are never “empty”. When a
> new variable was created or declared it was always initialized to the
> equivalent of zero for its data type. I think this was part of the effort,
> back in the early days of consumer database apps, to make “scripting”, as
> it was called then, easy for non programmers. You never had to worry about
> a variable having no value. It always had a value of zero at least and you
> could use it right away.
> 
> Most other languages have Null. Null indicates something has no value. In
> the case of numbers zero is a perfectly good value and different from not
> having any value.
> 
> 4D objects support Null.
> 4D developers for the most part do not.
> 
> Because we’ve never had to. You still don’t have to. There are work around
> methods such as OB is defined. There’s nothing really wrong with using it
> except it forestalls getting familiar with using Null and is more limited
> in some cases. Consider this block of code:
> 
> C_OBJECT($obj)
> $ok:=($obj=Null)  //   $ok = true
> $ok:=Not(OB Is defined($obj))  //  $ok = true
> $ok:=OB Is empty($obj)  // $ok = true
> 
> $obj:=New object
> $ok:=($obj=Null)  //   $ok = false
> $ok:=Not(OB Is defined($obj))  //  $ok = false
> $ok:=OB Is empty($obj)  // $ok = true
> 
> $obj.a:=123  //  any key:value
> $ok:=($obj=Null)  //   $ok = false
> $ok:=Not(OB Is defined($obj))  //  $ok = false
> $ok:=OB Is empty($obj)  // $ok = false
> 
> OB is empty is the most restrictive test because empty can be Null or empty
> can be undefined but Not(OB is empty) can only mean something is there.
> Testing $obj=Null is equivalent to the longer command test in every
> instance. I find it easier to type and easier to comprehend reading the
> code.
> 
> Here are the equivalent statements for clearing $obj:
> 
> CLEAR VARIABLE($obj)
> $obj:=Null
> 
> The results are the same. A ‘cleared’ object variable is a Null object
> variable.
> 
> There is one more really compelling use case where testing for Null is
> superior:
> 
> C_OBJECT($obj)
> $ok:=($obj.a.b.c[2]=Null)  // $ok = true
> $ok:=Not(OB Is defined($obj.a.b.c[2]))  // error
> 
> 
> This works compiled as well as interpreted and fill a big void (as it were)
> in being able to test for valid objects. Testing an object path against
> Null tells you if the path is valid or not. It does not tell you anything
> about what part of the path fails, however.
> 
> HTH
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *We go vote - they go home*
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: 4D Server crashing with MyConnect

[Two Way Communications via 4D_Tech]

Hi Paul,

I run the plugin also with v15.5, but on Windows.

Except, I run a 4D client on the same machine as the server, that is running 
all the code. Would that be a solution for you?

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 30 Apr 2018, at 09:06, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi,
> 
> We have been using MyConnect in 2 fairly large databases to extract data from 
> a MySQL server every night of the last 9 or 10 years. For the last few weeks 
> we’ve been struggling to track down 4D Server crashes which appear to be 
> occurring due to MyConnect or something in our code related to the MySQL 
> extraction. What’s strange is the code was working for years.
> 
> We are running v15.5 on OS X and we’ve upgraded to the latest version 3.01 of 
> MyConnect. 
> 
> I’ve done some logging to try to locate exactly where the error occurs in our 
> code. It doesn’t not always happen in the same place, with the same table or 
> records. This leads me to believe something is causing a memory leak or 
> causing 4D to access an invalid memory address. 
> 
> Any ideas would be welcome.
> 
> 
> Cheers,
> 
> 
> Paul
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Import data in 4D format using XML

[Two Way Communications via 4D_Tech]

Hi all,

In 4D v15.5, this code is working flawlessly:

$ref:=DOM Create XML Ref("settings-import-export")
DOM SET XML 
ATTRIBUTE($ref;"table_no";$Current_LB_table;"format";"4D";"char_display_format";"decimal";"platform";"automatic";"import_mode";"create")
  //
  // Definition of fields to export
For ($j;1;Get last field number($Current_LB_table))
If (Is field number valid($Current_LB_table;$j))
$elt:=DOM Create XML 
element($ref;"field";"table_no";$Current_LB_table;"field_no";$j)
End if 
End for 

IMPORT DATA("";$ref)


However, If I use it in 4D v16R5,  the ‘Import Data’ command does not open the 
file dialog, but returns ok=0?

Has anything changed?


Regards,

Rudy Mortier
Two Way Communications bvba 



**
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: Anyone using Thomas Maul's Email Component in v16.x?

[Two Way Communications via 4D_Tech]

Be careful: it used to be the case that a CRLF was put every 80 chars or so 
(can’t remember the exact number)
At some point (v15?) this was no longer the case: no CRLF’s at all.

At least here in Belgium, it caused a lot of problems because the software at 
the internet provider’s side didn’t interpret this in the correct way, which 
caused the e-mails to be unreadable.

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 18 Apr 2018, at 18:33, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Maybe this change in 16.3 HF2?
> 
>> 
>> ACI0097778   "BASE64 ENCODE" command inserts CRLF characters every 4 
>> characters. The new behaviour is that no more CRLF is inserted by the 
>> command. If CRLF is needed, it's up to the develop to insert it.
> 
> https://bugs.4d.fr/fixedbugslist?Version=16.3_HF2
> 
> 
> John DeSoi, Ph.D.
> 
> 
>> On Apr 18, 2018, at 11:12 AM, Dave Nasralla via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> The problem I am running into is that the body text is now rendered in
>> an email like as Base64 Encoded.
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D 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: URGENT: 4D in Citrix or Terminal Server environment

[Two Way Communications via 4D_Tech]

Hi Cheryl,

My customers use 4D client inside Citrix to connect to 4D server, on a daily 
basis.
What would you like to know?


Regards,


Rudy Mortier
Two Way Communications bvba 



> On 18 Apr 2018, at 16:12, Cheryl Michels via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Is anyone using 4D Server in a Citrix or Terminal Server environment and 
> making use of the ClientLocal folder?  If so, may I pick your brain for 15 
> minutes ASAP?  Thank you in advance!!!
> 
> Cheryl Michels
> President & System Architect
> che...@dwdev.com
> (425) 673-1974
> www.dwdev.com
> Dataworks Development, Inc.
> Providing secure and configurable data management solutions for research and 
> clinical labs since 1987.
> [Description: FreezerworksLogo]
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: 4D 15.5 on MacOs High Sierra 10.13.4

[Two Way Communications via 4D_Tech]

Guys,

I’ve found the cause.

Recently, I have upgraded MacOs to 10.13.4. Until then, the speed was fine.

I googled on ‘issues with MacOs 10.13.4’, and among others, I read that 
CleanMyMac 3 was likely to be the cause.
I have uninstalled it and now the issues are gone.

Damn CleanMyMac3 ! I feel foolish now having fallen in that trap!



Regards,

Rudy Mortier
Two Way Communications bvba 



> On 17 Apr 2018, at 00:11, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I’ve seen the phenomenon with applications other than 4D, which means it is 
> not caused by 4D specific pref. files, but rather, files managed by the OS. 
> at least we know that they are under the user’s directory, but otherwise the 
> files could be anywhere.
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: 4D 15.5 on MacOs High Sierra 10.13.4

[Two Way Communications via 4D_Tech]

Thanks Chuck, thanks Keisuke.

I switched to another user on my machine, but had to copy the entire database 
folder. Otherwise I got permission errors while trying to open the journal 
file???

It was effectively running much faster.

Is there a way to fix my own account?


Regards,

Rudy Mortier
Two Way Communications bvba 



> On 16 Apr 2018, at 22:19, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Try creating another account on the same machine and see what happens. You 
> could also delete all 4D preferences and see if that changes the situation
> 
> Chuck
> 
> Chuck Miller Voice: (617) 739-0306
> Informed Solutions, Inc. Fax: (617) 232-1064   
> mailto:cjmillerinformed-solutions.com 
> Brookline, MA 02446 USA Registered 4D Developer
>   Providers of 4D and Sybase connectivity
>  http://www.informed-solutions.com  
> 
> This message and any attached documents contain information which may be 
> confidential, subject to privilege or exempt from disclosure under applicable 
> law.  These materials are intended only for the use of the intended 
> recipient. If you are not the intended recipient of this transmission, you 
> are hereby notified that any distribution, disclosure, printing, copying, 
> storage, modification or the taking of any action in reliance upon this 
> transmission is strictly prohibited.  Delivery of this message to any person 
> other than the intended recipient shall not compromise or waive such 
> confidentiality, privilege or exemption from disclosure as to this 
> communication. 
> 
>> On Apr 16, 2018, at 3:30 PM, Keisuke Miyako via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> that could be a broken configuration issue,
>> which could also happen with apps other than 4D.
>> 
>> try a another mac with the same setup, or if that's not an option,
>> try with a newly created account on the same computer.
>> 
>> you might find that the slowness is actually not reproducible elsewhere.
>> 
>> 2018/04/17 0:34、Two Way Communications via 4D_Tech <4d_tech@lists.4d.com 
>> <mailto:4d_tech@lists.4d.com><mailto:4d_tech@lists.4d.com 
>> <mailto:4d_tech@lists.4d.com>>> のメール：
>> 
>> Has anyone experienced extreme sluggishness (including beach ball) when 
>> opening form properties or object properties?
>> 
>> For every change I make in the properties, I have to wait at least 3 seconds 
>> before 4D responds, occasionally showing the beach ball.
>> 
>> Making changes takes forever this way…
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

4D 15.5 on MacOs High Sierra 10.13.4

[Two Way Communications via 4D_Tech]

Has anyone experienced extreme sluggishness (including beach ball) when opening 
form properties or object properties?

For every change I make in the properties, I have to wait at least 3 seconds 
before 4D responds, occasionally showing the beach ball.

Making changes takes forever this way…


Regards,

Rudy Mortier
Two Way Communications bvba 


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

SDI demo by Keisuke

[Two Way Communications via 4D_Tech]

In the keynote presentation by Keisuke, he showed briefly opening an excel 
document and fetching data from the 4D database.

Now, I know this can be done using ODBC, but it is not easy to get that working 
on a Mac.
Furthermore, Excel 2016 doesn’t seem to be able to connect to 4D. (It used to 
be ok using the old MS query)

So I am hoping this feature that was demoed also works on Mac.

Although I could find the SDI database on the usb key of the Paris Summit, I 
couldn’t find this particular feature.
Mind you, the SDI database is NOT on the US Summit usb key.


Keisuke, I googled the VBA tools you mentioned, but didn’t get the answers I 
needed.

Could you elaborate a little more on that, and how you implemented that little 
demo?


Regards,

Rudy Mortier
Two Way Communications bvba 



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

Re: 4D Summit

[Two Way Communications via 4D_Tech]

I can confirm that. 
Was wondering why on earth he was dressed like that. ;-)


> On 23 Mar 2018, at 14:49, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Pictures or it did not happen   :)
> 
> On Fri, 23 Mar 2018 09:39:49 +0100, Arnaud de Montard via 4D_Tech wrote:
>> the second information is Wayne is able to resist to wind and cold 
>> weather on first floor of Effeil tower in Bermuda shorts and floral 
>> shirt
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D 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: Connect to MS Sql database

[Two Way Communications via 4D_Tech]

Have you tried BEGIN SQL .. END SQL? You can use variables or arrays this way.

Kind regards,

Rudy Mortier
Two Way Communications bvba 


> On 13 Oct 2017, at 19:33, STARDATA via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> The problem is that i have to put data into an associative array but sql
> execute doesn't seem to work. I've created a "User DSN" and i can connect to
> it trough the "External connection" window that appear if you leave the
> first SQL LOGIN parameter empty. After that i have an SQL EXECUTE that
> doesn't seem to work eventough the connection has been established.
> 
> Thanks for your attention and for your fast reply.
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: 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: Anyone using 4D Write Pro with a semblance of success?

[Two Way Communications via 4D_Tech]

I agree.

I would like to use 4D Write Pro to send e-mail messages. Although this will 
work perfectly to draft an email message from scratch, it will become a problem 
when you build an actual e-mail client in 4D. I have done this to have a 
tighter integration of emails with the database.

The problem starts when I want to forward an incoming e-mail message or reply 
to one. In that case, I want to include the incoming e-mail message, as is done 
in off-the-shelf e-mail apps like Apple Mail or outlook.

4D Write Pro cannot deal with this because it doesn’t support full HTML, so the 
incoming e-mail message’s content cannot be included in the forwarded e-mail 
message.
(especially if the incoming e-mail is HTML, which most of them are nowadays)

So I am still using Tiny MCE, in a web area. That way I can include a complete 
incoming HTML message, complete with graphics and formatting. But it is a lot 
of work to build that, and customization is cumbersome.

Regards,


Rudy Mortier
Two Way Communications bvba 

> On 16 Oct 2017, at 09:28, Paul Dennis via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> We use it but only for creating templates not as a real wp. It works but its
> a mess. The html is only usable with write pro so what is the point ? Would
> have been much better off integrating libreoffice open document format.
> Paul
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: 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: Canvas alternative

[Two Way Communications via 4D_Tech]

I have done quite some work with SVG lately. It is very powerful, especially if 
you combine it with the 4D XML DOM commands.
I have been able to draw a complete map that contains pictures, objects like 
rectangles, ellipses, polygons and even custom made objects with specific 
attributes.

A good place to start is the tech note SVG Area which lets you create, edit and 
move basic shapes. (I’m sorry, I couldn’t find the exact tech note reference)

Though I know that some developers have built their own calendar into SVG, I 
would preferably use hmCal. Very solid and decent support.

Met vriendelijke groeten,

Rudy Mortier
Two Way Communications bvba  -



> On 02 Oct 2017, at 15:56, Drew Waddell via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> We have used Canvas for quite a long time to do many different things in our 
> application and any time we try to upgrade from 1.5 to 2 functionality 
> changes in too many areas without a workaround.  With only one developer 
> working on the plugin we have found it's difficult to get necessary changes 
> so we always just revert back to 1.5.  We don't want to be stuck on 1.5 
> forever and will probably be forced to upgrade at some point so instead of 
> getting into the same situation with version 2 we are open to the idea of 
> trying something else.
> 
> Drew
> 
> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of John 
> Baughman via 4D_Tech
> Sent: Friday, September 29, 2017 3:35 PM
> To: 4D iNug Technical
> Cc: John Baughman
> Subject: Re: Canvas alternative
> 
> I moved a medical office scheduling dialog I had rolled myself to Canvas a 
> while back and have been very happy with it. I was especially glad I had made 
> the move recently when I had to change appointment minimum times from 15 mins 
> to 10 mins. All I had to do was change a variable.
> 
> Curious as to why you are moving away.
> 
> If I were to move from Canvas to something else today, I might take a look at 
> SVG as a possible alternative. At least for my application of Canvas, I think 
> I could do it with SVG.
> 
> John
> 
> 
>> On Sep 29, 2017, at 9:09 AM, Drew Waddell via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> We are considering trying to remove Canvas from our application.  I am 
>> curious if anyone has any alternatives that they would recommend.  We are up 
>> for trying to roll our own but were curious if someone has moved from Canvas 
>> to something else.
>> 
>> Thanks,
>> 
>> Drew Waddell
>> Development Team Lead
>> Orchard Software Corporation
>> **
>> 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
>> **
> 
> John Baughman
> Kailua, Hawaii
> (808) 262-0328
> john...@hawaii.rr.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
> **
> **
> 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
**

Screen flickering in 4D v16R4 on MacOS Sierra

[Two Way Communications via 4D_Tech]

I notice an annoying flickering when scrolling in a method or while moving 
objects on a form.

This is on an iMac 27” running Sierra. The flickering did not occur when 
running El Capitan.

Has anyone else noticed this?


Met vriendelijke groeten,

Rudy Mortier
Two Way Communications bvba  -



**
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: Getting a list of menu bars, menu's and menu items

[Two Way Communications via 4D_Tech]

Hi Keisuke, thanks for pointing this out. 

As I was looking for a way to list the contents of the menus as defined in the 
menu editor, I wasn’t looking at the commands to create dynamic menus…. 

… my bad ;-)

Regards,

Rudy Mortier
Two Way Communications bvba  -



> On 28 Sep 2017, at 00:20, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> you could also use Create menu($) to duplicate it in memory.
> 
>> 2017/09/28 1:20、Two Way Communications via 4D_Tech <4d_tech@lists.4d.com> 
>> のメール：
>> I eventually realised that I need to call SET MENU BAR($i) for every menu 
>> bar I want to get the menus and menu items for,
> 
> 
> 
> 
> **
> 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: Getting a list of menu bars, menu's and menu items

[Two Way Communications via 4D_Tech]

Hi Jeremy,

No, I am not adding dynamic menus.
I needed a list of all the menu bars, their menus and their menu items as set 
in the Menu editor.

I eventually realised that I need to call SET MENU BAR($i) for every menu bar I 
want to get the menus and menu items for, 

and then to this:
$MenuBarRef:=Get menu bar reference(Current process)
to get the menu ref to use.

You have to use MenuBarRef to do GET MENU ITEMS for the selected menu bar to 
get the menus

Then, you need to do GET MENU ITEMS for every menu in the menu bar, to get the 
menu items

It will not work if you do it differently.

Damn … I spent hours figuring this thing out… 


Regards,

Rudy Mortier
Two Way Communications bvba  -



> On 26 Sep 2017, at 19:54, Jeremy French <jeremyfre...@mac.com> wrote:
> 
> Hi Randy,
> 
> I gather you are adding one or more dynamic menus to the menu bar created in 
> the Menu Editor. In that case, you need to work with references, not a 
> positional integer.
> 
> The positional index works only for menus created in the Menu Editor.
> 
> Try this, which assumes no hierarchical menus:
> 
> --
> $mb_ref_t:=Get menu bar reference
> 
> ARRAY TEXT($mb_menu_title_at;0)
> ARRAY TEXT($mb_menu_ref_at;0)
> 
> GET MENU ITEMS($mb_ref_t;$mb_menu_title_at;$mb_menu_ref_at)
> 
> For ($menu_i;1;Size of array($mb_menu_title_at))
>   
>   $menu_title_t:=$mb_menu_title_at{$menu_i}
>   $menu_ref_t:=$mb_menu_ref_at{$menu_i}
>   
>   ARRAY TEXT($menu_item_text_at;0)
>   ARRAY TEXT($menu_ref_at;0)
>   
>   GET MENU ITEMS($menu_ref_t;$menu_item_text_at;$menu_ref_at)
>   
>   For ($menu_item_i;1;Size of array($menu_item_text_at))
>   
>   $menu_item_ref_t:=$menu_item_text_at{$menu_item_i}
>   
>   // get specifics using positional $menu_item_i OR reference 
> $menu_item_ref_t
>           
>   End for
> End for
> 
> - Jeremy French
> 
> 
>> On Sep 26, 2017, at 11:52 AM, Two Way Communications via 4D_Tech 
>> <4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>> wrote:
>> 
>> Although you can get a list of menus in the menu bar (GET MENU ITEMS), this 
>> doesn’t work when you pass the menu ref for one of the menus. 
> 

**
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: Getting a list of menu bars, menu's and menu items

[Two Way Communications via 4D_Tech]

Hi Jeremy,

Thanks for the input.

However, it doesn’t work completely.
Although you can get a list of menus in the menu bar (GET MENU ITEMS), this 
doesn’t work when you pass the menu ref for one of the menus. 

In this case, GET MENU ITEMS returns empty arrays

Has anyone else come across this?

Regards,

Rudy Mortier
Two Way Communications bvba  -



> On 26 Sep 2017, at 15:53, Jeremy French <jeremyfre...@mac.com 
> <mailto:jeremyfre...@mac.com>> wrote:
> 
> Hi Rudy,
> 
> Take a look at the commands in the “Menus” theme:
> 
> http://doc.4d.com/4Dv16R3/4D/16-R3/Menus.201-3217435.en.html 
> <http://doc.4d.com/4Dv16R3/4D/16-R3/Menus.201-3217435.en.html>
> 
> Then in the Application Environment, activate the menu bar you are interested 
> in and loop through the menus and menu items like this:
> 
> For ($menu_i;1;Count menus)
>   
>   $menu_title_t:=Get menu title($menu_i)
>   
>   For ($menu_item_i;1;Count menu items($menu_i))
>   
>   // Here use menu commands to retrieve menu item information.
>   
>   end for
>   
> End for
> 
> - Jeremy French
> 
> 
>> On Sep 26, 2017, at 8:51 AM, Two Way Communications via 4D_Tech 
>> <4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>> wrote:
>> 
>> way to programatically produce a list of all the menu’s (defined in the 
>> design environment) and their menu items.
> 

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

Getting a list of menu bars, menu's and menu items

[Two Way Communications via 4D_Tech]

I have been looking through the documentation and on this list, and there seems 
to be no way to programatically produce a list of all the menu’s (defined in 
the design environment) and their menu items.

Am I overlooking something? Can it even be done?


Met vriendelijke groeten,

Rudy Mortier
Two Way Communications bvba  -



**
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: Edit in list / subform / 4D v16

[Two Way Communications via 4D_Tech]

Ok, I tested a regular list of [Contacts], where the fields are side by side on 
1 row. Editing works here.

However, if you make the detail section bigger and put the fields vertically, 
editing is no longer possible… bug?

Regards,

Rudy Mortier
Two Way Communications bvba  -



> On 12 Sep 2017, at 13:21, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> to edit in list you need to click twice; that means to click an already 
> selected line with an interval longer than that of a double click. the exact 
> threshold is adjustable at the system level.
> 
> 
> 
> **
> 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: Edit in list / subform / 4D v16

[Two Way Communications via 4D_Tech]

In the output form, fields are one above the other, so the detail section is 3 
fields high. Could that be the cause?

Regards,

Rudy Mortier
Two Way Communications bvba  -



> On 12 Sep 2017, at 13:21, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> to edit in list you need to click twice; that means to click an already 
> selected line with an interval longer than that of a double click. the exact 
> threshold is adjustable at the system level.
> 
> 
> 
> **
> 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
**

Edit in list / subform / 4D v16

[Two Way Communications via 4D_Tech]

I thought this would be a no brainer but it’s starting to become a nuisance…

I create a subform for a table [Contacts] inside the form for the table 
[Customers]
The subform is set to display the [Contacts] Output form, is set to ‘Edit in 
list’ etc.

However, when I display the list of [Contacts] inside my [Customers] input 
form, they display fine, are selectable.

There is NO WAY however to ‘edit in list’. Whatever I do. Click, long click, 
etc.
And yes, the fields are set to be ‘enterable’.

This is 4D v16.1, on Mac OS Yosemite, 4D developer mode.


Am I overlooking something or just getting old? ;-)


Regards,

Rudy Mortier
Two Way Communications bvba  -

**
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: SVG component question

[Two Way Communications via 4D_Tech]

Thanks Keith, I was already afraid of that.

And yes, if there is a DOM then it is possible to use XML commands. But since i 
created the SVG using SVG_New, I assume there is no DOM, but I am not sure 
about that.


Rudy Mortier
Two Way Communications bvba  -



> On 05 Sep 2017, at 19:19, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I think a 'text' element's text can only be set when it is created, unlike a 
> textArea.  So the item that needs to be changed will need to be deleted and 
> created again.  
> 
> OTOH, I didn't know about addressing the "4d-text" attribute.  Maybe it can 
> be better addressed via XML commands?
> 
> Keith - CDI
> 
>> On Sep 5, 2017, at 12:05 PM, Two Way Communications via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Hi guys,
>> 
>> For the past hour I have been trying to modify the content of a text (NOT 
>> textarea) in an SVG document.
>> 
>> I use:
>> SVG_SET_ATTRIBUTES ($RPMKlblObjRef;"4d-text";[REAP_Markers]Label)
>> 
>> But the text does not get updated.
>> 
>> SVG SET ATTRIBUTES($RPMKlblObjRef;"4d-text";[REAP_Markers]Label) does work, 
>> but as soon as I refresh the SVG picture it is gone.
>> 
>> I can’t find an appropriate command in the SVG component.
>> 
>> Am I overlooking something?
>> 
>> 
>> 
>> Kind regards,
>> 
>> Rudy Mortier
>> Two Way Communications bvba  -
>> 
>> 
>> 
>> **
>> 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
> **

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

SVG component question

[Two Way Communications via 4D_Tech]

Hi guys,

For the past hour I have been trying to modify the content of a text (NOT 
textarea) in an SVG document.

I use:
SVG_SET_ATTRIBUTES ($RPMKlblObjRef;"4d-text";[REAP_Markers]Label)

But the text does not get updated.

SVG SET ATTRIBUTES($RPMKlblObjRef;"4d-text";[REAP_Markers]Label) does work, but 
as soon as I refresh the SVG picture it is gone.

I can’t find an appropriate command in the SVG component.

Am I overlooking something?



Kind regards,

Rudy Mortier
Two Way Communications bvba  -



**
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 Write PRO how to ...

[Two Way Communications via 4D_Tech]

Hi Keith,

Thanks… looks like we will have to wait a bit longer to resolve expressions in 
the headers…

Regards,

Rudy Mortier
Two Way Communications bvba  -



> On 22 Aug 2017, at 15:31, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 
> Maybe not super useful, but this:
> 
> WP EXPORT VARIABLE(waAreaPtr->;$destination;wk web page html 4D;wk html debug)
> SET TEXT TO PASTEBOARD($destination)
> 
> gives this result:
> 
> http://www.w3.org/1999/xhtml; xmlns:d4="http://www.4D.com;>
>
>4D Write Pro New Document
>
>
>
>body { -d4-version:1.01;background-color:#FF }
>ul, ol { margin:0;padding:0 }
>p,li { 
> white-space:pre-wrap;margin:0pt;padding:0pt;-d4-list-font:'Times New 
> Roman';-d4-font:'Times New Roman';font-family:'Times New Roman' }
>div.section1Footer { margin:0.5cm 2.5cm 1cm }
>div.section1Header { margin:1cm 2.5cm 0.5cm }
>p.Normal,li.Normal { white-space:pre-wrap }
>
>
>
>===BODY text===
>
>===HEADING text===
>
>
>===FOOTER text===
>
>
> 
> 
> Keith -CDI
> 
>> On Aug 22, 2017, at 8:22 AM, Koen Van Hooreweghe via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Rudi,
>> 
>> Probably not for the faint-hearted! But I think it is not possible to access 
>> a 4D Write Pro object’s contents and you’re limited to the ST and WP 
>> commands.
>> 
>> I did a quick test:
>> 
>> C_OBJECT($wpObject)
>> C_TEXT($jsonText)
>> $wpObject:=WP New
>> ST SET TEXT($wpObject;"Hello World!")
>> TRACE
>> $jsonText:=JSON Stringify($wpObject)
>> SET TEXT TO PASTEBOARD($jsonText)
>> 
>> If I look at the object in the debugger, I can only see the general 
>> settings, not the actual content.
>> 
>> This is what I get on the pasteboard:
>> {
>> "backgroundColor": 16777215, 
>> "dateCreation": "2017-08-22T13:17:56.918Z", 
>> "dateModified": "2017-08-22T13:17:56.918Z", 
>> "title": "4D Write Pro New Document", 
>> "version": 1.01
>> }
>> 
>> Not much to manipulate.
>> 
>> Koen
>> 
>> 
>>> Op 22 aug. 2017, om 14:26 heeft Two Way Communications via 4D_Tech 
>>> <4d_tech@lists.4d.com> het volgende geschreven:
>>> 
>>> Would we be able to check the actual 4D Write PRO object and manipulate it? 
>>> After all, it is a C_Object…
>> 
>> 
>> 
>> 
>> 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
>> **
> 
> **
> 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: 4D Write PRO how to ...

[Two Way Communications via 4D_Tech]

Thx Koen,

I had a look myself at the 4DWRPRO object in the debugger and like you say, not 
much there that could be useful…

Regards,

Rudy Mortier
Two Way Communications bvba  -



> On 22 Aug 2017, at 15:22, Koen Van Hooreweghe via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Rudi,
> 
> Probably not for the faint-hearted! But I think it is not possible to access 
> a 4D Write Pro object’s contents and you’re limited to the ST and WP commands.
> 
> I did a quick test:
> 
> C_OBJECT($wpObject)
> C_TEXT($jsonText)
> $wpObject:=WP New
> ST SET TEXT($wpObject;"Hello World!")
> TRACE
> $jsonText:=JSON Stringify($wpObject)
> SET TEXT TO PASTEBOARD($jsonText)
> 
> If I look at the object in the debugger, I can only see the general settings, 
> not the actual content.
> 
> This is what I get on the pasteboard:
> {
>  "backgroundColor": 16777215, 
>  "dateCreation": "2017-08-22T13:17:56.918Z", 
>  "dateModified": "2017-08-22T13:17:56.918Z", 
>  "title": "4D Write Pro New Document", 
>  "version": 1.01
> }
> 
> Not much to manipulate.
> 
> Koen
> 
> 
>> Op 22 aug. 2017, om 14:26 heeft Two Way Communications via 4D_Tech 
>> <4d_tech@lists.4d.com> het volgende geschreven:
>> 
>> Would we be able to check the actual 4D Write PRO object and manipulate it? 
>> After all, it is a C_Object…
> 
> 
> 
> 
> 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
> **

**
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 Write PRO how to ...

[Two Way Communications via 4D_Tech]

Damn it ;-)

Would we be able to check the actual 4D Write PRO object and manipulate it? 
After all, it is a C_Object…

Regards,

Rudy Mortier
Two Way Communications bvba  -



> On 22 Aug 2017, at 12:13, Koen Van Hooreweghe via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi Rudi,
> 
> Same issue, which makes 4D Write Pro for me a no go (yet).
> 
> Koen
> 
>> Op 21 aug. 2017, om 13:55 heeft Two Way Communications via 4D_Tech 
>> <4d_tech@lists.4d.com> het volgende geschreven:
>> 
>> Using the old 4D Write, I loop through all the frames (frames 1-> 7), using 
>> ‘WR SET FRAME’ . Then I resolve the expressions.
>> This way, all the references in the headers, text frames and footers are 
>> resolved before printing.
>> 
>> I have opened an 4D Write document in 4D Write PRO, and everything is there, 
>> including headers and footers.
>> 
>> However, I can’t find out how to select the headers and footers, so, when I 
>> use the command ST FREEZE EXPRESSIONS, and pass the 4D Write PRO area as 
>> object, only the references in the text part are resolved. The header keeps 
>> showing the references.
>> 
>> How do I select the header frame in 4D Write PRO?
> 
> 
> 
> 
> 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
> **

**
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 Write PRO how to ...

[Two Way Communications via 4D_Tech]

Thanks Justin,

I was afraid I would get this answer… 

Rudy Mortier
Two Way Communications bvba  -



> On 22 Aug 2017, at 04:03, Justin Carr via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> On 21 Aug 2017, at 9:55 pm, Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
>> 
>> Using the old 4D Write, I loop through all the frames (frames 1-> 7), using 
>> ‘WR SET FRAME’ . Then I resolve the expressions.
>> This way, all the references in the headers, text frames and footers are 
>> resolved before printing.
>> 
>> I have opened an 4D Write document in 4D Write PRO, and everything is there, 
>> including headers and footers.
>> 
>> However, I can’t find out how to select the headers and footers, so, when I 
>> use the command ST FREEZE EXPRESSIONS, and pass the 4D Write PRO area as 
>> object, only the references in the text part are resolved. The header keeps 
>> showing the references.
>> 
>> How do I select the header frame in 4D Write PRO?
> 
> Hi Rudy
> 
> Unfortunately I don't think that is possible yet with 4D Write Pro. It's one 
> of the remaining things stopping us from being able to use it.
> 
> Regards
> Justin
> **
> 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
**