Re: Form and DIALOG

[Jeremy Roussak via 4D_Tech]

Kirk,

Thanks. That’s certainly food for thought, and underlines my impression that 
this ability to pass information in both directions will be fantastically 
useful.

Jeremy

> On 29 Apr 2019, at 15:39, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Jeremy,
> 
> In the situation you describe I initialize the object that will be passed
> to the Dialog first. Like so:
> 
> $formObj:= New object("listbox_1";New
> Collection(100;200;300);"someObject";New Object("foo";"Hello world")
> DIALOG("MyDialogForm";$formObj)
> 
> //  Dialog is closed and $formObj contains any/every thing added to it or
> edited in the Dialog
> 
> 
> This also allows you to configure what's going to be in Form. Such as
> various entity selections, lists or what not. In the example above your
> form could have a collection based listbox whose datasource is
> 'Form.listbox_1' and it could display the 3 numbers. You could set this up
> in the On Load form event also, of course.
> 
> And it works in a similar way with a subform:
> 
> $subformObj:= New object("listbox_1";New Collection(100;200;300))
> Object get pointer(Object named;"subform_object")->:=$subformObj
> OBJECT SET SUBFORM(*;"subform_object";"MyDialogForm") // subform_object is
> an object type var
> 
> // formObj contains any/every thing added to it or edited in the subform
> 
> 
> When the subform object is itself an object or collection Form, in the
> context of the subform, takes on the value of the subform object.
> The great thing about this is that the code for the actual 4D form runs
> identically whether it's in a dialog or a subform at least with respect to
> Form (the function).
> 
> But wait, there's more.
> In the example right above let's say instead of $subformObj being a new
> object I assign it some object already in the parent form:
> 
> Object get pointer(Object named;"subform_object")->:=Form.someObject
> OBJECT SET SUBFORM(*;"subform_object";"MyDialogForm")
> 
> 
> Now in the context of the subform Form contains a 'reference' (say that
> with an accent like JPR) to 'someObject' which was originally defined
> before the dialog was loaded. Let's say the user changes 'foo' to "Hello
> everyone".
> In the subform:
> 
> Form.foo = "Hello everyone"
> 
> In the parent form:
> 
> Form.someObject.foo = "Hello everyone"
> 
> 
> I think this gives a whole new value to subforms. I can design forms to
> deal with a particular task or set of data and use them as a dialog or open
> the within a dialog without having to change the code. Have you ever wound
> up, or come across, a form with 10+ pages? These are ugly and difficult.
> Instead you could have one page with a subform.
> 
> 
> And gee we could use some more words for describing these things.
> 
> On Mon, Apr 29, 2019 at 1:05 AM Jeremy Roussak via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Is it safe to use the object returned by the Form command as a means of
>> passing data back to the caller? That is, should the method of the form
>> opened in DIALOG regard its Form object as read-only, or is it allowed to
>> alter it?
>> 
>> At present, changing the values of the object passed by DIALOG works: the
>> new values are available to the caller when the DIALOG command returns.
>> It’s quite handy. But there’s nothing in the documentation, as far as I can
>> see, to indicate whether this is sanctioned or likely to change.
>> 
> -- 
> 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
**

HTTP Get on 4D Server v15 - is it synchronous?

[Paul Lovejoy via 4D_Tech]

Hi,

We’re working on incorporating the retrieval of fairly voluminous xml from our 
website in an interactive form in 4D. Since we have workstations spread around 
about 50 locations accessing 4D Server over a VPN and the web server is running 
in the same subnet as 4D Server, it seems logical to have the methods with HTTP 
Get execute on 4D Server. I’m just worried about degradation of performance on 
4D Server, as some of the HTTP Gets can take between 1 and 5 seconds.

Does anyone know if 4D Server would execute these requests asynchronously or 
synchronously? Would the cooperative thread be stuck while waiting for the 
response?

Thanks for your thoughts (and prayers :D)


Paul
**
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: Data Merge from v13 to v15

[Charles Miller via 4D_Tech]

You could simply upgrade the 13 data base to 15 and use sql to get data you
need.
A straight merge will be tough as you probably have key problems.

Regards

Chuck

On Tue, Apr 30, 2019 at 2:53 AM Ronnie Teo via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Hi All,
>
> A client has requested to decommission  a v13 database and merge the data
> into a separate v15 database.
> The 2 database structures started the same (as in same tables and fields)
> but has expanded in different directions down the years.
> It would be fair to say that the fields in the v13 structure would be a
> subset of the v15 structure.
>
> A send/receive record option would not be feasible.
> Tinkling with some ideas, perhaps exporting table data to CSV file (from
> v13) and import into v15.
> Or perhaps just exporting individual tables (individual) fields to text
> files with custom delimiters….
>
> What would be the best way to accomplish this?
>
> Regards,
> Ronnie
> Tarawerkz
>
> **
> 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
> **

-- 
-
 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)
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: HTTP Get on 4D Server v15 - is it synchronous?

