Re: Copy and Paste

[Chuck Miller via 4D_Tech]

Ferdinando,

Sorry I don’t know answer, but you should switch to the discuss.4d.com group. 
Almost every one is there these day

I am getting ready to unsubscribe from these lists as I bet others have already 
done

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 Mar 23, 2021, at 12:56 PM, stardata.info via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi All,
> 
> Form some days in my method editor of 4D V16 on Windows, sometimes the 
> commands Copy and Paste not work.
> 
> For solve i need to restart windows
> 
> Someone know the solution?
> 
> 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
**

Re: Designer Password Question

[Chuck Miller via 4D_Tech]

The problem with that approach is many fold. First if something happens to 
users and groups and admin becomes bad you will be stuck. If you are going to 
follow that path, I would create another use by duplicating administrator and 
use that one

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 Jan 18, 2021, at 1:28 PM, Douglas von Roeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Ken:
> 
> Chuck pointed out that you didn't have access as designer (I just
> skimmed the email yesterday), rather you have access "to the design
> environment".
> 
> The empty U file is worth a try but as Thomas implies, perhaps there's no
> significant downside to leaving the current situation as is. I've been
> working on an application for almost 20 years for a programmer client and I
> don't log in as "designer". Until now, I've never even looked at U and
> I've discovered that I have zero access there. I do have full access to the
> code and forms and can even convert it to a project (I cancelled *that*
> operation) so, if you've got that level of access, perhaps "do nothing" is
> appropriate.

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

[Chuck Miller via 4D_Tech]

I don’t think so. I think the only person who can change designer password is 
designer. 

The only option would be to recreate structured and then move forms and methods 
over 

Regards 

Chuck

Sent from my iPhone

> On Jan 17, 2021, at 7:24 PM, Kenneth Geiger via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi All,
> 
> I recently “inherited” a 4D v12 (Windows) database. 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. My 
> question is…is there a way to reset the Designer Password? Or, is there a way 
> to delete ALL the passwords and start over?
> 
> Regards,
> 
> Ken Geiger
> SW Colorado
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: PING of life...

[Chuck Miller via 4D_Tech]

OK I think we should start by going all the way back. I can be reached at 
,7 my old compuserv account. Boy wish I remembered it for real, or 
perhaps when list was run outside of 4D by Karen (sorry don’t remember her last 
name)

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)
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: PING of life...

[Chuck Miller via 4D_Tech]

Just remember, we were all smart ass newbies at some point. 

Sill here but mostly on discuss

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 Jan 13, 2021, at 11:00 AM, Robert McKeever via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Yep
> 
>> On Jan 13, 2021, at 4:32 AM, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> G’day,
>> 
>> Are here still enough dinosaur/old timers present to have some decent 
>> discussions without that white noise and smart-arse newbies in the forum?
>> 
>> I’m following the lead of my neighbour David Adams and don’t participate in 
>> the forum any more.
>> 
>> Question is, are there other oldies willing to participate WITHOUT feeding 
>> anything into the forum(s) following the slogan “What happen in/on iNUG 
>> stays in/on iNUG”?
>> 
>> 
>> 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
>> **
> 
> _
> Bob McKeever  http://www.mswl.com 
> McKeever's Software Wizardry
> Port Coquitlam, B.C.
> bobmckee...@mac.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
> **

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

Re: Remember password

[Chuck Miller via 4D_Tech]

One more thing, there may a file with .mdp extension, you will need to delete 
that as well

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 Dec 23, 2020, at 7:42 AM, Miguel Gonzalez via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Thank you very much all for your help.
> I'll check Keysuke and Chuck's answers and I'll let you know what happened.

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

Re: Remember password

[Chuck Miller via 4D_Tech]

I have used code below

C_TEXT($Struct_T)

ARRAY TEXT($Parts_atxt;0)
ut_TextToArray (Structure file;->$Parts_atxt;Folder separator)//this method 
will place each part of path into array element to get structure name. You can 
do this any way you want
$Struct_T:=$Parts_atxt{Size of array($Parts_atxt)}
$Struct_T:=Substring($Struct_T;1;Position(".";$Struct_T)-1)


C_TEXT($PathToEngineLink_txt;$Attribute_txt;$xml_txt;$elemref_txt)


C_TEXT($FilePath_T)

Case of 
: (Application type=4D Remote mode)

$FilePath_T:=Get 4D folder(Active 4D Folder)+"Favorites 
v15"+Folder separator+"Remote"+Folder separator+$Struct_T+".mdp"
If (Test path name($FilePath_T)=Is a document)
DELETE DOCUMENT($FilePath_T)
End if 
: (Application type=4D Local mode)

$FilePath_T:=Get 4D folder(Active 4D Folder)+"Favorites 
v15"+Folder separator+"Local"+Folder separator+$Struct_T+".mdp"
$PathToEngineLink_txt:=Get 4D folder(Active 4D 
Folder)+"Favorites v15"+Folder separator+"Local"+Folder 
separator+$Struct_T+".4dlink"
If (Test path name($FilePath_T)=Is a document)
DELETE DOCUMENT($FilePath_T)
End if 
If (Test path name($PathToEngineLink_txt)=Is a document)
$xml_txt:=DOM Parse XML source($PathToEngineLink_txt)
$elemref_txt:=DOM Find XML 
element($xml_txt;"database_shortcut")
DOM SET XML ATTRIBUTE($elemref_txt;"md5_password";"")
DOM SET XML ATTRIBUTE($elemref_txt;"user_name";"")
DOM REMOVE XML ATTRIBUTE($elemref_txt;"md5_password")
DOM REMOVE XML ATTRIBUTE($elemref_txt;"user_name")
DOM EXPORT TO FILE($xml_txt;$PathToEngineLink_txt)


End if 

End case 


 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 Dec 22, 2020, at 8:29 AM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi
> 
> there is a checkbox in database settings / security
> 
> Users can change their password
> Display User List in Password Dialog Box

**
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: Attempt to read beyond end of stream

[Chuck Miller via 4D_Tech]

Like Chip stetted, almost all are on discuss forum now. I don’t think support 
will help on a v15 db as they no longer support it.

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 Dec 3, 2020, at 5:42 AM, Tarawerkz via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 
> I would like seek advice on an issue I encountered with a v15 structure file 
> which has been in use for a long time.
> 
> Recently, when I logged in with the designer password to make some amendments 
> to the code, I encounter a memory allocation error on a resource blob.
> So I did a structure repair and compact using MSC utility.
> 
> After the repair, the original error is resolved but a new error appeared in 
> its place,  
> This time it is an attempt to read beyond end of stream (error code 200).
> Subsequent repairs of the structure file does not remove the error.
> 
> The issue is data independent as it also appears with an empty data file.
> If I were to log in as a normal user (not the designer account), the error is 
> not encountered.
> 
> May I ask how I can recover the structure in this instance?
> 
> Regards,
> Ronnie
> Tarawerkz
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: PDF Creation

[Chuck Miller via 4D_Tech]

It is in manuals. but set print option. It also depends upon if on MAX or PC 
and what version of 4D.
You should join discuss.4d.com   Almost all discussion 
ks now there

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 Oct 8, 2020, at 11:04 AM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 
> I need to generate a PDF document from 4D application.
> 
> Someone know how i can do?
> 
> 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
**

Re: "Optimal" 4D Server hardware

[Chuck Miller via 4D_Tech]

yes SSD for data. It so much faster and more reliable

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 12, 2020, at 8:48 AM, Mike Kerner via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I just ordered a new server, Win, because we are using ODBC.  I ordered it
> like the gaming setups - SSD for the OS and mechanical for data.  I hadn't
> thought about adding a third drive for the backups and journal.  Any other
> thoughts/tips?

**
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: Can't Disable Catalina Prompt "Do you want the Applicaiton "ApplicationName" to accept incoming network connections?

[Chuck Miller via 4D_Tech]

Correct but cost is 99 per year

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 Aug 22, 2020, at 1:39 AM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> developer certificates work similar to HTTPS certificates.
> 
> you can obtain a certificate that has Apple has its root authority.
> you can also sign an app with a self-signed certificate and let the user add 
> you to their local keychain.
> 
> 2020/08/22 14:22、Chip Scheide via 4D_Tech <4d_tech@lists.4d.com 
>  >>のメール:
> if I recall correctly you can not sign/noterize an application without paying 
> apple $.

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

Re: ON MOUSE ENTER

[Chuck Miller via 4D_Tech]

What is the arrow number. Do you mean row number? you would not use on mouse 
enter. Until you select a row, you wil get nothing.

Additionally, this list is not used but almost anyone anymore. 
https://discuss.4d.com/  is were you should go

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 Aug 12, 2020, at 11:32 AM, stardata.info via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi All,
> 
> I need to know the arrow number of a list box, when the event " On Mouse 
> Enter " enter in one row.
> 
> Now i use the command OBJECT Get pointer but he not work.
> 
> Someone know how i can do?
> 
> 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
**

Re: Auto numbering method acting weirdly. Help needed

[Chuck Miller via 4D_Tech]

I don’t see anything that jumps out at me, but. How about tracing to see what 
is happening?

