RE: Write Pro: programmatically manipulate text expertise needed

2018-06-20 Thread Piotr Chabot Stadhouders via 4D_Tech 
Hi Justin, Pat,

Using WP SELECT that is called in a method via CALL FORM seems to work, thanks 
for that!

I must say, I can't believe it's 4D's intention that we constantly have to use 
CALL FORM for thinks to work.
Maybe they implement a more sophisticated way for doing this.

Thanks again,

Piotr

> -Oorspronkelijk bericht-
> Van: Justin Carr 
> Verzonden: maandag 18 juni 2018 5:00
> Aan: 4D iNug Technical <4d_tech@lists.4d.com>
> Onderwerp: Re: Write Pro: programmatically manipulate text expertise needed
> 
> On 15 Jun 2018, at 10:01 pm, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> >
> > Hi Piotr,
> > I think you can use WP SELECT to do this - WP SELECT ( {* ;} wpArea {;
> > targetObj} | {; startRange ; endRange} )
> >
> > Let me know if you can't get that to work and I'll take a closer look at it.
> >
> > HTH
> >
> > Pat
> >
> > On Wed, 13 Jun 2018 at 07:35, Piotr Chabot Stadhouders via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> >
> >> Hi Pat,
> >>
> >> Your tips seem to work, but I am hoping you also know the answer to
> >> the next problem.
> >> See example 1 : After replacing the text with ST SET
> >> TEXT($wp_obj;$text;$start_pos;$end_pos) the cursor must be set after
> >> the last inserted character. This replacing is done in the On After
> >> Keystroke event of the Write Pro area and is triggered when the user types 
> >> a
> space.
> >> However, I don't succeed in setting the cursor at the end of the
> >> inserted text, it stays at the position where it was (position after
> >> the original
> >> space)
> >>
> >> Do you also have a tip how to set the cursor to a different position
> >> in the "On After Keystroke" event of the Pro Area?
> 
> WP SELECT is the way to go but, like many things in 4D Write Pro, you need to
> do it in a separate execution cycle (from the ST SET TEXT).
> 
> CALL FORM will work in this instance (it doesn't work in most of the instances
> where 4D Write Pro needs to complete the current execution cycle before any
> new changes can be applied).
> 
> So, have a separate method to which you pass your 4D Write Pro object and
> your $endpos and run the WP SELECT from there. Call the method after your ST
> SET TEXT using CALL FORM.
> 
> J
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Uppercase Lowercase

2018-06-20 Thread stardata.info via 4D_Tech 

Chip,

The same method that i have done

Many thanks
Ferdinando

Il 20/06/2018 21:21, Chip Scheide ha scritto:

that is the only way.
a method - something like (all code written in email so ...):


// Method: Are_They_Equal
//$1 - text - first value to compare
//$2 - text - second value to compare
// RETURNS - boolean - are the 2 texts identical (character for character)
c_text($1;$2;$First;$Second)
c_boolean($0)

$First:=$1
$Second:=$2

