Re: Problem launching a bat file via LAUNCH EXTERNAL PROCESS

2016-12-29 Thread Neil Dennis
> Any idea why this is working on one computer but not another?

What error is returned in the error parameter from the Launch External Process?

Neil


--
Neil Dennis
4D Developer since 1990

GreaText - Designing Software for the Way You Work
716 East 1850 N
North Ogden, UT 84414

mailto:npden...@greatext.com
http://www.greatext.com/


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

Problem launching a bat file via LAUNCH EXTERNAL PROCESS

2016-12-29 Thread David Rose
This is a re-post of a message I posted on the NUG several months ago, but 
didn't get a response with a solution.


I have a bat file that I need to run programmatically from 4D v15 on a 
Windows 7 computer.


The bat file runs fine when I manually double-click on it. When run via the 
4D code below, the console window appears for a second, then closes. On one 
computer the bat file executes with the expected results, on another, it 
doesn't.


SET ENVIRONMENT VARIABLE("_4D_OPTION_BLOCKING_EXTERNAL_PROCESS";"false")
SET ENVIRONMENT VARIABLE("_4D_OPTION_CURRENT_DIRECTORY";"mybatfilefolder")
SET ENVIRONMENT VARIABLE("_4D_OPTION_HIDE_CONSOLE";SW_SHOW)
LAUNCH EXTERNAL PROCESS("c:\\Windows\\System32\\cmd.exe /C mybatfile.bat"

The cmd.exe application file is set to always run as administrator.

Any idea why this is working on one computer but not another?

TIA,
David Rose




---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

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

Re: CROP PDF DOCUMENT

2016-12-29 Thread Chuck Miller
That is what I already stated. You can only see on a mac. You can try creating 
a web are on a page and opening that way

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 29, 2016, at 6:21 AM, stardata.info  wrote:
> 
> Hi All,
> 
> I have one pdf documents and i want to crop a part of document, and save the 
> image cropped.
> Is possible using the 4D commands?
> 
> Thanks
> /Ferdinando/
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: CROP PDF DOCUMENT

2016-12-29 Thread STARDATA
Hi,

The command READ PICTURE FILE give OK=1 and the picture variable that i
insert in the command have one dimention, the problem is that i cannot to
see the pdf in the variable in the form.

Thanks
Ferdinando



--
View this message in context: 
http://4d.1045681.n5.nabble.com/CROP-PDF-DOCUMENT-tp5749442p5749457.html
Sent from the 4D Tech mailing list archive at Nabble.com.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: CROP PDF DOCUMENT

2016-12-29 Thread STARDATA
Hi,

I insert the complete path 
READ PICTURE FILE("C:\\Users\\Ferdinando\\Desktop\\test.pdf";vFoto;*)
The variable have one dimension, but in the layout i not see anything.

Thanks
Ferdinando



--
View this message in context: 
http://4d.1045681.n5.nabble.com/CROP-PDF-DOCUMENT-tp5749442p5749453.html
Sent from the 4D Tech mailing list archive at Nabble.com.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: CROP PDF DOCUMENT

2016-12-29 Thread STARDATA
Yes, on windows.
So i need to insert the complete path?

Thanks
Ferdinando



--
View this message in context: 
http://4d.1045681.n5.nabble.com/CROP-PDF-DOCUMENT-tp5749442p5749452.html
Sent from the 4D Tech mailing list archive at Nabble.com.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: eventpost , in process name, what is it?

2016-12-29 Thread Arnaud de Montard

> Le 29 déc. 2016 à 16:06, Aaron  a écrit :
> 
> Anyhow, Is there documentation on what $eventpost is for a process name?

A process name is what you gave to it, so I don't understand the question. 
How and when do you get that "$eventpost"? 


> is there a grace period for when process ids wont be reused,

As long as you don't end a process you created, it will not be re used. 
(ending a process = end of the process method)


> or are they available immediately in 4D?

No, there is a delay between New process and the ability to "talk to" the 
created process. 

-- 
Arnaud de Montard 


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

Re: CROP PDF DOCUMENT

2016-12-29 Thread STARDATA
Hi,

Im using READ PICTURE FILE("";vFoto;*) but i not see the PDF document.

Thanks
Ferdinando



--
View this message in context: 
http://4d.1045681.n5.nabble.com/CROP-PDF-DOCUMENT-tp5749442p5749449.html
Sent from the 4D Tech mailing list archive at Nabble.com.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: CROP PDF DOCUMENT

2016-12-29 Thread stardata.info

Hi Koen,

I can open a pdf document with the command OPEN DOCUMENT?

Thanks

/Ferdinando/


Il 29/12/2016 15:26, 4d_tech-requ...@lists.4d.com ha scritto:
Message: 13 Date: Thu, 29 Dec 2016 13:17:04 +0100 From: Compass - Koen 
Van Hooreweghe  To: 4D iNug Technical 
<4d_tech@lists.4d.com> Subject: Re: CROP PDF DOCUMENT Message-ID: 
<032e58c2-48cd-4b3b-8a61-be6364693...@telenet.be> Content-Type: 
text/plain; charset=us-ascii Hi Ferdinando, If it is a one page pdf, 
you could read it in a picture variable and use the 4D commandos to 
crop. Groeten, Koen Verstuurd vanaf mijn iPhone 6

Op 29 dec. 2016 om 12:21 heeft stardata.info  het 
volgende geschreven:

Hi All,

I have one pdf documents and i want to crop a part of document, and save the 
image cropped.
Is possible using the 4D commands?

Thanks
/Ferdinando/


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

Re: Quick Report -> Excel and accentuated characters v15

2016-12-29 Thread Paul Lovejoy
Interesting!

It works. I never would have expected that.

Thanks Arnaud and Ortwin.

Happy new years.


> Le 29 déc. 2016 à 10:53, Ortwin Zillgen  a écrit :
> 
>> Has anyone found a work-around?
> 
> export to HTML. Excel will open just fine, including all accented characters, 
> even some of the css, if applied, does survive.
> 
> 
> 
> Regards
> O r t w i n  Z i l l g e n
> -
>    
>  
> member of developer-network 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

RE: Not compiling: Tech Tip: Find and fix all Blank or Null UUID fields in an entire database - solved

2016-12-29 Thread Dennis, Neil
> QUERY BY FORMULA($table->;$field->="" |\
>  $field->="20202020202020202020202020202020" |\
> $field->="" |\ 
> $field->=Is field value Null($field->))

I don't think this is what you are looking for... the function "Is field value 
Null" returns a Boolean, so comparing the Boolean from the function against the 
$field-> will not give you the correct results.

Try this instead:

QUERY BY FORMULA($table->;(($field->="") | \
($field->="20202020202020202020202020202020") | \
($field->="") | \
Is field value Null($field->)))

Neil







--



Privacy Disclaimer: This message contains confidential information and is 
intended only for the named addressee. If you are not the named addressee you 
should not disseminate, distribute or copy this email. Please delete this email 
from your system and notify the sender immediately by replying to this email.  
If you are not the intended recipient you are notified that disclosing, 
copying, distributing or taking any action in reliance on the contents of this 
information is strictly prohibited.

The Alternative Investments division of UMB Fund Services provides a full range 
of services to hedge funds, funds of funds and private equity funds.  Any tax 
advice in this communication is not intended to be used, and cannot be used, by 
a client or any other person or entity for the purpose of (a) avoiding 
penalties that may be imposed on any taxpayer or (b) promoting, marketing, or 
recommending to another party any matter addressed herein.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: CROP PDF DOCUMENT

2016-12-29 Thread Compass - Koen Van Hooreweghe
Hi Ferdinando,

If it is a one page pdf, you could read it in a picture variable and use the 4D 
commandos to crop.

Groeten,
Koen

Verstuurd vanaf mijn iPhone 6

> Op 29 dec. 2016 om 12:21 heeft stardata.info  het 
> volgende geschreven:
> 
> Hi All,
> 
> I have one pdf documents and i want to crop a part of document, and save the 
> image cropped.
> Is possible using the 4D commands?
> 
> Thanks
> /Ferdinando/
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Quick Report -> Excel and accentuated characters v15

2016-12-29 Thread Arnaud de Montard

> Le 29 déc. 2016 à 10:53, Ortwin Zillgen  a écrit :
> 
>> Has anyone found a work-around?
> 
> export to HTML. Excel will open just fine, including all accented characters, 
> even some of the css, if applied, does survive.

Yes, seems fine. It was mentioned in my link to stack overflow discussion too. 

-- 
Arnaud de Montard 



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

Re: Quick Report -> Excel and accentuated characters v15

2016-12-29 Thread Ortwin Zillgen
> Has anyone found a work-around?

export to HTML. Excel will open just fine, including all accented characters, 
even some of the css, if applied, does survive.



Regards
O r t w i n  Z i l l g e n
-
   
 
member of developer-network 

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

Cannot connect 4D client v15R5 64-bit with 4D Server v15R5 64-bit

2016-12-29 Thread Akram Hamed
Hi,
I upgraded an application from 4D v13 to 4D v15R5.
I have 13 users under Windows 10 64-bit.

When I used the 4D Server v15R5 32-bit with 4D clients v15R5 32-bit, everything 
went very well.
But when I used the 4D Server v15R5 64-bit with 4D clients v15R5 64-bit, I got 
the following error:
-10002.

I changed the computers with Windows 7 64-bit configuration, but still the same 
error.

Any help.

Regards


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

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