Form Interconnects

[jeremey_garcia]

Hey all,

I'm trying to do a form interconnect off of a find/inspect form. I'm
looking at the "JD Edwards OneWorld A Developer's Guide" and it says to use
the grid columns. Well, I've tried that and it doesn't work. I've tried
all the combinations Grid Buffer, Business View Column, and Form
Interconnect and nothing works. Does anyone have any ideas I might be able
to try?

Thanks

Jeremey Garcia
Delta Woodside Industries
programmer/analyst
864.255.4174
[email protected]



Jeremey Garcia
Xe SP14 ES - AS/400 CO - AS/400 Deploy - NT Citrix

 

[jeremey_garcia]

This is what I get in the JDEDEBUG.LOG

Nov 12 13:57:49 ** 1900/628 SELECT * FROM TRNDTA/F55TSJG WHERE ( JGP001
= ' ' AND JGAN8 = 0.000000 AND JGMCU = ' ' ) ORDER BY JGP001 ASC,JGAN8
ASC,JGMCU ASC

my form interconnect looks like this:

GC Address Number <> mnAddressNumber
GC Category Codes - Payroll 001 <> szReportingCodesPay
GC Business Unit <> szCostCenter

where <> => the two arrows facing opposite each other.



Jeremey Garcia
Xe SP14 ES - AS/400 CO - AS/400 Deploy - NT Citrix

 

[Zoltan_Gyimesi]

Hi Jeremey,

Would you please explain us a bit more detailed what is your problem?
What kind of form type is "find/inspect"?
1.) What is the type of the caller form?
2.) What is the type of the called form?
3.) What is the Data Structure of the called form?
4.) What do you mean exactly "it doesn't work"?

Regards,
Zoltán


B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[jeremey_garcia]

I'm sorry, I messed up the detail:

The calling form is search & Select. It calls the fix/inspect form.

I searched the list and found something from February of this year on a
similar problem, but what I was trying off that didn't work as well. What I
mean as didn't work is when I click the button to call the fix/inspect form
it appears with no data.

I'm not sure what you mean by data structure. If you mean what are the key
fields, they are Address Number, Cost Center, and Cat codes (which we use to
place location in the UDC.) Before I received this request for more info I
had sent out what the JDEDEBUG.log shows as well as what my interconnect for
the calling form look like. If I still am short on info for you let me
know, and I'll try to do a better job of explaining what is (not) going on.



Jeremey Garcia
Xe SP14 ES - AS/400 CO - AS/400 Deploy - NT Citrix

 

[David Robertson]

Re: RE: Form Interconnects

Hi Jeremey,

according to your logs then, either the variables are not set up in the interconnect properly (but it looks ok in your post), or the GC values are null/zero. This will cause you to get and add form for the fix/inspect.

Is this code behind the SELECT hyper exit... button clicked?
Do you have a grid line selected when you click SELECT?

Regards,
David

 

[jeremey_garcia]

Re: RE: Form Interconnects

Morning David,

There is a row exit to click after a row is selected. So, yes a grid line is selected when I click on the row exit.

Jeremey Garcia
Xe SP14 ES - AS/400 CO - AS/400 Deploy - NT Citrix

 

[Zoltan_Gyimesi]

Re: RE: Form Interconnects

Hi Jeremey,

I also haven't received your second post before I replied your first one.

Let's see what could be the problem:
As far as I see, the table behind your Fix/Inspect form is a custom one: F55TSJG. Am I right?

I suppose, your table has a Unique Primary key. Am I right?
1.) Check your primary key in your table.
2.) Check the BSVW behind your Fix/Inspect: does it contain all the fields of the index?
3.) Open your Fix/Inspect with FDA and go Form/Data Structure.
4.) Check your interconnect Data Structure: are all the fields of your primary unique key in the beginning of your data structure with "BC" value in the first "Col/Type" column.
5.) FDA has to automatically create this data structure for you. Have you modified it?
6.) Have you any special filtering on the Fix/Inpsect (Filter Field) which can prevent the form to retrieve the record with the primary unique key passed in the data structure?
7.) Try to place the fields of the primary unique key from the BSVW (BC fields) onto your form and setup as Filter Field with EQ relation. Maybe you want to make them hidden if you don't want them to appear on the form.
8.) Finally check your Form call with Debugger that does your BC fields (field of your unique primary key) in the data structure receives the right values.

Please, let us know about your progression.

Good luck,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[jeremey_garcia]

Re: RE: Form Interconnects

Hi Zoltan,

The table is a custom table yes.

1. Primary Key is a composite key and it is unique.
2. Yes the BSVW does contain all the fields of the composite key.
4. On the calling form the unique key is all BC, however on the CALLED form they are not. They are UN
5. No, I have not modified the data structure.
6. No I have not setup filtering on the CALLED form (fix/inspect)
7. It won't let me filter on the CALLED form. Only the CALLING form.
It is already setup with an equal.
8. How do you use the debugger and where is it at? The only debugger I know about is the JDEDEBUG file.

Jeremey Garcia
Xe SP14 ES - AS/400 CO - AS/400 Deploy - NT Citrix

 

[Zoltan_Gyimesi]

Re: RE: Form Interconnects

Hi Jeremey,

Thanks for your update.

1.) You can pass the GC values of the fields of the unique index on your search and select. I have to work on this site.

2.) I suppose, the BSVW of your Fix/Inspect also contains all the field of the index.

3.) I do not know what type is UN, maybe UnKnown or UnAvailable or somtheing Un...