if (Length($First)=length($Second))

   For ($i;1;length($First_Value))
 
 if (character code($First[[$i]]) # character code($Second[[$i]])

   $i:=maxlongint -1 //exit loop
 end if
   end for

$0:= ($i # Maxlongint)



I need to a function for use in a IF statement.
For the moment, i have done a function that make a confront char by char.

Thanks
Ferdinando


Message: 1
Date: Wed, 20 Jun 2018 13:38:22 -0400
From: Chuck Miller
To: 4DTechList Tech<4d_tech@lists.4d.com>
Subject: Re: Uppercase Lowercase
Message-ID:

Content-Type: text/plain;   charset=us-ascii

If using sql you can select case sensitivity, but be careful, as it
will be set for every sql query where clause

Regards

Chuck

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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
  Jean-Paul Sartre



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Uppercase Lowercase

2018-06-20 Thread Keith Culotta via 4D_Tech 
...and check the length is =

Keith - CDI

> On Jun 20, 2018, at 2:32 PM, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> or
> C_BOOLEAN($0)
> C_TEXT($1;$2)
> $0:=(Position string ($1; $2; *) = 1)
> 
> Keith - CDI
> 
>> On Jun 20, 2018, at 2:19 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> How about
>> 
>> C_BOOLEAN($0)
>> C_TEXT($1;$2)
>> $0:=(Replace string ($1; $2; *) = “”)
>> 
>>> On Jun 20, 2018, at 3:05 PM, stardata.info  via 
>>> 4D_Tech <4d_tech@lists.4d.com > wrote:
>>> 
>>> I need to a function for use in a IF statement.
>>> For the moment, i have done a function that make a confront char by char.
>>> 
>>> Thanks
>>> Ferdinando
>>> 
>>> 
>>> Message: 1
>>> Date: Wed, 20 Jun 2018 13:38:22 -0400
>>> From: Chuck Miller>> >
>>> To: 4DTechList Tech<4d_tech@lists.4d.com >
>>> Subject: Re: Uppercase Lowercase
>>> Message-ID:
>>>  >> >
>>> Content-Type: text/plain;charset=us-ascii
>>> 
>>> If using sql you can select case sensitivity, but be careful, as it will be 
>>> set for every sql query where clause
>>> 
>>> Regards
>>> 
>>> Chuck
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: Uppercase Lowercase

2018-06-20 Thread Keith Culotta via 4D_Tech 
or
C_BOOLEAN($0)
C_TEXT($1;$2)
$0:=(Position string ($1; $2; *) = 1)

Keith - CDI

> On Jun 20, 2018, at 2:19 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> How about
> 
> C_BOOLEAN($0)
> C_TEXT($1;$2)
> $0:=(Replace string ($1; $2; *) = “”)
> 
>> On Jun 20, 2018, at 3:05 PM, stardata.info  via 
>> 4D_Tech <4d_tech@lists.4d.com > wrote:
>> 
>> I need to a function for use in a IF statement.
>> For the moment, i have done a function that make a confront char by char.
>> 
>> Thanks
>> Ferdinando
>> 
>> 
>> Message: 1
>> Date: Wed, 20 Jun 2018 13:38:22 -0400
>> From: Chuck Miller> >
>> To: 4DTechList Tech<4d_tech@lists.4d.com >
>> Subject: Re: Uppercase Lowercase
>> Message-ID:
>>   > >
>> Content-Type: text/plain;charset=us-ascii
>> 
>> If using sql you can select case sensitivity, but be careful, as it will be 
>> set for every sql query where clause
>> 
>> Regards
>> 
>> Chuck

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Uppercase Lowercase

2018-06-20 Thread Chip Scheide via 4D_Tech 
that is the only way.
a method - something like (all code written in email so ...):


// Method: Are_They_Equal
//$1 - text - first value to compare
//$2 - text - second value to compare
// RETURNS - boolean - are the 2 texts identical (character for character)
c_text($1;$2;$First;$Second)
c_boolean($0)

$First:=$1
$Second:=$2

if (Length($First)=length($Second))

  For ($i;1;length($First_Value))

if (character code($First[[$i]]) # character code($Second[[$i]])
  $i:=maxlongint -1 //exit loop
end if
  end for

$0:= ($i # Maxlongint)


> I need to a function for use in a IF statement.
> For the moment, i have done a function that make a confront char by char.
> 
> Thanks
> Ferdinando
> 
> 
> Message: 1
> Date: Wed, 20 Jun 2018 13:38:22 -0400
> From: Chuck Miller
> To: 4DTechList Tech<4d_tech@lists.4d.com>
> Subject: Re: Uppercase Lowercase
> Message-ID:
>   
> Content-Type: text/plain; charset=us-ascii
> 
> If using sql you can select case sensitivity, but be careful, as it 
> will be set for every sql query where clause
> 
> Regards
> 
> Chuck
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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 
 Jean-Paul Sartre
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Uppercase Lowercase

2018-06-20 Thread Jeffrey Kain via 4D_Tech 
How about

C_BOOLEAN($0)
C_TEXT($1;$2)
$0:=(Replace string ($1; $2; *) = “”)

> On Jun 20, 2018, at 3:05 PM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I need to a function for use in a IF statement.
> For the moment, i have done a function that make a confront char by char.
> 
> Thanks
> Ferdinando
> 
> 
> Message: 1
> Date: Wed, 20 Jun 2018 13:38:22 -0400
> From: Chuck Miller
> To: 4DTechList Tech<4d_tech@lists.4d.com>
> Subject: Re: Uppercase Lowercase
> Message-ID:
>
> Content-Type: text/plain;charset=us-ascii
> 
> If using sql you can select case sensitivity, but be careful, as it will be 
> set for every sql query where clause
> 
> Regards
> 
> Chuck
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: Uppercase Lowercase

2018-06-20 Thread stardata.info via 4D_Tech 

I need to a function for use in a IF statement.
For the moment, i have done a function that make a confront char by char.

Thanks
Ferdinando


Message: 1
Date: Wed, 20 Jun 2018 13:38:22 -0400
From: Chuck Miller
To: 4DTechList Tech<4d_tech@lists.4d.com>
Subject: Re: Uppercase Lowercase
Message-ID:

Content-Type: text/plain;   charset=us-ascii

If using sql you can select case sensitivity, but be careful, as it will be set 
for every sql query where clause

Regards

Chuck

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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 Write Pro to PDF

2018-06-20 Thread Randy Jaynes via 4D_Tech 
Armin,

I would love to try it out. I’ll raise the subject in our next development 
meeting.

I’m tired of all these PDF driver headaches on Windows over all these years, so 
a single solution that I never have to worry about installation issues and 
missing stuff on a client computer or bad Windows permission or  would definitely be a welcome relief.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Jun 20, 2018, at 1:47 PM, ADeeg via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Randy,
> 
> as mentioned before, try our plugin, within 5 minutes you have a working
> solution. It produces very small pdf files and has a lot of features on top.
> And yes the sample database has also a Write Pro area to print
> 
> The plugin comes with a silent driver installer and works from WinXP up to
> the the latest win10
> 
> http://www.node.de/indexplug.htm 
> 
> Regards Armin 
> 
> P.S.: I've tried the Win 10 internal pdf printer from 4D v16.3hf3 32Bit. The
> result produces big pdf files and the pdf files are corrupted
> 
> 
> 4D Tech mailing list wrote
>> Tim,
>> 
>> As I mentioned in my original message, I cannot use PDFCreator. So this
>> does not work for me on Windows:
>>> SET PRINT OPTION(Destination option;3;fileName)
>> 
>> as per documentation, but that was why I mentioned that I wasn't using
>> PDFCreator.
>> 
>> As per docs, It works fine on Mac, but not Windows. Which is ok. I was
>> having issues getting to the other drivers.
>> 
>> For years we’ve been doing this with 4D Write by simply changing printers
>> to
>>  Adobe PDF
>>  Win2PDF
>>  PDF995
>> 
>> Each of these print drivers provides a way to programmatically set the
>> document name so the driver works.
>> 
>> So I have managed to make this block of code work for all drivers but
>> Adobe PDF:
>> 
>>  GET PRINT OPTION(Destination option;$saveDestination;$savePath) 
>>  SET PRINT OPTION(Destination option;2;$tFullDocumentPath)
>> 
>>  WP PRINT($WriteArea;wk 4D Write Pro layout)
>> 
>>  SET PRINT OPTION(Destination option;$saveDestination;$savePath)
>> 
>> I still have to use the mechanisms that each of the printer drivers
>> themselves require for giving the driver the document path, but WP PRINT
>> still requires me to use the SET PRINT OPTION command to set the path or
>> it puts up the save as dialog to get a name even though the printer driver
>> itself doesn’t need it or use it.
>> 
>> So now all I have to do is figure out what the heck is wrong with Acrobat
>> PDF. It works fine and produces a proper PDF if I manually print and
>> choose Acrobat PDF, but generates a corrupt PDF if try to do the above
>> code programmatically.
>> 
>> The file is not readable by any application (except a text editor) AND
>> it’s 11MB in size, where the other printer drivers product a 209KB file.
>> 
>> Fun. Fun. Fun.
>> 
>> Getting there, though.
>> 
>> Randy
> 
> 
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html 
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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 Write Pro to PDF

2018-06-20 Thread Randy Jaynes via 4D_Tech 
No difference when using OPEN PRINTING JOB.

It doesn’t appear to be related to WP PRINT specifically because I’m also 
getting bad PDFs generated when trying similar code like
OPEN PRINTING JOB
PRINT SELECTION (tableptr->;*) //also tried with  ;> and no 2nd 
parameter 
CLOSE PRINTING JOB

It fails on both a Windows 10 machine and a Windows 7 machine. No clue why.

Other PDF drivers are working fine and producing better PDFs anyhow, so I’m not 
going to worry about it at the moment.

It totally appears to be an Acrobat PDF issue right now, so I’m moving on.

Thanks,
Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Jun 20, 2018, at 12:38 PM, Timothy Penner  > wrote:
> 
> It doesn’t look like you are using a printing job. 
> http://doc.4d.com/4Dv15/4D/15.6/OPEN-PRINTING-JOB.301-3818590.en.html 
> 
>  
> Does using one make any difference?
>  
> GET PRINT OPTION(Destination 
> option;$saveDestination;$savePath)   
> SET PRINT OPTION(Destination option;2;$tFullDocumentPath)
>  
> OPEN PRINTING JOB
> WP PRINT($WriteArea;wk 4D Write Pro layout)
> CLOSE PRINTING JOB
>  
> SET PRINT OPTION(Destination 
> option;$saveDestination;$savePath)
>  
> I am not sure if it will help with the corrupt PDF or not, but encapsulating 
> the print operation in a printing job has been the suggested way of printing 
> since v11.
>  
> -Tim 
>  
> 
> 
>   
> Timothy Penner
> Senior Technical Services Engineer
> Email:tpen...@4d.com 
> Web:  www.4D.com  
> 4D Inc
> 95 S. Market Street, Suite #240
> San Jose, CA 95113
> United States
> Telephone:+1-408-557-4600

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

crashing issue in v15 and v16

2018-06-20 Thread Chuck Miller via 4D_Tech 
Hi All,

In light of the wingdings issue on windows ten, I wrote the following two 
methods
Please note that if you have a write pro are on a form, the bolded line crashes 
on Macs every time. I have tried v15.6, v16r6 both 32 bit and 64 bit

Hope these help someone else out

Regards

Chuck
Begin ut_FormGetObjects


  //Method: ut_FormGetObjects
  //Description
  //
  // Parameters
  // 
If (False)
  // 
  //User name (OS): Chuck Miller
  //User (4D) : Designer
  //Date and time: 06/19/18, 16:18:44
  // 
  //Created : 
Mods_2018_06 

C_TEXT(ut_FormGetObjects ;$1)
C_POINTER(ut_FormGetObjects ;$2)
End if 
  //


C_TEXT($1;$FormName_txt)
$FormName_txt:=$1
C_POINTER($2;$ReportBlob_ptr)

$ReportBlob_ptr:=$2

ARRAY POINTER($VariableArray_aPTR;0)
C_LONGINT($Find_L;$i;$OBJType_L)
ARRAY LONGINT($pages_aL;0)
FORM GET OBJECTS($ObjectArray_atxt;$VariableArray_aPTR;$pages_aL)
C_LONGINT($ObjFontSize_L;$OBJType_L)

C_TEXT($VariableName_txt;$ObjStyleSheet_txt;$ObjFont_txt)
C_LONGINT($TableNUmber_L;$FieldNumber_L)
For ($i;1;Size of array($VariableArray_aPTR))
$VariableName_txt:=""
RESOLVE 
POINTER($VariableArray_aPTR{$i};$VariableName_txt;$TableNUmber_L;$FieldNumber_L)

$OBJType_L:=OBJECT Get type(*;$ObjectArray_atxt{$i})
$ObjStyleSheet_txt:=OBJECT Get style sheet(*;$ObjectArray_atxt{$i})
$ObjFont_txt:=OBJECT Get font(*;$ObjectArray_atxt{$i})
$ObjFontSize_L:=OBJECT Get font size(*;$ObjectArray_atxt{$i})
If ($TableNUmber_L>0)
$VariableName_txt:=Field name($TableNUmber_L;$FieldNumber_L)
End if 
TEXT TO BLOB($VariableName_txt+Char(Tab)+\
String($OBJType_L)+Char(Tab)+\
$ObjStyleSheet_txt+Char(Tab)+\
$ObjFont_txt+Char(Tab)+\
String($pages_aL{$i})+Char(Carriage return)\
;$ReportBlob_ptr->;UTF8 text without length;*)

End for 
  //End ut_FormGetObjects



Begin ut_LoadFormsAndGetInfo

  //Method: ut_LoadFormsandGetInfo
  //Description
  //
  // Parameters
  // 
If (False)
  // 
  //User name (OS): Chuck Miller
  //User (4D) : Designer
  //Date and time: 06/19/18, 16:18:02
  // 
  //Created : 
Mods_2018_06 
End if 
  //



C_TEXT($Path_txt)
C_POINTER($Table_ptr)

C_BLOB($Report_blb)
SET BLOB SIZE($Report_blb;0)

C_TEXT($FormName_txt)
C_LONGINT($Loop_l;$FormLoop_L)

ARRAY TEXT($TableForms_atxt;0)
ARRAY TEXT($VariableOrFieldName_atxt;0)

FORM GET NAMES($TableForms_atxt)
For ($FormLoop_L;1;Size of array($TableForms_atxt))
$FormName_txt:=$TableForms_atxt{$FormLoop_L}

TEXT TO BLOB($FormName_txt+Char(Carriage return);$Report_blb;UTF8 text without 
length)

FORM LOAD($TableForms_atxt{$FormLoop_L})
ut_FormGetObjects ($TableForms_atxt{$FormLoop_L};->$Report_blb)
FORM UNLOAD

End for 

For ($Loop_l;1;Get last table number)
If (Is table number valid($Loop_l))
TEXT TO BLOB(Table name($Loop_l)+Char(Carriage return);$Report_blb;UTF8 text 
without length)

ARRAY TEXT($TableForms_atxt;0)
$Table_ptr:=Table($Loop_l)
FORM GET NAMES($Table_ptr->;$TableForms_atxt)
For ($FormLoop_L;1;Size of array($TableForms_atxt))
$FormName_txt:="["+Table name($Loop_l)+"];"+$TableForms_atxt{$FormLoop_L}
TEXT TO BLOB($FormName_txt+Char(Carriage return);$Report_blb;UTF8 text without 
length)

FORM LOAD($Table_ptr->;$TableForms_atxt{$FormLoop_L})
ut_FormGetObjects ($FormName_txt;->$Report_blb)
FORM UNLOAD
End for 
End if 
End for 

C_TIME($Doc_tm)

$Doc_tm:=Create document("")

CLOSE DOCUMENT($Doc_tm)
BLOB TO DOCUMENT(Document;$Report_blb)

  //End ut_LoadFormsandGetInfo



 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)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  htt

Re: Bug in PrintList Pro v6 and only printing break levels

2018-06-20 Thread Ben Kershaw via 4D_Tech 

> On Jun 20, 2018, at 1:36 PM, Jim Hays wrote:
> 
> They recently put out a new PLPv6 beta with updates to break handling.  If
> you aren't already using that give it a try.
> PLP 6 was crashing for us with multiple break levels, the new beta is
> working well so far.

Jim,

Thanks for the reply. I tried v6.0.1b3 yesterday and it still had the issue, 
but it’s nice to hear they’re working on it. Hopefully they’ll be another beta 
soon.

Thanks,
Ben
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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 Write Pro to PDF

2018-06-20 Thread ADeeg via 4D_Tech 
Randy,

as mentioned before, try our plugin, within 5 minutes you have a working
solution. It produces very small pdf files and has a lot of features on top.
And yes the sample database has also a Write Pro area to print

The plugin comes with a silent driver installer and works from WinXP up to
the the latest win10

http://www.node.de/indexplug.htm

Regards Armin 

P.S.: I've tried the Win 10 internal pdf printer from 4D v16.3hf3 32Bit. The
result produces big pdf files and the pdf files are corrupted


4D Tech mailing list wrote
> Tim,
> 
> As I mentioned in my original message, I cannot use PDFCreator. So this
> does not work for me on Windows:
>> SET PRINT OPTION(Destination option;3;fileName)
> 
> as per documentation, but that was why I mentioned that I wasn't using
> PDFCreator.
> 
> As per docs, It works fine on Mac, but not Windows. Which is ok. I was
> having issues getting to the other drivers.
> 
> For years we’ve been doing this with 4D Write by simply changing printers
> to
>   Adobe PDF
>   Win2PDF
>   PDF995
> 
> Each of these print drivers provides a way to programmatically set the
> document name so the driver works.
> 
> So I have managed to make this block of code work for all drivers but
> Adobe PDF:
> 
>   GET PRINT OPTION(Destination option;$saveDestination;$savePath) 
>   SET PRINT OPTION(Destination option;2;$tFullDocumentPath)
> 
>   WP PRINT($WriteArea;wk 4D Write Pro layout)
> 
>   SET PRINT OPTION(Destination option;$saveDestination;$savePath)
> 
> I still have to use the mechanisms that each of the printer drivers
> themselves require for giving the driver the document path, but WP PRINT
> still requires me to use the SET PRINT OPTION command to set the path or
> it puts up the save as dialog to get a name even though the printer driver
> itself doesn’t need it or use it.
> 
> So now all I have to do is figure out what the heck is wrong with Acrobat
> PDF. It works fine and produces a proper PDF if I manually print and
> choose Acrobat PDF, but generates a corrupt PDF if try to do the above
> code programmatically.
> 
> The file is not readable by any application (except a text editor) AND
> it’s 11MB in size, where the other printer drivers product a 209KB file.
> 
> Fun. Fun. Fun.
> 
> Getting there, though.
> 
> Randy





--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Uppercase Lowercase

2018-06-20 Thread Chuck Miller via 4D_Tech 
If using sql you can select case sensitivity, but be careful, as it will be set 
for every sql query where clause

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 20, 2018, at 1:36 PM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 
> I need of a function that make a confront base even on uppercase/lowercase 
> characters.
> For example AAB must be different from aab.
> 
> How i can do?
> 
> Thanks
> Ferdinando

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

Uppercase Lowercase

2018-06-20 Thread stardata.info via 4D_Tech 

Hi All,

I need of a function that make a confront base even on 
uppercase/lowercase characters.

For example AAB must be different from aab.

How i can do?

Thanks
Ferdinando
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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 Write Pro to PDF

2018-06-20 Thread Timothy Penner via 4D_Tech 
It doesn’t look like you are using a printing job.
http://doc.4d.com/4Dv15/4D/15.6/OPEN-PRINTING-JOB.301-3818590.en.html

Does using one make any difference?

GET PRINT OPTION(Destination option;$saveDestination;$savePath)
SET PRINT OPTION(Destination option;2;$tFullDocumentPath)

OPEN PRINTING JOB
WP PRINT($WriteArea;wk 4D Write Pro layout)
CLOSE PRINTING JOB

SET PRINT OPTION(Destination option;$saveDestination;$savePath)

I am not sure if it will help with the corrupt PDF or not, but encapsulating 
the print operation in a printing job has been the suggested way of printing 
since v11.

-Tim



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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 Write Pro to PDF

2018-06-20 Thread Randy Jaynes via 4D_Tech 
Tim,

As I mentioned in my original message, I cannot use PDFCreator. So this does 
not work for me on Windows:
> SET PRINT OPTION(Destination option;3;fileName)

as per documentation, but that was why I mentioned that I wasn't using 
PDFCreator.

As per docs, It works fine on Mac, but not Windows. Which is ok. I was having 
issues getting to the other drivers.

For years we’ve been doing this with 4D Write by simply changing printers to
Adobe PDF
Win2PDF
PDF995

Each of these print drivers provides a way to programmatically set the document 
name so the driver works.

So I have managed to make this block of code work for all drivers but Adobe PDF:

GET PRINT OPTION(Destination option;$saveDestination;$savePath) 
SET PRINT OPTION(Destination option;2;$tFullDocumentPath)

WP PRINT($WriteArea;wk 4D Write Pro layout)

SET PRINT OPTION(Destination option;$saveDestination;$savePath)

I still have to use the mechanisms that each of the printer drivers themselves 
require for giving the driver the document path, but WP PRINT still requires me 
to use the SET PRINT OPTION command to set the path or it puts up the save as 
dialog to get a name even though the printer driver itself doesn’t need it or 
use it.

So now all I have to do is figure out what the heck is wrong with Acrobat PDF. 
It works fine and produces a proper PDF if I manually print and choose Acrobat 
PDF, but generates a corrupt PDF if try to do the above code programmatically.

The file is not readable by any application (except a text editor) AND it’s 
11MB in size, where the other printer drivers product a 209KB file.

Fun. Fun. Fun.

Getting there, though.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Jun 19, 2018, at 7:13 PM, Timothy Penner  > wrote:
> 
> Hi Randy
> 
>> However, I don’t seem to be able to do my 4D Write way of change
>> - switch printer to Adobe PDF / Web2Print / PDF995
>> - WR Print 
>> - switch back to normal printer
> 
> Where are you setting the filename?
> 
> Typically this is done with SET PRINT OPTION:
> http://doc.4d.com/4Dv16R4/4D/16-R4/SET-PRINT-OPTION.301-3318228.en.html 
> 
> 
> {
> Using a PDF option code (Windows)
> In order to be able to use a PDF option code in the option parameter, you 
> must have installed the PDFCreator driver in your 4D environment (for more 
> information, refer to the Integration of PDFCreator driver under Windows 
> section). Moreover, in order for option codes to be taken into account, you 
> need to have enabled control of PDF printing for 4D using the following 
> statement:
> 
> SET PRINT OPTION(Destination option;3;fileName)
> }
> 
> This KB article about printing 4D Write (not Pro) also seems to use the SET 
> PRINT OPTION:
> http://kb.4d.com/assetid=77200
> 
> -Tim
> 
> 
> 
> Timothy Penner
> Senior Technical Services Engineer
> 
> 4D Inc
> 95 S. Market Street, Suite #240
> San Jose,CA 95113
> United States
> 
> Telephone: +1-408-557-4600
> Fax:   +1-408-271-5080
> Email: tpen...@4d.com
> Web:   www.4D.com
> 

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Bug in PrintList Pro v6 and only printing break levels

2018-06-20 Thread Jim Hays via 4D_Tech 
Hi Ben,

They recently put out a new PLPv6 beta with updates to break handling.  If
you aren't already using that give it a try.
PLP 6 was crashing for us with multiple break levels, the new beta is
working well so far.

Jim Hays

On Tue, Jun 19, 2018 at 3:31 PM Ben Kershaw via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> For anyone upgrading to PrintList Pro v6 you may want to know about (what
> I think is) a bug. If you only print the break levels and not the detail
> rows using the “PL_SetColOpts” command and setting the third parameter
> (hideDetailArea) to 1, it will result in an output of “###Undefined
> value###” instead.
>
> This didn’t happen in v5, and it happens in 4D v15 and v16. I’ve reported
> it to e-node, but I thought others might want to know as well.
>
> I could be wrong and perhaps I’m configuring the PrintList area
> incorrectly, but at a minimum it’s a difference between v5 and v6.
>
> Regards,
> Ben Kershaw
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: 2 instances of 4D connected to different 4D Servers

2018-06-20 Thread Benedict, Tom via 4D_Tech 
Hi John,

>Thanks Julio.  Like you I duplicate 4D all the time to run multiple instances 
>on my Mac.
>
>On windows, however, I have been reluctant to fiddle with windows 
>installations as
>I  suspect that there are DLLs or other files installed in places that I know 
>not where.
>
>I did in fact just now try what you suggested and it works! I will do some 
>more testing, but it looks like that is the way to go.
>
>Anyone have any warnings with regard to using a duplicate of the 4D version 
>folder? For example...
>
> C:\Program Files (x86)\4D\4Dv16.0
> C:\Program Files (x86)\4D\4Dv16.0  - Copy
> put a shortcut of  C:\Program Files (x86)\4D\4D v16.0 - 
> Copy\4D\4D.exe on the desktop.

That's how I've done it for years for 4+ copies of 4D (4DDev, 4DQA, 4DUAT, 
4DTraining, 4DProduction etc). I've never had Windows complain about it. You 
can take it a step further and create .4DLink files to automate the connection 
too. Drop those in your Start Menu or Task Bar for single click access.

Tom Benedict
Optum


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**