• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Headerless Detail Form

Hi,

We're on OW B7321. I'm trying to get a headerless detail form to do a
'batch' insert of its rows, from the 'OK' button, into a database table.

Please, does anyone have any ideas on how I can get all the rows into one
table insert - using a loop, or something? At the moment, only the current
row is being inserted, and I can't seem to capture the rest in an If/While
statement.

Thanks,

Chinelo.
_____________________________________________________________________________________
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
 
Hi Chinelo,
Do you want to insert the Grid Rows based on your BusinessView (attached to the form, entered by the user) into the database, or you fill the Grid programatically from ER?
In first case, please check and experiment with the following settings:
1.) on Form Properties / Options...:
* No update on grid business view

2.) on Grid Properties / Options...:
* No Adds on Update Grid (?)
* Process All Rows in Grid

In the second case you can use "Get Max Grid Rows" and "Get Grid Row" system functions (Grid category) to construct your loop going through the grid rows and making your own Table I/O.

If you can describe your problem a bit detailed, maybe me/us can help you a bit more.

Please, let us know your results or further questions.
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Hi again,
Do all unique indices of the table get a unique value in the Grid?
If do not then it can cause a similar problem.
Zoltán

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

Thanks for your response.

I'm trying to fill the grid from ER, copying records from a template. The
problem is that I can't use a lot of the IO functions because the key in the
template is unique, and should not be the same as the keys in the new table,
so I can't use index filters. The unique keys in the 'copied' table are
going to be generated using a next number function. So, all I want really is
the records from the template.

Basically, I need to use a loop to pick up all the records in the grid of
the template (without its key field), generate a next number, and using that
as a key, insert the records into a new table. I hope this makes more sense.

Chinelo.
 
Re: RE: Headerless Detail Form

Hi Chinelo,
I have some additional question:
1.) What do you mean "template"? Is it an original or custom OW table or something other?
2.) Is the Business View of your form based on that table or is it a "dummy" view?
3.) Have you "Suppres(ed) Gridline(s)" in your ER with this system function?
4.) Have you already accomplished to fill the Grid Lines with your data?
5.) Do you want to enable for the user to add/delete/modify?
6.) Do you need to review Grid Lines before insrtations?
7.) Is your task to move data/records from your "template" into a OneWorld table ONLY? If your answer is yes and you don"t want user review/add/delete/modify then why do you want to use an interactive application to accomplish your task?

Please, answer my questions. My/Our helps could widely depend on your answers.

P.S.: Do you use the JDE Developers Mailing List or the Forum?
If you have never tried the Forum then try it via
http://www.jdelist.com/forums.shtml
or via the link that you will get in your post to follow your thread on the Forum.
I am answering you now from the Forum. It is GREAT, you will like it!

Good luck,
Zoltán

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