Re: v13 on Sierra?
On Sep 21, 2016, at 6:06 PM, Douglas von Roeder wrote: > Parallels allows us to run OS X but there was a licensing issue with one > version of OS X - not sure which version (10.x.x) or if it was OS X vs OS X > Server. > > Did you see anything about that in your research? Hi Doug, Well I remember there was an issue with 10.6 and you would get a message from Parallels and not allow it. I installed 10.6 Server, I have the DVD, so I didn’t have any problem. I did a quick search and found this in Parallels KB: http://kb.parallels.com/en/112323 So it was a know issue with 10.6. This link http://kb.parallels.com/en/118806 talks about 10.9 specifically and makes no mention of it not being allowed or not working. So I think it is cool. Parallels is allowing it. If there was a problem I’m sure Parallels would have put in a software block to not allow it like they did with 10.6. Tim Tim Nevels Innovative Solutions 785-749-3444 timnev...@mac.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 v15 & Mac OS Sierra
On Sep 21, 2016, at 5:44 PM, Tom Dillonwrote: > > 4D v15.2 & Mac OS Sierra > > Is anyone else using Sierra yet and are they experiencing spinning > psychedelic pizza of death delays in the form editor? > > Clicking on a form object takes about five seconds before it's selected. Ay > ideas on what might help this or why I upgraded to Sierra so fast? The same problem has been reported many times on El Capitan, so it’s not new with Sierra. Jim Crate ** 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: Expunging Char (0)
Doug, if I am reading this correctly (http://kb.4d.com/resources/inug?msgid=GmailId14980bbd87790d18 ) - Keisuke is saying... SET TEXT TO PASTEBOARD($text) $text:=Get text from pasteboard apply to your text field(s) Also I found this on game (12 years ago - from Pat Bensky) Here is some code to strip gremlins. You might not need some bits - e.g., the removal of leading and trailing spaces. ` GremlinsRemove ` 29/01/02 pb ` Deletes "gremlins" from text -- e.g. ` embedded tabs, spaces at beg. or end, line ends etc. ` parameters: $1 = pointer to the data to be checked ` (could be a field or variable) C_TEXT($text;$tOutput) C_LONGINT($i;$length;$type) $type:=Type($1->) If (($type=Is Text ) | ($type=Is Alpha Field ) | ($type=Is String Var )) If (Length($1->)>0) $text:=$1-> ` first remove leading spaces While (Ascii($text¾1)=32) $text:=Substring($text;2) End while ` then remove all trailing spaces While (Ascii($text¾Length($text))=32) $text:=Substring($text;1;Length($text)-1) End while ` Then remove all embedded gremlins ` Nothing below ASCII 32 (space) should be allowed, except ` 13 (CR) but only in text, not strings $length:=Length($text) $tOutput:="" For ($i;1;$length) Case of : (($type=Is Text ) & (Ascii($text¾$i)=13)) ` this is allowed $tOutput:=$tOutput+$text¾$i : (Ascii($text¾$i)=13) $tOutput:=$tOutput+" " : (Ascii($text¾$i)<32) ` not allowed Else $tOutput:=$tOutput+$text¾$i End case End for $1->:=$tOutput End if ` length > 0 End if ` type = text or string On Wed, 21 Sep 2016 14:19:14 -0700, Douglas von Roeder wrote: > I've hit a situation in a legacy application that has records with alpha > and text fields that contain numerous non-printing characters. The > non-printing characters are causing non-printing. > > How do I go about finding the records the have invalid characters and > deleting the Char(0)? > > One approach would be Query by formula checking to see if the position of > Char(0)>0 but that seems to be a painfully resource intensive approach. > > Another tack would be to update the trigger code but that means I only get > cleaned up data if the record is modified. > > Thoughts, comments, suggestions, etc. on this issue are welcome. > > -- > 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 > ** ** 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: v13 on Sierra?
On Sep 21, 2016, at 4:44 PM, Chip Scheide wrote: > don't feel bad... > OS 10.6.8 and still have v2003 to support. > > As soon as I can get them to v12 (in testing now) off to 10.9 But I do feel bad and I’m missing out on some cool macOS features. Like taking calls for my iPhone on my Mac. I would really like to be able to do that. But you can’t with 10.9. Tim Tim Nevels Innovative Solutions 785-749-3444 timnev...@mac.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 v15 & Mac OS Sierra
One thing that helps: Close the Properties list. Not much help, but it might help when you just need to move things around. Tom Dillon wrote: >4D v15.2 & Mac OS Sierra > >Is anyone else using Sierra yet and are they experiencing spinning >psychedelic pizza of death delays in the form editor? > >Clicking on a form object takes about five seconds before it's selected. >Ay ideas on what might help this or why I upgraded to Sierra so fast? -- -- Tom Dillon 825 N. 500 W. DataCraft Moab, UT 84532 tomdil...@datacraft-inc.com 720/209-6502 -- It's all just 1's and 0's. You just have to get them in the right order. -- ** 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 v15 & Mac OS Sierra
4D v15.2 & Mac OS Sierra Is anyone else using Sierra yet and are they experiencing spinning psychedelic pizza of death delays in the form editor? Clicking on a form object takes about five seconds before it's selected. Ay ideas on what might help this or why I upgraded to Sierra so fast? -- -- Tom Dillon 825 N. 500 W. DataCraft Moab, UT 84532 tomdil...@datacraft-inc.com 720/209-6502 -- Dopeler Effect: the tendency of stupid ideas to seem smarter when they come at you rapidly. -- ** 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: v12 - Which is faster?
Why would you want to load record across network Let’s say I have array with 100 elements. I query with array get 100 record do a distinct values get 100 elements voila you are done do a distinct value and get 99 records OH OH you have as problem you might also query index not sure of command. With this few records, to probably doesn’t make any difference time wise but with larger selections (in tens of thousands I bet it would) 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 Sep 21, 2016, at 4:56 PM, Peter Bozekwrote: > > Not sure I understand problem, but why you want to use query at all? You > can sort selection, step through records and check if any two items are > same? ** 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: Expunging Char (0)
Doug, this might be more then you think... as I recall there are a number of non-printing characters in unicode char(0) through char(31) except Char(10), char(13) so it may not be a "simple" Query by formula([table];position(char(0);[table]field)>0) It may actually be a case of do any of the characters in any text field in my database match any of these prohibited characters in this list. I had some old code to locate and exterminate gremlins (same idea, older systems) but it does not seem to be handy. That code may have come from the nug, you could check the archives... If i find it - I'll forward it to you. Chip On Wed, 21 Sep 2016 14:19:14 -0700, Douglas von Roeder wrote: > I've hit a situation in a legacy application that has records with alpha > and text fields that contain numerous non-printing characters. The > non-printing characters are causing non-printing. > > How do I go about finding the records the have invalid characters and > deleting the Char(0)? > > One approach would be Query by formula checking to see if the position of > Char(0)>0 but that seems to be a painfully resource intensive approach. > > Another tack would be to update the trigger code but that means I only get > cleaned up data if the record is modified. > > Thoughts, comments, suggestions, etc. on this issue are welcome. > > -- > 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 > ** ** 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 **
Expunging Char (0)
I've hit a situation in a legacy application that has records with alpha and text fields that contain numerous non-printing characters. The non-printing characters are causing non-printing. How do I go about finding the records the have invalid characters and deleting the Char(0)? One approach would be Query by formula checking to see if the position of Char(0)>0 but that seems to be a painfully resource intensive approach. Another tack would be to update the trigger code but that means I only get cleaned up data if the record is modified. Thoughts, comments, suggestions, etc. on this issue are welcome. -- 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: v12 - Which is faster?
On Wed, Sep 21, 2016 at 10:44 PM, Chip Scheide <4d_o...@pghrepository.org> wrote: > Table has about 150k records > query with array is performed on table > a number of records are in selection, but always <100. > record data is in cache. > Client/Server > > It is necessary to step through the selection to insure that only one > record exists > for each array element in the query with array, and if true, do some > processing. > > Which is faster/better? > is there a difference? > > > Query([table][table]index_Field=value) > or > use set > Query selection([table];[table]Indexed_field=value) > Not sure I understand problem, but why you want to use query at all? You can sort selection, step through records and check if any two items are same? -- Peter Bozek ** 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: v12 - Which is faster?
I would modify as follows set query destination into a variable query table check variable You might also query with array distinct values. If records in selection count = query with array count and distinct values count also equals, you have only one record each 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 Sep 21, 2016, at 4:44 PM, Chip Scheide <4d_o...@pghrepository.org> wrote: > > > Query([table][table]index_Field=value) > or > use set > Query selection([table];[table]Indexed_field=value) ** 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: v12 - Which is faster?
Try both ways with a timer... but my money is on Query table without the use set. Let us know. 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: v13 on Sierra?
On Sep 21, 2016, at 2:00 PM, Douglas von Roeder wrote: > I have a customer who wants to (re)start using their 4D app on the Mac. > After reading some of the comments here, we've decided to *not* release on > V13 and are using this as the opportunity to do the upgrade to V15.x/V16. > > The primary reason for this decision is that I read multiple reports of 4D > V13.5 crashing on 10.11 when quitting or when switching applications. I was > very relieved that my client agreed with me that it's not good to release a > version of software when we know it will crash under routine use. I’m still running Mavericks 10.9.5 on my development machine. Why? Because I have one active client still running v12, and one running v13. I also have some on v14 and v15. macOS 10.9 works great with all these version of 4D. No random crashing. I would love to upgrade to a newer macOS version but I don’t want to put up with “issues” while still developing on v12 and v13. I believe I read somewhere that v16 will required macOS 10.10 as a minimum. Tim Penner, can you confirm that? So I will have to upgrade before I can use that. I’m in the process of upgrading the v13 client to v15 so that issue will resolve itself. But the v12 client is a problem. Gonna have to figure out a way to get them to upgrade. I hate being so far behind on macOS versions, but I choose a sable work environment over the new macOS versions. Tim Tim Nevels Innovative Solutions 785-749-3444 timnev...@mac.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: v13 on Sierra?
Thanks to all that replied. I will recommend to not use Sierra. Jim Labos - infobase - Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/v13-on-Sierra-tp5747493p5747498.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: v13 on Sierra?
Many years ago the Mac version of 4D had a bug that caused it to crash when the open windows were closed using option-key/closebox-click. I think of that each time I use the technique. Keith - CDI > On Sep 21, 2016, at 1:13 PM, Douglas von Roederwrote: > > Customers forget a version that was delivered late. Customers do *not* > forget a version that has bugs. > ** 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: v13 on Sierra?
Hey all, I am running my engineering company on Version 13.6 (Windows server and mostly Windows clients, but with a couple of Mac clients, including myself). Unfortunately, 13.6 running on MacOS 12 Sierra is unpredictably unstable. It is frustrating because it is almost useable, but will occasionally just quit. I can relaunch and do exactly the same thing that I was previously doing and it works just fine. I have not been able to come up with any way to predict when it will go away, it just does. Sucks! Ed Glassgow glass...@pcisys.net On 9/21/16, 12:13 PM, "4D_Tech on behalf of Douglas von Roeder" <4d_tech-boun...@lists.4d.com on behalf of dvonroe...@gmail.com> wrote: Jim: I have a customer who wants to (re)start using their 4D app on the Mac. After reading some of the comments here, we've decided to *not* release on V13 and are using this as the opportunity to do the upgrade to V15.x/V16. The primary reason for this decision is that I read multiple reports of 4D V13.5 crashing on 10.11 when quitting or when switching applications. I was very relieved that my client agreed with me that it's not good to release a version of software when we know it will crash under routine use. Customers forget a version that was delivered late. Customers do *not* forget a version that has bugs. -- Douglas von Roeder 949-336-2902 On Wed, Sep 21, 2016 at 11:03 AM, Jim Labos - infobasewrote: > I have a customer that is asking if v13 will work on Sierra. > > I admit I didn't look too hard yet but anyone know if it's at least OK (I > have v13 on El Capitan and the only problem is in desgn mode it will quit > on > me randomly but seldom). > > Thanks > > Jim Labos - infobase > > > > - > Jim Labos - infobase > -- > View this message in context: http://4d.1045681.n5.nabble. > com/v13-on-Sierra-tp5747493.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 > ** ** 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: v13 on Sierra?
Jim: I have a customer who wants to (re)start using their 4D app on the Mac. After reading some of the comments here, we've decided to *not* release on V13 and are using this as the opportunity to do the upgrade to V15.x/V16. The primary reason for this decision is that I read multiple reports of 4D V13.5 crashing on 10.11 when quitting or when switching applications. I was very relieved that my client agreed with me that it's not good to release a version of software when we know it will crash under routine use. Customers forget a version that was delivered late. Customers do *not* forget a version that has bugs. -- Douglas von Roeder 949-336-2902 On Wed, Sep 21, 2016 at 11:03 AM, Jim Labos - infobasewrote: > I have a customer that is asking if v13 will work on Sierra. > > I admit I didn't look too hard yet but anyone know if it's at least OK (I > have v13 on El Capitan and the only problem is in desgn mode it will quit > on > me randomly but seldom). > > Thanks > > Jim Labos - infobase > > > > - > Jim Labos - infobase > -- > View this message in context: http://4d.1045681.n5.nabble. > com/v13-on-Sierra-tp5747493.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 > ** ** 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 **
v13 on Sierra?
I have a customer that is asking if v13 will work on Sierra. I admit I didn't look too hard yet but anyone know if it's at least OK (I have v13 on El Capitan and the only problem is in desgn mode it will quit on me randomly but seldom). Thanks Jim Labos - infobase - Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/v13-on-Sierra-tp5747493.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: v13 - what is happening here, extra Quotation mark
yes, I think this needs to be "\\" > On Sep 21, 2016, at 9:16 AM, Tai Buiwrote: > > Hi, > > Off the top of my head, is the \ character possibly acting as an escape > character? > > Best Regards, > -Tai B. > ** > 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 **
v13 - what is happening here, extra Quotation mark
line of code: Replace string([System_Prefs]File_Storage_Location;"\";$Path_Seperator)" see quote at the end of the line? If I delete it I get an syntax error mark in the method editor hitting enter places the quote mark there?!?! Chip ** 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: v13+ - Progress component
Thanks Doug! On Tue, 20 Sep 2016 14:40:10 -0700, Douglas von Roeder wrote: > Chip: > > I you're using the 4D component, call Progress QUIT (0) to close all. > > -- > Douglas von Roeder > 949-336-2902 > > On Tue, Sep 20, 2016 at 2:03 PM, Chip Scheide <4d_o...@pghrepository.org> > wrote: > >> How do you get rid of the progress bar window (and all potentially open >> progress meters inside it) >> if the process(es) in which the progress was opened are aborted (for >> example during debugging)? >> >> >> ** >> 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 > ** ** 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 **