Also if this is a multi user db. There could be failures

You could also do this
c_longint($FolderNo_L)
c_text($Prefix)
$Prefix:=[Repertoire]Folder prefix
Begin sql
select MAX([Repertoire].[Folder number]).
primary key of that table
from
[Repertoire]
where
[Repertoire].[Folder prefix] = :$Prefix
into
:$FolderNo_L,
:$Key
end sql
if ($Key = key of my record)
else

end if

Hope this helps

 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 Jul 22, 2020, at 4:28 PM, Stephane Potvin via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Good day all,
> 
> I have a database for organizing my printed music collection.
> 
> I use a folder numbering system to do so, using this format: Letter-number
> i.e. A-25, A-26, B-17, B-18, etc.
> 
> I have one field for the letter and one field for the number.
> 
> To make it easy, I use the method below to automatically fill the number when 
> I enter a letter.
> If I enter the letter A, the number will automatically fill the number with 
> 27 if the last one in existence was 26 for the letter A.
> It behaves fine for single letters and combinations: AB, ED, etc.
> 
> Everything works perfectly well except when I enter the letters CH.
> When I do the number field gets the value 207119, and up, whereas it should 
> currently be CH-271
> 
> I need your help figuring our why it behaves this way only for those letters.
> 
> Thank you in advance for your help.

**
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: Multiple instances of 4D Server v17

[Chuck Miller via 4D_Tech]

Nope it is correct. I think it was always supposed to work that way when using 
single server license 
Regards 

Chuck

Sent from my iPhone

> On Jul 22, 2020, at 10:20 AM, jarosz via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Does anyone have experience of this type of situation?
> 
> I have 3 copies of 4D Server v17 running on a Mac serving say database1,
> database2 & database3. I have a 2 user license for 4D server so can connect
> client1 to database1 and client2 to database1.
> 
> When I try to connect client1 to database2 I get the message "The maximum
> number of concurrent users for your license has been reached.” even though
> database2 has no clients already connected.
> 
> With older versions of 4D Server you could connect 2 users to each instance
> of 4D Server, no matter how many instances were active.
> 
> Under v17 it seems the number of users allowed is counted across all
> instances of 4D Server running on that Mac server.
> 
> Am I reading this correctly, or have I configured something wrongly?
> 
> Has the user licensing scheme tightened up significantly with newer versions
> like v17?
> 
> Any insights would be greatly appreciated.
> 
> Michael Jarosz
> 
> 
> 
> 
> --
> 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
> **

**
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: execute method

[Chuck Miller via 4D_Tech]

Hi Fedinado. yes it should work, but why not just try it and see for yourself. 
It would have taken about 30 seconds to do that

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 Jul 16, 2020, at 2:34 PM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi all,
> 
> Some one have experience with execute method command?
> 
> I've need to insert some rows of 4D commands in one text field of a table, 
> and after to execture this rows of code as a method.
> 
> Can i create programmatically method and after execute this method using 
> EXECUTE METHOD?
> 
> EXECUTE FORMULA have a limitated feature.
> 
> Thanks for your help
> 
> 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
**

Re: More values into one field

[Chuck Miller via 4D_Tech]

An array works but I would use a blob field if in an older version of 4D as 
object type are not available via SQL

You could also use json

 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 Jul 11, 2020, at 8:22 AM, Ken Geiger Gmail via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi Fernando,
> 
> Save the test values to an array and drop the array into an Object field. 
> 
> Regards,
> 
> Ken

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

Re: How to build a standalone app for Windows using Mac

[Chuck Miller via 4D_Tech]

Needs to be done on windows. And it has to be licensed

Regards 

Chuck

Sent from my iPhone

> On Jun 28, 2020, at 6:57 PM, James Knight via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi
> 
> 
> 
> It’s a long time since I compiled & built an application for Windows.
> 
> 
> 
> I’m on 17.4 for Mac, and I can compile & build an application for Mac no 
> problem.
> 
> 
> 
> What hoops do I need to jump through to build a standalone application which 
> will run on Windows? Can I do that on a Mac or do I need to download the 
> developer edition for Windows and build it on a Windows box?
> 
> 
> 
> Thanks!
> 
> 
> 
> James
> 
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: IP address problem

[Chuck Miller via 4D_Tech]

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 
>> <mailto: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 hand out the manual IP 
>> address to another device - creating a conflict.
>> 
>> 
> Just a note. DHCP with manual address must used a fixed up S far as I know or 
> you will get conflicts with other machines 
>> Hope this helps
>> 
>> Chip
>> 
>> 
>>> Hi All,
>>> 
>>> We have a built Client server v 16.x ru

Re: IP address problem

[Chuck Miller via 4D_Tech]

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 hand out the manual IP 
> address to another device - creating a conflict.
> 
> 
Just a note. DHCP with manual address must used a fixed up S far as I know or 
you will get conflicts with other machines 
> Hope this helps
> 
> Chip
> 
> 
>> Hi All,
>> 
>> We have a built Client server v 16.x running on a MAC
>> 
>> Network set up is
>> DHCP with manual address
>> 
>> This has been working till about 6n months ago.
>> 
>> The hospital seems to test power outages on  fairly regular basis. 
>> When they do change over to emergency power
>> 
>> The network pane in system preferences loses all except the IP 
>> address and her we go
>> 
>> The 4D server running starts listening on a different IP address. Has 
>> anyone ever seen this before. Tech support is telling me to switch to 
>> manual address.
>> 
>> I have run and used this setup at many other customers
>> 
>> 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)
>> 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
>> **
> 
> Hell is other people 

IP address problem

[Chuck Miller via 4D_Tech]

Hi All,

We have a built Client server v 16.x running on a MAC

Network set up is
DHCP with manual address

This has been working till about 6n months ago.

The hospital seems to test power outages on  fairly regular basis. When they do 
change over to emergency power

The network pane in system preferences loses all except the IP address and her 
we go

The 4D server running starts listening on a different IP address. Has anyone 
ever seen this before. Tech support is telling me to switch to manual address.

I have run and used this setup at many other customers

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

IMAP delete old emails

[Chuck Miller via 4D_Tech]

Hi all,

I know using IMAP that one can mark an emails delete flag. Has anyone actually 
done the actual delete portion of this action. I have an email account that is 
never accessed by a person, but only through 4D. We need to make sure old 
emails are deleted so we do not go over the quota set by the administrator




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

PDF to Jpeg

[Chuck Miller via 4D_Tech]

Hi all has any one written code that wil convert amulti page  pdf to 1 jpeg 

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)
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: Capturing Full Path Names with Picture Imports

[Chuck Miller via 4D_Tech]

Yes that is true, Another way would be to select file you can even do multiple 
files at a time this way and the array returned form the command contains the 
full path to the documents selected. You can even decide what type of files are 
acceptable

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 May 27, 2020, at 2:42 AM, Bernd Fröhlich via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Steven:
> 
>> I am trying to develop a small module to allow users to import images from 
>> anywhere on the host computer, for now.  Using "READ PICTURE FILE","CREATE 
>> THUMBNAIL” and "Get picture file name” I can accomplish most of what I want 
>> to do.  But I am stuck on how to capture the long path to the picture 
>> selected by the user in the selection dialog presented by "READ PICTURE 
>> FILE”.
> 
> Hi Steven,
> 
>  >
> 
> "If the command is executed successfully, the system variable Document 
> contains the full pathname to the open file"

**
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: Select Folder Dialog won't go away

[Chuck Miller via 4D_Tech]

What version of 4D and on Mac or windows

I have not seen this behavior

Stay safe and well
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 May 26, 2020, at 11:55 AM, Doug Hall via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> When executing this code from a remote connection, my "Select folder"
> dialog won't close.
> 
> $saveFolder:=*Select folder*("Select destination folder";Documents folder)
> 
> *DELAY PROCESS*(*Current process*;5)
> 
> 
> I put in the delay process in case the dialog wasn't being processed
> synchronously. The code works fine when running it on my local database,
> but the dialog hangs around until I quit 4D, when on a remote connection.
> 
> 
> Ideas? Anyone else seen this?
> 
> 
> Doug

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

[Chuck Miller via 4D_Tech]

It would seem to me your lop structure is flawed.

It should be
FTP Login
FTP_GetDirList
repeat
//select which file from list
ftp_getFileInfo
ftp_receive
ftp_delete
until
frp_loguot


 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 May 26, 2020, at 9:02 AM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 
> I use PFT commands for manage files on ftp area.
> 
> I use these commands into the cicle
> 
> REPEAT
> 
> FTP_Login
> FTP_GetDirList
> FTP_GetFileInfo
> FTP_Receive
> 
> FTP_DELETE
> 
> UNTIL
> 
> The first time that i try to delete the file using FTP_DELETE i have error 
> 10004 at the second cicle the commend have success.
> 
> Someone have suggestion?
> 
> 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
> **

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

Re: question about PROCESS 4D TAGS 4d v13

[Chuck Miller via 4D_Tech]

Is check array

Sent from my iPhone

