Re: Compiled Structure does not Match Data

[Charles Miller via 4D_Tech]

you can try deleting match file if that doesn’t work try opening with
original copy of structure and run tools

Regards

Chuck

On Tue, Oct 5, 2021 at 6:53 PM Peter Adam via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> I apolitically;ogise for asking a question related to v13 but my client
> has been tardy in accepting an upgrade.
>
> However before making the move I have had to make some changes to the v13
> DB and something that has been modified without issue for many years  now
> is failing when I compile and merge it.
>
> I compile and merge the structure with its datafile, no problems reported.
>
> I then launch the compiled server point it at the datafile that has just
> been used in the compiling process and i get the message
> The structure and data files do not correspond to each other. The data
> file cannot be opened with this structure.
>
>
> When I click the close button on the dialog, I then get an error dialog,
> Cannot delete record in table Resources of Database…
>
> and the details list a lot of Cannot save record… and the key line seems
> to be Wrong header.
>
> All this is happening on Windows 10.
>
> Suggestions?
>
>
>
>
> Cheers,
>
> Peter Adam
> Adam, Zievert & Associates P/L
>
> e: peter.a...@me.com
> Skype Phone: +61 3 9016 379
> t:  +61 3 9836 3539
> m: 0419 552 462
> www.adamzievert.com.au
>
>
>
> **
> 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
> **

-- 
-
 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
  https://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)
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: Duplicate Primary Key

[Charles Miller via 4D_Tech]

I would not do this. I would
begin swl
Select MAX ([table].[field])
from
[table]
into
:$max
end sql

On Wed, Sep 1, 2021 at 7:49 PM Randy Kaempen via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Paul,
>
> > On Sep 1, 2021, at 6:32 PM, Paul Chernoff via 4D_Tech 
> > <4d_tech@lists.4d.com> wrote:
> >
> > 4D 17.5
> >
> > Somehow when I create a new record for a table it wants to assign an
> > existing record’s primary key to a new record’s primary key field.
> >
> > How do I get the database to know that this value is already in use for
> > this unique field and to start incrementing primary key values starting at
> > a higher value?
>
> This code will fix the key for any integer or longint key.  Just pass a 
> pointer to the key field.
>
>   // FixAutoincrement  1/28/21
>   //
> C_POINTER($1)  // 1/28/16
> C_LONGINT($MaxValue)  // 1/29/16
>   //
> $FieldPtr:=$1  // 1/28/16
> $TablePtr:=Table(Table($FieldPtr))  // 1/9/21
>   //
> GET FIELD PROPERTIES($FieldPtr;$FieldType)  // 10/19/18
>   //
> If (($FieldType=8) | ($FieldType=9))  // Integer or Longint  10/19/18
>   //
> $OldMaxValue:=Get database parameter($TablePtr->;Table sequence 
> number)  // 1/4/21
>   //
> $TablePtr:=Table(Table($FieldPtr))  // 1/28/16
>   //
> ALL RECORDS($TablePtr->)  // 4/19/16
> ORDER BY($TablePtr->;$FieldPtr->;<)  // Get highest value  4/19/16
>   //
> $MaxValue:=$FieldPtr->  // 4/19/16
>   //
> If ($MaxValue>$OldMaxValue)  // 1/22/21
> SET DATABASE PARAMETER($TablePtr->;Table sequence 
> number;$MaxValue)  // 12/19/16
> End if   // 1/4/21
>   //
> End if   // Integer or Longint?  10/19/18
>
>
> Randy Kaempen
> Intellex Corporation
>
> **
> 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
> **



-- 
-
 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
  https://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)
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: Run v15.4 in demo mode

[Charles Miller via 4D_Tech]

One other option is to have another partner do it for you. I for one
have v15 in a VM

Regards


Chuck

On Thu, Aug 26, 2021 at 5:54 PM Perkins, Bradley D via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Thanks to everyone who commented and reached out privately.
>
> Based on all comments here, my best bet is to plan to visit the site and set 
> up the old Server and client which would have full licenses. We opted out of 
> the partner program when we retired the systems a few years back so any prior 
> partner licenses have expired.  A key point as Miyako pointed out is that no 
> demo mode has been available since v2003 and only the latest versions can be 
> run with an evaluation license.
>
> Thanks,
> Brad Perkins
>
> **
> 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
> **



-- 
-
 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
  https://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)
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: Array combination

[Charles Miller via 4D_Tech]

That only works if array size is 2


On Fri, May 28, 2021 at 7:50 AM David Samson via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> I think you can do it with one loop inside another.
>
> ARRAY TEXT(Array1;2)
> ARRAY TEXT(Array2;2)
>
> Array1{1}:="s"
> Array1{2}:="a"
>
> Array2{1}:="l"
> Array2{2}:="o"
>
> ARRAY TEXT(ArraysCombined;0)
>
>
> For ($i;1;Size of array(Array1))
>
>   For ($j;1;Size of array(Array2))
>$cCombination:=Array1{1}+Array2{$i}+Array1{2}+Array2{$j}
>APPEND TO ARRAY(ArraysCombined;$cCombination)
>   End for
>
> End for
>
> Hope this helps
> David Samson
>
>
>
> > In one 4D application i need to combine two array.
> >
> > For example i have an array with sone analytes, and another array with
> > the available results.
> >
> > I need to obtain one new array that contain all the possibile
> > combinations without repetitions.
> >
> >
> **
> 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
> **



-- 
-
 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
  https://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)
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: Network Unit

[Charles Miller via 4D_Tech]

Sure you can do this
C_BOOLEAN($0)
C_TEXT($1)

C_BOOLEAN($Availalble_b)
C_TEXT($in;$out;$err;$ServerName_txt)
$ServerName_txt:=$1
C_LONGINT($alive_L)
If (on windows)
SET ENVIRONMENT VARIABLE("_4D_OPTION_HIDE_CONSOLE";"true")
LAUNCH EXTERNAL PROCESS("ping -n 2 "+$ServerName_txt;$in;$out;$err)
$alive_L:=Position("could not find host";$out)
$Availalble_b:=Not($alive_L>0)

Else
SET ENVIRONMENT VARIABLE("_4D_OPTION_HIDE_CONSOLE";"true")
LAUNCH EXTERNAL PROCESS("ping -c 2 "+$ServerName_txt;$in;$out;$err)
$alive_L:=Position("Unknown host";$err)
$Availalble_b:=Not($alive_L>0)

End if

$0:=$Availalble_b


On Mon, Mar 22, 2021 at 9:59 AM stardata.info via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Hi All,
>
> In one of my applications in 4D V16 on windows, I need to use network unity.
> Can happen that one of the network unity is unavailable, so when I call
> TEST PATHNAME command, the 4d application remains sometimes in a " not
> responding " state. I try to use Net_Ping command to check if the ip address
> of the pc that contains the folder that I have to need to reach is
> available, but in the manual, I read that this command works only with
> administrator user.
>
> Someone can give a suggestion to solve it?
>
> Thanks
> Ferdinando
>
> **
> 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
> **



-- 
-
 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
  https://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)
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: PayPal Server-side SDK & 4D

[Charles Miller via 4D_Tech]

Hi David,

You should really move these questions over to discuss.4d.com. That is
where most of us lurk these days

Regards

Chuck

On Thu, Mar 18, 2021 at 4:02 PM David Rose via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> If any of you have implemented the PayPal server-side SDK (current version) 
> in a 4D application, in which 4D is the webserver, and would like to consult 
> on a project for a fee, please contact me directly.
> Thanks,
> David Rose
> drose...@gmail.com
>
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



-- 
-
 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
  https://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)
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: Designer Password Question

[Charles Miller via 4D_Tech]

One more thought. If you can prove ownership, perhaps 4D cN change designer
password for you

Regards

Chuck

On Sun, Jan 17, 2021 at 10:42 PM THOMAS BENEDICT via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> On Jan 17, 2021, at 16:24, Kenneth Geiger via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> >The original developer has forgotten the Designer Password. But,
> fortunately, he had enabled the settings to allow the >Administratror to
> access the design environment and the customer had that password. So, I’ve
> been able to make the changes >that the customer wanted. But, I really hate
> to leave this system the way it is.
>
> What’s the downside of leaving it as is?
>
> Tom benedict
> **
> 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
> **

-- 
-
 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
  https://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)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Remember "Layout Procedure" in 4D v2?

[Charles Miller via 4D_Tech]

During

On Thu, Jan 14, 2021 at 6:46 AM Jörg Knebel via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> G’day All,
>
> Back than we had only 3 “Situations”:
>
> Before
>
> ?
>
> After
>
>
> Can someone fill in the question marks - just curious…
>
>
> Thanks
>
> Cheers
> Jörg
> **
> 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
> **

-- 
-
 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
  https://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)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: v18 Folders in a package

[Charles Miller via 4D_Tech]

You will have to have components folder. Not sure of others but when I want
something to move I always create folders inside resources and that works
like a charm

Regards
Chuck

On Thu, Jan 14, 2021 at 6:56 AM Jörg Knebel via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> G’day All,
>
> Of course I can tested myself, but maybe someone can save me some time.
>
> If I create my own folders beside the standard ones (Log, Resources, etc.)
> are mine transferred to the client machine in a C/S
> environment?
>
> And while we're at it, what about the components in the 4D.app? Do I have
> to move them in to the Component-Folder of my structure package if I want
> them implemented in my standalone application and my C/S system?
>
> Thanks
>
> Cheers
> Jörg
> **
> 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
> **

-- 
-
 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
  https://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)
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: Record locking woes

[Charles Miller via 4D_Tech]

I had thought you were using my locked record component. Doesn’t it turn
who had it locked

On Thu, Dec 10, 2020 at 7:47 PM nug via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Alan,
> You need to add/use the commands for returning the lock record information.
> His can help determine who/where is locking the record.
>
> I am wondering if maybe the lock is indirect
> i.e. a parent record locked because a child is loaded read/write and, the
> parent record was dragged in to the modification of the child record due to
> automatic relation loading the parent
>
> Ex: a lineitem is being modified, and an automatic relation (possibly many
> levels removed) pulled and loaded the invoice which is being locked because
> there is a changed child record
>
> Just guessing
> Again - add record looking info commands to get a better idea
>
> Chip
>
>
> > On Dec 10, 2020, at 4:11 PM, Ben Kershaw via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > Alan Tilson wrote:
> >
> >> Locked By does return the locking process, user, machine, and proc name.
> >
> > Is the server holding the lock, or is another client? If it’s on the
> server, is it in the twin process for the client, a twin process for
> another client, or another process on the server?
> >
> > Regards,
> > Ben
> > **
> > 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
> **

-- 
-
 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
  https://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)
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: Old 4D Transporter (ResTransporter) or Equivalent

[Charles Miller via 4D_Tech]

You could run a. Me of snow leopard. I still have one not sure about the
tool. I can look and advise
It may be more than that. I don’t remember when you had plugins installed
in the apps
Regards

Chuck

On Sat, Jul 4, 2020 at 11:01 AM Peter Jakobsson via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi
>
> I was wondering if there’s a tool to split the 4D resource fork on a 4D
> 2004 database so I can transport it from Mac to Windows. I haven’t done
> this for years and have lost access to my old “Snowleopard” machine that I
> used to use for this type of thing.
>
> I need the “transporter” tool to run on a modern Mac OS.
>
> Any tips ?
>
> Regards
>
> Peter
>
> **
> 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
> **

-- 
-
 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
  https://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)
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: Native 4D code to convert numbers into text?

[Charles Miller via 4D_Tech]

Hi All,

I would do this a little differently. I would pass in number (real)
convert to text using commas and decimal points
build an array of each second so if you passed in and got the following string
111,111,222,333,444.26
you array would look like this
111
111
222
333
444.26
I would then separate last array using decimal point yielding
$decimal := 26

you array would look like this
111
111
222
333
444

Based upon size of array you have billions etc

Regards

Chuck






