Re: Generate Digest MD5 - Max Input File Size?
The code that was failing on the 687.6 MB file with an out of memory error follows. In order to use the Generate digest command on a file, you have to convert the file to a BLOB first. If I would have written it, I would have just read in the file directly and computing the checksum as it streamed in, but for some reason the method’s author chose to allow only BLOB or Text as input. C_POINTER($ptr_pathFilename;$1) $ptr_pathFilename:=$1 C_BLOB($blobbedDocument) DOCUMENT TO BLOB($ptr_pathFilename->;$blobbedDocument) $0:=Generate digest($blobbedDocument;MD5 digest) David Belote Colorado Springs On 10/19/16, 9:49 AM, "4D_Tech on behalf of Timothy Penner" <4d_tech-boun...@lists.4d.com on behalf of tpen...@4d.com> wrote: The docs say that Generate Digest accepts either a BLOB or a TEXT variable: http://livedoc.4d.com/4Dv15-R5/help/Command/en/page1147.html The docs also say that both Blobs and Text variables are limited to 2 GB - here are the relevant excerpts: BLOB http://livedoc.4d.com/4Dv15-R5/help/Title/en/page262.html#12745 A BLOB field or variable is a series of bytes (from 0 to 2 GB in length) that you can address individually or by using the BLOB Commands. There is no expression of type BLOB. Note: In the 4D Language Reference manual, BLOB parameters in command descriptions are denoted as BLOB. String http://livedoc.4d.com/4Dv16-R2/help/Title/en/page262.html#1211073 String is a generic term that stands for: * Alphanumeric fields or variables: an Alphanumeric field may contain from 0 to 255 characters (limit set when field is defined). * Text fields or variables: a Text field, variable, or expression may contain from 0 to 2 GB of text.. * Any String or Text expression There is no difference between a string or text variable. You can assign a string to a text field and vice-versa; 4D does the conversion, truncating if necessary. You can mix string and text in an expression. Note: In the 4D Language Reference manual, both string and text parameters in command descriptions are denoted as String, except when marked otherwise. -Tim ** 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: What's it take to get access to the Super Reports forum?
They don't seem very keen on customer service. On Wed, Oct 19, 2016 at 6:18 PM, Chuck Miller < cjmil...@informed-solutions.com> wrote: > Same as ALP now e-node.net. > > 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 > > > > > > On Oct 19, 2016, at 9:14 PM, Kirk Brookswrote: > > > > Hi guys, > > Can any SR users give me some insight into how to get support? I've got a > > project that uses SR and would like to get help. > > > > -- > > Kirk Brooks > > San Francisco, CA > > === > > ** > > 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 > ** -- Kirk Brooks San Francisco, CA === ** 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: What's it take to get access to the Super Reports forum?
Same as ALP now e-node.net. 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 > On Oct 19, 2016, at 9:14 PM, Kirk Brookswrote: > > Hi guys, > Can any SR users give me some insight into how to get support? I've got a > project that uses SR and would like to get help. > > -- > Kirk Brooks > San Francisco, CA > === > ** > 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 **
What's it take to get access to the Super Reports forum?
Hi guys, Can any SR users give me some insight into how to get support? I've got a project that uses SR and would like to get help. -- Kirk Brooks San Francisco, CA === ** 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: Tabbing into Popup Drop down List not working?
having said that, the settings doesn't seem to take effect in 4D... > 2016/10/20 9:16、Keisuke Miyakoのメール: > find the radio button on the bottom half of the screen "All controls" 宮古 啓介 セールス・エンジニア 株式会社フォーディー・ジャパン 〒150-0043 東京都渋谷区道玄坂1-10-2 渋谷THビル6F Tel: 03-6427-8441 Fax: 03-6427-8449 keisuke.miy...@4d.com www.4D.com/JP ** 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: How do you populate an Excel spreadsheet using 4D?
Steve: I wrote code to generate Excel-compatible documents using XML. The code works fine but the files that it creates get pretty large. I was able to insert formulas on the fly but couldn't create workbooks. A couple of years ago, I looked around for a way to create more robust documents and started using the plugin from Pluggers. The plugin gives me a tremendous amount of control over the output and, like all of the other products from Pluggers, it was money well spent. -- Douglas von Roeder 949-336-2902 On Wed, Oct 19, 2016 at 5:06 PM, Steve Makohinwrote: > Hi Andrea, > > Thank you for your reply. > > You describe what I've been doing as my "rolled my own" solution. I was > wondering if someone else had come to a simpler or more elegant solution. > > -Steve > > > > -Original Message- > From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Andrea > Angeli > Sent: Tuesday, October 18, 2016 11:52 AM > To: 4D iNug Technical > Subject: Re: How do you populate an Excel spreadsheet using 4D? > > Hallo Steve, > I used 4D HTML Tag using xlsx file or old excel xml file and it work fine. > You can build your own graphic in an excel document, save it in xml. Open > the file withe a text editor like text wrangler replace the cell values > with 4D HTML TAG. You can 4DTEXT and the powerful 4DLOOP if you have table > with array and 4DIF for any condition you have. Write your method open your > template file fill all your variables and arrays that are in the file then > use the command “PROCESS 4D TAGS”, save all in the new document and that’s > it! > I used also a method that write the file directly in xlsx, but it is more > complex because you have to know all the xml structure and attribute values. > > Andrea > > > > Il giorno 18 ott 2016, alle ore 06:35, Steve Makohin < > stevemako...@gmail.com> ha scritto: > > > > Does anyone know how to populate a formatted Excel spreadsheet using > > 4D, and do so under 4D's control? My preferred method is to have 4D > replace "tags" > > in the spreadsheet with its own values. I'd also prefer if someone > > already has the code to do this. I'll be coding in v14. > > > > I've written a sophisticated Excel spreadsheet generator for another > > client, but I'm wondering if there's an easier, simple way to go about > > this when the spreadsheet is of a known, fixed format. > > > > -Steve > > > ** > 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: Tabbing into Popup Drop down List not working?
http://stackoverflow.com/questions/11916847/focus-ring-on-nspopupbutton-doesnt-appear-on-pressing-tab be default, pop-up menus are not navigable by the tab key on Mac OS. you can change the behaviour by System Preferences > Keyboard > Shortcut find the radio button on the bottom half of the screen "All controls" > 2016/10/20 2:23、Janet Jonasのメール: > Anything I’m missing? 宮古 啓介 セールス・エンジニア 株式会社フォーディー・ジャパン 〒150-0043 東京都渋谷区道玄坂1-10-2 渋谷THビル6F Tel: 03-6427-8441 Fax: 03-6427-8449 keisuke.miy...@4d.com www.4D.com/JP ** 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: How do you populate an Excel spreadsheet using 4D?
Hi Andrea, Thank you for your reply. You describe what I've been doing as my "rolled my own" solution. I was wondering if someone else had come to a simpler or more elegant solution. -Steve -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Andrea Angeli Sent: Tuesday, October 18, 2016 11:52 AM To: 4D iNug Technical Subject: Re: How do you populate an Excel spreadsheet using 4D? Hallo Steve, I used 4D HTML Tag using xlsx file or old excel xml file and it work fine. You can build your own graphic in an excel document, save it in xml. Open the file withe a text editor like text wrangler replace the cell values with 4D HTML TAG. You can 4DTEXT and the powerful 4DLOOP if you have table with array and 4DIF for any condition you have. Write your method open your template file fill all your variables and arrays that are in the file then use the command “PROCESS 4D TAGS”, save all in the new document and that’s it! I used also a method that write the file directly in xlsx, but it is more complex because you have to know all the xml structure and attribute values. Andrea > Il giorno 18 ott 2016, alle ore 06:35, Steve Makohin> ha scritto: > > Does anyone know how to populate a formatted Excel spreadsheet using > 4D, and do so under 4D's control? My preferred method is to have 4D replace > "tags" > in the spreadsheet with its own values. I'd also prefer if someone > already has the code to do this. I'll be coding in v14. > > I've written a sophisticated Excel spreadsheet generator for another > client, but I'm wondering if there's an easier, simple way to go about > this when the spreadsheet is of a known, fixed format. > > -Steve ** 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 **
antivirus on intel servers
Hi All, I am sure out has been asked before but what are people running for anti virus on VM servers running 4D server 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 ** 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: Tabbing into Popup Drop down List not working?
I am not yet on v15, still on v13 from my memory - on a Mac - popups have not been tubbable. for the combo box - here is what I use for them (it is simple) Whether this can resolve your problem with them I do not know, but it might be worth a try. On Data Change is the only event turned on for the combo box Follows the combos object method: Case of : (Form event=On Data Change) //if the user made/changed combo selection utl_combo_Check_Selection (Self ;<>x_User_Option;->[Experiments]Assigned_to_Tech;->cmb_User_IDs) End case utl_combo_Check_Selection, accepts a pointer to the combo box, a text value to display if the entry is incorrect, pointer to the field or var to assign the value, and (optionally) a pointer to a secondary array which is assigned to the field/var, rather then the actual entry (basically an ID value). In the above example, [Experiments]Assigned_to_Tech will be assigned a longint User ID, rather then the User's name. The code for this method follows: //Project Method: utl_Combo_Check_Selection // $1 - pointer - to combo box to check the entered value // $2 - string - text to display in message box - what the combo is asking for // $3 - pointer (optional) - to field/var to assign value // $4 - pointer (optional) - to secondary array to assign value from //determines if the user entry in a combo box ($1) is valid. //that is doe sthe user entered value exist in the combo boxes' list //of values. If the entry is valid, either the that value, or alternatively the //corresponding secondary array value ($4) is assigned. //Returns a longint to show that the user entry was valid //RETURNS - longint - location where item was found returns -1 if not acceptable //• Updated 2/25/16 by Chip - added utility call for type check C_POINTER($1;$3;$4;$Combo;$Destination;$Secondary) C_TEXT($2;$Alert_Specifics;$Entered_Value;$msg) C_LONGINT($Loc;$0;$Type) $Combo:=$1 //combo box being edited/modified $Alert_Specifics:=$2 //text for user message if an error occurs If (Count parameters>=3) $Destination:=$3 //destination field - if provided If (Count parameters=4) $Secondary:=$4 //secondary (parallel) array to use for assigning field value - if provided Else $Secondary:=<>ptr_Nil End if Else $Destination:=<>ptr_Nil $Secondary:=<>ptr_Nil End if If ($Combo->{0}="") //if the combo box was cleared - clear the underlying field too $Loc:=Find in array($Combo->;<>x_Combo_None) //try to locate a "none" option Else //there is a value in the combo - locate it in the allowed (contents of the combo box) values $Loc:=Find in array($Combo->;$Combo->{0}) End if If ($Loc>0) //the entered/selected item was found - user elected/entered a valid value If (Not(Nil($Destination))) //there is a destination field/var to populate If (Not(Nil($Secondary))) //there is a secondary value to use $Destination->:=$Secondary->{$Loc} Else // no secondary, but there is a destination, assignment use combo array value $Destination->:=$Combo->{$Loc} End if Else // //do nothing - no additional field/var to get value for End if //assign the combo box - makes the combo entry match the text in the pop-up list $Combo->{0}:=$Combo->{$Loc} Else //the entered value is not valid If ($Combo->{0}#"") //stop message for empty item selection GOTO OBJECT($Combo->) //reset the entry area back to the combo box $Type:=Type($Combo->) //invalid entry - clear data entry area of the combo box Case of : ($Type=String array) | ($Type=Text array) $Entered_Value:=$Combo->{0} $Combo->{0}:="" : ($Type=Real array) | ($Type=Real array) | ($Type=LongInt array) | ($Type=Integer array) $Entered_Value:=String($Combo->{0}) $Combo->{0}:=0 : ($Type=Date array) $Entered_Value:=String($Combo->{0}) $Combo->{0}:=<>d_Empty_Date End case $msg:="'"+$Entered_value+"' is not an allowed "+$Alert_Specifics+<>x_Cr $msg:=$msg+"Please select a(n) "+$Alert_Specifics+", from the list." utl_msg_Alert ($msg) //tell user If (Not(Nil($Destination))) //if there is a destination specified - clear it too $Type:=Type($Destination->) Case of : (utl_type_Is_Alpha ($Destination)) //: ($Type=Is String Var) | ($Type=Is Alpha Field) | ($Type=Is Text) $Destination->:="" : (utl_type_Is_Numeric ($Destination)) //: ($Type=Is LongInt) | ($Type=Is Real) $Destination->:=0 : ($Type=Is Date) $Destination->:=<>d_Empty_Date End case End if Else //selection is empty If (Not(Nil($Destination))) //if there is a destination specified - clear it too $Type:=Type($Destination->) Case of : ($Type=Is String Var) | ($Type=Is Alpha Field) | ($Type=Is Text) $Destination->:="" : ($Type=Is LongInt) | ($Type=Is Real) $Destination->:=0 : ($Type=Is Date) $Destination->:=<>d_Empty_Date End case End if End if End if $0:=$Loc // On Wed, 19 Oct 2016 10:23:19 -0700, Janet Jonas wrote: > I have always used Combo boxes on my forms from time immemorial, but > we were having crashing issues using them in v15, and
Show Line Numbers in Printed Methods
From time to time, I generate a PDF of a method and would like to have the line numbers render in the document. Is there a way to do that from within 4D? -- Douglas von Roeder 949-336-2902 ** 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: How to determine if a SET exists?
Kirk Brooks wrote: >That being said I think the best solution for me right now is the error 39 >trap Jeremy and David and some others have suggested. Just FYI, the Save Set command saves the specified set to a document unless the set does not exist, in which case no document is created, no error is generated and OK is set to 1. So, you could call Save Set and test for the document's existence to determine if the set exists, then delete the document. Probably more work than testing for Error 39, but it's there. -- -- Tom Dillon 825 N. 500 W. DataCraft Moab, UT 84532 tomdil...@datacraft-inc.com 720/209-6502 -- Life is a great big canvas; throw all the paint you can at it. --- Danny Kaye -- ** 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: Generate Digest MD5 - Max Input File Size?
The docs say that Generate Digest accepts either a BLOB or a TEXT variable: http://livedoc.4d.com/4Dv15-R5/help/Command/en/page1147.html The docs also say that both Blobs and Text variables are limited to 2 GB - here are the relevant excerpts: BLOB http://livedoc.4d.com/4Dv15-R5/help/Title/en/page262.html#12745 A BLOB field or variable is a series of bytes (from 0 to 2 GB in length) that you can address individually or by using the BLOB Commands. There is no expression of type BLOB. Note: In the 4D Language Reference manual, BLOB parameters in command descriptions are denoted as BLOB. String http://livedoc.4d.com/4Dv16-R2/help/Title/en/page262.html#1211073 String is a generic term that stands for: * Alphanumeric fields or variables: an Alphanumeric field may contain from 0 to 255 characters (limit set when field is defined). * Text fields or variables: a Text field, variable, or expression may contain from 0 to 2 GB of text.. * Any String or Text expression There is no difference between a string or text variable. You can assign a string to a text field and vice-versa; 4D does the conversion, truncating if necessary. You can mix string and text in an expression. Note: In the 4D Language Reference manual, both string and text parameters in command descriptions are denoted as String, except when marked otherwise. -Tim ** 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: Generate Digest MD5 - Max Input File Size?
Depends on which version of 4D you’re talking about. There are now 64 bit versions for Mac and Win. Charlie > On Oct 19, 2016, at 10:18 AM, Jeffrey Kainwrote: > > 4D is a 32-bit application, so it's probably somewhere shy of 2GB since you > need to load the document into a blob in memory. How big are your files? > >> On Oct 19, 2016, at 10:08 AM, David Belote wrote: >> >> What is the maximum file size that the “Generate digest” command can process >> when computing an MD5 checksum? > > ** > 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: 4D Tags
There is no Transformation tag for this, Replace string command is your only option!. Technically, you do not have to “replace” the line breaks, HTML ignores them, just add the tags is all that’s required. Keeping the line breaks is beneficial if you ever won’t to inspect the finished HTML in a text editor. Charlie Vass 4D TS > On Oct 19, 2016, at 12:57 AM, Sujit Shahwrote: > > Is there a 4D Transformation tag that will replace "\r" with Line Breaks > ? > > Or do I need to do a > > Replace text (VarName;"\r";"") > > and use > ** > > -- > > xxx > "There must be ingenuity as well as intention, strategy as well as > strength. " > ** > 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: Generate Digest MD5 - Max Input File Size?
4D is a 32-bit application, so it's probably somewhere shy of 2GB since you need to load the document into a blob in memory. How big are your files? > On Oct 19, 2016, at 10:08 AM, David Belotewrote: > > What is the maximum file size that the “Generate digest” command can process > when computing an MD5 checksum? ** 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 **