Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #11970 > unrolled thread

Last question... I hope

Started byJeff Rollo <jrollo64@gmail.com>
First post2018-09-20 05:22 -0700
Last post2018-09-21 02:27 +0300
Articles 10 — 5 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  Last question... I hope Jeff Rollo <jrollo64@gmail.com> - 2018-09-20 05:22 -0700
    Re: Last question... I hope dlzc <dlzc1@cox.net> - 2018-09-20 07:19 -0700
    Re: Last question... I hope "Jamal" <noooospam@example.com> - 2018-09-20 12:03 -0400
      Re: Last question... I hope dlzc <dlzc1@cox.net> - 2018-09-20 09:21 -0700
        Re: Last question... I hope Jeff Rollo <jrollo64@gmail.com> - 2018-09-20 15:34 -0700
          Re: Last question... I hope "Jamal" <noooospam@example.com> - 2018-09-20 20:47 -0400
            Re: Last question... I hope Jeff Rollo <jrollo64@gmail.com> - 2018-09-20 19:19 -0700
              Re: Last question... I hope "Jamal" <nospam@example.com> - 2018-09-21 11:44 -0400
                Re: Last question... I hope Jeff Rollo <jrollo64@gmail.com> - 2018-09-21 17:40 -0700
    Re: Last question... I hope Chris Pyrgas <"chris (at)"@xsharp.eu> - 2018-09-21 02:27 +0300

#11970 — Last question... I hope

FromJeff Rollo <jrollo64@gmail.com>
Date2018-09-20 05:22 -0700
SubjectLast question... I hope
Message-ID<7dd5b67d-6e34-40ef-a7d2-6e439582f25e@googlegroups.com>
For the last few months I've had a screen (jobinfo) the had a setrelation with its sub form (Jobinfo_Details) AND ITS BEEN WORKING BEAUTIFULLY.

Jobinfo uses the CLIENT server, jobinfo_Details uses the DETAILS server. The common field in both is CLCODE. The tag in both index files is the first one in the order, and in both cases is called CLCODE.

Tonight, doing a last minute check before releasing it, I noticed the relationship no longer works. No idea why.

Is there any possibility that one of the previous changes I've made due to other questions I've had answered here could have caused this?

What do I look for please? It's been working fine for months.

I've reindexed ADAM, DELETED and recreated all databases and indexes, touched all entities and rebuilt etc. I even redesigned the entire form from scratch....

[toc] | [next] | [standalone]


#11971

Fromdlzc <dlzc1@cox.net>
Date2018-09-20 07:19 -0700
Message-ID<30ede87d-dd00-4ad1-8009-dc1c53b0ef6f@googlegroups.com>
In reply to#11970
Dear Jeff Rollo:

On Thursday, September 20, 2018 at 5:22:19 AM UTC-7, Jeff Rollo wrote:
> For the last few months I've had a screen (jobinfo)
> the had a setrelation with its sub form (Jobinfo
>_Details) AND ITS BEEN WORKING BEAUTIFULLY.
> 
> Jobinfo uses the CLIENT server, jobinfo_Details uses
> the DETAILS server. The common field in both is
> CLCODE. The tag in both index files is the first one
> in the order, and in both cases is called CLCODE.
> 
> Tonight, doing a last minute check before releasing
> it, I noticed the relationship no longer works. No
> idea why.
> 
> Is there any possibility that one of the previous
> changes I've made due to other questions I've had
> answered here could have caused this?

Yep.  You indicated that you changed from command-based code (Clipper), to object-based VO code, and one set of problems went away.  One of those commands you removed was probably SET RELATION TO (or needed to be).

https://groups.google.com/d/msg/comp.lang.clipper.visual-objects/uiH4aGRABYw/mEB-1RJpEgAJ

Since I don't do VO, I cannot help with how it is supposed to be done in VO.

> What do I look for please? It's been working fine
> for months.
> 
> I've reindexed ADAM, DELETED and recreated all
> databases and indexes, touched all entities and
> rebuilt etc. I even redesigned the entire form
> from scratch....

Don't do witchcraft.  Remember, things are always in the last place you look...