On Tue, Jun 16, 2020 at 5:44 PM David Adams via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Thanks!
>
> On Wed, Jun 17, 2020 at 1:08 AM Keith Culotta 
> wrote:
>
> > This was written for v6 a while back.  The app is still being used believe
> > it or not.
> >
> > =
> >   // METHOD: DtoS - Dollar to String - kc 3/1/00
> >   // INPUT: real - dollar to convert to string
> >   // was -> $0:=String($1;"$###,###,###,##0.00")
> >
> > String(200;$0)
> > _O_C_INTEGER($i;$sec)
> > C_REAL($partVal)
> >
> > _O_ARRAY STRING(12;mag1;20)  //  this should be be declared elsewhere
> > _O_ARRAY STRING(12;mag2;8)
> > _O_ARRAY STRING(12;mag3;4)
> > mag1{0}:=""
> > mag1{1}:=" One"
> > mag1{2}:=" Two"
> > mag1{3}:=" Three"
> > mag1{4}:=" Four"
> > mag1{5}:=" Five"
> > mag1{6}:=" Six"
> > mag1{7}:=" Seven"
> > mag1{8}:=" Eight"
> > mag1{9}:=" Nine"
> > mag1{10}:=" Ten"
> > mag1{11}:=" Eleven"
> > mag1{12}:=" Twelve"
> > mag1{13}:=" Thirteen"
> > mag1{14}:=" Fourteen"
> > mag1{15}:=" Fifteen"
> > mag1{16}:=" Sixteen"
> > mag1{17}:=" Seventeen"
> > mag1{18}:=" Eighteen"
> > mag1{19}:=" Nineteen"
> >
> > mag2{1}:=" Twenty"
> > mag2{2}:=" Thirty"
> > mag2{3}:=" Forty"
> > mag2{4}:=" Fifty"
> > mag2{5}:=" Sixty"
> > mag2{6}:=" Seventy"
> > mag2{7}:=" Eighty"
> > mag2{8}:=" Ninety"
> >
> > mag3{1}:=" "
> > mag3{2}:=" Thousand"
> > mag3{3}:=" Million"
> > mag3{4}:=" Billion"
> >
> > $theNum:=$1  //  Num(Request("a Number"))
> > $Target:=String(Trunc($theNum;0))
> > $TLength:=Length($Target)
> > $sec:=1
> > $theOutput:=""
> > While (Length($Target)>0)
> > $partVal:=Num(Substring($target;Length($target)-3+1;3);$sec)
> > If ($partVal=0)
> > $theOutput:=" "+$theOutput
> > Else
> > $theOutput:=DtoS_Get3
> > (Substring($target;Length($target)-3+1;3);$sec)+mag3{$sec}+$theOutput
> > End if
> > $target:=Substring($Target;1;Length($target)-3)
> > $sec:=$sec+1
> > End while
> > $cents:=String(Round(Round($theNum;2)-Trunc($theNum;0);2);"#.00")
> > $cents:=Substring($cents;2;2)
> > $theOutput:=$theOutput+"Dollars and "+$cents+"/100"
> >
> >
> > $theOutput:=Replace string($theOutput;"  ";" ")  // extra spaces may
> > appear for "000"
> > $0:=Replace string($theOutput;"  ";" ")
> >
> >
> > =
> >   // METHOD: DtoS_Get3 - return words for a 3 digit section xxx,XXX,xxx
> >   // INPUT1: string - 0..999
> >   // INPUT2: integer - what 3 digit section are we in ...3,2,1
> >
> > _O_C_STRING(3;$1)
> > _O_C_STRING(200;$0)
> > _O_C_INTEGER($numValueR2;$numValueR1;$numValueM2;$2)
> >
> > While (Length($1)<3)
> > $1:="0"+$1
> > End while
> >
> > $numValueR2:=Num(Substring($1;2;2))
> > $numValueR1:=Num(Substring($1;3;1))
> > $numValueM2:=Num(Substring($1;2;1))
> > $numValueL1:=Num(Substring($1;1;1))
> >
> > If ($numValueR2<20)  //  handle the rightmost 2 digits
> > $0:=mag1{$numValueR2}
> > Else
> > $0:=mag2{$numValueM2-1}+mag1{$numValueR1}
> > End if
> >
> > If ($numValueL1>0)
> > $0:=mag1{$numValueL1}+" Hundred"+$0
> > End if
> >
> > Keith - CDI
> >
> > > On Jun 16, 2020, at 4:48 AM, David Adams via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> > >
> > > I'm looking for code that converts something like this:
> > >
> > > 24120.10 into something like this:
> > >
> > > twenty-four thousand, one hundred and twenty point one
> > >
> > > The hope is to emulate Python's num2words.
> > >
> > > I figure anyone who had to write a check printing feature years ago might
> > > have something along these lines, and may be willing to share. I'm not
> > > trying to print checks, that's just an example.
> > >
> > > Definitely after native code, hoping to avoid a PHP call.
> > >
> > > For reference, Dani Beaubien sent me a link to an old post from Garri
> > Ogata
> > > with something like the code I'm asking about:
> > >
> > >
> > >
> > http://4d.1045681.n5.nabble.com/Number-To-Text-native-4D-code-td4864780.html
> > >
> > > I also found what looks like a version of that code here:
> > >
> > > https://kb.4d.com/assetid=76423
> > >
> > > This version has a bunch of extra ) characters, but runs once you fix
> > them.
> > > However, this code does *not* include decimals. I'd like to keep the
> > > decimals part.
> > >
> > > Thanks for any help.
> > > **
> > > 4D Internet Users Group (4D iNUG)
> > > New Forum: https://discuss.4D.com
> > > Archive:  

Re: Pict in 4D Write Pro Template headers

[Charles Miller via 4D_Tech]

If they are truly Picts they are no longer supported. You will have to
convert using a 32 bit version of 4D.

Regards

Chuck

On Fri, Jun 12, 2020 at 2:22 AM nisshaa2004 via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi,
>
> I have some templates that I migrated from 4D Write 32 bit to 4D Write Pro
> 64 bit.
>
> Some of these templates have headers which are picts. These documents are
> stored in the Templates tables as 4D Write Pro Documents, previously in 64
> bit they were stored as blobs. Is there a way to get the headers to display
> in 64 bit.
>
>
> Thanks & Regards
> Nisha Fernando
>
>
>
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

-- 
-
 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
  https://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)
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: IP address problem

[Charles Miller via 4D_Tech]

Hi All,
This can't be multihoming as I only have one address


On Thu, Jun 4, 2020 at 1:49 PM Douglas von Roeder via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Chuck:
>
> Good question. How is multi-homing handled?
>
> The web server can listen on multiple IP addresses but I've never seen
> anything that discusses how the application/data server handles that.
>
> --
> Douglas von Roeder
> 949-910-4084
>
>
> On Thu, Jun 4, 2020 at 7:47 AM Chuck Miller via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > OK I guess some more info may help. It seems that if I have a server that
> > I run at client with their IP address scheme and then run same structure on
> > server in my office it shows as broadcasting on more than one IP address.
> > So the question now is where does 4D get IP address to show on the server
> > admin window? I think this might be part of the problem. I am going to post
> > this on the new forum as well with some screen shots
> >
> > 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.
> >
> > > On Jun 4, 2020, at 7:20 AM, Chuck Miller via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> > >
> > > Thanks for input. I will address each below your response
> > >
> > > Sent from my iPhone
> > >
> > >> On Jun 4, 2020, at 1:44 AM, Chip Scheide <4d_o...@pghrepository.org
> > > wrote:
> > >>
> > >> Chuck,
> > >> There are 2 ways to resolve this, and using both is probably best.
> > >> (following assumes DHCP)
> > >>
> > >> 1 - put a battery on the computer (server) so that when power goes down
> > during tests the computer does not turn off.
> > >> 1a - if this is already the case (it should be if it is a server) and
> > IP addresses are being changed on the server then there is a switch in the
> > network who's battery has failed - and Enterprise IT should track it and
> > fix it ( might need to enter a ticket)
> > >>
> > > There is a UPS. Indeed the machine and server never went down
> > >
> > >
> > >> 2 - talk with the IT/network people, give them the server's MAC ID
> > (network card ID) and request a fixed IP address server through DHCP
> > >> Notes on #2 : the network admin can assign a specified IP address to a
> > specific MAC address, which is assigned via DHCP, then regardless of power
> > outage, server reboot, etc and generally the time off the network, the IP
> > address of the computer does not change.
> > > This is the setup. Indeed the IP is manual.
> > >>
> > >> and BTW
> > >> - MAC is a network card term and refers to the network card's ID
> > >> - Mac(intosh) is an Apple Computer Co. computer.
> > >>
> > >> DHCP with manual address usually means that the IP address has been
> > assigned by specific computer Admin, rather than network admin. The IP
> > address assigned this way can (and appears to) conflict with the DHCP
> > server assigning addresses.
> > >> This is because, as I understand it, the DHCP server does not 'know'
> > about the manual address.
> > > The address is permanent and was assigne by network folks
> > >
> > >
> > >
> > >
> > >>
> > >> Quickly:
> > >> DHCP hands out IP addresses in a specified range xxx.xxx.xxx.1 - 255.
> > the range can be restricted, say xxx.xxx.xxx.100 - 200.
> > >> and/or the DHCP server can hand out specific IP addresses to specified
> > MAC address, and random to all others.
> > >> Where I was working, IT did all of this.
> > >> Servers, and other devices which required that IP address NOT change
> > over time, (requested to be fixed), were assigned in the range 1- 30, 31 -
> > 220 were for network attached devices (computers, tablets etc), and 220 -
> > 254 were for reserved for printers.
> > >> However, ALL addresses were assigned via DHCP - assigning a manual
> > address was not allowed because:
> > >> the DHC server did not know about it, and could/would 

Re: Tip: Speed up/repair v15 Design Environment

[Charles Miller via 4D_Tech]

Hi All,

As a note when your window goes wonky like that you can also hold
shift key down when opening window and voila it is back to default


On Sun, May 17, 2020 at 8:07 PM Peter Jakobsson via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Hi
>
> I might be late to the party on this one but in case in might help someone in 
> similar situation….
>
> Over the last year or so, I’ve been working with a really sluggish design 
> environment in v15 (Mac). I wasn’t actually aware it was sluggish until now. 
> Symptoms like the method editor being so slow to reflect what I was typing 
> that I was about 4 letters ahead of it before the characters appeared. “Tab” 
> clairvoyance taking half a second to a second before detecting the command 
> etc.
>
> Then today the explorer went wonky - the bottom edge of the window went below 
> the screen bottom and the more I tried to shrink the explorer window it just 
> grew longer instead.
>
> After digging around for a while I tried binning the “~/Library/Application 
> Support/4D/4D Window Bounds v15” folder and……voila ! Everything is dead 
> snappy again.
>
> Regards
>
> Peter
> **
> 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
> **



-- 
-
 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
  https://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)
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: Opinion

[Charles Miller via 4D_Tech]

You could write code and check each field in each table checking for type.
I think field type 7 is a link to a sub table. If desired some  ok me in my
company can do this part for you as well as the code to unlink and update
the data. I have done this before.
I might even do this part in 12.
Regards

Chuck

On Fri, Apr 24, 2020 at 6:38 PM Kenneth Geiger via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi Chuck,
>
> Thanks! I totally agree with you and was anticipating these changes. I
> have just one really dumb question… In all my years using 4D, I have NEVER
> used a sub-table. Just how would I recognize if this structure includes and
> sub-tables?
>
> Regards,
>
> Ken
>
> > On Apr 24, 2020, at 4:12 PM, Chuck Miller via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > First, I would not use windows 7 at all. I would move to windows 10
> >
> > Second here are some potential ares of concern that you will need to
> deal with
> >
> > 1. Are there any sub-tables. If so I would recommend creating new tables
> and moving data in v 15
> >
> > 2. There are probably obsolete pictures in the db. You can use JPRs
> component in 16 (32 bit mode)
> >
> > 3. I would also not use the built in primary key stuff, but would add a
> UUID to each table and table that  the primary key. I have previously
> posted code I have used to create these. You need to create these with an
> empty data file. When you open an existing data file, all of these keys
> should be populated automatically. If not I have code that will check and
> make sure that all records have UUIDs.
> >
> > 4. I would also run tools on structure air each in 12 and then at each
> step up to a newer version
> >
> >
> >
> > Others may tell you that you can use an existing unique key in a table
> for this. I would not, as these are used only for journaling. I would not
> want to make a UUID key on a one table that was used in a many table as the
> link. I would keep all my other long ints for that.
> >
> > Regards
> >
> > Chuck
> >
> 
> > Chuck Miller Voice: (617) 739-0306
> > Informed Solutions, Inc. Fax: (617) 232-1064
> > mailto:cjmillerinformed-solutions.com <
> http://informed-solutions.com/>
> > Brookline, MA 02446 USA Registered 4D Developer
> >   Providers of 4D and Sybase connectivity
> >  http://www.informed-solutions.com <
> 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 24, 2020, at 5:16 PM, Kenneth Geiger via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >>
> >> Hi all,
> >>
> >> I’m solicitating your opinions.
> >>
> >> I’ve picked-up a new 4D client. They have an existing 4D system (v12
> running on Win7) that has been stagnant for quite e few years. I believe it
> was originally written under 2004 or maybe even 6.8.5. They’re looking to
> replace their computers with Win10 machines and and upgrade 4D. I’m a Mac
> guy and I do my Win development in a VMWare environment. I’ve got several
> configurations available. I’ve got a Win7 environment that has a 4D v14
> installation and a Win10 environment with 4D v15, v16, and v17
> installations. My thought is to skip v14 and open the v12 system under v15,
> take care of what needs to be updated, and then move it to v17. Your
> thoughts would be most appreciated.
> >>
> >> Stay safe and healthy,
> >
> > **
> > 4D Internet Users Group (4D iNUG)
> > Archive:  http://lists.4d.com/archives.html <
> http://lists.4d.com/archives.html>
> > Options: https://lists.4d.com/mailman/options/4d_tech <
> https://lists.4d.com/mailman/options/4d_tech>
> > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com  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: replace obsolete plugins

[Charles Miller via 4D_Tech]

Ok just found api pack from pluggers and am asking for upgrade.

Regards
Chuck

On Fri, Apr 24, 2020 at 1:37 PM Charles Miller 
wrote:

> There is no Ali pack for 17 that I can find. Do you know where I can find
> it?
>
> Regards
>
> Chuck
>
>
> On Fri, Apr 24, 2020 at 1:36 PM Douglas von Roeder via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> API Pack works with versions of 4D as far back as 6.7 so you can just swap
>> out the version that you’ve got for the current version = zero code.
>>
>> If the ZIP plugin isn’t compatible with V17, I think Miyako has a plugin
>> that does ZIP. Lacking that, you could fire up something with AppleScript
>> or LEP.
>>
>> 4D Pack - I thought all of the functionality of 4D Pack had been rolled in
>> to 4D. What functionality do you need to replace from 4D Pack?
>>
>> --
>> Douglas von Roeder
>> 949-910-4084
>>
>>
>> On Fri, Apr 24, 2020 at 10:16 AM Charles Miller via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>
>> > Hi All,
>> > Environment 4D v17
>> >
>> > I have a db which uses the following 3 plugins
>> > 4D pack
>> > API Pack
>> > zip
>> >
>> > What I am looking for is anyone who has replaced any of commands in
>> > API pack with native 4D. I think I can deal with the rest
>> >
>> > Regards
>> >
>> > Chuck
>> > --
>> >
>> >
>> -
>> >  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
>> >   https://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
>> > **
>> **
>> 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
>   https://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.
>
-- 
--

Re: replace obsolete plugins

[Charles Miller via 4D_Tech]

There is no Ali pack for 17 that I can find. Do you know where I can find
it?

Regards

Chuck


On Fri, Apr 24, 2020 at 1:36 PM Douglas von Roeder via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> API Pack works with versions of 4D as far back as 6.7 so you can just swap
> out the version that you’ve got for the current version = zero code.
>
> If the ZIP plugin isn’t compatible with V17, I think Miyako has a plugin
> that does ZIP. Lacking that, you could fire up something with AppleScript
> or LEP.
>
> 4D Pack - I thought all of the functionality of 4D Pack had been rolled in
> to 4D. What functionality do you need to replace from 4D Pack?
>
> --
> Douglas von Roeder
> 949-910-4084
>
>
> On Fri, Apr 24, 2020 at 10:16 AM Charles Miller via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > Hi All,
> > Environment 4D v17
> >
> > I have a db which uses the following 3 plugins
> > 4D pack
> > API Pack
> > zip
> >
> > What I am looking for is anyone who has replaced any of commands in
> > API pack with native 4D. I think I can deal with the rest
> >
> > Regards
> >
> > Chuck
> > --
> >
> >
> -
> >  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
> >   https://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
> > **
> **
> 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
  https://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
