Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #11970 > unrolled thread
| Started by | Jeff Rollo <jrollo64@gmail.com> |
|---|---|
| First post | 2018-09-20 05:22 -0700 |
| Last post | 2018-09-21 02:27 +0300 |
| Articles | 10 — 5 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | Jeff Rollo <jrollo64@gmail.com> |
|---|---|
| Date | 2018-09-20 05:22 -0700 |
| Subject | Last 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]
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2018-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]
| From | "Jamal" <noooospam@example.com> |
|---|---|
| Date | 2018-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]
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2018-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]
| From | Jeff Rollo <jrollo64@gmail.com> |
|---|---|
| Date | 2018-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]
| From | "Jamal" <noooospam@example.com> |
|---|---|
| Date | 2018-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]
| From | Jeff Rollo <jrollo64@gmail.com> |
|---|---|
| Date | 2018-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]
| From | "Jamal" <nospam@example.com> |
|---|---|
| Date | 2018-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]
| From | Jeff Rollo <jrollo64@gmail.com> |
|---|---|
| Date | 2018-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]
| From | Chris Pyrgas <"chris (at)"@xsharp.eu> |
|---|---|
| Date | 2018-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