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

Data selection for grid?

Mike Mackinnon

Well Known Member
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C07F0A.D2718770
Content-Type: text/plain;
charset="iso-8859-1"

Does anyone know how to get a data selection for a grid to work?

The problem I have is that the type of join for the business view I am using
does not allow me to use the QBE line to select the grid records (I can use
it but does not "filter" data records). I would like to use this field to
select only the records entered in the QBE line. Currently what is
happening is that the QBE entry is being "ignored" due to left outer join
being used in business view. Can anybody help me?


Mike MacKinnon
One World B733, SP 11.3

------_=_NextPart_001_01C07F0A.D2718770
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>Data selection for grid?</TITLE>
</HEAD>
<BODY>



<FONT SIZE=3D2 FACE=3D"Arial">Does anyone know how to get a data =
selection for a grid to work?</FONT>
</P>



<FONT SIZE=3D2 FACE=3D"Arial">The problem I have is that the type of =
join for the business view I am using does not allow me to use the QBE =
line to select the grid records (I can use it but does not =
"filter" data records). I would like to use this field =
to select only the records entered in the QBE line. Currently =
what is happening is that the QBE entry is being "ignored" =
due to left outer join being used in business view. Can anybody =
help me?</FONT></P>





<FONT SIZE=3D2 FACE=3D"Arial">Mike MacKinnon</FONT>

<FONT SIZE=3D2 FACE=3D"Arial">One World B733, SP 11.3</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C07F0A.D2718770--



One World;One World Xe; B7333; Windows NT
 

Larry_Jones

Legendary Poster
Mike,

One solution would be to add additional filtering in ER that checked for the presence of a value in the QBE column(s) and if non-blank tested for null values in the business view column(s). If null value found and column s/b filtered then hide or delete the grid row. You would place this code in the "Grid Record is Fetched" event of the Form.

Larry Jones
ljones@wagstaff.com
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
 

Zoltan_Gyimesi

Legendary Poster
Mike,
Do you use left outer join?
Does QBE ignored for all the field or only for field comming from the
"right" side?
Have you tried the filtering putting the critical BC field as FC (Form
Control) and setting the Filter properties of them accordingly? Does it
worked or also doesn't? Please let us know your answers. Thanks.
Zoltán

>

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

Mike Mackinnon

Well Known Member
Thanks for the suggestion Larry,

As I understand your response:
I can't really use the suppress/hide function for each record because I do not want to read through each record as there may be thousands of entries taking a long time time to read through suppressing each one so that only one record displays in the grid. I tried this and the "data selection" took too long to return grid values.
I appreciate your response!

Mike
One World B733,SP 11.3 (this time)

One World;One World Xe; B7333; Windows NT
 

Mike Mackinnon

Well Known Member
Re: RE: Data selection for grid?

Thanks for your response Zoltan!

Yes this is a left outer join. There is only one field being ignored on the QBE line. This is the compare column. I have tried using a hidden field value and setting filter but this does not work either. Do you have any other suggestions?

Mike MacKinnon
One World B733, SP 11.3 (This time)

One World;One World Xe; B7333; Windows NT
 

Zoltan_Gyimesi

Legendary Poster
Larry is right but use the "Suppress Grid Line" system function instead of
"hide or delete".
Zoltán

>

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

Mike Mackinnon

Well Known Member
Re: RE: Data selection for grid?

The suppress grid line takes TOO long since I have to read through every single record in the business view even if I only want to display one grid record. I don't suppose it's possible to stop fetching when a grid line record has been found??

Mike

One World;One World Xe; B7333; Windows NT
 

Zoltan_Gyimesi

Legendary Poster
Re: RE: Data selection for grid?

Mike,
What does it mean "compare column" and does it reside in the left or right side of the join? What is the data type of it (and ALIAS)?
If it is on the right side then is it the only BC on this side or exists other where the filtering isn't ignored?

About HIDDEN FC Filters:
How assign you a vallue to this field and in which event?
Have you tried without hidding and entering value manually? If yes then was the result the same?

Zoltán

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

Zoltan_Gyimesi

Legendary Poster
Re: RE: Data selection for grid?

Mike,
If you want to filter on an exact value on the "right" side then why do you use left-outer join?
About stopping fetch:
I have never tried but you can try to use "Suppress Find" system function call when you have got a hit. Please, let me know your experiences if you have tried it.

At last an other coin:
Do not use the Fetch properties of the form (suppress it) and use a Select/FetchNext or GetchSingle Table IO with your filtering, populating GB fields and inserting Grid Buffer into the grid. Please, also share your experiences if you tried it. Thanks.
Zoltán

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