David A. Smith

[toc] | [prev] | [next] | [standalone]


#11974

From"Jamal" <noooospam@example.com>
Date2018-09-20 12:03 -0400
Message-ID<po0gcn$4g3$1@news.albasani.net>
In reply to#11970
Without providing your code, it would be hard to tell or help.

Also, an advice when you have no idea why something is not working, isolate 
the code to a minimal and try in a small sample. You'll be surprised when 
you fine it to be really a minor issue.


Jamal

"Jeff Rollo"  wrote in message 
news:7dd5b67d-6e34-40ef-a7d2-6e439582f25e@googlegroups.com...

For the last few months I've had a screen (jobinfo) the had a setrelation 
with its sub form (Jobinfo_Details) AND ITS BEEN WORKING BEAUTIFULLY.

Jobinfo uses the CLIENT server, jobinfo_Details uses the DETAILS server. The 
common field in both is CLCODE. The tag in both index files is the first one 
in the order, and in both cases is called CLCODE.

Tonight, doing a last minute check before releasing it, I noticed the 
relationship no longer works. No idea why.

Is there any possibility that one of the previous changes I've made due to 
other questions I've had answered here could have caused this?

What do I look for please? It's been working fine for months.

I've reindexed ADAM, DELETED and recreated all databases and indexes, 
touched all entities and rebuilt etc. I even redesigned the entire form from 
scratch.... 

[toc] | [prev] | [next] | [standalone]


#11975

Fromdlzc <dlzc1@cox.net>
Date2018-09-20 09:21 -0700
Message-ID<ee8e575b-e74c-49d9-820b-0edfb487b1f3@googlegroups.com>
In reply to#11974
Dear Jamal:

On Thursday, September 20, 2018 at 9:03:37 AM UTC-7, Jamal wrote:
> Without providing your code, it would be hard to
> tell or help.
> 
> Also, an advice when you have no idea why something
> is not working, isolate the code to a minimal and try
> in a small sample. You'll be surprised when you fine
> it to be really a minor issue.

Can you tell him how to set a relation between two databases in VO?  I don't do VO, and when he removed command-based instructions (like SET RELATION TO...), he might have messed up the translation...

David A. Smith

[toc] | [prev] | [next] | [standalone]


#11980

FromJeff Rollo <jrollo64@gmail.com>
Date2018-09-20 15:34 -0700
Message-ID<4fde8c3c-baeb-46f7-af96-eba02e5471c2@googlegroups.com>
In reply to#11975
Here is the code. It's been this way for months....