> On May 21, 2020, at 6:47 PM, ernie hilgers via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> Mac 10.13, 4D v13
> 
> Working with PROCESS 4D TAGS and testing it baffles me because, 
> I created a 'template' html document, that gets opened by 4D 
> which contains this code:
> 
>  
>
>
>
> 
> 
> In a 4D method that runs this aTxtHeaders array is filled with 7 text strings.
> 
> The template get's opened:
> 
> $path_t:=Get 4D folder(Current Resources folder)+"monthly.html"
> DOCUMENT TO BLOB($path_t;$template_x)
> 
> PROCESS 4D TAGS($template_x;$processed_x)
> 
> $path_t:=Get 4D folder(Database Folder)+"attachmentz"+Folder 
> separator+"Rob_321.html"
> BLOB TO DOCUMENT($path_t;$processed_x)
> 
> standard code to be found in the manual.
> 
> When I open the Rob_321.html file with BBEditI see this result, which is 
> correct
> 
>  bordercolor="#f0f0f0" width="100%">
> 
>   Description
>   
>   Hours
>   Income
>   Misc
>   Year Totals
>   
> 
>  
> 
> So I copy that exact -same- code over to another 4D project, using the -same- 
> array and same open file code.
> Then when I open this Rob_321.html  using BBEdit I see this: 
> 
>  bordercolor="#f0f0f0" width="100%">
> 
> 
>
>
> 
> 
>
>
> 
> 
> What am I missing ? or doing wrong ?   
> Both programs written by me are opened with the same version of 4D v13
> Also opened the test-code and the final-code simultaneous with 2 4D v13 
> programs and compared Preference settings. 
> 
> 
> ernie hilgers (aruba)
> 
> **
> 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
**

Viewing PDF documents on windows

[Chuck Miller via 4D_Tech]

Hi All,

environment 4D v15.6

I have a form that displays pdf document in a web area on windows. This part 
works as it should. What is weird is the file once displayed is locked. Is 
there any trick to get it to display in read only so I can not delete the file.

The following is the code:

C_TEXT($Deleted_txt)
$Deleted_txt:="File named 
"+RatingRPTBDEPTFolder_txt+MatchedDocuments_atxt{MatchedDocuments_atxt}+" will 
be deleted"
C_TEXT($file_txt)

Case of 
: (Folder separator=":")
WA SET PAGE 
CONTENT(*;"ExistingRatingReport_MAC";""+$Deleted_txt+"";"file:///")
Else 
WA SET PAGE 
CONTENT(*;"ExistingRatingReport_WIN";""+$Deleted_txt+"";"file:///")
End case 
DELETE 
DOCUMENT(RatingRPTBDEPTFolder_txt+MatchedDocuments_atxt{MatchedDocuments_atxt})

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)
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: Compiled Client server application updates.

[Chuck Miller via 4D_Tech]

I think I have upgraded automatically from 16 to 17 so I would bet it works 
form 17 to 18

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 May 13, 2020, at 10:10 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> This definitely works for versions within a main version number (ie,
> anything in v18). I haven't tried it for major version number updates (eg
> v17 to v18).
> 
> Pat
> 
> On Wed, 13 May 2020 at 14:39, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com 
> >

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

Re: Multple windows within the same process

[Chuck Miller via 4D_Tech]

workers


 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, 2020, at 7:17 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Maybe it was in a dream ... but I'm sure I recall reading something about a
> new feature (v17) that allows more than one window to be open within a
> process. But now I can't find that info. Did I imagine it?
> Pat

**
4D Internet Users Group (4D iNUG)
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

[Chuck Miller via 4D_Tech]

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 
 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 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
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D v6 client for windows

[Chuck Miller via 4D_Tech]

I still have all of the old partner CD’s DVDs but can not open any of them on 
my current mac or PC. I would guess you will have to contact 4d support. 
Perhaps they can assist

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 21, 2020, at 11:41 PM, JK200sx via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Can someone please help me with a 4D client for windows for 4D version 6.
> Actually the server is V6.0.6
> 
> 
> 
> Thank you.
> 
> 
> 
> John K

**
4D Internet Users Group (4D iNUG)
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: reporting table relations

[Chuck Miller via 4D_Tech]

Never mind.

I figured it out

If any interested, here is the code

C_TEXT($Rep_txt)
C_LONGINT($Table_l;$Field_L;$OneField_L;$OneTable_L)
For ($Table_l;1;Get last table number)
If (Is table number valid($Table_l))
For ($Field_L;1;Get last field number($Table_l))

If (Is field number valid($Table_l;$Field_L))

GET RELATION 
PROPERTIES($Table_l;$Field_L;$OneTable_L;$OneField_L)
If ($OneTable_L>0)

$Rep_txt:=$Rep_txt+Table 
name($OneTable_L)+","+Table name($Table_l)+Char(Carriage return)+Char(Line feed)

End if 

End if 
End for 
End if 




End for 
c_time($Doc_tm)
$Doc_tm:=Create document("")

SEND PACKET($Doc_tm;$Rep_txt)
CLOSE DOCUMENT($Doc_tm)

 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, 2020, at 3:03 PM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 4D v 17.4
> 
> has anyone written code to report on all table relations in a structure. I am 
> looking at doing this but can not see the command I would use. I am sure I 
> simply can not see the forest for the trees
> 
> Thanks and 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
**

reporting table relations

[Chuck Miller via 4D_Tech]

Hi All,
4D v 17.4

has anyone written code to report on all table relations in a structure. I am 
looking at doing this but can not see the command I would use. I am sure I 
simply can not see the forest for the trees

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

Re: Longitude Index: B-Tree or Cluster

[Chuck Miller via 4D_Tech]

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


 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 14, 2020, at 3:24 PM, John J Foster via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Arnaud,
> 
> Hmmm...
> 
> I think I would like the data to be obvious to my eyes when I look at it.
> 
> My initial goal was simply to be able to match up a location with a missing 
> Olson Timezone ID. Import the data, fix the data in the much larger db, and 
> then export it back out to reimport into it’s source db. The imported data 
> will always be a much smaller subset (at this time).
> 
> Then I realized that having the ability to do a radial search would be nice.  
> Show me all cities within 4 minutes from this longitude/latitude. So being 
> able to search quickly is important.
> 
> So all of this work is for those two needs.
> 
> Anyway, appreciate,
> John…
> 
> 
>>> Le 13 avr. 2020 à 23:51, John J Foster via 4D_Tech <4d_tech@lists.4d.com 
>>> > a écrit :
>>> 
>>> Hey Bernard,
>>> 
>>> I would use text values if I didn’t think I needed to do range searches. 
>>> It’s not a “live” db so I can play and experiment to my hearts content.
>> 
>> Considering 5 million pairs of long/lat values is a lot, I'd first try to 
>> see if I can store values in a different field type than a real. Examples:
>> - integer or longint : multiply by 10^x and remove decimals; depends on the 
>> number of digits you need to keep (example, Lat,Long=48.862725,2.28759 
>> becomes 48862725,2287590)
>> - uuid: no limit about the encoded number, but I don't know if performances 
>> are better than real
>> 
>> -- 
>> Arnaud de Montard 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> 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: one server window on client

[Chuck Miller via 4D_Tech]

I did not, but this happens with multiple connection types and points, but will 
try and advise but not today

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 14, 2020, at 4:25 PM, lists via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Did you try clearing the local resources and start over?, we have had 
> unexplained issues on specific machines that went away when we started fresh.
> 
> Lahav

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

one server window on client

[Chuck Miller via 4D_Tech]

Hi All,

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

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

Re: Longitude Index: B-Tree or Cluster

[Chuck Miller via 4D_Tech]

You could use a hash and store it. I have a sequence that is too long to query 
and that is what I did works like a charm.

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 14, 2020, at 5:48 AM, Arnaud de Montard via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Considering 5 million pairs of long/lat values is a lot, I'd first try to see 
> if I can store values in a different field type than a real. Examples:
> - integer or longint : multiply by 10^x and remove decimals; depends on the 
> number of digits you need to keep (example, Lat,Long=48.862725,2.28759 
> becomes 48862725,2287590)
> - uuid: no limit about the encoded number, but I don't know if performances 
> are better than real

**
4D Internet Users Group (4D iNUG)
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

[Chuck Miller via 4D_Tech]

I think it will only work for designer or administrator accounts
Not sure if you are running with no passwords
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 10, 2020, at 4:18 PM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Tim,
> 
> The OPEN ADMINISTRATION WINDOW command can be called by any client to view 
> the Server UI. I believe you can even launch client on the server machine 
> where the service is running. (You do have have Designer or Administrator 
> access though.)

**
4D Internet Users Group (4D iNUG)
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

[Chuck Miller via 4D_Tech]

Cluster is meant when there are many duplicates. To do queries I would make a 
duplicate field and use a string conversion or a long code version. and not a 
real. Reals in my opinion are the slowest when it comes to queries. Or 
manipulation 

Sent from my iPhone