**

replace obsolete plugins

[Charles Miller via 4D_Tech]

Hi All,
Environment 4D v17

I have a db which uses the following 3 plugins
4D pack
API Pack
zip

What I am looking for is anyone who has replaced any of commands in
API pack with native 4D. I think I can deal with the rest

Regards

Chuck
-- 
-
 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
  https://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: Configure 4D server as Windows Service on Windows Server 2016

[Charles Miller via 4D_Tech]

I looked at the blogs posted and they seem to be in project mode. If I
convert to normal, can they be used in v17.4 or must they be in an r
release

Regards

Chuck

On Fri, Apr 17, 2020 at 8:02 PM Keisuke Miyako via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> 4D Server does not have to run on a server OS.
> many users find the option both practical and affordable.
> the server side admin window makes perfect sense for those kinds of 
> distribution.
>
> for headless deployment,
>
> https://blog.4d.com/headless-4d-applications/
>
> you can either:
>
> 1. take advantage of the limited version of the admin window which is 
> available on the client side, or
>
> 2. publish your own remote admin api using the admin features that are now 
> accessible by code,
>
> https://blog.4d.com/customize-the-admin-dialog-with-4d-code/
> https://blog.4d.com/build-a-web-based-monitoring-dialog-step-by-step
>
> > On Apr 11, 2020, at 0:06, Tonu Mikk via 4D_Tech <4d_tech@lists.4d.com> 
> > wrote:
> > How are people configuring a 4D server to run as Windows service so that 
> > multiple
> > users can have access to the 4D server admin screens?
>
> **
> 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
  https://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: Longitude Index: B-Tree or Cluster

[Charles Miller via 4D_Tech]

Should have been search

On Tue, Apr 14, 2020 at 5:33 PM John J Foster via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hey Chuck,
>
> Not sure what “hash and stir” means?
>
> Matching data requires one kind of index for speed and doing a radial
> search another.
>
> In the db where I only have 1/2 million records with longitude as a real
> the index returns a range quite quickly. So I’ll keep it for the radial
> search.
>
> For matching the data the jury is still out.
>
> Appreciate,
> John…
>
>
> > Sure you hash and stir that, when searching for a particular lat/long
> combination you has entry and search
> >
> > This will not help in distance calculations
> >
> > How about this for a create a concatenated key that has two parts for
> each
> >
> > Named LatKey
> >   Lat_before decimal
> >   Lat_after decimal
> >
> > LongKey
> >   Long_before decimal
> >   long_after decimal
> >
> > do queries
> > and process using fields that contain the entire lat and long as a real
> >
> > 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
> **

-- 
-
 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
  https://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: one server window on client

[Charles Miller via 4D_Tech]

I have tried that as well. I added change user after trying to log in as
designer. Result crash. Logging in as administrator. Result crash. Change
user. Result crash

Regards

Chuck

On Tue, Apr 14, 2020 at 3:47 PM Tim Nevels via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> On Apr 14, 2020, at 2:00 PM, Chuck Miller wrote:
>
> > Environment windows server 2016. 4D 17.4 running as a built server.
> Server running as a service.
> >
> > I am logged in as Administrator.
> >
> > A one line method
> > OPEN ADMINISTRATION WINDOW
> >
> > 4D crashes every time
> >
> > I have changed method to add change user crashes in the same place
> >
> > Any ideas
>
> Try “Designer" user. That’s how I always access the 4D Server window from
> 4D Client.
>
> Start a new process, then:
>
> CHANGE CURRENT USER(“Designer”;”password”)
> OPEN ADMINISTRATION WINDOW
>
> When I’m done, I switch back to the previous 4D user.
>
> 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
> **

-- 
-
 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
  https://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: one server window on client

[Charles Miller via 4D_Tech]

Yes on a client. not on the server

On Tue, Apr 14, 2020 at 3:25 PM lists via 4D_Tech <4d_tech@lists.4d.com> wrote:
>
> Chuck,
>
> Just to make sure, you are executing that command on a client, not on the 
> server with a stored proc or Execute on server right?
>
> Lahav
>
> -Original Message-
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Charles Miller via 
> 4D_Tech
> Sent: Tuesday, April 14, 2020 1:17 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Charles Miller 
> Subject: Re: one server window on client
>
> Tried that with same result
>
> On Tue, Apr 14, 2020 at 3:15 PM Bob Miller via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> > Hi Chuck,
> >
> > RE> A one line method
> > RE> OPEN ADMINISTRATION WINDOW
> >
> > RE> 4D crashes every time
> >
> > What if you open a new process method with the one line?
> >
> > I call OPEN ADMINISTRATION WINDOW and it does work, but I have it in
> > its own process.  Can't say why other than that's how I wrap all my
> > primary methods.
> >
> > Bob Miller
> > Parker Hannifin Corp.
> > **
> > 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
>   https://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
> **
> **
> 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
  https://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: one server window on client

[Charles Miller via 4D_Tech]

Tried that with same result

On Tue, Apr 14, 2020 at 3:15 PM Bob Miller via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Hi Chuck,
>
> RE> A one line method
> RE> OPEN ADMINISTRATION WINDOW
>
> RE> 4D crashes every time
>
> What if you open a new process method with the one line?
>
> I call OPEN ADMINISTRATION WINDOW and it does work, but I have it in its
> own process.  Can't say why other than that's how I wrap all my primary
> methods.
>
> Bob Miller
> Parker Hannifin Corp.
> **
> 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
  https://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: Can't Access Design Mode in 6.0.6

[Charles Miller via 4D_Tech]

Hi All,
compiled?

On Tue, Apr 7, 2020 at 12:14 PM Randy Kaempen via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> This is for one you fellow old-time experts.
>
> I have a new client, who is trying to convert from 6.0.6 to v17.  Yes, that's 
> right, 6.0.6.  Believe it or not, I did one from this old a version a year 
> ago.
>
> I've got an old machine to run it on.  I have the database structure and the 
> developer password.  However, I can't get into design mode.  I am logged in 
> as Designer.  There is an option on their menu that says User Mode.  However, 
> when I select it, the database quits.  If I do option-f, the database quits.  
> If I do option-F4, the database quits.  I have managed to run a procedure and 
> interrupt it with option-click.  I get the dialog with Trace and Edit on it.  
> The buttons are enabled.  However, when I click either one, the database 
> quits.
>
> I thought it might be an authorization issue.  I have license codes from back 
> then, but I don’t see a place to enter them.  Also, I created a brand-new 
> database and it let me access design mode and see the structure.
>
> I can't figure out why it won't let me into design mode.  Any ideas?
>
> Thanks.
>
>
> Randy Kaempen
> Intellex Corporation
>
> **
> 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
  https://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: Receive packet stop character

[Charles Miller via 4D_Tech]

Perhaps it is a new line

On Wed, Mar 25, 2020 at 9:31 PM JOHN BAUGHMAN via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I have a tab delimited text file and I want to get the first row with…
>
> C_TEXT($TextValue)
> $DocRef:=Open document($IndexPath)
> RECEIVE PACKET($DocRef;$TextValue;”\r")
> CLOSE DOCUMENT($DocRef)
>
> This was working fine until about an hour ago when it suddenly started
> bringing in the whole document which has many rows. Using “\t” works fine
> just bringing the first field in the first row.
> Any ideas?
>
> Mac OS High Sierra
> 4D v14 in Unicode mode
>
> John
>
>
> John Baughman
> Kailua, Hawaii
> (808) 262-0328
> john...@hawaii.rr.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
> **

-- 
-
 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
  https://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: Why did 4D kill the Solutions Guide?

[Charles Miller via 4D_Tech]

I think the answer is more complex. Firstly when you looked there was a
paucity of developers listed. It made 4D look even more small than they
really are. Second. I know that Tracy had reached out to all developers to
update their listings. Most do not so were really out of date. The last
time I looked and it was available you could search for a developer in many
states and find no one.
If enough developers will agree to update their pages and infomercial, I
would bet it would come back

Hope this helps.

On Fri, Mar 13, 2020 at 7:34 PM Robert ListMail via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> One of the benefits of being a 4D partner was the ability to be
> represented in the online solutions guide (previously shown on the 4D web
> site), when and why did 4D take this away? Enquiring minds want to know!
>
> Thanks,
>
> Robert
> **
> 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
  https://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: is anyone working with dropbox via 4D? how?

[Charles Miller via 4D_Tech]

I would like to see that as well Thanks

Chuck

On Thu, Mar 5, 2020 at 3:15 PM Neal Schaefer via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> We have a very basic method using their API to upload files from 4D to a 
> Dropbox account. I'd be happy to share code if you're interested.
>
> Neal Schaefer
> Director, Product & Content Management Systems
>
> ABC-CLIO
> 147 Castilian Drive | Santa Barbara, CA | 93117
> nschae...@abc-clio.com | 
> www.abc-clio.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
> **



-- 
-
 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
  https://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: dropbox api

[Charles Miller via 4D_Tech]

We had used drop box and now use BOX to save changed methods upon save
or close to folder structures. In both cases I just treat it as a
folder

Regards

Chuck

On Thu, Mar 5, 2020 at 2:59 PM Mike Kerner via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> is anyone working with dropbox via 4D?  how?
>
> --
> On the first day, God created the heavens and the Earth
> On the second day, God created the oceans.
> On the third day, God put the animals on hold for a few hours,
>and did a little diving.
> And God said, "This is good."
> **
> 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
  https://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: Related Table Field in Quick Report Causes Report to Fail to Generate

[Charles Miller via 4D_Tech]

Does it crash immediately? If not perhaps there is an index problem.
What happens with only one record on the report?  Also what 4D
version, and O/S combination  are you running in?

Regards

Chuck

On Tue, Feb 25, 2020 at 1:20 PM Tom Benedict via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> It’s been many years since I’ve done much with Quick Reports, but now a 
> customer has reported that a specific Quick Report template that they use is 
> no longer working. The “Print Preview” and “Print” icons in the QR Toolbar 
> are enabled, but clicking on them does “nothing” (no report is generated). 
> Only if the two columns which reference fields in one of the related tables 
> are removed will the report generate. There are other columns which reference 
> related fields in other tables, and they work fine, but using fields from 
> this one related table stops report generation.
>
> I’ve tried rebuilding the report from scratch, but once I add a column from 
> the troublesome table, the report stops generating. I’ve confirmed that the 
> tables are related (actually deleted and recreated the relation) and I’ve 
> tried adding a calculated column which holds a query to relate the tables. 
> And I tried rebuilding using the QR Wizard. I’ve also tried it on different 
> data files.
>
> The customer reports that this QR template worked until we gave them a new 
> structure file. Unfortunately we don’t have the source code for their prior 
> build, so I can’t compare structures, but I don’t see any evidence of recent 
> schema changes which may have introduced this behavior.
>
> Is there something obvious I’ve overlooked?
>
> 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
> **



-- 
-
 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
  https://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: Poor Image Quality When Converting Pict Image to JPG and TIF Using CONVERT PICTURE (SOLVED)

[Charles Miller via 4D_Tech]

Hi ken. I assume you hav no PCs that uses this database. If you do viewing
PDFs may not yield the same result. You also as far as.i know can’t display
in a picture variable or print them in a picture variable

Chuck
On Fri, Feb 7, 2020 at 6:36 AM Ken Eyring via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Converting to PDF instead of PNG, JPG or TIF solved the blurry issue.
>
> Thank you very much!
>
>
>
> On 02/06/20 4:25 PM, Keisuke Miyako via 4D_Tech wrote:
> > Hello,
> >
> > PICT is a container format, it can contain either raster or vectorial
> images.
> > it sounds like you have vectorial images.
> >
> > on Mac, you can use the command to convert PICT to PDF,
> > which will result in "sharp" images.
> >
> > otherwise you need to scale up the image before converting it to a
> rasterised image such as PNG, TIF or JPG.
> >
> >
> >
> >
> >> On Feb 7, 2020, at 2:00, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> >>
> >> CONVERT PICTURE([Logos]Logo;".TIF")
> >>
> >> I also get the same issue when trying to convert to jpg:
> >>
> >> CONVERT PICTURE([Logos]Logo;".JPG")
> >>
> >> Any thoughts how I can best convert the images in my data file without
> losing any quality?
> >
> > **
> > 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
> **

-- 
-
 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
  https://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: button clicks

[Charles Miller via 4D_Tech]

I tried enable object first. It has no effect. I cN get Multiple clicks in.
I even tried disable object  first line of code and enable on click for
select in hr list box. Also had no effect. I can get multiple clicks in



On Thu, Jan 30, 2020 at 5:14 PM Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> yes, that is how click events work.
>
> similar to keystrokes, the actions are queued.
>
> if you have genuine concerns that the user can click multiple time before
> the object method completes,
> you can surround the code block with OBJECT SET ENABLED.
> the appearance will not change (4D only refreshed the UI at the end of the
> even cycle)
> but you will block clicks during method execution.
>
> no need to do it everywhere, if your method is quick enough.
>
> and for object methods that take more than a millisecond to complete,
> the recommendation is to use a worker and CALL FORM to not block the UI.
>
> 2020/01/31 5:32、Charles Miller via 4D_Tech <4d_tech@lists.4d.com 4d_tech@lists.4d.com>>のメール:
>
> When I click the up or down buttons I find that I can click them a
> second time before the code to perform the action has completed. Is
> that what others would expect?
>
>
>
> **
> 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
  https://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
**

button clicks

[Charles Miller via 4D_Tech]

Hi All,

I have a form which is displaying a listbox.

I can select one or more lines on the list box.
I also have a button that moves the selected lines up or down so as to
finally adjust display order for those records

When I click the up or down buttons I find that I can click them a
second time before the code to perform the action has completed. Is
that what others would expect?

I would have thought that button clicks were not stacked up until code
underneath has completed. I have tried to disable button on first
mouse click and after the coed enable it again. It seems that this
does not reset button til code is completed


Thanks and regards

Chuck


-- 
-
 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
  https://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: Is There a Win32API.bundle For v17.3HF2?

[Charles Miller via 4D_Tech]

I think it is a 32 bit and this will never run on 10.15

Regards

Chuck

On Sun, Jan 12, 2020 at 2:30 AM Ken Eyring via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> If there's a Win32API.bundle for v17.3 HF2, can someone please let me
> know where I can find it?
>
> I downloaded the 8.3 version from here:
>
> https://github.com/OrchardSoftware/4D-Win32API/releases/download/8.3/4D-Win32API-master.zip
>
> But it has errors when I run it on Windows with 4D v17.3 HF2 and other
> 4D v17.x versions.
>
> Using Mac Server OSX 10.15.2 with 4D Server 17.3 HF2 64-bit with Windows
> 10 Home 4D v17.3 HF2 (32-bit and 64-bit).  Both have the errors for the
> Win32API plugin.
>
> Thanks,
> Ken
>
>
>
>
> **
> 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
  https://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: auto upgrade component

[Charles Miller via 4D_Tech]

My mistake not a component it comes from summit 77598-AutoAppUpdates.
I am thinking of implementing and wondering how well it really works
and was customization needed

Chuck

On Tue, Jan 7, 2020 at 1:38 PM Pat Bensky via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Where did you find that component?
>
> On Tue, 7 Jan 2020 at 18:14, Charles Miller via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > Hi All,
> > I am looking for some assessment of this component form 4D.
> >
> > Ease of implementation
> > Any changes needed
> > What version of 4D are you using
> > How seamless is it really.
> >
> > Thanks and regards
> >
> > Chuck
> >
> > --
> >
> > -
> >  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
> >   https://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
> > **
>
>
>
> --
> *
> 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
> **



-- 
-
 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
  https://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
**

auto upgrade component

[Charles Miller via 4D_Tech]

Hi All,
I am looking for some assessment of this component form 4D.

Ease of implementation
Any changes needed
What version of 4D are you using
How seamless is it really.

Thanks and regards

Chuck

-- 
-
 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
  https://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: Reading and writing large arrays to disk

[Charles Miller via 4D_Tech]

Th e overhead for writing 1 k is the same as writing 1 meg to disk. Writing
one element at a time will take much longer

Regards
Chuck

On Mon, Jan 6, 2020 at 4:18 AM Peter Bozek via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Mitch,
>
> If the speed is the issue, you may try to write/read array elements to disk
> using SEND PACKET / RECEIVE PACKET. If you want to speed up reading, insert
> number of elements into first line, like
>
> Create document
> SEND PACKET(file;Size of array(arrayElement)+"\n")
> loop for all elements in array
>   SEND PACKET(file;arrayElement{}+"\n")
> end loop
> Close Document
>
> and vice versa
>
> Open document
> RECEIVE PACKET(file;$t;"\n")
> arraySize:=Num($t)
> array text(arrayElement;arraySize)
> for 1..arraySize
>   RECEIVE PACKET(file;$t;"\n")
>   arrayElement{}:=$t
> end for
> Close Document
>
> The above should avoid a part, where you (or 4D) is resizing a big memory
> block to insert additional array elements.
>
> --
> Peter Bozek
>
>
> On Mon, Jan 6, 2020 at 5:09 AM Mitchell Shiller via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > Hi,
> >
> > I have large string arrays (about 200 k elements).
> > I need to write and read them to disk.
> > Speed is the most important criteria.
> >
> > Options
> > 1) Create a text variable (loop with CR delimiter) and then TEXT TO
> > DOCUMENT.
> > 2) VARIABLE TO BLOB, COMPRESS BLOB, BLOB TO DOCUMENT
> > 3) OB SET ARRAY, JSON STRINGIFY, TEXT TO DOCUMENT
> >
> > Obviously using the reverse commands to read from disk.
> > Option one seems by far the slowest.
> >
> > Anyone know if 2 or 3 is faster?
> > Does the COMPRESS BLOB help? The resultant file is about 2 MB in size
> > without compression.
> > If yes to COMPRESS BLOB , Any différence from native 4D vs. GZIP
> > compression?
> >
> > Thanks as always.
> >
> > Mitch
> >
> >
> >
> > Sent from my iPad
> > **
> > 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
> > **
>
>
>
> --
> --
>
> Peter Bozek
> **
> 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
  https://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: running server v17.3 as a service

