Re: V17 MSC Reports Orphaned Methods...
Okay, after a lot of testing…. I noticed that after deleting a form object and seeing MSC report the warning, on a couple of occasions the “anomaly” was cleared solely by re-launching 4D. I still would like to ensure that I have a clean, corruption-free structure and for MSC to report a clean bill of health. So, if you have any ideas on what to check, I’m all ears. BTW: I could see that the 4D Forum shows that this was an issue with an old V13 beta but was quickly fixed after being reported by Tony R. Robert > On Nov 17, 2018, at 1:10 AM, Robert ListMail via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > MSC shows that there is an anomaly...The problem is that this issue continues > after the structure repair. ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
V17 MSC Reports Orphaned Methods...
While using v17R3 (Build 17.228509) and v17.0 HF3, I noticed that my converted structure (coming from v11) that I’ve been regularly modifying during this v17 upgrade started to report anomalies via MSC Verify. To reproduce a problem I just delete a from object that was recently duplicated, just for testing and then MSC shows that there is an anomaly. On several occasions, orphaned methods (sometimes up to 93 orphaned methods) were viewable via Explorer and were deleted (and the Trash emptied) and sometimes MSC just completed the repair (seemingly without issue). However, deleting a single object (testing with two different forms) will trigger the warning: "The method resource CC4D of id 17 is not used anywhere”. The problem is that this issue continues after the structure repair. So, any thoughts on how to get a clean bill of health from MSC…? I’ve deleted all orphaned methods, repaired & compacted the structure. I’m running out of things to try. BTW: a few days ago, I noticed that I could not select buttons on a form I was working with and I could not duplicate that form either. I rebuilt that form copying some of the objects and all seemed well. MSC did not report any issues at the time. Here is one screenshot of the larger warning list…. https://www.dropbox.com/s/6wmk6nqb3qp7o8c/Screenshot%202018-11-16%2019.44.33.png?dl=0 Thanks, Robert ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Related Fields in a Listbox (Manual Relations)
Actually, "ok" and "better" are reversed in the examples. More efficient to let the Automatic Relations do the work. Keith - CDI > On Nov 16, 2018, at 1:26 PM, Sannyasin Siddhanathaswami via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Thanks. Just what I needed! > > Sannyasin Siddhanathaswami > On Nov 16, 2018, 9:09 AM -1000, Keith Culotta via 4D_Tech > <4d_tech@lists.4d.com>, wrote: > These have worked: > > // ok > GET AUTOMATIC RELATIONS($o;$m) // before the listbox displays > SET AUTOMATIC RELATIONS(True;$m) > > > // better > : (Form event=On Display Detail) // in the listbox method > RELATE ONE([many]linkField) > > Keith - CDI > > On Nov 16, 2018, at 12:54 PM, Sannyasin Siddhanathaswami via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Aloha all, > > Is there a simple way to include related field (with Manual relations) in a > current selection listbox in v17? > > Not sure why I haven’t done this before with listboxes. > > Sannyasin Siddhanathaswami > > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Related Fields in a Listbox (Manual Relations)
Thanks. Just what I needed! Sannyasin Siddhanathaswami On Nov 16, 2018, 9:09 AM -1000, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com>, wrote: These have worked: // ok GET AUTOMATIC RELATIONS($o;$m) // before the listbox displays SET AUTOMATIC RELATIONS(True;$m) // better : (Form event=On Display Detail) // in the listbox method RELATE ONE([many]linkField) Keith - CDI On Nov 16, 2018, at 12:54 PM, Sannyasin Siddhanathaswami via 4D_Tech <4d_tech@lists.4d.com> wrote: Aloha all, Is there a simple way to include related field (with Manual relations) in a current selection listbox in v17? Not sure why I haven’t done this before with listboxes. Sannyasin Siddhanathaswami ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Related Fields in a Listbox (Manual Relations)
These have worked: // ok GET AUTOMATIC RELATIONS($o;$m) // before the listbox displays SET AUTOMATIC RELATIONS(True;$m) // better : (Form event=On Display Detail) // in the listbox method RELATE ONE([many]linkField) Keith - CDI > On Nov 16, 2018, at 12:54 PM, Sannyasin Siddhanathaswami via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Aloha all, > > Is there a simple way to include related field (with Manual relations) in a > current selection listbox in v17? > > Not sure why I haven’t done this before with listboxes. > > Sannyasin Siddhanathaswami ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Related Fields in a Listbox (Manual Relations)
Aloha all, Is there a simple way to include related field (with Manual relations) in a current selection listbox in v17? Not sure why I haven’t done this before with listboxes. Sannyasin Siddhanathaswami ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: v13 - how to manage not enough stack space error
Thanks I actually have this in place due to the fact that the initial call is for one parent (i.e maternal or paternal lineage), and subsequent (recursive) calls are for both parents; however I am reluctant to use the level limit as I do not know what a 'real' limit is. With a breeding colony, the genealogy could go back many many generations, and while a limit for monkeys might be 10, a limit for mice might be 100, how many generations do you limit fruit flies, or bacteria? On Fri, 16 Nov 2018 08:46:04 +0100, Ingo Wolf via 4D_Tech wrote: > In such cases I use a longint parameter "level" to the recursive > method. On first run this parameter is set to 1 and is incremented > with every level of recursion. I then test for an arbitrary "level" > (e.g. 1000) and abort the further recursion. > > HTH > Ingo Wolf > > > 4d_tech-requ...@lists.4d.com schrieb am Thu, 15 Nov 2018 12:00:01 -0800: >> From: Chip Scheide <4d_o...@pghrepository.org> >> To: 4D iNug Technical <4d_tech@lists.4d.com> >> Subject: v13 - how to manage not enough stack space error >> Message-ID: <20181115111943838786.b0800...@pghrepository.org> >> Content-Type: text/plain; charset=us-ascii >> >> >> I have a recursive routine (genology) >> The routine is fine and works as expected - as long as the data is >> valid. >> >> I was working in my test data, which I have apparently F*&^%ed and the >> routine recurses until I get a stack error and 4D crashes (stand alone). >> >> How can I manage this so that I can exit the recursion gracefully with >> a useful(?) error message. Memory available measurements? free stack >> space? >> I.E. The operation is being truncated due to inconsistent data. >> >> Thanks >> Chip > > > -- > ViELMAC Ingo Wolf > Rheinhessenring 53A > D 55597 Wöllstein > Tel. +49 (0)6703 3070320 > Fax +49 (0)6703 3070321 > e-mail i...@vielmac.de > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Format of MySql data file
Hi Paul, Yup - that's exactly what I was actually trying to do. But I can't import the whole file in one go - it crashes - so I was hoping to break it up into more manageable sections and import them one at a time. Maybe there is some corruption in the file but I can't find where it is if I can't parse the file! Pat On Fri, 16 Nov 2018 at 08:37, Paul Dennis via 4D_Tech <4d_tech@lists.4d.com> wrote: > I would do as follows. Install a copy of mysql. Download and use heidi an > open source sql client and import the dump file file. Then you will be able > to view the "structure" and the tables/data. Heidi can export the data from > the tables you need. It's quite straightforward. Alternatively you could > use the plug-in from Pluggers to connect and replicate into 4D. It comes > with a demo method to replicate the table straight into 4D. > Paul > > > > -- > Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** -- * CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky * ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Format of MySql data file
Hi John, I've tried opening the document with Document to Text, Receive Packet, and Blob to Text. They all yield the same result. Pat On Fri, 16 Nov 2018 at 02:03, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> wrote: > Pat, > > > > > On Nov 15, 2018, at 5:18 PM, Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > I want to break this file down into individual files for each table, to > > make it more manageable. So I created a method to parse the file and > create > > a new file for each table. > > But ... > > The content all looks like gobbledygook when opened in 4D - eg: > > ,'xÃÃà> > > > You did not say how you opened it in 4D. If you used Document to text, you > need to specify right character set. If you used BLOB commands or RECEIVE > PACKET, all the possible parameters involved can lead to the problems you > are seeing. > > > > The character set is UTF-8. > > If I open it in BBEdit it looks fine (readable text). > > And the popup at the bottom in BBEdit says "UTF-8"? > > John DeSoi, Ph.D. > > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** -- * CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky * ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Format of MySql data file
I would do as follows. Install a copy of mysql. Download and use heidi an open source sql client and import the dump file file. Then you will be able to view the "structure" and the tables/data. Heidi can export the data from the tables you need. It's quite straightforward. Alternatively you could use the plug-in from Pluggers to connect and replicate into 4D. It comes with a demo method to replicate the table straight into 4D. Paul -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
