Lantica User Forum - [DUP] Sesame 1.1.5a Crash

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › [DUP] Sesame 1.1.5a Crash

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: 1

Send Topic

Print

Hot Topic (More than 10 Replies)

[DUP] Sesame 1.1.5a Crash (Read 1489 times)

drastixnz Full Member Offline A Newbie.... Posts: 146 Location: New Zealand Joined: Nov 29^th, 2006	[DUP] Sesame 1.1.5a Crash Sep 17^th, 2007 at 10:23pm	Print Post
	Duplicate of issue reported here Hi All, I have a subform that has a relational link, and when I enter =;/= into the Keyword field, or even .. the program crashes. I have closed down everything on my laptop but no luck Help, as i am now stuck until I get this issue fixed. Drastixnz EDIT: When i enter =;/= into the Keyword filed which is linked to the subfrom to another keyword field I push F10 then it crashes
	« Last Edit: Sep 18^th, 2007 at 8:49pm by Hammer »

	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Sesame 1.1.5a Crash Reply #1 - Sep 17^th, 2007 at 10:35pm	Print Post
	You're using a field of type Keyword as your key field? Is that on the parent, the child or both?

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

drastixnz Full Member Offline A Newbie.... Posts: 146 Location: New Zealand Joined: Nov 29^th, 2006	Re: Sesame 1.1.5a Crash Reply #2 - Sep 17^th, 2007 at 10:39pm	Print Post
	hi Hammer I had a Keyword field as a key field on both forms. I have just tried on the parent form a keyword as the key feild, and i linked to a date field on the subform, but still crashed Regards


	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Sesame 1.1.5a Crash Reply #3 - Sep 17^th, 2007 at 10:42pm	Print Post
	Try linking to a Text field at both ends. Does that fix it?

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

drastixnz Full Member Offline A Newbie.... Posts: 146 Location: New Zealand Joined: Nov 29^th, 2006	Re: Sesame 1.1.5a Crash Reply #4 - Sep 17^th, 2007 at 10:47pm	Print Post
	No it does not.


	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Sesame 1.1.5a Crash Reply #5 - Sep 17^th, 2007 at 10:55pm	Print Post
	You may have a bad record. Can you send the app into Support so they can run it through the debugger?

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

drastixnz Full Member Offline A Newbie.... Posts: 146 Location: New Zealand Joined: Nov 29^th, 2006	Re: Sesame 1.1.5a Crash Reply #6 - Sep 17^th, 2007 at 11:01pm	Print Post
	Do you just want the DSR? and what is the email address i need to send it to?


	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Sesame 1.1.5a Crash Reply #7 - Sep 17^th, 2007 at 11:05pm	Print Post
	Whichever is crashing. DSR/DDT or DB/DAT. Send it to support@lantica.com along with any passwords they need and instructions for how to make it happen.

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

drastixnz Full Member Offline A Newbie.... Posts: 146 Location: New Zealand Joined: Nov 29^th, 2006	Re: Sesame 1.1.5a Crash Reply #8 - Sep 17^th, 2007 at 11:08pm	Print Post
	Hi, I have just tried the same thing with a blank database. it crashes. Drastixnz


	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Sesame 1.1.5a Crash Reply #9 - Sep 17^th, 2007 at 11:10pm	Print Post
	drastixnz wrote on Sep 17^th, 2007 at 11:08pm: Hi, I have just tried the same thing with a blank database. it crashes. Send it in and we'll find out why.

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

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Sesame 1.1.5a Crash Reply #10 - Sep 18^th, 2007 at 8:45pm	Print Post
	Hello Drastixnz, Remove the default retrieve spec on the subform and the problem will not happen. The problem is that the default retrieve spec on the subform is using a programmed retrieve spec, It's the same problem that was reported in the thread http://www.lantica.com/Forum3/cgi-bin/yabb2/YaBB.pl?num=1189742964 If you are trying to use a retrieve spec in the subform to hide sub-records that are not in a particular date range, it is not going to work. A retrieve spec in a subform only says Retrieve all parents where one or more of the subrecords matches the criteria specified here. When the Parent records are retrieved they will display all of their records, not just the ones that match the retrieve criteria that caused the Parent to be retrieved in the first place. One way to look at is like a Gym full of families. The Family is the parent record and each family member is a subrecord of the family. If you say will each family(Parent form) with a family member(Child form) less than three years old please stand up, the entire family is going to stand up. The retrieve spec of less than three years old is run against each family member(Child records) in each family(Parent Records) and if one of them is less than three years old the condition is met, so that family stands up. If you need more explanation let me know. -Ray

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

drastixnz Full Member Offline A Newbie.... Posts: 146 Location: New Zealand Joined: Nov 29^th, 2006	Re: [DUP] Sesame 1.1.5a Crash Reply #11 - Sep 19^th, 2007 at 7:25pm	Print Post
	Thank you for your help, i removed it an it now worked. I am now wondering why did it start doing that because I have had that in there for a while.


	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