[Charles Miller via 4D_Tech]

Thh hi a is that helps a lot. When trying to enable the interact with
desktop on server 2026. You can see alerts but can not do anything about
them. I am making program changes but how might one handle an unexpected
 Alert

Regards and happy holidays

Chuck
On Mon, Dec 30, 2019 at 6:43 PM Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> the documentation points you in the right direction
>
>
> https://doc.4d.com/4Dv17/4D/17.3/Registering-a-Database-as-a-Service.300-4640983.en.html
>
> read carefully the passage on “Local System Account” and printing.
>
> > 2019/12/30 22:35、Chuck Miller via 4D_Tech <4d_tech@lists.4d.com>のメール:
> > How to implement and what pitfalls or gotchas there might be.
> > I will be using a built server, with a data file outside of the package
> folder
>
>
>
>
> **
> 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
  https://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: Options for Connecting to MS SQL Server from OS X 10.14+

[Charles Miller via 4D_Tech]

Since you are on a Mac you might need driver. Actual technology has the best

Regards
Chuck

On Wed, Dec 18, 2019 at 4:37 AM Narinder Chandi via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi all. We have a requirement to connect to MS SQL Server databases hosted
> on AWS from 4D v17.3 on Mac OS 10.14+. The use case scenario is likely to
> be that:
> * only a single user will need to connect, either via 4D Client or from 4D
> standalone - tbc
> * we may need to ingest large amounts of data from SQL Server into 4D
> tables in order to analyse it - the developer wishes to do this from 4D for
> his convenience
> * the requirement is most likely one-way read only from MS SQL Server and
> write to 4D - tbc
>
> If my initial investigations are correct we need:
> * an ODBC manager
> * SQL Server ODBC driver
>
> For the ODBC manager it seems there are really only 2 choices - both free:
> * http://www.odbcmanager.net - ODBC Manager
> * http://www.iodbc.org - iODBC
>
> For the ODBC driver there seems to be these options - requiring licences:
> * http://www.actualtech.com
> * https://www.openlinksw.com
>
> It looks like ODBC Manager is supported and maintained by Actual
> Technologies who can also provide a driver.
>
> Does anybody have recent experience of connecting to MS SQL Server from 4D
> v17 on Mac OS 10.14? If so:
> * what combination of driver manager and SQL Server driver worked for you
> - was it from the ones I have listed or some other?
> * could you kindly elaborate on your experience - connection, reliability,
> driver stability, performance, etc
> * any other useful pointers for consideration?
>
> Regards,
> Narinder Chandi,
> ToolBox Systems Ltd.
> https://toolbox.systems
>
> I am available for new consulting opportunities…
> http://4d.1045681.n5.nabble.com/ANN-4D-Developer-Available-td5765443.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
> **

-- 
-
 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
  https://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: FLUSH BUFFER

[Charles Miller via 4D_Tech]

It also depends on size of cache. How big is cache and how much me memory
on machine


On Fri, Dec 13, 2019 at 11:42 AM stardata.info via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> 20 Seconds
>
> Thanks
>
> Ferdinando
>
> Il 13/12/19 17:00, Tom Benedict ha scritto:
> > What is the “Flush Cache every..” value in Database Settings>Memory? If
> there are ‘lots’ of records being flushed, sometimes that can take a while.
> Setting the value smaller causes it to happen more frequently, but fewer
> records, which can be more efficient.
> >
> > HTH,
> >
> > Tom Benedict
> >
> >> On Dec 13, 2019, at 07:39, stardata.info via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >>
> >> Hi All,
> >>
> >> In one my application in 4D V13.4 on Windows, in some circumstances 4D
> client freezes, seems when in one process he must to write more records.
> >>
> >> During these freezes periods, the 3/4 processes launched from my
> applications work, but the front end interface is locked and is not
> responsive.
> >>
> >> After some seconds or minutes, 4D client work normally. Is possibile
> that this is because he must to write more records ( i think around 100 -
> 300 records )?
> >>
> >> Is necessary to use FLUSH BUFFER commands?
> >>
> >>
> >> Thanks
> >> Ferdinando
> >> **
> >> 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
> **

-- 
-
 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
  https://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: Can't Define DEP Exception On Windows

[Charles Miller via 4D_Tech]

Also why are you not running last version of 15 which I think is 15.6

Regards

Chuck

On Tue, Dec 10, 2019 at 7:49 PM Ken Eyring via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Hi Everyone,
>
> I have a customer who has a Windows 2008 R2 Server.  I had 4D v12.5
> installed on the machine and added 4D Server and 4D Client v12 as DEP
> exceptions.  These ran with no problems for many years.  I want to
> update the 4D software on the same machine to v15.4 and when I attempt
> to add the 4D Server v15.4 and 4D Client v15.4 applications to the DEP
> exceptions list, Windows displays the following message:
>
>  "This program must run with data execution prevention (DEP)
> enabled.  You cannot turn off DEP for this program."
>
> I'm wondering if the 4D v15.4 applications will run properly without the
> DEP exception, or if there is something that I need to configure in
> order to allow DEP exceptions to be added for the 4D Server v15.4 and 4D
> Client v15.4 applications.
>
> Any suggestions would be very much appreciated.
>
> Thank you,
> Ken Eyring
> **
> 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
  https://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: v15 - Designer user corruption

[Charles Miller via 4D_Tech]

Hi All,
Do you have any copy where this problem does not occur. I so, save
users and groups and then load users and groups as a first shot. I am
not sure this will work but it may

You could also create a new db with no users and groups, save it and
then try loading that one.

C_BLOB($Blob_blb)
USERS TO BLOB($Blob_blb)

blob to document and then

DOCUMENT TO BLOB($File_Path;$Blob_blb)
BLOB TO USERS($UsersAndGroupd_b)

I don't think an of these will help as designer and admin are not
included in command , but worth a try,

On Tue, Nov 26, 2019 at 3:07 PM Chip Scheide via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> some of you may remember my frustration with a stack error when opening
> a database with an interpreted component, and getting a Stack error
> before any of my code was running.
>
> Well, thanks indirectly to tech support I have determined the cause:
> the designer user is corrupted in some manner
>
> if I log in as administrator the database loads normally.
> if I log in as designer I get the stack overflow error.
>
> I now need some help in removing or repairing the users.
>
> anyone else had this issue - if so how was it resolved?
> and what about other users of the system how were they handled?
>
> Thanks
> Chip
>
> We have done so much, with so little, for so long;
> We are now qualified to anything with nothing 
>   - unknown
> **
> 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
  https://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: 4d write pro and rich text

[Charles Miller via 4D_Tech]

Thanks I know about that. It is the creation of the write pro doc that is
printed later

Chuck

On Mon, Nov 11, 2019 at 5:18 PM Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> 4DWrite Pro areas allow rich text entry. See:
>
>
> https://doc.4d.com/4Dv17/4D/17/Using-a-4D-Write-Pro-area.200-3726280.en.html
>
> There's also a more user-friendly toolbar component available ... see
> https://blog.4d.com/4d-write-pro-a-new-bar-is-born/
>
> Helpful?
>
> Pat
>
> On Mon, 11 Nov 2019 at 12:08, Chuck Miller via 4D_Tech <
> 4d_tech@lists.4d.com>
> wrote:
>
> > Either that or allow for rich text entry
> >
> > Chuck
> >
> > Sent from my iPhone
> >
> > > On Nov 11, 2019, at 12:10 PM, Pat Bensky via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> > >
> > > So are you saying that you want users to be able to paste formatted
> text
> > > from Word and have the formatting carry through to the 4D report?
> > > Pat
> > >
> > >> On Sun, 10 Nov 2019 at 23:00, Charles Miller via 4D_Tech <
> > >> 4d_tech@lists.4d.com> wrote:
> > >>
> > >> We create a report now with 4D write and ha e various text areas we
> > would
> > >> love to allow for formatting in them now users paste in from word
> > >>
> > >> Regards
> > >>
> > >> Chuck
> > >>
> > >> On Thu, Nov 7, 2019 at 6:21 PM Pat Bensky via 4D_Tech <
> > >> 4d_tech@lists.4d.com>
> > >> wrote:
> > >>
> > >>> Chuck,
> > >>> Can you explain in a bit more detail what you are trying to do?
> Create
> > a
> > >>> rich text area on the fly? Add rich text to plain text as part of a
> > >> report?
> > >>> Pat
> > >>>
> > >>> On Thu, 7 Nov 2019 at 19:06, Charles Miller via 4D_Tech <
> > >>> 4d_tech@lists.4d.com> wrote:
> > >>>
> > >>>> I see from documentation the following
> > >>>>
> > >>>> different rich text areas within 4D (text variables/fields and list
> > >>> boxes),
> > >>>> a 4D Write Pro (or 4D Write) area and a 4D rich text area,
> > >>>> an external styled text and a 4D rich text area.
> > >>>>
> > >>>> What I don't see is ability to do this when creating a report on the
> > >>>> fly. I assume it is possible but do not see how. Can anyone shed
> light
> > >>>> on this
> > >>>>
> > >>>> Regards
> > >>>>
> > >>>> Chuck
> > >>>> --
> > >>>>
> > >>>>
> > >>>
> > >>
> >
> -
> > >>>> 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
> > >>>>  https://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.ht

Re: 4d write pro and rich text

[Charles Miller via 4D_Tech]

We create a report now with 4D write and ha e various text areas we would
love to allow for formatting in them now users paste in from word

Regards

Chuck