[Tom Benedict via 4D_Tech]

If you’re doing any significant volumes I would move the Web Server to one or 
more 4D Clients. That’s the best way to scale web services to avoid impacting 
4D Server adversely. It will keep 4D Server doing what it does best. You’ll 
need to get a Web Services client license.

Tom Benedict

> On Apr 30, 2019, at 02:18, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi,
> 
> We’re working on incorporating the retrieval of fairly voluminous xml from 
> our website in an interactive form in 4D. Since we have workstations spread 
> around about 50 locations accessing 4D Server over a VPN and the web server 
> is running in the same subnet as 4D Server, it seems logical to have the 
> methods with HTTP Get execute on 4D Server. I’m just worried about 
> degradation of performance on 4D Server, as some of the HTTP Gets can take 
> between 1 and 5 seconds.
> 
> Does anyone know if 4D Server would execute these requests asynchronously or 
> synchronously? Would the cooperative thread be stuck while waiting for the 
> response?
> 
> Thanks for your thoughts (and prayers :D)
> 
> 
> Paul
> **
> 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: CSV import with version 13

[Charles Miller via 4D_Tech]

Thanks I will take a look at it. I will also try comping Miyakos code which 
works in 15. I did not remember that regex was avaliable

 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 29, 2019, at 1:32 PM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi. All does anyone have v13 code that will do this they are willing to 
> share. I have new client still at 13 and I need to write import before I can 
> do upgrade
> 
> Thanks and regards
> 
> Chuck
> 
> Sent from my iPhone
> **
> 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: Data Merge from v13 to v15

[Chip Scheide via 4D_Tech]

Ronnie,
I do not remember, and with a little bit of experimenting you can 
figure it out.
BUT
as I recall if use SEND RECORD from [table A] which is a subset of 
[table A] in the receiving table this works.

issues :
- field order would need to be the same (at least through the fields 
sent from the old system).
- field data types probably have to match
- as Chuck said, Record keys might be an issue depending on what/how 
the internal keys were designed.

Keys:
-if you used UUIDs (unlikely, but not impossible, in v13) then no issue
- if you used longings (most likely) then you probably end up with 
duplicated keys for different data., and you will need some way to 
determine what to do with the duplicated key data.
  -- look for other identifiers to determine if the 'old' data is 
duplicated
   --- if not duplicated generate new keys, and save
   --- if duplicated - what to do?  that is a business process decision 
and will likely need to be take up with the owners of the data.


If I remember incorrectly and SEND/RECEIVE RECORD fail if the strutter 
is at all different.  Then writing an export/import will be needed.  
You will still need to watch the key issue above.

If you want/need, I can send you a v13 component that includes a record 
export to text.
let me know off list.

Chip