SELF:ViewAs(#FormView)

oSFJobInfo_DETAIL := JobInfo_DETAIL{SELF,JOBINFO_JOBINFO_DETAIL}
oSFJobInfo_DETAIL:show()
IF oSFJobInfo_DETAIL:Server != NIL 
	oSFJobInfo_DETAIL:Server:SetOrder("CLCODE")
ENDIF

self:SetSelectiveRelation(oSFJobInfo_DETAIL,#CLCODE)

oDCPCode:TextLimit := 4

self:PostInit(oWindow,iCtlID,oServer,uExtra)

return self

[toc] | [prev] | [next] | [standalone]


#11982

From"Jamal" <noooospam@example.com>
Date2018-09-20 20:47 -0400
Message-ID<po1f2f$35s$1@news.albasani.net>
In reply to#11980
First, you are checking if the server of child window is not NIL, and 
setting the order. So if it is server is NIL, the SetOrder() is never 
reached!!, then you're setting the relation and you are not checking if it 
succeeded.
Why would a child server be NIL?

Anyway, revise your code:


IF oSFJobInfo_DETAIL:Server != NIL
     if oSFJobInfo_DETAIL:Server:SetOrder("CLCODE")
            // oSFJobInfo_DETAIL:Server:GoTop()  // initially omit, then 
check it makes a difference

            if !self:SetSelectiveRelation(oSFJobInfo_DETAIL,#CLCODE)
                 InfoBox{, "Error", "Relation is not set"}:show()
            endif
    else
        InfoBox{, "Error", "Orderis  not set"}:show()
    endif
else
    InfoBox{, "Error", "Server is NIL"}:show()

endif

BTW, use the debugger to trace the code to see what's going on!


HTH,
Jamal

"Jeff Rollo"  wrote in message 
news:4fde8c3c-baeb-46f7-af96-eba02e5471c2@googlegroups.com...

Here is the code. It's been this way for months....


SELF:ViewAs(#FormView)

oSFJobInfo_DETAIL := JobInfo_DETAIL{SELF,JOBINFO_JOBINFO_DETAIL}
oSFJobInfo_DETAIL:show()
IF oSFJobInfo_DETAIL:Server != NIL
oSFJobInfo_DETAIL:Server:SetOrder("CLCODE")
ENDIF

self:SetSelectiveRelation(oSFJobInfo_DETAIL,#CLCODE)

oDCPCode:TextLimit := 4

self:PostInit(oWindow,iCtlID,oServer,uExtra)

return self 

[toc] | [prev] | [next] | [standalone]


#11983

FromJeff Rollo <jrollo64@gmail.com>
Date2018-09-20 19:19 -0700
Message-ID<7dc89944-788f-4755-a275-457e3857ffec@googlegroups.com>
In reply to#11982
Thanks Jamal. Actually, that code you referred to (Why would a server be NIL etc) is inserted automatically by VO. Not my handiwork I'm afraid. Anyway, thank you very much for your time and assistance. Thanks to your help, it's going again :)

[toc] | [prev] | [next] | [standalone]


#11985

From"Jamal" <nospam@example.com>
Date2018-09-21 11:44 -0400
Message-ID<po33kb$sl$1@gioia.aioe.org>
In reply to#11983
For the sake others in the future who may have the same issue, what part of 
my post helped you?

Jamal

"Jeff Rollo"  wrote in message 
news:7dc89944-788f-4755-a275-457e3857ffec@googlegroups.com...

Thanks Jamal. Actually, that code you referred to (Why would a server be NIL 
etc) is inserted automatically by VO. Not my handiwork I'm afraid. Anyway, 
thank you very much for your time and assistance. Thanks to your help, it's 
going again :) 

[toc] | [prev] | [next] | [standalone]


#11988

FromJeff Rollo <jrollo64@gmail.com>
Date2018-09-21 17:40 -0700
Message-ID<a2445d11-fc90-4f91-9ced-7113f994e5ed@googlegroups.com>
In reply to#11985
Hi Jamal, this bit of advice:

if !self:SetSelectiveRelation(oSFJobInfo_DETAIL,#CLCODE) 
     InfoBox{, "Error", "Relation is not set"}:show() 
            endif 
    else 
        InfoBox{, "Error", "Order is  not set"}:show() 
    endif 
else 
    InfoBox{, "Error", "Server is NIL"}:show() 

endif 

It alerted me to the fact that the CLIENT.CDX file was no longer being created.

[toc] | [prev] | [next] | [standalone]


#11981

FromChris Pyrgas <"chris (at)"@xsharp.eu>
Date2018-09-21 02:27 +0300
Message-ID<po1a8f$140n$1@gioia.aioe.org>
In reply to#11970
Are you absolutely sure the index files are in the correct place and are 
not corrupted? Maybe try recreating them (the files) from scratch, just 
in case.

Chris



> For the last few months I've had a screen (jobinfo) the had a setrelation with its sub form (Jobinfo_Details) AND ITS BEEN WORKING BEAUTIFULLY.
>
> Jobinfo uses the CLIENT server, jobinfo_Details uses the DETAILS server. The common field in both is CLCODE. The tag in both index files is the first one in the order, and in both cases is called CLCODE.
>
> Tonight, doing a last minute check before releasing it, I noticed the relationship no longer works. No idea why.
>
> Is there any possibility that one of the previous changes I've made due to other questions I've had answered here could have caused this?
>
> What do I look for please? It's been working fine for months.
>
> I've reindexed ADAM, DELETED and recreated all databases and indexes, touched all entities and rebuilt etc. I even redesigned the entire form from scratch....
>

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web