4.) Please, place the fields of the index from the BSVW onto the Fix/Inspect. Save/Exit FDA - re-open the APPL with FDA and check the type again, does it remained UN or does changed to BC.

Let us know what happened and will continue to work around your issue.

Read you again,
Zoltán

P.S.: You can call the "Debug Application" from the GH902 "Cross Application Development Tools" menu. It would be too long to discuss here how to use it. Please, check chapter 22th "Debugging" in your "Development Tools" documentation which is part of the OneWorld Documentation CD. If you do not have this then please, download it from the KNowledge Garden.


B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[jeremey_garcia]

RE: RE: Form Interconnects

Afternoon Zoltan,

Thanks for the suggestions.

Placing the fields from BSVW onto the form left the data structure as UN, I
tried to change the data structure manually, but it didn't like that.

I then deleted everything created a new project, file, BSVW, and forms and
tried the same procedure over again with only one field as the key and it
worked. (go figure, must be a JDE thing.) I then changed the file to have
the composite key, and recreated the BSVW. I then went to update the forms
and they didn't want to pick up the changes to the BSVW. So I destroyed the
forms and recreated them. Finally picked up the changes to the file. Tried
to pass the GC record and it didn't work. Went back and passed the BC and
it worked. I don't know why it doesn't want to pass the GC record, the book
says to pass the GC records. Or is the book wrong?



Jeremey Garcia
Xe SP14 ES - AS/400 CO - AS/400 Deploy - NT Citrix

 

[Zoltan_Gyimesi]

Re: RE: RE: Form Interconnects

Hi Jeremey,

Thanks for your update.
Very strange that GC doesn't work but BC does.
Could you confirm that passing BC values to the Fix/Inspect selecting different rows on your Search/select form the Fix/Inspect pick up different records?

On the other hand, why is your starting form Search and Select. As far as I know, the OneWorld standard is Find/Browse type to start an application.

Would you try use Find/Browse instead of Search and select?

Keep us informed. Thanks.

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[jeremey_garcia]

RE: RE: RE: Form Interconnects

Morning,

I put in a find/browse form and setup the form interconnect on it, and using
the debug I noticed that the GC variables have values, but when it goes into
the fix/inspect form the form interconnect values are still blank. So, to
me the values are not being passed. I went back and tried the BC values and
found out they aren't being passed either. Lucky me.



Jeremey Garcia
Xe SP14 ES - AS/400 CO - AS/400 Deploy - NT Citrix

 

[Zoltan_Gyimesi]

Re: RE: RE: RE: Form Interconnects

Hi Jeremey,

Thanks for your update.
I haven't currently any other idea how to resolve this issue.
Don't you think that this is the time to contact with JDE Response Line?

Please, let us know if you will be able to resolve this issue.
Good Luck!

Zoltán
P.S.: I'm really sorry that is issue remained open here.

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[Ken]

Re: RE: RE: RE: Form Interconnects

Jeremey,
What are you doing on the Called form with the passed values?
Are they being fed directly into a control or are you massaging the information before feeding them into a control?
I had a similar problem once and resolved it by moving my logic from the "Dialog is Initialized" event to the "Post Dialog" event.
The strange thing is when I did a debug in the "Dialog is Init" event, even the values that were coming through correctly did Not show.
Of course we could be comparing apples to oranges in what I was doing compared to yourself.
But thought I'd pass it on to you.

Ken
OneWorldXe B7333 SP13
Windows NT, AS400

 

[jeremey_garcia]

RE: RE: RE: RE: Form Interconnects

I am wanting to be able to update certain information. This is a learning
task, to prepare me for what we will be doing in the near future. I wanted
to be able to get this to work during the little bit of downtime I had.

As for want I was feeding them into, I want to be able to feed them directly
into a control. So let me ask a dumb question here, do I gotta have some
code on the called form to bring them in? My very limited knowledge of it
is a put the form interconnect on the calling form and when I click on the
button it is supposed to fill in the fields. Or am I understanding the book
wrong?



Jeremey Garcia
Xe SP14 ES - AS/400 CO - AS/400 Deploy - NT Citrix

 

[jeremey_garcia]

Re: RE: RE: RE: Form Interconnects

Zoltan,


You have provided me tons of help directly and indirectly. So please don't feel bad that this one was not resolved. You seem to know numerous tips, tricks and hints that I hope one day to know. So thank you for your help.

Jeremey Garcia
Xe SP14 ES - AS/400 CO - AS/400 Deploy - NT Citrix

 

[Zoltan_Gyimesi]

Re: RE: RE: RE: RE: Form Interconnects

Hi Jeremey,

Try to examine original OneWorld applications (e.g. P01012) with FDA how do they use Form Interconnect. Try the same way and if it dtill doesn't work for you then this is really the time to contact with JDE Response Line.

That's all.

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[DBohner-(db)]

Re: RE: RE: RE: RE: Form Interconnects

Jer,

I have seen this behavior - and gotten around it. I had to manually program each step of the logic.

In the OK button, grab your Currently Selected Row's Grid Collums - and shove them into variables.

Shove those variables into your Form Interconnect just like you have done.

On the Target Form - Verify that your Form Data Structure is valid (this has burnt me before)... meaning, that you have the same variable types and sequence as the calling form is sending (you probably do).

Now the manual part...!

In the POST Dialogue Is Initialized - Move add logic that, if your FI field contains a value - manually shove it into its corresponding FC field.

I have seen this repeatedly - I don't know what causes it...

Hope this helps!

Daniel Bohner
[email protected]
www.existinglight.net
JDE - XE & AS/400
JDE - B7331 & MS SQL 7x