There's two regular form. For example: rf1 and rf2, add into rf1 form
four character fields with name ch1, ch2, ch4 and ch5; into rf2 form ->
ch1, ch2, ch3. Create join form jf1: join two forms rf1 with rf2
(inner), add into join form fields ch[1-5]. Join criteria: ch1 -> ch1,
ch2 -> ch2. Create next join jf2: join form jf1 with itselt (outer), add
into join form fields ch[1-5], criteria is ch3 -> ch4. Create regular
form rf3 with character field ch5. Create join form jf3: join jf2 with
rf3 (outer) , add into join form fields ch[1-5], criteria is ch5 -> ch5.
Add data in regular forms in that way it meet the criteria. Open Remedy
User, open form 'jf3' and press F5. It work. Change data in that way it
don't meet the criteria, it don't work (only mssql server 2005).

 

________________________________

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
Sent: Thursday, November 08, 2007 7:37 PM
To: arslist@ARSLIST.ORG
Subject: [SPAM] Re: [SPAM] Re: Problem with MS SQL Server 2005

 

What's your join criteria? Try removing that criteria, SAVE the join,
then put the criteria back again and SAVE it again.. Maybe for some
reason your join definition has got corrupted and recreating the join as
described might fix it.

 

Have you seen the query it runs on the SQL server when you perform a
search?

 

Joe D'Souza

        -----Original Message-----
        From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Beketov Danila
        Sent: Thursday, November 08, 2007 11:28 AM
        To: arslist@ARSLIST.ORG 
        Subject: Re: [SPAM] Re: Problem with MS SQL Server 2005

        ** 

        Each regular form have 1 record. All join form joined as outer.

         

        
________________________________


        From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
        Sent: Thursday, November 08, 2007 7:10 PM
        To: arslist@ARSLIST.ORG
        Subject: [SPAM] Re: Problem with MS SQL Server 2005

         

        Let me guess.. large tables in the join, unindexed join
criteria? Resulting in a table scan - it will eventually show the
results if you do not press Stop, but your solution is check the join
criteria and make sure that the fields in that criteria are indexed from
the AR System. A DB level index will not help the AR System to interpret
the index.

         

        Joe D'Souza

                -----Original Message-----
                From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Beketov Danila
                Sent: Thursday, November 08, 2007 9:32 AM
                To: arslist@ARSLIST.ORG
                Subject: Problem with MS SQL Server 2005

                ** 

                I have a serious problem with MS SQL Server 2005.

                 

                I create some join forms and I get data from last join
on MS SQL Server 2000.

                When I try create the same join forms and retrieve data
from its I contemplate this massage "Performing Search".

                 

                It last until I press button "Stop Search".

                 

                Anybody confronted with this problem?

                 

                I attached sample where join "6" do not work on MS SQL
Server 2005, but successfully work on MS SQL Server 2000.

__20060125_______________________This posting was submitted with HTML in
it___

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Reply via email to