• 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!

Grid Line Suppress

DBohner-(db)

Legendary Poster
Howdy,

Recently I was working on a MOD to the P0101S, P0101SL and P01012 forms...
making the address columns in the grid QBE-able.

I wanted to get away with as little modification as possible... I added
F0116 to their Businessviews, then commented out some JDE code, and dropped
the address columns in - via the updated BSVW...

I soon realized that there can be multiple F0116 records for each F0101.
Originally I wanted to just suppress the writing of any record where the
'Beginning Effective Date' of the two tables was not equal... I tried
everything in my power - but I couldn't get the function "Suppress Grid
Line" to work.

So, now comes the question... how does the function work/not work? Is it
form-type specific?

I did get around the situation by further modding the BSVW to include
'Beginning Effective Date' ==.

Thanks for any helpful reminders.



Daniel Bohner
drbohner@existinglight.net
www.existinglight.net
JDE - XE & AS/400
JDE - B7331 & MS SQL 7x
 

Zoltan_Gyimesi

Legendary Poster
Hi Daniel,
Which event do you issue the SuppressGridLine call in?
It works always fine for me in the "Grid Record Is Fetched" event for all form types which has a grid.
Regards,
Zoltán

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

DBohner-(db)

Legendary Poster
I had tried the grid line suppress function within the "Write grid line - Before" and "Grid line is fetch" ER. It didn't work on either of them.

Then, today... I rebuild my workstation - and it suddenly works (in either ER).... Any suggestions what might have been exploding in the background?



Daniel Bohner
drbohner@existinglight.net
www.existinglight.net
JDE - XE & AS/400
JDE - B7331 & MS SQL 7x
 
Personnaly, i was'nt able to make this function work. So, if
someone does have the solution, i'll be glad to have too.
S.Viardot
Cap Gemini
XE Update2
NT 4 Service Pack 6.0A> ---------- Original Message -----------
grid line - Before" and "Grid line is fetch" ER. It didn't work on
either of them.
(in either ER).... Any suggestions what might have been exploding
in the background?
Cat=&Board=OWDEV&Number=20846
forum.

Serge Viardot
Ingénieur de Développement
Division Industrie
sviardot@capgemini.fr
 

Zoltan_Gyimesi

Legendary Poster
Hi Serge,
Would you tell a bit more about your scenario?
What type of form on?
Which event in?
etc.

Regards,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Typically, i make a logical test and use the grid suppress function
to delete line which don't match the test.
But thus function doesn't match and i should use the hind grid line
function instead.

If VA frm_Success is equal to <Zero>
Hide Grid Row(FC Grid, <Currently Selected Row>)
End If
If GC OrderNumber is equal to VA frm_DocumentOrderInvoiceE
Hide Grid Row(FC Grid, <Currently Selected Row>)
Else
VA frm_DocumentOrderInvoiceE = GC OrderNumber
End If

So if you could help me.
Cat=&Board=OWDEV&Number=20895
forum.

Serge Viardot
Ingénieur de Développement
Division Industrie
sviardot@capgemini.fr
 

Zoltan_Gyimesi

Legendary Poster
Serge,

You haven't mentioned which event do you want to use it in.
SuppressGridLine is not for deletion of an existing grid line. It prevents a fetched record to be written to the grid.
If you want to delete a line from the grid then why don't you use DeleteGridRow system function (Grid Category).
Here is the help of SuppressGridLine:
======================================================================
SuppressGridLine suppresses the current line about to be written to the grid.

Parameters

Parameter Description I/O Required Notes
Grid Grid Control.
Return Values

Return Value Description
None This does not return a value
Special Handling Instructions and Prerequisites

This function is usually used on the event GridRecordIsFetched to determine whether to allow the record to be written to the grid.
======================================================================
Hope, could help.
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Thanks, i'll test it as soon as possible
prevents a fetched record to be written to the grid.
DeleteGridRow system function (Grid Category).
====================================================================
==
to the grid.
determine whether to allow the record to be written to the grid.
====================================================================
==
Cat=&Board=OWDEV&Number=20924
forum.

Serge Viardot
Ingénieur de Développement
Division Industrie
sviardot@capgemini.fr
 
Top