Eric Roys (offline,<[EMAIL PROTECTED]>) pointed
out that if I set my selection statement to:
( $Find Entries Entry list$ != "" ) AND (EXTERNAL( $Find
Entries Entry list$))
I wouldn't need to use an Active Link to set the default
selection. That simplifies the workflow.
For some reason
$Find Entries Entry list$ != $NULL$
did not work.
Dwayne Martin
Jamies Madison University
---- Original message ----
>Date: Thu, 27 Apr 2006 09:06:36 -0400
>From: Dwayne Martin <[EMAIL PROTECTED]>
>Subject: Re: Form freezes on display SOLVED
>To: [email protected]
>
>Found it!
>
>I have a table field that displays entries for a form with
>27,000 records. The Qualification string for the table is
>“EXTERNAL($Find Entries Entry list$).” Since $Find Entries
>Entry list$ was NULL on display the table was trying to load
>all 27K entries.
>
>I created an Active Link that on display set $Find Entries
>Entry list$ to "'Entry ID' = $NULL$" and that solved the problem.
>
>Now here’s the embarrassing part. I had an Active Link like
>that all along and for some reason I decided that it was
>obsolete and disabled it. Boy is my face red!
>
>Thanks everyone who responded. You at least pointed me in the
>right direction.
>
>Dwayne Martin
>James Madison University
>
>---------
>
>Dwayne Martin
>Computing Support
>James Madison University
>________________
>Date: Tue, 25 Apr 2006 15:17:17 -0400
>From: Dwayne Martin <[EMAIL PROTECTED]>
>Subject: Re: Form freezes on display
>To: [email protected]
>
>Thanks, Bill,
>
>I tried SQL logging, but my form has so many fields that the
>log won't print them all. It goes:
>
>*/SELECT C1,C2,C3,C4,C5,C6,C7,C8,0,C536870916,C536870927
>[etc]C563000061,C5
>63000062...
>
>I don't see the entire selection statement, or the results.
>
>I did look at all of my field names and none look like any
>Oracle reserved words, but I try checking on this further.
>
>It looks like my form is getting so big it is unworkable.
>I'll try breaking its functions into to smaller forms.
>
>Thanks again,
>Dwayne
>
>Date: Tue, 25 Apr 2006 19:02:29 -0000
>From: "Baxter, Bill" <[EMAIL PROTECTED]> Add To
>Address Book | This is Not Spam
>Subject: Re: Form freezes on display
>To: [email protected]
>
>**
>Let me restate my last suggestion. It was not a special
>character in the field name, the field was named something
>that was an Oracle reserved word.
>
>---- Original message ----
>>Date: Tue, 25 Apr 2006 18:59:54 -0000
>>From: "Baxter, Bill" <[EMAIL PROTECTED]>
>>Subject: Re: Form freezes on display
>>To: [email protected]
>>
>>Another thing to look for is a special character in a field
>name. I had
>>a similar issue once where when the query was submitted the
>character
>>caused the SQL statement to error. Have you done SQL logging?
>
>>
>
>>
>>Bill Baxter
>>Senior Consultant, Service Management
>>Business and Systems Aligned. Business Empowered.
>>BearingPoint || 115 Perimeter Center Place, NE Suite 380,
>South Terraces
>>Atlanta, GA 30346 ||
>>Office: 678.731.2750 || Mobile: 678.910.5325
>>[EMAIL PROTECTED] || www.bearingpoint.com
>>
>>
>>
>>
>>
>
>>
>>________________________________
>>
>>From: Action Request System discussion list(ARSList)
>>[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
>>Sent: Tuesday, April 25, 2006 2:42 PM
>>To: [email protected]
>>Subject: Re: Form freezes on display
>>
>>
>>**
>
>>No, that old limitation was a Windows one, back in ARS v3 or
>4. You had
>>32 MB for Windows and 64 MB for UNIX. It would save the
>record with
>>more than that, but would not re-open. Now that we have
>about a 2 GB
>>limitation, that's not a problem any more.
>>
>
>>My guess here is that there's a problem with some piece of
>workflow
>>referencing an orphaned field or a bad SQL command or something.
>>
>>
>>Rick
>>
>>
>>________________________________
>>
>>From: Action Request System discussion list(ARSList)
>>[mailto:[EMAIL PROTECTED] On Behalf Of Sylvia Holy
>>Sent: Tuesday, April 25, 2006 11:34 AM
>>To: [email protected]
>>Subject: Re: Form freezes on display
>>
>>
>>**
>
>>Hi Dwayne,
>
>>
>>I had a similiar problem several years ago with a record
>where someone
>>had pasted a huge file into the work log field. The system
>saved the
>>entry but whenever you tried to open it would freeze up. Could
>>something like have happened to your single record form?
>
>>
>>HTH,
>
>>
>>Sylvia Holy
>>
>>
>>
>>
>>
>>Dwayne Martin <[EMAIL PROTECTED]>
>
>>Sent by: "Action Request System discussion list(ARSList)"
>><[email protected]>
>
>>
>>04/25/2006 01:26 PM
>
>>Please respond to
>>[email protected]
>>
>
>>
>>
>>To
>> [email protected]
>
>>cc
>>
>
>>Subject
>> Form freezes on display
>
>>
>>
>
>>
>>
>>
>>
>>Greetings everyone,
>>
>>I was working with a form which normally has a single record.
>>Suddenly it started freezing when I tried to display that
>>record. The "Processing Search Results" window pops up, then
>>disappears and a white rectangle stays in its place, but the
>>record never appears. I have to kill the User tool. The
>>workflow.log shows no errors or loops. I can still display the
>>form in Query or Submit mode.
>
>>
>>I copied the form to another form called "DeleteMe", and
>>created a single record in the new "DeleteMe" form. It too
>>hung when I tried to display the record. There is no workflow
>>in "DeleteMe" so the problem must be in the form itself.
>>
>>I deleted all the newly-created fields and it still hung.
>
>>Then I started deleting the old fields, and it stopped hanging.
>>
>>I went back to my original form and made a "DeleteMe2" form.
>
>>This time I first deleted the old fields that I had deleted
>>from "DeleteMe", but it still hung. Then I deleted the
>>newly-created fields and it stopped hanging.
>>
>>I am totally puzzled. Any suggestions on what to look for?
>>
>>(ARS 6.3, HPUX-11 server, Oracle 9.2 db)
>>
>>Dwayne Martin
>>Computing Support
>>James Madison University
>>
>>________________________________________________________________________
>>_______
>>UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>>
>>__20060125_______________________This posting was submitted
>with HTML in
>>it___ __20060125_______________________This posting was
>submitted with
>>HTML in it___
>
>>
>>***************************************************************************************************
>>The information in this email is confidential and may be
>legally privileged. Access to this email by anyone other than
>the intended addressee is unauthorized. If you are not the
>intended recipient of this message, any review, disclosure,
>copying, distribution, retention, or any action taken or
>omitted to be taken in reliance on it is prohibited and may be
>unlawful. If you are not the intended recipient, please reply
>to or forward a copy of this message to the sender and delete
>the message, any attachments, and any copies thereof from your
>system.
>>***************************************************************************************************
>>
>>_______________________________________________________________________________
>>UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>
>Dwayne Martin
>Computing Support
>James Madison University
Dwayne Martin
Computing Support
James Madison University