> On Apr 12, 2020, at 6:57 PM, Bernard Escaich via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> John,
> 
> You have geodesic functions in Math4D, component available here : 
> https://forums.4d.com/Post/EN/31847250/1/31847251#31847251
> 
> HTH
> Cordialement,
> 
> Bernard Escaich
> 
> 
> 
>> Le 10 avr. 2020 à 02:03, John J Foster via 4D_Tech <4d_tech@lists.4d.com> a 
>> écrit :
>> 
>> Hi All,
>> 
>> I have a GEO database of almost 5 million cities. They include various data 
>> and latitude and longitude.
>> 
>> I need to use the Longitude file in searches. To speed it up I need to 
>> index. Many of the values are similar like 141.235 or 141 3.23 and so on. So 
>> for those who might know would a Cluster index be better suited or a B-Tree?
>> 
>> Thanks,
>> John…
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Can't Access Design Mode in 6.0.6

[Chuck Miller via 4D_Tech]

Can you upgrade to a newer version, Let’s say 11 and see what happens

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 7, 2020, at 12:13 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?

**
4D Internet Users Group (4D iNUG)
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: Image Export Issues

[Chuck Miller via 4D_Tech]

Remember why was stated. Launch a process. Do something like this
$CurrentNumber_L:=start
repeat

Launch new process($CurrentNumber_L)
wait til  new process completes
$CurrentNumber_L:=$CurrentNumber_L+50



until (end)

The new process will export 50 pictures_

This method probably will clear memory issues when new process ends

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 2, 2020, at 11:54 AM, Robert McKeever via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> So, I modified the code to use WRITE PICTURE FILE. Nice. Runs much faster. It 
> did quit late last night. And again this morning when I was also reading 
> email, this time with a system crash message - unable to grow buffer.
> 
> Once I finish with email, and the web, I’ll restart the machine and restart 
> the export from where it left off. It is having its problems when it goes to 
> export a series of 40Mb retinal scans.

**
4D Internet Users Group (4D iNUG)
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: Image Export Issues

[Chuck Miller via 4D_Tech]

Do you have vmware or parallels. If not both are reasonably priced. If so you 
can create a leopard server to 10.12 version to run inside I am having no 
problems using 15 in this manner

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 1, 2020, at 11:22 AM, Robert McKeever via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I have a Mini with 10.11.6, and my ancient 17” MacBook Pro at 10.6.8 (the 
> only machine left that will run 4D V11). Bit of a pain to get the drive setup 
> on the Mini - I have to find a Thunderbolt 2 cable (I have the adaptor for it 
> for Thunderbolt 3). 
> 
> Yes, all documents are created as part of the code. Each picture is in a 
> picture field within the database, and that record also carries the picture 
> type - either JPEG or BMP.
> 
> I think it is memory allocation/recovery as well - 4D needs some time to do 
> its stuff. The IDLE command, which I have used to good effect on compiled, 
> server side processes, but since it is stand-alone, interpreted, it is not 
> applicable. maybe DELAY PROCESS. I’ll tinker with it.
> 
> All the images have non-zero size. I can view them within 4D. Extracting them 
> is getting frustrating.

**
4D Internet Users Group (4D iNUG)
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: Image Export Issues

[Chuck Miller via 4D_Tech]

One I would at list upgrade to 15.6

Two I would try using an older O/S I would bet 15 does not run well on version 
you listed. I use 10.12 in a VM

Three I would bet it is a memory issue

Why are you using the document command. Have you created the document first.

I assume each picture is in it’s own document. If so I think you can just pass 
the path in and not use Document. You would have HD:folder:Filename.jpg or 
whatever

I might also test file size and if 0 skip it. I wrote code to export many more 
pictures than that and found I had to do it in stages. We also had to convert 
image types as our data was old. If you want I can send you that code privately 
(If I can find it)



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 Mar 31, 2020, at 11:19 PM, Robert McKeever via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> The database is 4D v15.4, iMac 10.14.6, using a Pegasus 9Tb RAID (sweet 
> drive).

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

Re: v17.4 and UUIDs

[Chuck Miller via 4D_Tech]

> On Mar 27, 2020, at 11:58 AM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> not 100% sure, but maybe the duplicates are actually nulls.
I assume you are correct

> 
> if you display the UUID fields in a list form, and resize the window, do the 
> values change?


> 
> if yes, what you see are phantom UUIDs, there are actually null.
> 
> I assume you added auto-generating UUIDs, 
Yes I do
> I assume you did this in a v17.4 structure file, 
Yes I do
> I assume you opened a v13.x datafile,
> expecting that the newly created UUId filed would automatically be populated.
Yes I do
> 
> my question is, did the primary key wizard show up?
No it does not
> 
> or maybe I should ask, is the UUID also a primary key?
Yes it is


Additionally,
I have the following code to fix the problem. Only the tables which 4D tells me 
have duplicates are updated

READ WRITE(*)
C_LONGINT($TableNumber_L;$Primary_key_field_id_L)

For ($TableNumber_L;1;Get last table number)
If (Is table number valid($TableNumber_L))
$Primary_key_field_id_L:=0
C_POINTER($Table_ptr;$Field_ptr)
$Table_ptr:=Table($TableNumber_L)
C_TEXT($ConstraintID_txt)

Begin SQL

SELECT CONSTRAINT_ID
FROM _USER_CONSTRAINTS
WHERE TABLE_ID = :$TableNumber_L AND CONSTRAINT_TYPE = 
'P'
INTO :$ConstraintID_txt;

SELECT COLUMN_ID
FROM _USER_CONS_COLUMNS
WHERE CONSTRAINT_ID = :$ConstraintID_txt
INTO :$Primary_key_field_id_L;
End SQL

$Field_ptr:=Field($TableNumber_L;$Primary_key_field_id_L)
ALL RECORDS($Table_ptr->)
ARRAY TEXT($UUIDKeys_atxt;0)

DISTINCT VALUES($Field_ptr->;$UUIDKeys_atxt)
If (Records in selection($Table_ptr->)#Size of 
array($UUIDKeys_atxt))

APPLY TO SELECTION($Table_ptr->;$Field_ptr->:=Generate 
UUID)
End if 
End if 


End for 



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

Re: v17.4 and UUIDs

[Chuck Miller via 4D_Tech]

It is not my code. It is 4D that fills in the UUIDs in this circumstance. The 
question is why does 4D fill in some but not all UUIDs

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 Mar 27, 2020, at 11:56 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Bug in your code?

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

alter table and primary keys

[Chuck Miller via 4D_Tech]

Hi All,

I have a customers structure that has fields (Longint) named ID set as the 
primary key for each table.

This is a structure I took over. We are trying to upgrade to v17.4 now since 
the keys are set as primary and there is a foreign field definition related I 
can not do the following as I get errors. The errors I get are
The list of foreign key constraints is not empty for table: Constants of 
database: JakeCH-WUUID
Cannot alter primary key definition of table Constants
Failed to execute ALTER TABLE command.

I do not went to have to undraw and redraw every relationship line to make this 
work. Since when do you have a foreign key that can only relate to a primary key

Regards

Chuck


Begin SQL
ALTER TABLE [Constants] DROP PRIMARY KEY;

ALTER TABLE [Constants] ADD [Constants_UUIDKey_s] UUID AUTO_GENERATE 
PRIMARY KEY;
End SQL



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

Display off server process window on client

[Chuck Miller via 4D_Tech]

Hi all,

I have looked and tired and can’t figure out how to do this. v 17 running as  
service so I need to be able to view settings etc on client. Where do I find 
this in documentation so I can set it up

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

Re: Gmail, LSA, and OAuth

[Chuck Miller via 4D_Tech]

what relay would you propose. 

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 Mar 19, 2020, at 12:44 PM, Mike Kerner via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> or you can do this a different way - using a mail relay.  that way your 4d
> app doesn't have to be changed.  the relay accepts your smtp and then
> relays the message to google.

**
4D Internet Users Group (4D iNUG)
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: barcode

[Chuck Miller via 4D_Tech]

The only problem is creation of of bar code. I think hmbar code does all types 
(128 etc) which are harder to do programmatically.  When I tried, I was able to 
get 128 working on a Mac or a PC but not both. The coding seems to have been 
slightly different

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 Mar 18, 2020, at 3:45 PM, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Is there a problem with using a font? Just asking as that is what I am doing. 
> Seems to work great.
> The font is free, so cost is not an issue.
> 
> Thanks
> 
> Jody

**
4D Internet Users Group (4D iNUG)
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 interface with Sharepoint

[Chuck Miller via 4D_Tech]

I know a late response but, you might start here

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/get-to-know-the-sharepoint-rest-service?tabs=csom
 



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 Mar 4, 2020, at 2:23 PM, Luc Devar via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
>  need to create an interface with Sharepoint. Right now, I am managing all 
> the documents within 4D but the client
> would like to move this portion to Sharepoint.  I will need to push and 
> retrieved documents basically. Nothing more than that.
> 
> Anyone has done something similar or maybe someone can point me to the right 
> place to start investigating on how can this be done.
> 
> 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
**

Re: Use Named Selection Unexpectedly Loads First Record of Named Selection

[Chuck Miller via 4D_Tech]

I think has always been behavior. Simply use unload record after use command. 
Set named selection etc

Regards 
Chuck

Sent from my iPhone

