Re: PDF Creation

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 dri

Re: 4D Friday Happy Hour on ZOOM

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

Re: HMAC SHA256 in native 4D code

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 n

Re: HMAC SHA256 in native 4D code?

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

Re: HMAC SHA256 in native 4D code?

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

Re: Citrix Playbook

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

Re: Document encoding

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

Document encoding

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

Re: The future of output forms

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 Co

The future of output forms

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 th

Debug log analyzer v14

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

Object get title and cliff

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: reference

Re: 4D Server Hosting - The Future ?

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

Re: 4D Server Hosting - The Future ?

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

Re: My 4D Experience Blog

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 th

Re: 4DWrite Pro <-> 4DWrite Classic Cross Reference

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 t

Re: Log integration issue in mirror database

>> >> Actually, I did. I did verify the records and indexes in the MSC of the >> mirror database. >> They checked out fine. >> >> Regards, >> >> Rudy Mortier >> Two Way Communications bvba >> >> >> >>> On 19 May 201

Re: How can a line of code be separated into multiple lines?

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;$Ar

Log integration issue in mirror database

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

Re: Sending mail in 4D v11 on Mac

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 ju

Sending mail in 4D v11 on Mac

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_

Re: Runtime error ST GET OPTIONS

the left > operand in an assignment (:=), in previous versions. > but now (I think since 16R4), an attempt to assign"undefined" is made. > > perhaps that is why you are getting a runtime error, > >> 2018/12/15 9:47、Two Way Communications via 4D_Tech >> <4d

Runtime error ST GET OPTIONS

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)

Re: Distinct Values on Composite Index

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)

Re: Anybody running v17 server on Windows 2008r2?

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

Re: LAUNCH EXTERNAL PROCESS, v15, on MacOS Mojave

t; > 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.4

LAUNCH EXTERNAL PROCESS, v15, on MacOS Mojave

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,

Re: I've updated sideORDA

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 Communi

Re: Longing IDs or UUIDs as primary key?

lways 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

Re: Longing IDs or UUIDs as primary key?

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

Re: Longing IDs or UUIDs as primary key?

; 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 >>> &

Re: Icon & Picture Button Sources...

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

Re: Using listbox as output form replacement

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

Longing IDs or UUIDs as primary key?

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 ‘prima

Re: Write Pro: Creating headers/footers

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_

Re: Creating a form object to use as dynamic form

ithin 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 …

Re: Creating a form object to use as dynamic form

I agree, Tim, lots of new stuff in 4D and it is quite troublesome to find the missing peace of information, especially when documentation and examples are spread over 4D doc center, the blog and even on github. Mostly, the process I’m going through when trying something new is: - read the docs

Re: Creating a form object to use as dynamic form

Thanks a lot John! I really need to get my head around this object concept ;-) Regards, Rudy Mortier Two Way Communications bvba > On 24 Sep 2018, at 17:42, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> wrote: > > On Sep 24, 2018, at 9:44 AM, Two Way Communications via 4D_T

Creating a form object to use as dynamic form

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,

Re: 4D for iOS: anyone?

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

Re: 4D for iOS: anyone?

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

4D for iOS: anyone?

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 ther

Re: ORDA - updating data in listboxes

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 dif

Re: Double-click event on a hierarchical listbox not working

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 cli

Re: Adding elements to a listbox containing a collection

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!

Adding elements to a listbox containing a collection

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

Re: v13 - Record to Blob?

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 Schei

Re: Confused about ORDA

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

Re: Confused about ORDA

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

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

Re: 4D Write PRO expressions

R6/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 exp

4D Write Pro range / elements

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.

4D Write PRO expressions

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 a

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

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

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

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 > &l

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

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

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

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

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

les, 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@

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

> 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 Write PRO: editing a table / collections

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 th

Re: Remote access to 4D Server.

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 Communication

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

ct 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 el

Re: Remote access to 4D Server.

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 Deskt

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

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 un

Re: Comparing all methods in structures

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 Communicati

Re: issue on windows 10 and 4D 15

The thing is, that the user may not want to change his settings under Windows. The cause is that the pictures have been resized manually in the 4D form editor. I had the same issue in one of my applications a while ago. I replaced the pictures on the form with a .png file in the resources, or I

Re: Musing on creating PDFs in 4D

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

Re: Objects without Stylesheets suddenly displayed as Wingdings!

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

Re: 15.5 The database cannot be published

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 >

Re: Preventing Return and Enter from Closing a Dialog

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

Re: First experiments with 4D View PRO

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 Mi

Re: First experiments with 4D View PRO

> 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

First experiments with 4D View PRO

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 u

Re: setting up mirror

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 re

Re: setting up mirror

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

Re: EC2 server on Amazon AWS

ttps://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 A

EC2 server on Amazon AWS

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 ad

Re: Import data in 4D format using XML

out 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> >> のメール： >>

Re: Testing for Null is superior to OB is defined

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 c

Re: 4D Server crashing with MyConnect

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

Import data in 4D format using XML

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 F

Re: Anyone using Thomas Maul's Email Component in v16.x?

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 inte

Re: URGENT: 4D in Citrix or Terminal Server environment

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 Ser

Re: 4D 15.5 on MacOs High Sierra 10.13.4

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

Re: 4D 15.5 on MacOs High Sierra 10.13.4

gt;> >> 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 Com

4D 15.5 on MacOs High Sierra 10.13.4

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… Re

SDI demo by Keisuke

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

Re: 4D Summit

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 i

Re: Connect to MS Sql database

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

Re: Anyone using 4D Write Pro with a semblance of success?

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 pr

Re: Canvas alternative

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

Screen flickering in 4D v16R4 on MacOS Sierra

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

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

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 real

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

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

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

> > $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 > &g

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

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 Tw

Re: v16x centipedes, trilobites and various other arthropods

Hi Randy, To my knowledge you need ALP v 10 when using 4D v16. Unfortunately, it is not out yet… Regards, Rudy Mortier Two Way Communications bvba - > On 13 Sep 2017, at 18:07, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I'm just now trying to get our produ

Re: Edit in list / subform / 4D v16

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

Re: Edit in list / subform / 4D v16

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 lis

Edit in list / subform / 4D v16

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]

  1   2   >