On Thu, Nov 7, 2019 at 6:21 PM Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Chuck,
> Can you explain in a bit more detail what you are trying to do? Create a
> rich text area on the fly? Add rich text to plain text as part of a report?
> Pat
>
> On Thu, 7 Nov 2019 at 19:06, Charles Miller via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > I see from documentation the following
> >
> > different rich text areas within 4D (text variables/fields and list
> boxes),
> > a 4D Write Pro (or 4D Write) area and a 4D rich text area,
> > an external styled text and a 4D rich text area.
> >
> > What I don't see is ability to do this when creating a report on the
> > fly. I assume it is possible but do not see how. Can anyone shed light
> > on this
> >
> > Regards
> >
> > Chuck
> > --
> >
> >
> -
> >  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
> >   https://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
> > **
>
>
>
> --
> *
> 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
> **

-- 
-
 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
  https://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
**

4d write pro and rich text

[Charles Miller via 4D_Tech]

I see from documentation the following

different rich text areas within 4D (text variables/fields and list boxes),
a 4D Write Pro (or 4D Write) area and a 4D rich text area,
an external styled text and a 4D rich text area.

What I don't see is ability to do this when creating a report on the
fly. I assume it is possible but do not see how. Can anyone shed light
on this

Regards

Chuck
-- 
-
 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
  https://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
**

listbox magic and v17

[Charles Miller via 4D_Tech]

Hi All,
Is anyone using this combination. We are not sure if problem we are
encountering is something inside our code base or inside LB Magic

Thanks and regards

Chuck

-- 
-
 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
  https://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
**

4 write pro and rulers

[Charles Miller via 4D_Tech]

Hi All,

In working on conversion to write pro from 4d write, I can't figure
out how to copy ruler programmatically The 4D write version can do
this. How do I do this in write pro



-- 
-
 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
  https://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: How to view PDF's on Windows with 4D V16

[Charles Miller via 4D_Tech]

I use open url on windows. It opens I web page or default reader depending
upon settings

Regards

Chuck

On Thu, Oct 31, 2019 at 11:07 AM Robert McKeever via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I’ve tried PDF View, and the PDF’s fail to load. Works fine on the Mac.
>
> Any ideas?
> _
> 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
> **

-- 
-
 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
  https://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: Compiling for Windows and Mac

[Charles Miller via 4D_Tech]

I am confused when you are running on a windows server.  I thought you had
to co pile on windows. I know that if you are building server and clients
that is true. What is also true is that you have to build the first Mac
client on a Mac and the first windows client on a pc. Once you have done.
That you can include both in your built server and allow for automatic
updates

Regards
Chuck

On Fri, Oct 18, 2019 at 1:51 AM Paul Lovejoy via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Thanks!
>
> Paul
>
> > On 18 Oct 2019, at 06:17, Keisuke Miyako via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > that's basically right,
> >
> > v11 was the last version that supported i386 and ppc.
> > the label back then was "Compile for PPC and Intel processors (Mac Intel
> and Windows)"
> >
> > http://library.4d-japan.com/REFERENCE/v11/4D_v11_Design_Ref.pdf
> >
> > ---
> >
> > stating with v12, we have the option to "also compile for 64-bit"
> > for a while we could compile for 64-bit in addition to 32-bit (no option
> to drop 32-bit, since Windows clients and Mac are 32-bit)
> > at the time, 64-bit implicitly meant Server, Windows.
> >
> > starting with v15 we have 64-bit version for Mac.
> > this time the compiler was updated to generate code that could work for
> 64-bit on both platforms,
> > so there was no need to mention the platform for compilation.
> >
> > and then, finally with 17R5 we no longer have 32-bit support.
> >
> >> 2019/10/18 12:44、Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com>のメール:
> >> I can no longer find the option to compile for both platforms. Is this
> no longer necessary or am I missing something. Is it the same object code
> regardless of OS, since they’re both Intel processors?
> >
> >
> >
> >
> > **
> > 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
> **

-- 
-
 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
  https://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: certification matrix for v15

[Charles Miller via 4D_Tech]

thanks that did it

regards


Chuck

On Mon, Oct 7, 2019 at 1:33 PM Narinder Chandi via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> You can download it from here and other versions from 2004 to v17 can be 
> found there too:
>
> ftp://188.165.34.189//Documents/Products_Documentation/LastVersions/Line_15/VIntl
>
> Regards,
>
> Narinder Chandi,
> ToolBox Systems Ltd.
>
> I am available for new consulting opportunities…
> http://4d.1045681.n5.nabble.com/ANN-4D-Developer-Available-td5765443.html
> --
>
> -Original Message-
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of 4D Tech Mailing 
> List <4d_tech@lists.4d.com>
> Reply-To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> Date: Monday, 7 October 2019 at 18:29
> To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> Cc: Charles Miller 
> Subject: certification matrix for v15
>
> Hi All,This seems to be missing form 4Ds web site anyone have copy
>
> Thanks and regards
>
> Chuck
>
> --
> 
> -
>  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
>   https://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
> **
>
>
> **
> 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
  https://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
**

certification matrix for v15

[Charles Miller via 4D_Tech]

Hi All,This seems to be missing form 4Ds web site anyone have copy

Thanks and regards

Chuck

-- 
-
 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
  https://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: File Decoding: EBCDIC

[Charles Miller via 4D_Tech]

Try this link as a start

https://stackoverflow.com/questions/5277301/how-to-convert-ebcdic-with-chinese-chars-to-utf-8-format


Regards

Chuck

On Mon, Oct 7, 2019 at 8:53 AM Bob Miller via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Hello,
>
> I have a project where sales data is being sent to an FTP site and I'm
> picking it up and importing into 4D.  The latest dataset comes from Asia
> Pacific and is stored as a double byte character set in EBCIDIC format.  I
> need to somehow open this and convert it back to the source character
> base, which is Simplified Chinese.
>
> I have no idea where to start with this; any ideas would be most welcome!
>
> Thank you,
>
> -Bob Miller
> Parker Hannifin Corp.
>
> ll
> "PLEASE NOTE: The preceding information may be confidential or privileged.
> It only should be used or disseminated for the purpose of conducting
> business with Parker. If you are not an intended recipient, please notify
> the sender by replying to this message and then delete the information from
> your system. Thank you for your cooperation. Parker Hannifin Corporation
> and its subsidiaries, affiliates and associated companies ("Parker")
> process personal data in accordance with Parker’s Personal Data Privacy
> Policy which may be accessed from www.parker.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
> **

-- 
-
 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
  https://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
**

folder structure in a hierarchical list box

[Charles Miller via 4D_Tech]

Hi all,
4D version is 15.

has anyone coded this. For a variety of reasons  we are trying to best
show resource folder structure in a list box. We want to code for an
unknown folder depth so that if we need to add a folder no additional
coding would need be done.
We are doing this as we have distributed servers and sometimes have to
move items from the main server to all others. Current implementation
is by file type. I have been asked to change to folder structure and
would rather not have to recode it.

thanks and regards

chuck
-- 
-
 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
  https://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: 4D ODBC, MS SQL and Alpha Fields

[Charles Miller via 4D_Tech]

can we see the entire sql statement you are using. What version of 4D?

Lastly, If you can I have always found it easier to go from 4D to sql
server. If you are on PC you already have odbc on PC if on mac you
would have to buy odbc driver for sql server. I always use the one
from actual technologies

Regards

Chuck

On Thu, Oct 3, 2019 at 12:56 PM Paul Jones via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> We pull data from 4D into MS SQL using the 4D ODBC Driver.  On occasion, we 
> have a problem with some Alpha fields where only the first 2 characters are 
> pulled into SQL.
>
> In MS SQL,  the associated field has been configure to use varchar(255) {or 
> whatever the field length is for the 4D field}
>
> I've tried several different ways to pull the data and I've found the 
> following:
> If I only query for records where the field contains data {not like ""}, the 
> field doesn't get truncated.  If I try to select all records,  the truncation 
> occurs.
>
> I have a very inefficient workaround which is to pull the truncated fields 
> one at a time into a temporary table and then update the record in the 
> original table.  While that works,  if I have to do that for every Alpha 
> field,  the process takes way to long.
>
> Here is an example of what gets returned without filtering for blank records:
>
> "wh
> 
>   "
> "no
> 
>   ?   
>   
>   
>   "
> "wh
> 
>   "
>
>
>   *   Note the 2nd records appears to contain a length of 257 characters when 
> in fact the field is only 10 characters.
>
> The correct field values that should be returned are:
> "wholesale"
> "non_exempt"
> "wholesale"
>
>
> Just wondering if anyone has worked with pulling data from 4D into MSSQL and 
> if have had this same issue and have found a solution to the problem.
>
>
> Paul Jones
>
>
> _
> Please consider the environment before printing
> **
> 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
  https://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: Debug Application Process Window missing toolbar

[Charles Miller via 4D_Tech]

I would delete the file. It will recreate itsel next launch

On Thu, Sep 19, 2019 at 3:19 AM Koen Van Hooreweghe via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi Paul,
>
> There is some 4D prefs file 4ddebugger.json which might contain faulty
> values. I don't know exactly where to find it on Windows, but on Mac its
> home/Library/Application Support/4D/4D Window Bounds
> v17/runtime/[projectForm]/4ddebugger.json.
>
> See also: https://forums.4d.com/Post/EN/16299793/1/16299794
>
> HTH
> Koen
>
> > Op 19 sep. 2019, om 04:20 heeft Paul Ringsmuth via 4D_Tech <
> 4d_tech@lists.4d.com> het volgende geschreven:
> >
> > 4Dv17R5
> > Windows 10 under VirtualBox
> >
> > The toolbar is missing in the Debug Application Process Window except
> for a couple of pixels.
> >
> > I can’t find a way to get it back. Any suggestions?
> >
> > Paul Ringsmuth
> > pringsm...@charter.net 
> >
>
>
>
> 
> Compass bvba
> Koen Van Hooreweghe
> Kloosterstraat 65
> 9910 Aalter
> Belgium
> tel +32 495 511.653
>
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

-- 
-
 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
  https://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
**

list box vs old style form

[Charles Miller via 4D_Tech]

Hi All,
Environment v15 client server

I am trying to usse type ahead on a field based list box where search
as character is typed. If I am using old style output form, there does
not seem to be a need to a entry variable to implement this feature.
Any ideas as to how I would do this using a field base listbox in v15

Thanks and regards

Chuck

-- 
-
 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
  https://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: V16 Server Issue

[Charles Miller via 4D_Tech]

Probably not this but a really tight loop of any kind with no idle and
delay process might have the ability to do this. Like retry loading a
record till that processs has it locked

Regards

Chuck

On Thu, Sep 12, 2019 at 1:14 PM Stephen J. Orth via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I have a weird situation I'm wondering if anyone can shed some light on.  I
> will describe what has been communicated to me.
>
> First, this is an OEM system using V16.3 NB 225762 running on a virtual of
> Windows Server 2016.  The system is comprised of the server and 1 client
> that also runs on the server hardware and has been running since early
> 2019.
> The remaining connections are all browser based.
>
> I've been told the Server system appeared to be "frozen".  When one of TS
> guys logged onto the box the Administrating screen appeared to unresponsive
> (not updating the chart) and no backup was performed since 9/6/19.
>
> The 1 client connection showed it being disconnected from the server (i.e.
> 4D disconnect error present).  Clicking on the reconnect button did not
> work, as the client said it could not reach the server.  So, the next step
> was to terminate the client software.
>
> As soon as the client software was terminated the Server started running a
> backup and functioning again.
>
> Has anyone seen anything like this?  Why/how would a client connection
> cause
> the system to freeze and prevent it from backing up for 6 days?
>
> Thanks in advance!
>
>
> Best,
>
>
> Steve
>
> *
>   Stephen J. Orth
>   The Aquila Group, Inc.  Office:  (608) 834-9213
>   P.O. Box 690   Mobile:  (608) 347-6447
>   Sun Prairie, WI 53590
>
>   E-Mail:  s.o...@the-aquila-group.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
> **

-- 
-
 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
  https://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: v15 - How to get an (form) object into a blob?

[Charles Miller via 4D_Tech]

Hi chip when I get back from vacation I can send you link to JPR’s code
that will go through all form and then you can fix any of the Picts

Regards

Chuck

On Mon, Sep 9, 2019 at 6:33 PM Chip Scheide via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I have passed an application to 4D inc to check it for 64 bot
> compatibility.
> The report showed a number of PICTs, outside of the library.
>
> I *think* I have found them, but.. I am not sure how I can check.
>
> The objects are form objects (type 'Static Picture'), they are not
> variables.
> How can I determine if a static picture is of type PICT?
>
> I have code to test if a picture in a variable is of type PICT.
>
> any ideas?
> Thanks
> Chip
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

-- 
-
 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
  https://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: Folder equivalent for: "SET DOCUMENT PROPERTIES"

[Charles Miller via 4D_Tech]

Good to know. It seems like it might be useful, but I can not figure
out why in a 4D environment. I suppose I am just being dense

Regards
Chuck

On Wed, Sep 4, 2019 at 12:04 PM Chip Scheide via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> On a Mac from the UI you *can* lock a folder.
>
> The lock restricts the folder during deletion (a warning message is
> presented), and this stops the folder from being written into.
> For a PC the equivalent would be Read only.
>
> NOTE:
> This is an **excellent** way to restrict browsers data storage.
> Locate the cookies, history and/or any other folder you wish to
> restrict.
> Clear the contents.
> Lock it.
>
> The browser will work as normal - BUT - it can not write anything to
> those folder(s)
> no cookies saved, no history (if you want) saved, etc etc etc
>
> Chip
>
> On Wed, 4 Sep 2019 11:20:44 -0400, Chuck Miller via 4D_Tech wrote:
> > What do you mean by locked. Locked means the file is in use by
> > another application/ process.  Do you really mean permission?
> >
> > I do not think you can lock a folder like a file except if you use
> > permissions.
> >
> > 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.
> >
> >> On Sep 3, 2019, at 8:39 AM, Chip Scheide via 4D_Tech
> >> <4d_tech@lists.4d.com> wrote:
> >>
> >>>
> >>> The parameters “locked” and “invisible” are of special interest.
> >
> > **
> > 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
> **



-- 
-
 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
  https://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
**

4d write to write pro conversion

[Charles Miller via 4D_Tech]

Hi All,

we use 4D write extensively and have many issue trying to convert.

For example, we need to know the total number of pages to be printed
so that we can have page 1 of x etc on each page