> On Mar 12, 2020, at 6:05 PM, Douglas von Roeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Keith:
> 
> Thank you for confirming that.
> 
> --
> Douglas von Roeder
> 949-910-4084
> 
> 
>> On Thu, Mar 12, 2020 at 1:49 PM kculotta via 4D_Tech <4d_tech@lists.4d.com>
>> wrote:
>> 
>> It works just as you described in v18 Mac too.
>> If you put NEXT RECORD after ALL RECORDS, that second record is later
>> restored.
>> 
>> Keith - CDI
>> 
>>> On Mar 12, 2020, at 3:10 PM, Douglas von Roeder via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>> 
>>> 4D 17R6 on Windows.
>>> 
>>> ALL RECORDS([People])
>>> //Lots of records in the current selection
>>> //There is a current record
>>> 
>>> UNLOAD RECORD([People])
>>> //Lots of records in the current selection
>>> //There is no current record
>>> 
>>> COPY NAMED SELECTION([People];"ASD")
>>> //Lots of records in the current selection
>>> //There is no current record
>>> 
>>> QUERY([People];[People]SSAN="8675309”)
>>> //No record found
>>> //There is no current selection
>>> //There is no current record
>>> 
>>> USE NAMED SELECTION("ASD”)
>>> //Lots of records in the current selection
>>> //There is a current record
>>> 
>>> CLEAR NAMED SELECTION("ASD")
>>> //Lots of records in the current selection
>>> //There is a current record
>>> 
>>> I wasn’t expecting a Use named selection to load a record.
>>> 
>>> Has anyone else experienced this? It is reproducible?
>>> 
>>> --
>>> Douglas von Roeder
>>> 949-910-4084
>> **
>> 4D Internet Users Group (4D iNUG)
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Execute on client command - locking records

[Chuck Miller via 4D_Tech]

Remember you must have code in the following sequence

Unload record
read only

The reason it may be unlocking on server is that the process ends

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 Mar 11, 2020, at 11:29 AM, Janet Jonas via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I also forgot to note the 4D version - it is 17.4.
> 
> If I try to do the editing on the client machine, it reports that the record 
> is locked by the " Registered Client" process, so I am certain the issue 
> is in Execute on client.
> 
> JJ

**
4D Internet Users Group (4D iNUG)
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 use Zint plugin since upgrading my Mac

[Chuck Miller via 4D_Tech]

That does not seem to work when the error says damaged. It does work for all 
others warnings errors 

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 Mar 2, 2020, at 11:14 AM, James Crate via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Here’s what worked for me, but with different plugins:
> 
> Open System Preferences, Security & Privacy settings, General tab:
> Launch 4D, open the database, click cancel for the complaints about the 
> plugin(s).
> Go to System Preferences, in the lower half under the “Allow apps downloaded 
> from” bit, there should be a warning about a plugin. Click Allow (or whatever 
> the button is to allow the plugin to operate). 
> Quit 4D.
> Repeat for each plugin that requires this.
> 
> Jim Crate

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

Re: Can't use Zint plugin since upgrading my Mac

[Chuck Miller via 4D_Tech]

Yes is the same problem I have with another plug in the developer created a 
signed application for Catalina but no luck. Any ideas on this o r

Sent from my iPhone

> On Feb 28, 2020, at 8:44 AM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> a plugin is not an app or executable, you can't add it to spctl (gatekeeper) 
> by right click. 
> 
> go to github, find releases, and grab the latest release that matches your 
> version.
> **
> 4D Internet Users Group (4D iNUG)
> 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: Necessary To End Task After Quitting Server

[Chuck Miller via 4D_Tech]

I am not sure this is it.  we have had this type of error since v15. It is 
never a process we have started and it does not appear anywhere on 4D’s list of 
processes. When we see this message (Waiting for task to complete) we can wait 
forever and 4D will NEVER quit

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 Feb 26, 2020, at 2:58 PM, Allan Udy via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Tim,
> 
> 
> Timothy Penner wrote on 27/02/20 6:34 AM:
>> the very last line of code in the On Server Shutdown message is a logging 
>> entry, which DOES get executed so we no it's not getting hung up on code in 
>> there. Perhaps the application is releasing the memory?
>> 
>> Take a look at the Task Manager and watch the memory for the 4D Server.exe 
>> process after you choose QUIT. Essentially the memory value of the process 
>> decreases until it reaches 0 and then the application finally quits.
> 
> Many thanks for your explanation -- it makes some sense, we'll investigate.  
> We're not far away from moving to v18  :-)
> 
> Cheers,
> Allan Udy

**
4D Internet Users Group (4D iNUG)
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 over different platforms

[Chuck Miller via 4D_Tech]

OK so use Filemaker for this project. 4D was designed and runs on MAC and 
Windows machines natively.

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 Feb 25, 2020, at 5:58 PM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I've seen a File Maker application that can be used in iOs and Windows and in 
> all devices...

**
4D Internet Users Group (4D iNUG)
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: NEED HELP

[Chuck Miller via 4D_Tech]

Dis you change OS versions



Sent from my iPhone

> On Feb 23, 2020, at 7:43 PM, Tom Dillon via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> No, I didn't. So will try that. Thanks
> 
>> On Sun, Feb 23, 2020 at 3:37 PM Randy Kaempen 
>> wrote:
>> 
>> Tom,
>> 
>>> On Feb 23, 2020, at 5:33 PM, Tom Dillon via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>> 
>>> I am not sure if this is the right forum but I need help on a problem
>>> that's just cropped up.
>>> 
>>> I have been successfully  building stand alone apps using V13.3 for years
>>> now and suddenly each time I try to "Build the app" it starts coping over
>>> file but just before it finishes 4d crashes. I have tried everything to
>> get
>>> it to work.
>>> 
>>> Anybody have any ideas as to what causing this?
>> 
>> To ask the obvious questions:
>> 
>> Did you run the MSC on the structure to make sure there’s no damage?
>> 
>> Did you try replacing the 4D Volume Desktop with a fresh copy?
>> 
>> 
>> 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
> **

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

Bar code

[Chuck Miller via 4D_Tech]

Hi all. 

I had thought there was a tech note or something on how to draw bar codes in 4D 
using bag area. Can someone point me the the right direction

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

re-index issue

[Chuck Miller via 4D_Tech]

Hi All,

environment
4D 17.4
Mac OSX (10.15.3) Catalina
Developer

Every time I log into a particular DB with the same file It seems to re-index 
some of the fields. I am not sure why. Anyone have any ideas.

For the data file I am using, I restored from a backup including the journal. 
When I launched it re-indexed everything. I quit and the went back in and 
re-indexing started again

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

Re: Write PICT to disk, 64bit

[Chuck Miller via 4D_Tech]

sure did you try moving into blob then blob to document. You may have to export 
and import into a version of 4D that supports 32 bit if running server, you may 
be able to connect using a 32 bit client you did not say what version of 4D you 
are using. All of these should have been fixed while in 32 
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 Feb 13, 2020, at 10:17 AM, Bill Hutten via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi all: We have some 4D Write Pro documents that contain PICT (and other 
> format) images. This code will give us a list of all images from the document:
> 
> $res := WP Get Elements($area; wk_type_image)
> 
> We would like to be able to write these images to disk - but PICTURE TO BLOB 
> and WRITE PICTURE FILE both require a relevant codec, which of course for 
> PICT does not exist in 64bit 4D. Does anyone have any idea how we might solve 
> this problem?
> 
> 
> Thanks
> 
> - bill

**
4D Internet Users Group (4D iNUG)
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: New Notarization Issues

[Chuck Miller via 4D_Tech]

Slightly related. Any idea why I have a plug-in that is signed but shows as 
damaged on Catalina but not in windows. I am not sure of other Mac OS versions. 
Chuck 
Sent from my iPhone

> On Feb 11, 2020, at 8:01 PM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I am not 100% sure, but it might be because plugins that support v17 (up to 
> R6) or earlier
> have their manifest.json file under Contents, where the code sign CLI might 
> fail to find it.
> 
> v18 plugins have moved the location to Contents/Resources,
> but then, the plugin is no longer compatible with v17.
> that is why I am now posting 2 builds,
> which are virtually identical except for the location of manifest.json.
> 
> see:
> 
> https://github.com/miyako/4d-plugin-curl-ftp/releases
> 
> very curious to know if 3.9.v18 is successfully signed with the official 
> shell script.
> 
> 
> 
> On Feb 12, 2020, at 8:28, Cannon Smith via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I’m less sure what to do about the cURL FTP plugin. I know Miyako has it 
> ready for notarization and I assumed 4D’s shell script would take care of 
> plugins correctly, but maybe there is something I have to do manually with it.
> 
> **
> 4D Internet Users Group (4D iNUG)
> 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: Printing a form with a graphic icon

[Chuck Miller via 4D_Tech]

Could they be grabbing a pdf

Sent from my iPhone

> On Feb 11, 2020, at 10:52 AM, Gary Boudreaux via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> One of my databases allows the user to print a purchase order with a small 
> graphic icon in the header (about 100x100 pixels). The graphic only prints 
> about half of the time. I suspect that he is grabbing graphics from a variety 
> of sources, so I’m not sure what the format is. The graphic is stored in a 
> field for the PO, and it does always display when the input form is shown. 
> Any idea what could cause the inconsistency when 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
> **

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

Re: 4D v16 in mixed mode 32 and 64bit

[Chuck Miller via 4D_Tech]

If you are using plugins that have two versions I think you are stuck. I  would 
love to 64 bit all the way. also I would no of go to 16 I would go to 17. 16 
will be obsolete very shortly

Regards 
Chuck

Sent from my iPhone

> On Jan 29, 2020, at 4:46 AM, Andrew Hobson via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hello,
> 
> Until now, my main 4D Application runs on 4D v15.
> With new computers arriving installed with MacOS 10.15 Catalina, I need to
> move to 4D v16 and 64bit.
> 
> I have some real basic questions.
> 
> 
> 1)  Can you live in a mixed mode environment. 4D Server in 64bit and 4D
> Clients in 32bit and 64bit ?
> If yes, what about the plug-ins. The plug-in bundle must contain both code 32
> and 64 bit ?
> Because from my observations, for some 4D plug-ins, they come in two flavors
> 32bit or 64bit. Not both mode. So how do you manage that ?
> 
> 
> 2)  Is there an interest in living in a mixed mode 32/64 bit, or is it
> futile ? From the moment you migrate to 64bit, you need to forget 32bit ?
> 
> Thanks for helping me understand ;-)
> 
> Andrew
> **
> 4D Internet Users Group (4D iNUG)
> 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: catalina and 4D

