Lantica User Forum - [BRF] Subform retrieve crashing

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › [BRF] Subform retrieve crashing

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: 1

Send Topic

Print

Hot Topic (More than 10 Replies)

[BRF] Subform retrieve crashing (Read 1740 times)

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	[BRF] Subform retrieve crashing Sep 14^th, 2007 at 4:09am	Print Post
	Bug Report Filed. Related to having a programmed retrieve in the subform combined with a parent retrieve. In many cases, can be avoided by using the pipe syntax described in this thread. New database design, Version 2.0.2 One parent record, one record in subform Retrieve specs and results: Parent: LastName = "/=" works OK, one records found Parent: LastName = "=" works OK, no records found Child: Date = "9/12/2007" works OK, one record found Child: Date = ">8/31/07..<10/1/07" works OK, one record found Child: Date = ">{ (@date-30) }" works OK, one record found Parent = "/=" AND Child/Date = "/=" works OK, one record found Parent = "/=" AND Child/Date = ">8/31/07..<10/1/07" works OK, one record found Parent = "/=" AND Child/Date = ">{ (@date-30) }" crashes Sesame Is there some type of rule I am breaking? Why does this combination crash when other combos are OK and just Parent/Child retrieves are OK
	« Last Edit: Sep 16^th, 2007 at 1:04am by Hammer »
	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Subform retrieve crashing Reply #1 - Sep 14^th, 2007 at 11:18am	Print Post
	Main difference I see is that the child retrieve is programmed, but the parent is not. Might be causing the flag that tells us we need to compile a programmed retrieve to be in the wrong state at some point. We'll run it through the debugger and see what's up.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Subform retrieve crashing Reply #2 - Sep 14^th, 2007 at 1:23pm	Print Post
	Thanks Erika .....

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Ben Lantica Support Offline Posts: 218 Joined: Apr 7^th, 2005	Re: Subform retrieve crashing Reply #3 - Sep 14^th, 2007 at 2:17pm	Print Post
	Hi Bob, We documented your crash and reported it to development. In the meantime, you should be able to use ">\|@Date - 30\|" in your subform without a problem. It will also run faster than your programmed retrieve spec. -Ben


	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Subform retrieve crashing Reply #4 - Sep 14^th, 2007 at 2:56pm	Print Post
	That works for now, thanks. Glad to know it wasn't me. Sometimes the simplest things are difficult when you work too long on them.

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Subform retrieve crashing Reply #5 - Sep 14^th, 2007 at 3:04pm	Print Post
	Bob_Hansen wrote on Sep 14^th, 2007 at 2:56pm: That works for now, thanks. Incidentally, the method Ben gave you is the one you want to be using anyway. It is much much much faster than using the {} syntax when you don't need to refer to field values.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Subform retrieve crashing Reply #6 - Sep 14^th, 2007 at 5:49pm	Print Post
	And that is documented in which manual/page? Searching for pipe did not bring up this syntax, and found no reference about the speed benefits.

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Subform retrieve crashing Reply #7 - Sep 14^th, 2007 at 6:14pm	Print Post
	Bob_Hansen wrote on Sep 14^th, 2007 at 5:49pm: And that is documented in which manual/page? Searching for pipe did not bring up this syntax, and found no reference about the speed benefits. User Guide - page 282.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Subform retrieve crashing Reply #8 - Sep 14^th, 2007 at 8:15pm	Print Post
	My User Guide, p 282 is only for Max and Min I went through the whole Search section and saw no mention of programmed criteria effect on speed. I went through the whole Search group of pages, and found no pipe "\|" character as provided in Ben's formula. ">\|@Date - 30\|" does have two pipe chars, correct? Do I have the wrong manual? Searched pp 271-30? Programmed Searches started on 303. Do I have a different font?

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Subform retrieve crashing Reply #9 - Sep 14^th, 2007 at 8:17pm	Print Post
	You have the wrong manual. You have the older one which is not the same as the printed one or the one included in the 2.0.1 or 2.0.2 Full Sesame Installs. -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Subform retrieve crashing Reply #10 - Sep 14^th, 2007 at 8:20pm	Print Post
	Bob_Hansen wrote on Sep 14^th, 2007 at 8:15pm: Do I have the wrong manual? The User Guide got quite a few updates after the Conference. If you download the current manuals or order the printed versions, you'll have the right page numbers.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Subform retrieve crashing Reply #11 - Sep 14^th, 2007 at 9:31pm	Print Post
	Aaargh! Wrong manuals .... Big Dummy here ...... I did not see a separate download for manuals only so I downloaded full package. When installing, was not offered any prompts and many files in my folders were overwritten without warning. I missed the note on the download page. Will have to use last night's backup to restore some. BUT... on page 282 of the User Guide, (just as you said) I found excellent explanation of the pipe and the speed-performance issues. I don't recall hearing about any of that during beta test, but perhaps I missed that class. There are so many new features, that I am still seeing new things every day. Just like this! Thanks again for your patience, and excellent support.

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Carl Underwood Senior Member Members Offline Posts: 1351 Location: New Hampshire Joined: Mar 11^th, 2003	Re: Subform retrieve crashing Reply #12 - Sep 15^th, 2007 at 5:27am	Print Post
	Bob_Hansen wrote on Sep 14^th, 2007 at 9:31pm: Aaargh! �Wrong manuals .... �Big Dummy here ...... Don't feel bad Bob. A few days ago, I reported some typos in the manuals, only to find out that I was using old ones that were from the conference disk. And I did install the full version from the most recent release. But, the problem was that I had shortcuts on my desktop for each PDF, and the new files use underscores instead of spaces in the filenames. Well, I blissfully kept using the same shortcuts, not thinking that the filenames would be different. Needless to say, I have since changed the shortcuts.

	Carl Underwood CDU Computer Consulting LLC Epsom, New Hampshire
	WWW IP Logged

Page Index Toggle

Pages: 1

Send Topic

Print

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid XHTML

Valid CSS

Powered by Perl

Source Forge