We change the style based upon the data

We need to see what fits on a page and if not enough insert page break
so that there is never Header with no detail at bottom of page

We sometimes need to insert text and particular styles in the the
middle of the document. The list goes on.

FYI there are many pictures printed as well

Any ideas how we might proceed? Does anyone know 4D's plans re
implementing all 4D write features in 4D write pro and if so when that
might occur.

-- 
-
 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
  https://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: windows versions for 4D v13.6

[Charles Miller via 4D_Tech]

You don’t. For a short period this customer is stuck using 4D v 13.6. It is
that version I am asking about.

Regards
Chuck

On Fri, Aug 30, 2019 at 10:35 PM JOHN BAUGHMAN via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> If I understand your question…
>
> Windows 10 - v17R5 64bit
> Windows 2008 R2 Enterprise - v16 R6 64bit
>
> John
>
>
> > On Aug 30, 2019, at 10:31 AM, Chuck Miller via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > Is anyone running server on OS newer than windows server 2003. If so
> what version
> >
> >
> > 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)
> > 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
> **

-- 
-
 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
  https://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: looking for Barclay Berry

[Charles Miller via 4D_Tech]

Found him. Thanks

On Fri, Aug 30, 2019 at 3:51 PM Chuck Miller via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi all
>
> Does anyone have contact info for Barclay. I am interested in upgrade to
> Listbox Magic as on foundation store it only supports up to v13 I need v17
>
> We would ultimately buy the source but hope there is upgraded source as
> well
>
>
> 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)
> 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
  https://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: save listbox

[Charles Miller via 4D_Tech]

You are better of creating CSV files so you can handle carriage returns
etc. there are a few tech notes on the subject

Regards
Chuck
On Tue, Aug 13, 2019 at 6:30 PM Adam Bevan via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Chips solution probably the quickest.
> I ended up writing to a tab deliminated text file, so I could load it up
> into a spreadsheet.
>
> $vH_FileRef:=Create document($vT_FilePath)
> LISTBOX GET
>
> ARRAYS(*;$vT_ListboxName;$aT_ColumnNames;$aT_HeaderNames;$aptr_ColumnVars;$aptr_HeaderVars;$aB_ColVisible;$aL_ColStyle)
>
> $ vL_rCount:=Size of array($ aptr_ColumnVars{1}->)
> For($vL_rNum;1;$vL_rCount)
> CLEAR VARIABLE($vT_TextToWrite)
>
> $vL_Count:=$aT_ColumnNames
> for($vL_cNum;1;$vL_cCount)
> if(length($vT_TextToWrite)#0)
> $vT_TextToWrite:=$ vT_TextToWrite +Char(tab)
> end if
> Case of
> :(Type($vptr_Column->{$vL_cNum})=Is Text)
> $vT_TextToWrite:=$vT_TextToWrite+$vptr_Column->{$vL_cNum}
>
> : (Type($vptr_Column->{$vL_Num})=Is date)
> $vT_TextToWrite:=$vT_TextToWrite+String(Year
> of($vptr_Column->{$vL_Num}))+"-"+String(Month
> of($vptr_Column->{$vL_Num}))+"-"+String(Day of($vptr_Column->{$vL_Num}))
>
> :(Type($vptr_Column->{$vL_cNum})=Is Time)
> $vT_TextToWrite:=$vT_TextToWrite+String($vptr_Column->{$vL_cNum};HH MM SS)
>
> :(Type($vptr_Column->{$vL_cNum})=Is Longint)
> $vT_TextToWrite:=$vT_TextToWrite+String($vptr_Column->{$vL_Num})
>
> else   // unsupported array types
> // don't write to text file.
> end case
> end for   // each column
>
> $vH_FileRef:=Append document($vT_FilePath)
> SEND PACKET($vH_FileRef;$vT_TextToWrite)
> end for   // each row
>
> CLOSE DOCUMENT($vH_FileRef)
>
> Adam Bevan
> Developer & CEO, Argus Productions Inc.
> 
>
>
> On Tue, 13 Aug 2019 at 15:29, Peter Mew via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> > Hi
> > Does anyone have a routine, component, plugin, or pointer to the right
> > direction, that will save the contents of an array based listbox, so that
> > the data can be restored at a later date
> > thanks
> > -pm
> > 4d v13
> > **
> > 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
> **

-- 
-
 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
  https://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: list box and form open and close detail events

[Charles Miller via 4D_Tech]

That’s what I’m doing but was curious as to why. Shouldn’t it fire
especially when you set edit in the list box
Regards
Chuck

On Thu, Jul 25, 2019 at 8:56 PM Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> open/close detail form events are only applicable when a table list form
> is used standalone.
> (modify/display selection)
>
> they never worked when the same list form was used as a subform.
> in that sense, this is not really a listbox issue.
>
> perhaps you can use the on load/on unload event of the detail form instead.
>
> if you need to capture the transition prior to the detail form being
> loaded,
> maybe you can use the on double click~filter event~dialog sequence
> and manage the action by code.
>
> > 2019/07/26 6:09、Charles Miller via 4D_Tech <4d_tech@lists.4d.com>のメール:
> >
> > In converting some of our old forms which make use of open and close
> > detail form events in the form method. I have discovered that these
> > two events do not seem to fire when using a listbox. We are still at
> > v15, but does anyone have any ideas. We are using dialog to open the
> > form and not modify or display selection
> > When we use modify or display selection the buttons at the top of the
> > form disappear.
>
>
>
>
> **
> 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
  https://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
**

list box and form open and close detail events

[Charles Miller via 4D_Tech]

Hi All,

In converting some of our old forms which make use of open and close
detail form events in the form method. I have discovered that these
two events do not seem to fire when using a listbox. We are still at
v15, but does anyone have any ideas. We are using dialog to open the
form and not modify or display selection
When we use modify or display selection the buttons at the top of the
form disappear.

Thanks and regards

Chuck

-- 
-
 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
  https://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: Static Pictures to Library Pictures

[Charles Miller via 4D_Tech]

Not really you need more, as you have to convert old PICT pictures to
another format. You also have to deal with transparency issues

Regards

Chuck

On Wed, Jul 24, 2019 at 12:29 PM Chip Scheide via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> well...
> I do not have the mentioned database but...
>
> SET PICTURE TO LIBRARY
> looks like the command you need
> you should be able to step through your forms in code, and locate the
> picture objects, then
> send them to the library
>
> Chip
> On Wed, 24 Jul 2019 09:11:30 -0700, Tom Benedict via 4D_Tech wrote:
> > Chuck Miller responded to Ben Sokal’s post regarding moving Static
> > Pictures to Library Pictures...
> >
> >> On Jun 4, 2019, at 17:06, Chuck Miller via 4D_Tech
> >> <4d_tech@lists.4d.com> wrote:
> >>
> >> If you had gone to one of 4D’s road shows, JPR had a db that would
> >> do this for you. Perhaps you can request it from 4D. You still have
> >> to load each form but it is pretty seamless.
> >>
> >> Regards
> >>
> >> Chuck
> >>
> >>
> >>> On Jun 4, 2019, at 7:11 PM, Ben Sokal via 4D_Tech
> >>> <4d_tech@lists.4d.com> wrote:
> >>>
> >>> We are finally moving to v17 and need to fix all our static PICT
> >>> images. From previous posts and from the 4D knowledge base I
> >>> understand how to convert library images by looping through them
> >>> and running the conversion code. But the problem is we have over
> >>> 1100+ static PICT images that aren't in the library. The MSC has
> >>> identified these images but that's only somewhat helpful since that
> >>> still means we have to go to every object on hundreds of forms, and
> >>> change the properties from STATIC PICTURE to LIBRARY PICTURE. I can
> >>> spend week(s) doing this but...maybe someone has found a more
> >>> efficient way to handle bad static images that aren't in the
> >>> picture library?
> >>>
> >>> - Ben
> >
> >
> > Chuck, I’ve looked through the USB Drive that we received at this
> > year’s 4DWT and haven’t found the DB you mention. Perhaps it was part
> > of another DB with an unrelated name? Or maybe it was from a previous
> > 4DWT.
> >
> > Anyhow, if you have any further clues on this, it would be great. We
> > have about 800 static pictures on forms which need conversion.
> >
> > 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
> **



-- 
-
 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
  https://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: Static Pictures to Library Pictures

[Charles Miller via 4D_Tech]

It was from the previous road show. If you need it I can forward you a
copy as I have JPRs permission to do so, please notify me privately

Regards
Chuck

On Wed, Jul 24, 2019 at 12:11 PM Tom Benedict via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Chuck Miller responded to Ben Sokal’s post regarding moving Static Pictures 
> to Library Pictures...
>
> > On Jun 4, 2019, at 17:06, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
> > wrote:
> >
> > If you had gone to one of 4D’s road shows, JPR had a db that would do this 
> > for you. Perhaps you can request it from 4D. You still have to load each 
> > form but it is pretty seamless.
> >
> > Regards
> >
> > Chuck
> >
> >
> >> On Jun 4, 2019, at 7:11 PM, Ben Sokal via 4D_Tech <4d_tech@lists.4d.com> 
> >> wrote:
> >>
> >> We are finally moving to v17 and need to fix all our static PICT images. 
> >> From previous posts and from the 4D knowledge base I understand how to 
> >> convert library images by looping through them and running the conversion 
> >> code. But the problem is we have over 1100+ static PICT images that aren't 
> >> in the library. The MSC has identified these images but that's only 
> >> somewhat helpful since that still means we have to go to every object on 
> >> hundreds of forms, and change the properties from STATIC PICTURE to 
> >> LIBRARY PICTURE. I can spend week(s) doing this but...maybe someone has 
> >> found a more efficient way to handle bad static images that aren't in the 
> >> picture library?
> >>
> >> - Ben
>
>
> Chuck, I’ve looked through the USB Drive that we received at this year’s 4DWT 
> and haven’t found the DB you mention. Perhaps it was part of another DB with 
> an unrelated name? Or maybe it was from a previous 4DWT.
>
> Anyhow, if you have any further clues on this, it would be great. We have 
> about 800 static pictures on forms which need conversion.
>
> 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
> **



-- 
-
 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
  https://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: 4D eMail Editor - full HTML support

[Charles Miller via 4D_Tech]

Do you hav to view result in 4d. If not save it in a doc and you hen in a
blob in 4d. If you need to see save the text in a text field

Regards
Chuck

On Tue, Jul 23, 2019 at 2:26 AM rooftop99--- via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> HI All,
>
> Environment:  All Windows OS, 4D v16R4 Server/Client  (Headed to v17 64bit
> soon…)
>
> Our marketing department is creating eMails in Outlook which included
> images, hyperlinks (text and image), backgrounds, etc.  We would like to
> take these emails and copy the body content into a field in 4D to be
> retrieved for future email campaigns sent from 4D. The links, images and
> formatting need to be maintained.
>
> I have looked at 4D Write Pro as an option but it doesn’t appear to accept
> the entire contents of an outlook email via paste and it is expensive.
> Also looked at TinyMCE in a WebArea… potential.
>
> Just checking to see if anyone is doing something similar and would be
> willing to steer me in the right direction.
>
> Thanks!
> Kirk
> **
> 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
  https://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: Macs slow down generating PDFs

[Charles Miller via 4D_Tech]

What is drive like?  WhT kind of drive?  How full is it?  When was last
time you restarted the machine?

Regards

Chuck

On Wed, Jul 3, 2019 at 8:43 AM Jeffrey Kain via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Interesting - Mac 32-bit is blazing fast and doesn't have this issue.
> 64-bit Mac can crank about a one per second (slowing down to a handful per
> minute after a few hours). Windows 10 is steady at about 1 per second on
> very fast hardware.  My 2017 iMac running v17 32-bit can rip through about
> 3 per second and it doesn't slow down.
>
>
> > On Jul 2, 2019, at 10:29 PM, Jeffrey Kain 
> wrote:
> >
> > Memory was stable for 4D - didn’t check the overall system though.
> >
> >> On Jul 2, 2019, at 6:26 PM, Wayne Stewart via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >>
> >> What's memory consumption look like?
>
> **
> 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
  https://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: v13 problem

[Charles Miller via 4D_Tech]

Thanks but can not get to user. The person finally got me designer password

On Tue, Jul 2, 2019 at 3:45 PM Chip Scheide via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I just thought of this...
> If you can get to the 'user' environment
>
> select a table -
> reduce the selection to 1 record
> Apply formula (from record menu)
> insert SET USER PROPERTIES()
>
> to change designer password.
>
> Chip
> On Mon, 1 Jul 2019 12:37:46 -0400, Chuck Miller via 4D_Tech wrote:
> > Hi All,
> >
> > I just took over a v13 account and when I log in as administrator, I
> > do not see designer as user. I do not see a splay screen. The plan is
> > to fix known issues nd then move to v17
> >
> > Can anyone advise how I might get to the structure as administrator
> > and how I might see the designer user name, so I can change the
> > password
> >
> > 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)
> > 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
> **

-- 
-
 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
  https://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
**