[Chuck Miller via 4D_Tech]

So if I download an installer and install on an external and then copy. I won’t 
get the message. Is that the way it works?  My problem in responsiveness. When 
running 17.3 it sometimes doesn’t even launch. I have been running 17.3 on 
previous laptop. 

Sent from my iPhone

> On Jan 14, 2020, at 12:10 AM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> it does not apply to apps you copied outside the internet (external removable 
> drive, etc).

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

catalina and 4D

[Chuck Miller via 4D_Tech]

Hi All,

I have new laptop that I bought without thinking too hard. It only tuns 
Catalina. I am trying to run v17.3 and have some issues. Is anyone using 
catalina and if so what might I do to fix the slowness I am seeing. Should I be 
using an R  release and if so which one

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

Re: HTTP Upload file size too low

[Chuck Miller via 4D_Tech]

Just curious could you not code something so that it uses FTP?

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 Jan 8, 2020, at 8:44 PM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> The client and the server have to agree on sending with the chunked protocol. 
> This is obviously not supported by WEB GET BODY PART. That means you would 
> have to code the transfer yourself using WEB GET HTTP BODY (using chunked 
> encoding) and then you will have to parse the multi-part form yourself 
> because you can't use WEB GET BODY PART.
> 
> I did something like this aeons ago using ITK before 4D's web server was 
> implemented. Even if I could find the code, I don't think it would be much 
> help.
> 
> John DeSoi, Ph.D.

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

Re: running server v17.3 as a service

[Chuck Miller via 4D_Tech]

I left out the last sentence. If you are running this under server 2016, you 
can see the alert but can not respond in any way. This makes it much harder as 
sometimes you can have an unexpected alert come up.


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 Dec 30, 2019, at 6:49 PM, Charles Miller via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 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

**
4D Internet Users Group (4D iNUG)
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 v17 and catalina

[Chuck Miller via 4D_Tech]

Hi All,

I am running combination on my development machine. Does anyone else notice how 
slow 4D is in loading. Am I imagining that 4D and other programs are slow to 
load


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

running server v17.3 as a service

[Chuck Miller via 4D_Tech]

Hi all,

I have a customer who is making this request and know virtually nothing about 
this. Can some one point me to some documentation on this. 

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

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

Re: peer to peer app in 4D

[Chuck Miller via 4D_Tech]

I don’t think 4D is built for this, but what do you mean by close. Are they 
logged into 4D. Are they broadcasting their location in some way to another app?

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 Dec 18, 2019, at 8:36 AM, Joe Dombroski via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am writing a basic app that will find people who are physically close to
> you. Kind of like Uber. Can 4D do that elegantly?

**
4D Internet Users Group (4D iNUG)
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

[Chuck Miller via 4D_Tech]

I think he said he was running 2003.x If so I would make cache much smaller. I 
would make it 1.5 gig and I would set auto flush on server to 1 minute

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 Dec 18, 2019, at 11:42 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Ferdinando,
> try setting the cache to 8gig (8000MB) that is 50% of installed RAM.
> 
> run it for a bit, see if this helps.
> 
> Chip

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

Re: O/S Replication and Backup interaction with 4D (2004, v15)

[Chuck Miller via 4D_Tech]

In all cases they should be able to set backup to exclude particular files and 
or directories.  Both backups could be causing problems especially with the 
2004 dB

Sent from my iPhone

> On Dec 4, 2019, at 10:00 AM, Peter Jakobsson via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi
> 
> I have a legacy 4D server which appears to be getting trashed by the backup 
> services in Windows 10 server.
> 
> The platform contractor cannot turn off any of the backup stuff and I can’t 
> upgrade to v17 for several weeks due to…..reasons, so need to find a way 
> round this. (There are 2 virtual machines running inside the host. One of 
> these runs a 4D 2004 server, the other runs a 4D v15 server).
> 
> One thing the contractor said is that there are 2 levels of backup - the 
> “Host replication” which runs every 15 minutes - and the guest backup (which 
> I presume is Windows Shadow Copy Service) which runs once per evening.
> 
> Am I right in thinking that legacy 4D servers should be ok with the host 
> replication but not with the guest backup (which causes file locking 
> conflicts with 4D I imagine) ?
> 
> If that’s the case I’m thinking of finding a shell script to take the 4D 
> server down in the evenings and put it back up early morning.
> 
> Regards
> 
> Peter
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
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 Modify a column using SQL

[Chuck Miller via 4D_Tech]

Do you mean the name or the data.

If data it is an update command it name of column it would be an alter command

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 Dec 2, 2019, at 2:22 PM, Jim Labos - infobase via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Does anyone know if this has changed since 2013?
> 
> I couldn't find anything but I could be missing something.
> 
> Thanks

**
4D Internet Users Group (4D iNUG)
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: Significant Debugger Window Issue

[Chuck Miller via 4D_Tech]