On Tue, 30 Apr 2019 14:53:26 +0800, Ronnie Teo via 4D_Tech wrote:
> Hi All,
> 
> A client has requested to decommissiona v13 database and merge the 
> data into a separate v15 database.
> The 2 database structures started the same (as in same tables and 
> fields) but has expanded in different directions down the years.
> It would be fair to say that the fields in the v13 structure would be 
> a subset of the v15 structure.
> 
> A send/receive record option would not be feasible.
> Tinkling with some ideas, perhaps exporting table data to CSV file 
> (from v13) and import into v15.   
> Or perhaps just exporting individual tables (individual) fields to 
> text files with custom delimiters….
> 
> What would be the best way to accomplish this? 
> 
> Regards,
> Ronnie
> Tarawerkz
> 
> **
> 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
**

Re: RRe: 4D 17.1 network issues

[Douglas von Roeder via 4D_Tech]

Allan:

" the client connections to 4D Server v17 are flakey and not as good as
they've been in the past :-(“
That’s my impression, as well.

(To clarify, the posting was under my name but was for a client who, at the
time, was subscribed via the digest.)

Looking back over the 10+ years since V11, that version (which I’ve dubbed
“4D Vista”) did set the low water mark but the dot releases of V11 went a
long way to cleaning things up. I didn’t use V11, opting to join the fray
with V12. The system my client was describing was started in V6, IIRC. It
was moved to 2004, then V12/13 and then V15. V15 was a very solid version,
with this issue arising only with V17R3.

Networking is a topic that has come up on the 4D Forum over the years and
the position that Thomas Maul seems to be that the code, as far as they are
able to determine, is functioning as they expect so these are edge
conditions that they’re not able to resolve. Thomas has indicates that 4D
does want to resolve the issues so, if there is a way that the behaviors
can be reproduced, they want to know about it. That's my interpretation of
the message threads on the Forum over the years.

--
Douglas von Roeder
949-336-2902


On Mon, Apr 29, 2019 at 6:56 PM Allan Udy (Golden Micro) 
wrote:

>
> From: Douglas von Roeder  
>
> To: 4D iNug Technical <4d_tech@lists.4d.com> <4d_tech@lists.4d.com>
> Subject: Re: 4D 17.1 network issues
>
> I can confirm this same issue on v17r3 on Windows 64 bit client and server
> running Windows Server 12r2 Datacenter. In addition, the server will
> refuse connection until somebody touches the server admin window at which
> point it will accept connections again.
>
>
> Doug, for some months we've been having on-going issues with v17R3 server
> (on Windows Server 12) autonomously set the 'Reject New Connections' button
> on the Application Server page of the Server Admin window (so that it now
> reads 'Accept New Connections').
>
> When this happens we've found the only way that clients can reconnect
> again is if we restart the 4D server.
>
> Having said all of this, we haven't seen the issue for a couple of weeks,
> and that 'could' be related to changing back to the Legacy Network Layer --
> not confirmed yet.
>
> We've also had other Client disconnection issues where the 'New
> Connections' button has not magically be changed, but client apps still
> cannot connect.  All in all our experience is that in some regards the
> client connections to 4D Server v17 are flakey and not as good as they've
> been in the past :-(
>
> Cheers,
> Allan Udy
>
> Golden Micro Solutions Ltd, Blenheim, New Zealand
> http://www.golden.co.nz 
>
>
**
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: Data Merge from v13 to v15

[Mike Beatty via 4D_Tech]

Ronnie-

I often work with datafiles in size greater than 100GB, so please take that 
into consideration of your needs — small datafiles might not need as extensive 
an effort.

Based on my experience, I would highly recommend you use the sql export/sql 
import routines — they are the most efficient, assuming there is no level of 
data manipulation.

In the event there is any need for data manipulation (change in field 
order/data types, update UUIDs, etc.), then your best bet will be to create a 
generic series of routines that will allow you to monitor the export and import 
routines on a table level basis.


HTH, 

Mike

Mike Beatty
Objective Systems




> 
> A client has requested to decommissiona v13 database and merge the 
> data into a separate v15 database.
> The 2 database structures started the same (as in same tables and fields) but 
> has expanded in different directions down the years.
> It would be fair to say that the fields in the v13 structure would be a 
> subset of the v15 structure.
> 
> A send/receive record option would not be feasible.
> Tinkling with some ideas, perhaps exporting table data to CSV file (from v13) 
> and import into v15.   
> Or perhaps just exporting individual tables (individual) fields to text files 
> with custom delimiters….
> 
> What would be the best way to accomplish this? 

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

Collections and Entity Selections Cheat Sheets

[Cannon Smith via 4D_Tech]

I’ve been using collections and entity selections more lately and notice I 
spend a lot of time in the docs trying to remember what function does what. 
Some of them aren’t named very intuitively (at least to me). And I keep 
forgetting which ones return a deep or shallow copy or use a query string or a 
method. So I made a couple of cheat sheets that organize the functions in a way 
that makes sense to me. Makes it a lot faster to find the function I’m after 
for a certain situation.

Anyway, perhaps they will be helpful to some of you as well. You can find the 
PDFs here:



I’m relatively new to these functions, so if my understanding needs to be 
corrected somewhere, please let me know!

--
Cannon.Smith
Synergy Farm Solutions Inc.
Aetna, AB Canada




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

Split Screen Support with 4D and MacOS?

[Tom Benedict via 4D_Tech]

After 25 years of using 4D on Windows I have started using 4D on Mac. I am 
rather surprised at how many useful productivity features in Windows are 
extremely hard to accomplish on MacOS. I suspect it’s mostly a newbie thing. 

Right now I’m trying to copy/paste a lot of code edit from one 4D structure to 
another. I have read that it is possible to set up ‘split screen’ views of 
applications on MacOS, which would make it a lot easier to keep track of my 
changes. To assign and application to a split portion of a screen you’re 
supposed to click-hold on the “full screen” (green) button in any window’s 
titlebar, then drag the resulting small window image to the side of the screen 
you want the app to be limited to. That works for non-4D apps, but click-hold 
on the “full screen” button on a 4D window doesn’t appear to do anything on a 
4D window (no small windows image appears). I’ve tried this with 4D v15 and 
v16. 

Am I missing something? If not, how do others work with two 4D structures on 
MacOS?

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

Re: Split Screen Support with 4D and MacOS?

[Jeffrey Kain via 4D_Tech]

You could use Exposé to put your code windows side by side.  Or just drag 
methods from one Explorer window to another.

> On Apr 30, 2019, at 6:05 PM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Am I missing something? If not, how do others work with two 4D structures on 
> MacOS?

**
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: Split Screen Support with 4D and MacOS?

[Chip Scheide via 4D_Tech]

Tom,
don't copy/paste
drag n drop

- open 2 copies of 4D with what ever systems you want
- display the explorer in both
- adjust the windows so you can see the column (list of methods/forms 
whatever) in the destination.
- drag from the source to destination.  
  -- release when the cursor is a green +

example
source  -- moving 5 methods 
- select the 5 methods
- click and hold any of the selected ones, drag
- drag to explorer window in destination
- drop

depending on your setting you may see a dialog to click through 
regarding what to do with duplicated resources (style sheets, methods 
etc)

Chip

On Tue, 30 Apr 2019 15:05:00 -0700, Tom Benedict via 4D_Tech wrote:
> After 25 years of using 4D on Windows I have started using 4D on Mac. 
> I am rather surprised at how many useful productivity features in 
> Windows are extremely hard to accomplish on MacOS. I suspect it’s 
> mostly a newbie thing. 
> 
> Right now I’m trying to copy/paste a lot of code edit from one 4D 
> structure to another. I have read that it is possible to set up ‘
> split screen’ views of applications on MacOS, which would make it a 
> lot easier to keep track of my changes. To assign and application to 
> a split portion of a screen you’re supposed to click-hold on the “
> full screen” (green) button in any window’s titlebar, then drag the 
> resulting small window image to the side of the screen you want the 
> app to be limited to. That works for non-4D apps, but click-hold on 
> the “full screen” button on a 4D window doesn’t appear to do 
> anything on a 4D window (no small windows image appears). I’ve tried 
> this with 4D v15 and v16. 
> 
> Am I missing something? If not, how do others work with two 4D 
> structures on MacOS?
> 
> 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
> **
---
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
**

Connecting to FTP

[Robert McKeever via 4D_Tech]

I run an FTP server for my clients. All of the connections are secure FTP - 
port .

I can’t get the FTP_Login to work. I assume that it is using regular FTP, port 
21.

I tried ###.###.###.###: for the address, but no joy.

Any Ideas?

_
Bob McKeever  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
**

Re: Connecting to FTP

[John DeSoi via 4D_Tech]

Bob,

You need to use the IT_SetPort command.

John DeSoi, Ph.D.


> On Apr 30, 2019, at 6:49 PM, Robert McKeever via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I run an FTP server for my clients. All of the connections are secure FTP - 
> port .
> 
> I can’t get the FTP_Login to work. I assume that it is using regular FTP, 
> port 21.
> 
> I tried ###.###.###.###: for the address, but no joy.
> 
> Any Ideas?

**
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: Connecting to FTP

[Robert McKeever via 4D_Tech]

IT_SetPort returns 0.

The FTP Login returns 10032 - Unknown or invalid response.

> On Apr 30, 2019, at 5:32 PM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Bob,
> 
> You need to use the IT_SetPort command.
> 
> John DeSoi, Ph.D.
> 
> 
>> On Apr 30, 2019, at 6:49 PM, Robert McKeever via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> I run an FTP server for my clients. All of the connections are secure FTP - 
>> port .
>> 
>> I can’t get the FTP_Login to work. I assume that it is using regular FTP, 
>> port 21.
>> 
>> I tried ###.###.###.###: for the address, but no joy.
>> 
>> Any Ideas?
> 
> **
> 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 
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
**

Re: Connecting to FTP

[Chuck Miller via 4D_Tech]

I believe you can’t do secure ftp this way. I think the famous Miyako wrote a 
wrapper plugin for curl. Check his site out

Regards 

Chuck

Sent from my iPhone

> On Apr 30, 2019, at 10:03 PM, Robert McKeever via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> IT_SetPort returns 0.
> 
> The FTP Login returns 10032 - Unknown or invalid response.
> 
>> On Apr 30, 2019, at 5:32 PM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> Bob,
>> 
>> You need to use the IT_SetPort command.
>> 
>> John DeSoi, Ph.D.
>> 
>> 
>>> On Apr 30, 2019, at 6:49 PM, Robert McKeever via 4D_Tech 
>>> <4d_tech@lists.4d.com> wrote:
>>> 
>>> I run an FTP server for my clients. All of the connections are secure FTP - 
>>> port .
>>> 
>>> I can’t get the FTP_Login to work. I assume that it is using regular FTP, 
>>> port 21.
>>> 
>>> I tried ###.###.###.###: for the address, but no joy.
>>> 
>>> Any Ideas?
>> 
>> **
>> 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 
> 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
**

Re: Data Merge from v13 to v15

[Ronnie Teo via 4D_Tech]

Hi Chuck,

Thanks for your reply.
What do you think of the option of converting the v13 structure to v15, 
synchronise the field order/type, then use Send/receive record?

Regards,
Ronnie
Tarawerkz

> On 1 May 2019, at 12:08 AM, 4d_tech-requ...@lists.4d.com wrote:
> 
> Message: 6
> Date: Tue, 30 Apr 2019 06:12:24 -0400
> From: Charles Miller mailto:miller.c...@gmail.com>>
> To: 4D iNug Technical <4d_tech@lists.4d.com >
> Subject: Re: Data Merge from v13 to v15
> Message-ID:
>>
> Content-Type: text/plain; charset="UTF-8"
> 
> You could simply upgrade the 13 data base to 15 and use sql to get data you
> need.
> A straight merge will be tough as you probably have key problems.
> 
> Regards
> 
> Chuck

**
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: Data Merge from v13 to v15

[Ronnie Teo via 4D_Tech]

Hi Mike, thanks for the reply.

Yes, in my scenario, the size of the data file is much smaller, less than 10GB.

So I should think an export/import by table would be the approach.
The slight complication is that a couple of the main tables have many 
subtables….one of them alone has 40+ subtable fields.
So my export/import routines would have to handle that.
UUIDs would be crested and saved with the records during the import into v15.

Perhaps I can also consider to convert the v13 structure to v15, synchronise 
the field order/type, then use Send/receive record.

Regards,
Ronnie
Tarawerkz

> On 1 May 2019, at 3:00 AM, 4d_tech-requ...@lists.4d.com wrote:
> 
> Date: Tue, 30 Apr 2019 12:42:35 -0400
> From: Mike Beatty  >
> To: 4d_tech@lists.4d.com 
> Subject: Re: Data Merge from v13 to v15
> Message-ID: <668050ce-59e3-4274-ae49-4168ee331...@gmail.com 
> >
> Content-Type: text/plain; charset=utf-8
> 
> Ronnie-
> 
> I often work with datafiles in size greater than 100GB, so please take that 
> into consideration of your needs — small datafiles might not need as 
> extensive an effort.
> 
> Based on my experience, I would highly recommend you use the sql export/sql 
> import routines — they are the most efficient, assuming there is no level of 
> data manipulation.
> 
> In the event there is any need for data manipulation (change in field 
> order/data types, update UUIDs, etc.), then your best bet will be to create a 
> generic series of routines that will allow you to monitor the export and 
> import routines on a table level basis.
> 
> 
> HTH, 
> 
> Mike
>   
> Mike Beatty
> Objective Systems

**
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: Connecting to FTP

[John DeSoi via 4D_Tech]

Sorry, I missed the word "secure" in your description; I thought you just 
changed the the FTP port to . 

Secure FTP (SFTP) is a completely different protocol from FTP. It is not 
supported by 4D IC.


John DeSoi, Ph.D.


> On Apr 30, 2019, at 9:03 PM, Robert McKeever via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> IT_SetPort returns 0.
> 
> The FTP Login returns 10032 - Unknown or invalid response.
> 
>> On Apr 30, 2019, at 5:32 PM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> Bob,
>> 
>> You need to use the IT_SetPort command.
>> 
>> John DeSoi, Ph.D.
>> 
>> 
>>> On Apr 30, 2019, at 6:49 PM, Robert McKeever via 4D_Tech 
>>> <4d_tech@lists.4d.com> wrote:
>>> 
>>> I run an FTP server for my clients. All of the connections are secure FTP - 
>>> port .
>>> 
>>> I can’t get the FTP_Login to work. I assume that it is using regular FTP, 
>>> port 21.
>>> 
>>> I tried ###.###.###.###: for the address, but no joy.

**
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: Split Screen Support with 4D and MacOS?

[Wayne Stewart via 4D_Tech]

Hi,

Like Chip said - two copies of 4D

This is also a really useful app from the App Store if you want
something splitscreenie (is there such a thing?)

https://itunes.apple.com/au/app/bettersnaptool/id417375580?mt=12

Regards,

Wayne



On Wed, 1 May 2019 at 08:25, Chip Scheide via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Tom,
> don't copy/paste
> drag n drop
>
> - open 2 copies of 4D with what ever systems you want
> - display the explorer in both
> - adjust the windows so you can see the column (list of methods/forms
> whatever) in the destination.
> - drag from the source to destination.
>   -- release when the cursor is a green +
>
> example
> source  -- moving 5 methods
> - select the 5 methods
> - click and hold any of the selected ones, drag
> - drag to explorer window in destination
> - drop
>
> depending on your setting you may see a dialog to click through
> regarding what to do with duplicated resources (style sheets, methods
> etc)
>
> Chip
>
> On Tue, 30 Apr 2019 15:05:00 -0700, Tom Benedict via 4D_Tech wrote:
> > After 25 years of using 4D on Windows I have started using 4D on Mac.
> > I am rather surprised at how many useful productivity features in
> > Windows are extremely hard to accomplish on MacOS. I suspect it’s
> > mostly a newbie thing.
> >
> > Right now I’m trying to copy/paste a lot of code edit from one 4D
> > structure to another. I have read that it is possible to set up ‘
> > split screen’ views of applications on MacOS, which would make it a
> > lot easier to keep track of my changes. To assign and application to
> > a split portion of a screen you’re supposed to click-hold on the “
> > full screen” (green) button in any window’s titlebar, then drag the
> > resulting small window image to the side of the screen you want the
> > app to be limited to. That works for non-4D apps, but click-hold on
> > the “full screen” button on a 4D window doesn’t appear to do
> > anything on a 4D window (no small windows image appears). I’ve tried
> > this with 4D v15 and v16.
> >
> > Am I missing something? If not, how do others work with two 4D
> > structures on MacOS?
> >
> > 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
> > **
> ---
> 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
**

Resizing text on en Entry form

[Chip Scheide via 4D_Tech]

I have code to resize the font in a listbox/listing form.

I was wondering if there anyone has code they would share to resize all 
text on an entry form?  something like command/control + (or -) on a 
web page.

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

Re: Split Screen Support with 4D and MacOS?

[Tom Benedict via 4D_Tech]

Thanks Chip,

>- display the explorer in both
> 
> - adjust the windows so you can see the column (list of methods/forms 
> whatever) in the destination.

Drag and Drop between Explorer windows will work, but since I’m moving code 
between versions (15 to 16) I’m reluctant to replace whole methods where v16 
specific changes may have already been made, so I’d like to compare first, 
hence my goal of having a side-by-side ‘split window’ view.

Tom

> On Apr 30, 2019, at 15:23, Chip Scheide <4d_o...@pghrepository.org> wrote:
> 
> Tom,
> don't copy/paste
> drag n drop
> 
> - open 2 copies of 4D with what ever systems you want
> - display the explorer in both
> - adjust the windows so you can see the column (list of methods/forms 
> whatever) in the destination.
> - drag from the source to destination.  
>  -- release when the cursor is a green +
> 
> example
> source  -- moving 5 methods 
> - select the 5 methods
> - click and hold any of the selected ones, drag
> - drag to explorer window in destination
> - drop
> 
> depending on your setting you may see a dialog to click through 
> regarding what to do with duplicated resources (style sheets, methods 
> etc)
> 
> Chip
**
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: Resizing text on en Entry form

[Herr Alexander Heintz via 4D_Tech]

Wow…
Its basically not that complicated, BUT…
It would require not only changing the font size, but also resizing and moving 
all objects accordingly.
Again technically quite simple…

Resize: 125%
for each object
get coordinate, multiply with 1.25 and set then move object, 
set font to size*1.25

Furthermore you will have to adjust the dimensions of the form, as well as of 
the window, unless your form has scroll bards for both directions (which IMHE 
user hate…).

GET WINDOW RECT, SET WINDOW RECT, etc.

It gets funnier once subforms are involved )
But again, just a recursive call (EXECUTE METHOD IN SUBFORM)

Also make sure you do it for all form pages.

Might write this in the next few days and post it on my BLOG...

If your form window already fills the screen, it would overflow and make 
scrolling necessary, something that is AFAIK not possible with DIALOG, only 
with MODIFY and ADD.
Both are regarded as obsolete.

So before doing it you must check if the result will overflow the available 
screen space.

Cheers
Alex


> Am 01.05.2019 um 06:09 schrieb Chip Scheide via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> I have code to resize the font in a listbox/listing form.
> 
> I was wondering if there anyone has code they would share to resize all 
> text on an entry form?  something like command/control + (or -) on a 
> web page.
> 
> Thanks
> Chip
> ---
> 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
**