command WA OPEN URL(*

[Charles Miller via 4D_Tech]

Hi All,

When I run this command on macs or windows that are not using edge as
the new browser. The selected document. In this case a PDF appears on
my 4D window. On PC using edge it opens inside the browser. Any ideas

Thanks and regards

Chuck
-- 
-
 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
  https://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: v14+ find in design

[Charles Miller via 4D_Tech]

Make sure you have search in methods and search in forms selected. I
also never do a case sensitive search


Regards

Chuck

On Thu, Jun 27, 2019 at 1:00 PM Dave Halbert via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> I suspect that I'm not totally understanding the question correctly but
> if this helps on V15.5 running locally on a Mac
>
> Object method is
>
> Case of
> : (Form event=On Data Change)
>
> [Stock]DescriptionInv:=Settocaps (->[Stock]DescriptionInv)
>
> End case
>
> 
>
> Using Find in design
>
> Find = Text
>
> Which = contains - entered is = ->[Stock]DescriptionInv
>
> Mod date of parent = indifferent
>
> Folder = Top level
>
> Search Forms and Methods = Yes
>
> Case sensitive = No
>
> 
>
> Result is zero occurrences
>
>
> --
> --
> The Better Beverage Company
> 5 Arthur St
> Edinburgh EH6 5DA
>
> 0131 55 33 121
> **
> 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
  https://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: Transferring a DB from Firebird to 4D using RazorSQL on Mac

[Charles Miller via 4D_Tech]

Go to https://firebirdsql.org/en/odbc-driver/ and download the ODBC
driver. Create ODBC connection on your windows box.

Log in and you should be all set


Regards


Chuck

On Wed, Jun 26, 2019 at 10:00 AM Charles Miller  wrote:
>
> I assume this is on windows.. If so, is there an ODBC driver, if so
> you can simply do general selects from 4D by logging into Firebird db
> using ODBC
>
> Regards
>
>
> Chuck
>
> On Wed, Jun 26, 2019 at 8:57 AM Jörg Knebel via 4D_Tech
> <4d_tech@lists.4d.com> wrote:
> >
> > Hi All,
> >
> > I try to transfer a Firebird db to 4D using RazorSQL.
> >
> > Transferring the structure was no big drama but getting the data exported 
> > out of the Firebird using RazorSQL produces an Error no matter what export 
> > option is chosen.
> >
> > The error message reads:
> > Error: serverVersion is an invalid version
> > (GDSServerVersion.INVALID_VERSION)
> >
> > A search for GDS-Server produces rubbish only.
> >
> > Anyone here with some pointers?
> >
> > Any and all help is appreciated.
> >
> > Thanks.
> >
> > Cheers
> > Jörg
> > **
> > 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
>   https://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.



-- 
-
 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
  https://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: Transferring a DB from Firebird to 4D using RazorSQL on Mac

[Charles Miller via 4D_Tech]

I assume this is on windows.. If so, is there an ODBC driver, if so
you can simply do general selects from 4D by logging into Firebird db
using ODBC

Regards


Chuck

On Wed, Jun 26, 2019 at 8:57 AM Jörg Knebel via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Hi All,
>
> I try to transfer a Firebird db to 4D using RazorSQL.
>
> Transferring the structure was no big drama but getting the data exported out 
> of the Firebird using RazorSQL produces an Error no matter what export option 
> is chosen.
>
> The error message reads:
> Error: serverVersion is an invalid version
> (GDSServerVersion.INVALID_VERSION)
>
> A search for GDS-Server produces rubbish only.
>
> Anyone here with some pointers?
>
> Any and all help is appreciated.
>
> Thanks.
>
> Cheers
> Jörg
> **
> 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
  https://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
**

list box and sort

[Charles Miller via 4D_Tech]

HI all,

I have not had this problem before but it must be something dumb I am
doing. I have listbox 1 where I have columns created through code and
on header click event. When I enter on header click event I do a
customer sort on  column 2. The code looks like this
case of
: (Form event=On Header Click)
C_TEXT($nameofObj_txt)
C_LONGINT($dumTbl_L;$dumFld_L)
RESOLVE POINTER(Self;$nameofObj_txt;$dumTbl_L;$dumFld_L)
if(: ($nameofObj_txt="LB_Header2_l")
If (Self->=1)
ORDER BY FORMULA([TIN_Inspections];NTI_SortByFormula (Self->);>)
Else
ORDER BY FORMULA([TIN_Inspections];NTI_SortByFormula (Self->);<)
End if

This works every time the value of LB_Header2_l variable changes as it should

I have another listbox form where columns not created by code where
C_TEXT($nameofObj_txt)
C_LONGINT($dumTbl_L;$dumFld_L)
RESOLVE POINTER(Self;$nameofObj_txt;$dumTbl_L;$dumFld_L)

Case of

: ($nameofObj_txt="LB_Header2_l")
If (Self->=1)
ORDER BY FORMULA([TIN_Inspections];NTI_SortByFormula (Self->);>)
COPY NAMED SELECTION([TIN_Inspections];"NTI_TunnelInspSet")

Else
ORDER BY FORMULA([TIN_Inspections];NTI_SortByFormula (Self->);<)
COPY NAMED SELECTION([TIN_Inspections];"NTI_TunnelInspSet")

End if
$0:=-1
The value of LB_Header2_l never changes so sorting does not work
Additionally no other sort works either. Any ideas?

Thanks and regards
Chuck

-- 
-
 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
  https://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: [Tip]Set Query Destination

[Charles Miller via 4D_Tech]

Also I would bet crash wa due to undefined variable and not set query
destination.

Regards

Chuck

On Fri, Jun 21, 2019 at 10:38 AM Douglas von Roeder via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Chip:
>
> When Set query limit and Set query destination came out, I ran into the
> situation where queries “stopped working” because I had forgotten to add
> the code to reset them. To avoid that, I made it a practice to type the
> “reset” code *before* I type the code to change the destination or limit
> from their normal settings.
>
> --
> Douglas von Roeder
> 949-336-2902
>
>
> On Fri, Jun 21, 2019 at 6:50 AM Chip Scheide via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > [Tl;DR] at end
> >
> > This command is your friend - and - your foe!  :)
> >
> > Yesterday I spent a significant amount of time trying to track down a
> > compiled/built app crash, but did/does not happen interpretedly.
> >
> > The crash happened only occasionally, after placing alerts and asserts,
> > I determined that the crash was happening in a utility method which was
> > doing a query. A method which, in the running code, had already been
> > called repeatedly - without - issue.
> > Since the method which was doing the query had been called repeatedly
> > -before- the crash, I was perplexed as to what the issue was.
> > After some more poking and prodding, it appeared that the crashing only
> > occurred in the utility method, after a specific method (X) was called.
> > Looking at X and watching it execute (interpretedly) provided no
> > obvious clue as what the cause was.
> > After staring at the code, and running both interpretedly and built
> > many more times it finally dawned on me what the issue was...
> > Set Query Destination
> >
> > In method X I was doing some work looking for duplicate data, and in so
> > doing I was loping over a code that looked like this:
> > Set Query Destination(Into variable;$Local)
> >  
> > Set Query destination(Into current selection)
> >  
> > Set Query Destination(Into variable;$Local)
> >
> > You might see the issue now...
> > It turns out I never returned the query destination back to Current
> > Selection.
> > To make the problem even more challenging, the utility method where the
> > query was crashing was in a component.
> >
> > Interpretedly, 4D was happy to create and type the local any time a
> > query was executed after query destination was left into a local
> > variable but... Needless to say compiled/built 4D DID NOT LIKE
> > THAT!  :)
> >
> > [TL;DR]
> > -- always -- reset your query destinations  :)
> > Chip
> > ---
> > Gas is for washing parts
> > Alcohol is for drinkin'
> > Nitromethane is for racing
> > **
> > 4D Internet Users Group (4D iNUG)
> > Archive:  http://lists.4d.com/archives.html
> > Options: https://lists.4d.com/mailman/options/4d_tech
> > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> > **
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

-- 
-
 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
  https://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: Conversion from v2003

[Charles Miller via 4D_Tech]

There is still 4D for OCI in v17. which is connection to Oracle.

I am using it on windows with great success

Regards

Chuck

On Tue, Jun 11, 2019 at 3:52 PM Luc Devar via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> I have a client that still uses an old v2003 DB.  They finally decided to 
> upgrade to a more current version.  I am doing a quick analysis to assets the 
> amount of work that needs to be done.  I can see the v2003 use old plugins 
> that does not exist anymore. Most of them I can deal with but the plugins 4D 
> for Oracle and DDE_Tools are the one that concerns me.
>
> I think M. Miyako Keisuke has developed something that duplicates the old 4D 
> for Oracle plugins. Is it a plugin or a component ? I am not sure as I am 
> starting to look into this.
>
> I am not too familiar with DDE_Tools. I am wondering if someone can point me 
> in a direction to help me have more information on that plugins and how to 
> replace it in V17. Maybe there is something similar out there now. A new 
> plugin, a component or tech note that would help me replace it and move to 
> v17.
>
> Luc Devar
> **
> 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: v15 to v17 Conversion of Obsolete _o_C_STRING/_o_ARRAY STRING Commands

[Charles Miller via 4D_Tech]

There’s code that will convert all in one fell swoop. It puts comments at
end please advise if you want it and I will forward

Regards
Chuck

On Fri, Jun 7, 2019 at 11:49 AM Narinder Chandi via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi all. I am migrating a v15 database to v17, 4D Server running on Mac. I
> need some opinions as to what to do with regards to converting commands
> marked as obsolete as per this article:
>
>
> https://doc.4d.com/4Dv15/4D/15/Deprecated-or-removed-features-in-v15-product-range.200-2063067.en.html
>
> I have been addressing them by theme, and in some cases the conversion is
> straight forward, e.g. _o_ENABLE BUTTON/_o_DISABLE BUTTON is replaced by
> OBJECT SET ENABLED whilst some others can be removed completely, e.g.
> _o_REDRAW LIST.
>
> I am now looking at how to deal with the obsolete Compiler theme commands
> _o_C_INTEGER, _o_C_STRING and _o_ARRAY STRING.
>
> _o_C_INTEGER I have simply replaced with C_LONGINT as the docs state that
> "...4D and the compiler retype Integers into Longints internally."
>
> However, I am conflicted as to how best to deal with _o_C_STRING and
> _o_ARRAY STRING which are replaced by C_TEXT and ARRAY TEXT respectively.
> The docs state "The operation of the [_o_C_STRING/_o_ARRAY STRING] command
> is strictly identical to that of the [C_TEXT/ARRAY TEXT]". Of course the
> string length parameter in the obsoleted commands makes the conversion
> non-trivial and code will need to reviewed for any functional regressions,
> e.g. in relation to database fields of type String where the length can
> still be defined (auto-truncation may not be the desired/intended
> behaviour!).
>
> I have searched the archives on this topic but opinions seem to be divided
> on whether or not to do this conversion? Perhaps I am mistaken, but I am of
> the opinion that it will have to be done sooner or later as 4D reserves the
> right to remove obsoleted commands and will eventually do so?
>
> TL;DR the options are:
> 1. Replace
> 2. Do nothing for v17
>
> Thoughts?
>
> I will deal with my questions and options regarding Subrecords in a
> separate email!
>
> Regards,
>
> Narinder Chandi,
> ToolBox Systems Ltd.
> --
>
>
> **
> 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: Open a v17 data file when Structure is unknown

[Charles Miller via 4D_Tech]

Perhaps if you can prove ownership of the data 4D can assist. I know that
even when you buy an application  you do not own the app just a license to
use but you do own the data

What happened to the structure. Is there a compiled version somewhere

Regards
Chuck

On Thu, Jun 6, 2019 at 3:20 PM Tim Nevels via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> On Jun 6, 2019, at 2:00 PM, Jörg Knebel wrote:
>
> > Has someone tried to find that “WEDD” resource in the structure and the
> data file and has manipulate it already?
> >
> > I just want to prevent me going into “crazy, ridiculous amount of work
> and effort” to get it done.
>
> The “WEDD” is a UUID. If you had a structure file you could do an “Export
> -> Structure definition to XML” and it would provide you the UUID. But
> since you don’t have a structure file you have no idea what to look for in
> the data file. Plus, I would expect 4D is not storing the raw UUID in the
> data file, it is most likely obfuscated in some way so that you can’t just
> scan for the UUID value.
>
> But the WEDD is only the first part of marrying a data file and structure
> file. Each table also has a UUID assigned to it, and that info is recorded
> in both the data file and structure file and they have to match. That is
> the purpose of the “.match” file that is created next to the data file when
> you open a database with a matching structure and data file. If a data file
> has major damage, you can still run MSC and recover some of the damage if
> you have  the ".match” file. And the .match file can only be generated by
> 4D when it opens a married data file and structure file.
>
> The “.match” file UUIDs listed do not exactly match the table UUIDs that
> you get from the "Export -> Structure definition to XML” file. There is
> again some obfuscation that hides the true values. But with the structure
> file and the .match file, MSC can make the translation/connection to be
> able to recover data from the damaged data file. So you would need to
> figure out this translation mechanism also.
>
> 4D thought through all of this with the v11 data file format. They wanted
> to make it super hard to do exactly what you are trying to do — take a data
> file that you have no structure file for and then reverse engineer out the
> structure so that you can extract the data.
>
> Good luck!
>
> 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
> **

-- 
-
 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: Open a v17 data file when Structure is unknown

[Charles Miller via 4D_Tech]

Open in server and open wil sql. You might be able to get table and field
definitions from 4Ds tables

Regards

Chuck