This will also reset window coordinates of design environment to default, so if 
you have a method that has opened off screen (Previously on a second monitor, 
holding shit key down will reset to default

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 Nov 17, 2019, at 8:39 AM, Jim Hays via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> (adding this to an old thread so I can find the answer 2 years from now...)
> My structure file was crashing the instant it hit the debugger (v17.2).
> 
> Here's how to clear your debugger expression pain:
> https://kb.4d.com/assetid=78161
> 
> "If by accident an expression is added and saved to the pane that executes
> code that causes issue it is possible to clear the expressions by holding
> down the *SHIFT* button while the debugger is opened.
> 
> After the debugger is opened with the cleared expression pane it is
> important to save a new set of expressions or else the next time the
> expression pane is opened the last saved set of expression (the one that
> were possibly causing issues) will return."
> 
> (Click the Save icon)
> 
> Also found the answer here from Achim PESCHKE:
> https://forums.4d.com/Post/EN/3360111/1/3360112#3368866
> 
> The debugger expressions _are_ stored in the structure.  This happened when
> I tried the same structure on different machines.
> 
> 
> As for v18 Project Mode?  Next to the project folder:
> Project
> userPreferences.[macOSUserName]
> debuggerWatches.json
> 
> So nice!
> 
> BTW - I think converting your structure to project mode clears the debugger
> pane - not that it helps you if you aren't ready to use project mode.
> 
> 
> Jim Hays
> 
> 
> 
> 
> On Sat, Aug 24, 2013 at 11:02 PM David Belote 
> wrote:
> 
>> One last post on this topic from me that I think might help someone else
>> who has to delete the 4D preference file and because of it, have to
>> reenter the license information.  As noted before, it looked like I was
>> going to have to reenter my license information after deleting  the
>> corrupted preference file (saved it to a save location), but I think I
>> found a way around this.
>> 
>> I initially found that if I started up 4D without any preference file,
>> that it started in demo mode.  But if I put the corrupted preference file
>> back in place that 4D would start up as usual with my licenses, but of
>> course, the debug window wouldn't work properly.
>> 
>> After playing around with it a few times, I found that if I started up 4D
>> using the corrupted "4D Preferencesv13.4DPreferences" file that caused the
>> debug window not to work correctly, but then deleted that same corrupted
>> 4D preferences file while 4D was running, that when I quit 4D, 4D wrote a
>> new "4D Preferencesv13.4DPreferences" file.  That new 4D preferences file
>> includes the pointers to my license files. Everything is running just like
>> it is supposed to.
>> 
>> It makes sense because the corrupted preference file somehow didn't
>> contain the correct info to allow the debug window to run, but it did
>> contain my license info (and the other required parameters).  So when 4D
>> quit and it found that the preference file was missing, 4D wrote the new
>> one with the info that was present in the running 4D app.
>> 
>> I verified that this worked by pulling down 4D/About 4D and it contains my
>> name and company name.  Then in then pulling down Help/Update License, I
>> can see my licenses.
>> 
>> Dave Belote
>> Colorado Springs, Colorado USA
>> 
>> 
>> On 8/23/13 12:23 PM, "Donald Koffman"  wrote:
>> 
>>> I second the thank you. It fixed the same problem on the OC.
>>> 
>>> On Aug 23, 2013, at 9:19 AM, David Belote 
>>> wrote:
>>> 
 Miyako, Chip, and all who helped me with this,
 
 Thanks for using the Show On Disk command.  With it I found the file you
 all have been talking about. When I deleted the "4D 

Re: 4D 2002r8

[Chuck Miller via 4D_Tech]

Email again if you still need it I. Two weeks I am out of country but have all 
the old cds from 4d it might be on one of them

Chuck 

Sent from my iPhone

> On Nov 11, 2019, at 3:40 PM, Uist Macdonald via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Does anyone have a copy of 4D2003r8 installer? Or a link?
> 
> Thanks
> 
> Uist
> 
> -- 
> 
> Ceres Computer Consultants Ltd
> 
> Registered Office:
> South Scotstarvit
> Chance Inn
> Cupar
> Fife KY15 5QJ
> 
> +44 (0) 1334 828002
> 
> Registered in Scotland : SC107838
> 
> An ISO 9001 registered company.
> 
> This message including any attachments, is intended and authorized for
> the addressee only, and may contain privileged and/or confidential
> information.  If you are not the authorized addressee, you are not
> authorized to either review or disseminate this message.  Accordingly,
> if you are not the intended and authorized recipient, please disregard
> this message and notify the sender.  If you are the authorized
> addressee, you may use this for the purpose for which it was intended; a
> direct, personal communication to you and your legal agents.  You may
> not distribute it to or publish it in any public forum without prior,
> specific, written permission from the sender.
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: 4d write pro and rich text

[Chuck Miller via 4D_Tech]

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

creating csv files

[Chuck Miller via 4D_Tech]

Hi All,

I am successfully creating csv files with one expection. Occasionally, I will 
have a column created from a text field, that looks like a number. For example 
6108900015297 Most other data does not look like that there could be letters, 
dashes, etc part if customer PO number. When I open the document this item as 
well as others like it come in as scientific notation. Can anyone advise how I 
might stop that from happening


This is the code I am using. Indeed when you open with text editor the data 
looks correct. It is only when opened by excel where it looks like this 
6.1089E+12
instead of
6108900015297

$line_txt:=$line_txt+Char(Double quote)+Replace 
string($arr_ptr->{$Rows_L};Char(Double quote);Char(Double quote)+Char(Double 
quote))+Char(Double quote) 



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

Re: 4D Write Pro license

[Chuck Miller via 4D_Tech]

Have you added the license key to your development environment  

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 Nov 5, 2019, at 9:33 AM, Doug Hall via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I'm a bit confused. In converting from v15 to v16, I've encountered a 4D
> Write Pro "privilege error" when using the WP New() command, even though I
> have have a valid 4D Developer Professional license installed (which
> includes an unlimited 4D Write Pro license). I'm trying to convert my 4D
> Write Blobs from v15 to Objects compatible with 4D Write Pro.
> 
> Anyone else encounter this?

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

[solution] printing PDFs on windows from 4D

[Chuck Miller via 4D_Tech]

Hi All

There is a program named PDFtoPrinter.exe which I am using to print PDFs on 
windows from cmd using LEP form inside 4D

If the files desired do not print correctly, you will need to download PDF 
Exchange and print PDF form there. When it prints and is sized correctly, you 
will need to export the setting and place the file named PDF-XChange Viewer 
Settings.dat in the same folder you have placed PDFtoPrinter.exe. I found it at 
http://www.columbia.edu/~em36/pdftoprinter.html 


Please note that it is a wrapper for PDF exchange

Hope this helps someone else

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

combining pdfs on windows

[Chuck Miller via 4D_Tech]

Hi All,

We are using PDF tool kit to combine pdfs via 4D on windows machines. It is 
working OK but was wondering if there was any native way to do this without 3rd 
[arty software.  We have PDF 1 which is printed as a PDF from 4D and PDF 2 
which is stored on a files server, which is an enterable PDF. We create PDF 1, 
then combine with PDF 2 and email the resultant PDF.

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

Re: Compiling for Windows and Mac

[Chuck Miller via 4D_Tech]

What I said was if you want a built server. It must be created on platform it 
will run on

In my opinion everyone should be using a built client server. More control and 
I think more security re connections

Regards 

Chuck

Sent from my iPhone

> On Oct 18, 2019, at 12:05 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Chuck,
> Nope. Compiled is compiled for either platform. As Miyako said you could
> indicate if you wanted 64 bit and there is the question of the variable
> definitions but aside from that 4D is wonderfully agnostic with regard to
> platform - at least at this level.
> 
>> On Fri, Oct 18, 2019 at 2:47 AM Charles Miller via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>> 
>> 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
>> **
> 
> 
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> What can be said, can be said clearly,
> and what you can’t say, you should shut up about
> 
> *Wittgenstein and the Computer *
> 

Re: post-icon conversion

[Chuck Miller via 4D_Tech]

When you converted them did you make sure to deal with the background. I have 
posted on this before. I will try and remember and repost on Monday what the 
command is to set the background properly

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 Oct 4, 2019, at 10:05 PM, Mike Kerner via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> We got a project moved from 2k4 to 17, and got the icons converted.  They
> appear as one would expect in the picture library.  However, the buttons
> that use them now display a white background and the red word "Library".
> If I create a new picture button and assign the same ID, the image
> appears correctly.
> What do I have to do to get 4D to refresh or reload or whatever to load
> these images into the old buttons?
> **
> 4D Internet Users Group (4D iNUG)
> 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
**

How do you create a enhancement request on forum

[Chuck Miller via 4D_Tech]

Hi All,

I want to create the following enhancement request to the forum and am not sure

In the 4D link file I want to allow for more than one Ip address connection. If 
there is more than one I would like to have the ability to set as cascade, 
which means try first one, then next etc.

If set to user selection, I would like 4D to give user a choice regarding which 
to connect to,

This would really help in a situation where you had a mirror and the production 
server becomes unavailable. When connecting the client would try production and 
if no available would then try the next one in line

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

Re: mirror to production

[Chuck Miller via 4D_Tech]

Good thought but when you have a but client a new 4dlink file gets created on 
connection and that is the one that is used

Regards 

Chuck

Sent from my iPhone

> On Oct 4, 2019, at 3:13 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
>> On Oct 4, 2019, at 2:00 PM, Chuck Miller wrote:
>> 
>> We are ready to implement our new mirror code and are writing documentation 
>> on this process. The one thing I have not figured out is how to turn the 
>> mirror into production.
>> 
>> The server itself is pretty easy as I have a record that has IP address of 
>> production machine in a record.
>> 
>> What I do not understand is how to update the clients.  Production and 
>> Mirror are on different subnets so the built client on the machine will not 
>> be able to connect to without a change to 4Dlink file.
>> 
>> What I was hoping was to use a DNS name and simply change the IP address it 
>> points to so if I had
>> 
>> Server_prod which pointed at 192.168.5.5 
>> Server_Mirros which pointed at 192.162.5.17
>> 
>> The IP’s are of course not the real ones in use
>> 
>> I could simply change DNS name and voila each client would connect 
>> seamlessly. This code is for a large hospital and changing DNS names like 
>> this does not seem to be in the cards. 
>> 
>> Can anyone tell me how they are doing this
> 
> DNS name change is definitely the way to go, but if you can’t do that, then 
> you could do something like this.
> 
> First, all of your 4D Client users need to have a network file server share 
> that they all have mounted.  
> 
> On that share create a folder and put in that folder a .4Dlink file that 
> everyone will use to connect to 4D Server. 
> 
> Next make a shortcut to this 4Dlink file and send this to all your users. 
> Tell them this is the file they should double-click to connect to 4D Server. 
> No user will have the real 4Dlink file on their hard drive. They only get to 
> have a shortcut to the 4Dlink on the network share. 
> 
> When you want to switch from production to mirror server you just change the 
> IP address inside 4Dlink file on the file server share. 
> 
> Tim
> 
> *
> Tim Nevels
> Innovative Solutions
> 785-749-3444
> timnev...@mac.com
> *
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: v15 - what code runs before On Startup?

[Chuck Miller via 4D_Tech]

Hi chip

This is what I would do I would create a new component. I would open old 
component with problem and move half of the methods in. Try and run with that 
if it works I would quit and move half the remaining methods. Continue to do 
this until you find the offending one

Regards 

Chuck

Sent from my iPhone

> On Sep 30, 2019, at 5:58 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I have a component which I am trying to debug. The host is interpreted, 
> stand alone.
> 
> When the component is compiled and built the host starts, but of course 
> I can not trace the code in the component - from which I am getting an 
> error message.
> 
> When I swap in the interpreted version of the component, during 
> database startup I get an error not enough memory (obviously stuck in a 
> loop). 
> 
> However, currently the very first line of code in the host ON STARTUP 
> is TRACE.
> The not enough memory error is presented BEFORE the trace is hit.
> 
> The ON STARTUP of the component is empty (no code).
> 
> What code could be running?
> 
> Thanks
> Chip
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: QUERY WITH ARRAY - SQL Equivalent?

[Chuck Miller via 4D_Tech]

Here goes

C_TEXT($INCLUDED_txt)
$INCLUDED_txt:=“(“+String(al_Personnel_ID{1})
for($LOOPL;2;size of array(al_Personnel_ID))

$INCLUDED_txt:= $INCLUDED_txt+”,”+String(al_Personnel_ID{LOOPL})

end for
$INCLUDED_txt:=$INCLUDED_txt+”)"
begin sql
select [Personnel].[field],...

from [Personnel]
where
Personnel]Personnel_ID in :$INCLUDED_txt:

end sql

 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 18, 2019, at 11:44 AM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hello SQL Afficionados!
> 
> I need to get a selection of records, based upon an array of ID numbers.
> (What I want is to end up the arrays... not the selection of records)
> 
> e.g.
> QUERY WITH ARRAY([Personnel]Personnel_ID;al_Personnel_ID)

**
4D Internet Users Group (4D iNUG)
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 - execute immediate

[Chuck Miller via 4D_Tech]

Ae you placing between a begin and end sql statement?

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 12, 2019, at 2:28 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am trying to play with the sql commands.
> I wanted to build a string to be executed (Execute Immediate)
> HOWEVER 4D is not tokenizing this command.
> 
> It is listed in the v15 4D sql reference...
> any ideas?
> has this been depreciated, and a replacement command created - but the 
> documentation was not updated?

**
4D Internet Users Group (4D iNUG)
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"

[Chuck Miller via 4D_Tech]

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

Re: v2003 installer?

[Chuck Miller via 4D_Tech]

Is it  in the archives at 4d 
If not I can find one on an old cd
Sent from my iPhone

> On Aug 31, 2019, at 9:09 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Anybody know where I can find a 4Dv2003 Mac installer?
> 
> PB
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

windows versions for 4D v13.6

[Chuck Miller via 4D_Tech]

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

looking for Barclay Berry

[Chuck Miller via 4D_Tech]

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

Looking for old plugin

[Chuck Miller via 4D_Tech]

Hi all

I am looking for an old plug in named outlookconduit4d. It is in use at a 
client and in bundle form. I know armin deeg has something I can use to replace 
it but would rather find the original. Can anyone point me i the correct 
direction. 

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

Re: Win32API setup woes

[Chuck Miller via 4D_Tech]

What drive are you putting the result. I have found problems when on c 

Regards 

Chuck

Sent from my iPhone

> On Aug 23, 2019, at 7:20 AM, David Garrard via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hello Keisuke and Timothy,
> 
> I have isolated things to a simple new structure "TestDB.4db" that has one 
> method that calls a couple Win32API commands.
> 
> I downloaded the latest Win32API for Github and have placed it in the 
> \Plugins directory next to this structure.  There is no \Win4DX directory for 
> this test setup. 
> 
> On one Windows computer this structure shows up correctly in the 4D Explorer 
> and is enabled - version 8.2.2.  When I execute code with the Win32API 
> commands on this computer all is good. 
> 
> On the other Windows computer this structure shows up in the 4D Explorer, but 
> is marked as Disabled - need to upgrade.
> 
> Both these computers have Microsoft Visual C++ redistributables installed.  
> X86 and 64bit.
> 
> Both are using v16.3 Build 16.217894 32 bit.
> 
> One thing that might be associated is that when I compile the compiled 
> structure is placed in a directory entitled "STR#  10135,18", instead of 
> "Compiled Structure".  I had ignored this since I am seeing the Disabled 
> state of the plugin in the interpreted database, but perhaps there is some 
> string resource issue that might be causing this problem. So if anyone knows 
> how to fix that issue, it may address the disabled plugin issue. 
> 
> Thank you,
> 
> David 
> 
> -Original Message-
> From: Keisuke Miyako [mailto:keisuke.miy...@4d.com] 
> Sent: August 21, 2019 7:58 AM
> To: dgarr...@gmail.com; 4D iNug Technical <4d_tech@lists.4d.com>
> Subject: Re: Win32API setup woes
> 
> license error is the default exception when a plugin call fails. the real 
> cause could be anything.
> 
> first you should check in 4D's explorer that the plugin is loaded. if not, 
> you'd get the licensing error.
> 
> maybe you are missing vc runtimes. maybe the architecture doesn't match. keep 
> in mind that 4dx folders are not supported in 64bit since v12, and all 
> platforms sine v14.
> 
> 
> 
> 
> 株式会社フォーディー・ジャパン
> 宮古 啓介
> テクニカルサービスマネージャー
> 〒150-0043 東京都 渋谷区道玄坂1-10-2-6F
> 
> Phone : 03-4400-1789
> Fax :   03-6427-8449
> Email : keisuke.miy...@4d.com
> Web :   jp.4d.com
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: PICTs

[Chuck Miller via 4D_Tech]

JPR has given me permission to send out his component that will help you in 
fixing this problem. If you want it please advise

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 Aug 19, 2019, at 9:40 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> one more question...
> how do I find the 'static PICTs' referenced in the 64 bit report?
> I have looked at, and know what is on all of my forms - I do not have any 
> static PICTS that I can see/find.
> 

**
4D Internet Users Group (4D iNUG)
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: PICTs

[Chuck Miller via 4D_Tech]

Yes you can usehm free from  https://www.hmplugins.com/ 


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 Aug 19, 2019, at 5:33 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> In v13, or v15 is there a way to tell is a picture in the library is in 
> PICT, or other format?
> 
> Thanks
> Chip
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Windows shutdown with 4D Server running as a service

[Chuck Miller via 4D_Tech]

Shouldn’t you first stop the service, which will quit 4D

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 Aug 8, 2019, at 8:03 AM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi John,
> 
> I believe that 4D Server does a 1 minute countdown when downing while running 
> as a service, so that should notify any connected users. At least that’s what 
> it did when I tested NET STOP and NET START some years ago. I don’t know 
> whether that also happens when downing Windows. I would hope so. Do you see 
> any evidence of that on the client?
> 
> Tom Benedict
> 
>> On Aug 8, 2019, at 01:14, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> What is the best practice for shutting down a windows computer when 4D 
>> Server is running as a service?
>> 
>> I have been opening the administration window too see if there are any users 
>> connected. If so, I have been disconnecting them before shutting down the 
>> computer.
>> 
>> Just shutting down the computer seems to work as well, but what does 4D 
>> server do in this case?
>> 
>> Thanks,
>> 
>> 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
>> **
> 
> **
> 4D Internet Users Group (4D iNUG)
> 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: Prevent Client from Sleeping

[Chuck Miller via 4D_Tech]

The question is to why. I would think you just want to stop the drive from 
spinning down. Most companies hate when you do that as they want computer to 
lock after as short period of inactivity

On Mac there is a setting to stop drive from spinning down. I bet there is on 
windows as well

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 Aug 7, 2019, at 1:59 PM, Jim Medlen via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am trying to prevent clients from Sleeping when connected to a 4D server.

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

pointer issue

[Chuck Miller via 4D_Tech]

Hi All,
The following fails 
$MetalAmount_ptr:=Get pointer("$MetalAmount_"+String($MetalPos_L)+"_aR")
$MetalAmount_ptr->{$Loop_L}:=$metalFactors_aR{$InnerLoop_L}

When I changed arrays to process
$MetalAmount_ptr:=Get pointer("MetalAmount_"+String($MetalPos_L)+"_aR")
$MetalAmount_ptr->{$Loop_L}:=$metalFactors_aR{$InnerLoop_L}


It seems even in the same method you can not have a pointer to a local array. I 
am not sure as to why. Any insight would be appreciated, as I know you can pass 
a pointer to local (i.e. $) array form method 1 to method 2 and that works. I 
would guess I could write a method but that seems kind of a worth around

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

Re: FORMAT NUMBER

[Chuck Miller via 4D_Tech]

Read my previous note. You will need to convert the array to text array and 
fill as a formatted number using code I already supplied

Regards 
Chuck 

Sent from my iPhone

> On Aug 5, 2019, at 5:59 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> if ###,## does not display a blank for 0 you may have to  convert back 
> and forth to/from text to get the formatting you want
> 
> Chip
> 
>> On Mon, 5 Aug 2019 23:24:26 +0200, stardata.info via 4D_Tech wrote:
>> Sorry i use 4D V16 on Windows.
>> 
>> I need to display a number in an array real displayed in a list box.
>> In column settings of the list box, if I do not insert anything in 
>> Display number format, the decimal numbers are correctly displayed, 
>> but I have 0 instead of blank.
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: FORMAT NUMBER

[Chuck Miller via 4D_Tech]

That is why I asked about version and what you show is truncated not rounded

Also I would suppose ###.## would take care of all

Didn’t think of that one


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 Aug 5, 2019, at 12:14 PM, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 10.1237 as 10.123 <- rounding

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