On Tue, Jun 4, 2019 at 6:15 PM Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> G’day All,
>
> How do you retrieve data from a v17 data file when the structure is
> unknown?
>
> I tried to open it with some kind of generic structure (lots of tables
> with 250 text-fields) each, like in the old days, but 4Dv17 "finds out"
> that there is a mismatch. :-(
>
> Thanks for all and any help.
>
> Cheers
> Jörg
> **
> 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: Log integration issue in mirror database

[Charles Miller via 4D_Tech]

Is there any way you are integrating out of order
Regards
Chuck

On Sun, May 19, 2019 at 11:28 AM Two Way Communications bvba POP via
4D_Tech <4d_tech@lists.4d.com> wrote:

> Hi Tom,
>
> 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 2019, at 17:22, Tom Benedict  wrote:
> >
> >
> >> On May 19, 2019, at 07:33, Two Way Communications via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >>
> >> 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.
> >>
> >> 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?
> >>
> >
> > I agree that the indexes may be suspect. Have you rebuilt the index
> file? (just delete the .indx file and it will auto-rebuild).
> >
> > Also, have you run MSC on the master data file? That could be
> informative.
> >
> > HTH,
> >
> > 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
> **

-- 
-
 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: How can a line of code be separated into multiple lines?

[Charles Miller via 4D_Tech]

Put \ at end of line

Regards

Chuck

On Sat, May 18, 2019 at 3:11 PM Stephen J. Orth via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Chris,
>
> Use the backslash character (\)...
>
>
> Steve
>
> *
>   Stephen J. Orth
>   The Aquila Group, Inc.  Office:  (608) 834-9213
>   P.O. Box 690   Mobile:  (608) 347-6447
>   Sun Prairie, WI 53590
>
>   E-Mail:  s.o...@the-aquila-group.com
> *
>
> -Original Message-
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Chris Belanger
> via 4D_Tech
> Sent: Saturday, May 18, 2019 2:10 PM
> To: 4D iNUG Technical <4d_tech@lists.4D.com>
> Cc: Chris Belanger 
> Subject: How can a line of code be separated into multiple lines?
>
> 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
> **
>
> **
> 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: list box issue

[Charles Miller via 4D_Tech]

This is sub form so events don’t work the way you think and why would it
work the first time in and only fails when activate happens. I have even
changed to a variable and set during on display detail

Regards
Chuck

On Tue, May 14, 2019 at 3:35 PM Chip Scheide <4d_o...@pghrepository.org>
wrote:

> On Tue, 14 May 2019 15:28:40 -0400, Charles Miller via 4D_Tech wrote:
> > If I change the column to
> > allow entry, this issue goes away
>
> Form event = on activated
>   set enterable
>   set disabled
>
> ??
> Chip
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
>
-- 
-
 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
**

list box issue

[Charles Miller via 4D_Tech]

Hi All,

we are running a v15 db with a list box as a sub form All is set to
non-enterable. All works as it should except for check boxes.

When we first bring up form check boxes appear as they should. If we
click off onto another window and then go back check box is no longer
showing the same. it is greyed out - check mark is no longer blue

Any ideas. We have tried redraw to no avail. If I change the column to
allow entry, this issue goes away, but this is something that we can
not do, as we track all changes so that they can be distributed to
other copies of data bases running as appropriate
I have tried replacing  the field with a variable to no avail


Thanks and regards

Chuck

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

for selection based list box only

[Charles Miller via 4D_Tech]

Hi all,

I know how to change row color and font color for row in a selection
based list box, but can't seem to figure out how to do so for a
particular cell

Object set color for the particular cell does mot work. This is still
a v15 database

Thanks and regards

Chuck


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

[Charles Miller via 4D_Tech]

You could write code to export methods as text into two folders one for v15
and one for v16 and then use BBEdit to compare the methods. It will
Illustrate the differences

Regards
Chuck

On Wed, May 1, 2019 at 12:34 AM Tom Benedict via 4D_Tech <
4d_tech@lists.4d.com> wrote:

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

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

[Charles Miller via 4D_Tech]

I the case of sub tables I would convert them to standalone e tables in
both subs before I tried to import
You should have done this way back but need to do this now
Regards

Chuck

On Tue, Apr 30, 2019 at 10:29 PM Ronnie Teo via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> 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  mikebeatty.li...@gmail.com>>
> > To: 4d_tech@lists.4d.com 
> > Subject: Re: Data Merge from v13 to v15
> > Message-ID: <668050ce-59e3-4274-ae49-4168ee331...@gmail.com  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
> **

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

[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: 4D 17.1 network issues

[Charles Miller via 4D_Tech]

If it shows as active, that may be part of the problem. I found many
moons ago similar issues when one of my customers had new server with
to NIC cards. It seems what happens is that client connects to 1,
inactive for period of time, goes back and tries using 2, crash just
as you are having. There used to be terminal command to combine two
NICs into one on a MAC. Have you tried restarting the machine. You
should not have a real IP on ethernet connection and self assigned on
wifi. Something is not adding up

Regards
Chuck

On Wed, Apr 24, 2019 at 12:28 PM Peter Bozek via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> On Wed, Apr 24, 2019 at 4:06 PM John DeSoi via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> > No, just Ethernet is enabled. WiFi and the other connection types are not
> > connected (red dot). But that just helped me answer the question. If I
> > disable WiFi on my laptop, the server shows a 169.254.X.X link-local
> > address. I wonder why and if that could be a source of problems.
> >
> > It shows a red dot, "not connected", but it is active according to
> > ifconfig:
> >
> > en10: flags=8863 mtu 1500
> > ether a6:e9:75:40:77:fa
> > inet6 fe80::10be:87e1:3ea2:51c7%en10 prefixlen 64 secured scopeid
> > 0x17
> > inet 169.254.132.126 netmask 0x broadcast 169.254.255.255
> > nd6 options=201
> > media: autoselect (100baseTX )
> > status: active
> >
> >
>
> 169.x.x.x seems like a self-assigned address,  could it be you have some
> problem with DHCP?
>
> --
>
> Peter Bozek
> **
> 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: last(?) 2 built app questions :)

[Charles Miller via 4D_Tech]

Yes you need to build on Windows. Why do you need 4dlink file. That is link
to server

Regards
Chuck

On Thu, Apr 18, 2019 at 5:18 PM Chip Scheide via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> 1 - saved passwords - I can not find a  .4dlink file for the built app.
> Is there one?  if so where is it stored (as it is not in the location
> where 4D places a link file for a non-built system.
>
> 2 - this is a bit aways yet, Windows... Am I correct to get a windows
> built app I need to build it on a Windows platform?
>
> Thanks
>
> ---
> 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
> **

-- 
-
 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: trying to Build double clickable app

[Charles Miller via 4D_Tech]

The license needs to be added to but;d. I should have been more specific
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. 

> On Apr 17, 2019, at 1:34 PM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> You have to install desktop as well

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

Re: Printing Structure Diagram (Somewhat O.T.).

[Charles Miller via 4D_Tech]

you need to find someone who needs a boat anchor


On Wed, Apr 17, 2019 at 12:35 PM Jack Stewart via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Your email reminds me that I have a whole lot of legacy,
> Macintosh 4D applications software and accompanying manuals
> complete with original 3-ring binders which I would like to
> sell. I used to do a lot of 4D development but have gotten away
> from it in recent years. I stopped purchasing updates in 2003.
>
> This 4D material contains the full gamut of 1990 to 2003 4D
> applications ranging from 4D itself to 4D Write, 4D Draw, 4D
> whatever :) I own it.
>
> I would like to sell it all if there is a market for it. Some
> applications remain unopened and everything is in excellent
> condition. The manuals alone contain a wealth of relational
> database theory and I have lots of 3rd party 4D books as well.
>
> Just wondering if anyone can advise me if there is any demand
> for this material. I would like to see it go to a good use.
>
> Thanks,
>
> Jack
>
>
> On 3/30/19, rooftop99--- via 4D_Tech said ……
>
> >Hi All,
> >
> >We are in the midst of analyzing a very old 4D application.
> >We’d like to print/plot/PDF a structure diagram, in all
> >it’s glory, to hang on the wall.  It must represent all
> >structure elements such as Tables, Fields, Relations, Indexes,
> >etc….  I have seen these diagrams for other platforms but I
> >haven’t been successful in extracting such from 4D.
> >Way back in the day I could print a tiled version of the
> >structure from the Structure editor window but that print menu
> >seems to be disabled (at least for me) in current versions of
> >4D.  Ideally I would like to export the database as xml or
> >JASON and load it into another charting specific application to
> >manipulate and print.  I just need to find the proper
> >application (or 4D component/methods) that can consume the
> >xml/JASON and provide the needed diagrams.
> >
> >An example of what I am hoping for can be found in the top
> >image of Vanessa Talbot’s 4D blog entry titled, “Detailed
> >Analysis of Your Database Structure”  Here is the link if it
> >is allowed on the Nug:
> >"https://blog.4d.com/detailed-analysis-database-structure/“
> >Something, clean, clear, and readable.
> >
> >FYI: We are on 4D v16R5 at the moment.  Moving to v17 soon.
> >
> >Any help is appreciated!
> >
> >Thank you!!
> >Kirk
> >**
> >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
> **



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

world tour

[Charles Miller via 4D_Tech]

If you still have a chance run do not walk. Great content on both days.

Chuck

-- 
-
 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: Count in Text

[Charles Miller via 4D_Tech]

That will not work, as you would also change then, therefore etc. I
did not think it 100% through, but putting in an array would solve the
problem as you could see if position = search word and only increment
when iot did. You would also have to decide is The = the etc

Regards
Chuck

On Tue, Apr 9, 2019 at 4:29 PM Keith Culotta via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> ...and this.  It's probably slower than using Position, but I'd have to test 
> to be sure.  (3 Lengths and 1 Replace string)
>
> C_LONGINT($count;$len1;$len2;$lenFind)
>
> $string:="This message and any attached documents contain information which 
> maybe confidential, subject to privilege or exempt from disclosure 
> underapplicable law.  These materials are intended only for the use of 
> theintended recipient. If you are not the intended recipient of 
> thistransmission, you are hereby notified that any distribution,disclosure, 
> printing, copying, storage, modification or the taking ofany action in 
> reliance upon this transmission is strictly prohibited.Delivery of this 
> message to any person other than the intendedrecipient shall not compromise 
> or waive such confidentiality,privilege or exemption from disclosure as to 
> this communication.tf"
>
> $len1:=Length($string)
> $find:="the"
> $lenFind:=Length($find)
> $string2:=Replace string($string;$find;"";*)  // optional *
> $len2:=Length($string2)
>
> $count:=$len1-$len2/$lenFind
>
> ALERT(String($count))
>
> Keith - CDI
>
> > On Apr 9, 2019, at 3:05 PM, Charles Miller via 4D_Tech 
> > <4d_tech@lists.4d.com> wrote:
> >
> > Not sure what you are really asking for. I think you have to roll your
> > own in any case if you have text as follows:
> >
> > $string:="this is a test of the find in string. in case you missed the 
> > point."
> >
> > To find "the"
> > There are multiple ways, one is to parse the text into arrays based up
> > words and find in array. There seems to be a new command in 17 r
> > release that will do the parse for you
> >
> > The second way is to do a position inside a repeat loop
> > c_Longint($pos_l;$start_l;$Count_L)
> > $start_l:=0
> > $Count_L:=0
> > repeat
> > $pos_l:=position("the";$string;$start_L)
> > if($pos_l>0)
> > $Count_L:=$Count_L+1
> > $strart_L:=$pos_L+1
> > end if
> > until($Pos_L<1)
> >
> > You should be able to change the code to use find in array. I might
> > sort the array first
> > Hope this helps
> >
> > Regards
> > Chuck
> > On Tue, Apr 9, 2019 at 3:39 PM Peter Mew via 4D_Tech
> > <4d_tech@lists.4d.com> wrote:
> >>
> >> Hi
> >> Is there a 4D command that will count the number of occurences of
> >> character, in string
> >> thanks
> >> -pm
> >> **
> >> 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:/

relation names

[Charles Miller via 4D_Tech]

Hi All,

On page 192 of the desgn reference. It states

Relations created via SQL

The appearance of relations is different when they have been generated
via SQL (square shaped connectors):

OK I see that but see no way of creating the relations. Can anyone advise

If I can not do this I want to add a feature request to re-enable this
feature and to allow us to rename the relations themselves

Thanks and regards


Chuck

-- 
-
 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: Count in Text

[Charles Miller via 4D_Tech]

Not sure what you are really asking for. I think you have to roll your
own in any case if you have text as follows:

$string:="this is a test of the find in string. in case you missed the point."

To find "the"
There are multiple ways, one is to parse the text into arrays based up
words and find in array. There seems to be a new command in 17 r
release that will do the parse for you

The second way is to do a position inside a repeat loop
c_Longint($pos_l;$start_l;$Count_L)
$start_l:=0
$Count_L:=0
repeat
$pos_l:=position("the";$string;$start_L)
if($pos_l>0)
$Count_L:=$Count_L+1
$strart_L:=$pos_L+1
end if
until($Pos_L<1)

You should be able to change the code to use find in array. I might
sort the array first
Hope this helps

Regards
Chuck
On Tue, Apr 9, 2019 at 3:39 PM Peter Mew via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Hi
> Is there a 4D command that will count the number of occurences of
> character, in string
> thanks
> -pm
> **
> 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
**

ORDA and 4D selections

[Charles Miller via 4D_Tech]

Hi all,

is there any way to perform a query using ORDA and create a current
selection or set from the result.

Thanks and regards

Chuck



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

[Charles Miller via 4D_Tech]

I think the problems with odd creator o. Windows had to do with 4D as when
I went to 17.1 it started working again.
When using earlier 4D releases no pdf was created own windows at all

Hope this helps


Regards

  Chuck

On Tue, Apr 2, 2019 at 9:09 PM Keith Goebel via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Koen, thanks for your reply.
> While it is comforting to know I’m not the only one in the 4D world having
> this problem, it is amazing that we are the only two :-)
> I guess we’ll have to look at the pdf plugins available for 4D v17.
>
> 4D PDF Printer Plugin ?
> I’m under the impression that the only 4D PDF plugin that can be “dropped”
> into an existing db and will allow you to set it as the “current” printer
> when printing a 4D report is 4D PDF Printer Plugin from eNode.
> If anyone knows that I have got that wrong, please speak up…
>
> Just FYI, and for the archives...
> We were using PDFCreator but started encountering problems when using it
> on Win10 and upwards computers - that was what made us switch to Microsoft
> Print to PDF.
>
> A Google search shows that others (using other applications) have also run
> up against this occasional “bad” pdf file generation with Microsoft Print
> to PDF. I saw no solutions offered.
> Cheers, Keith
>
>
> > On 2/04/2019, at 8:40 pm, Koen Van Hooreweghe 
> wrote:
> > …
> > Just to confirm I've seen issues with PDF's generated from 4D v17R3
> using MS PDF driver. This is happening on my Citrix account at a customers
> site. Acrobat Reader says the document contains an error and cannot be
> displayed correctly...
> >
> >> Op 1 apr. 2019, om 05:10 heeft Keith Goebel via 4D_Tech <
> 4d_tech@lists.4d.com > het volgende
> geschreven:
> >>
> >> Has anyone else encountered this problem and, if so, have you managed
> to determine what is causing the “bad” pdfs?
>
> **
> 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: v13 - Auto UUID

[Charles Miller via 4D_Tech]

What version. And is field Indexed. Is it primary key

On Tue, Mar 26, 2019 at 5:23 PM Chip Scheide via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> New database
> table has 2 fields set to auto UUID - unique
> trying to create a new record gives an error which turns out to be
> related to the UUID fields.
> If I assign (Generate UUID) in the trigger a new record is saved, if
> not a new record is rejected.
>
> Ideas??
>
> Chip
>
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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