Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

why is my view not shown in listbox

Status
Not open for further replies.

Nifrabar

Programmer
Mar 16, 2003
1,343
NL
Hi,
In the viewdesigner I created:
Code:
SELECT ALLTRIM(STR(Tfinancieel.nantwform)) AS antwform,;
  Tfinancieel.dantwdat, Tfinancieel.nbedrag,;
  IIF(Tfinancieel.lag,"Ja ","Nee") AS ag, "nog maken",;
  combineer(Tgraven.cvak,Tgraven.crij,Tgraven.cnummer,IIF(glgraffinentiteit,"*",ALLTRIM(STR(nlaag)))) AS graflokatie,;
  Tfinancieel.copmerk, Tfinancieel.nfin_id, Table22.naam;
 FROM ;
     db_kerkhof!tfinancieel ;
    LEFT OUTER JOIN db_kerkhof!tgraven ;
   ON  Tfinancieel.ngraf_id = Tgraven.ngraf_id ;
    LEFT OUTER JOIN db_kerkhof!table22 ;
   ON  Tfinancieel.nbedragsrt = Table22.id;
 WHERE  Tfinancieel.ncont_id = ( ?lnCont_ID );
   AND  Tfinancieel.nstatus = ( 1 )

this view looks OK.
I can run it from viewdesigner as well as projectmanager.

As I put this view as rowsource in a listbox the box remains empty.
The problem seems to be caused by table 22.
Here table22 is having 2 fields : I as ID, C(10)as Naam.
Table22 is just for trying as the original which should be used in left-outer join is some more complex table.
If I remove that one from the view than all remaining is shown in listbox.
I can't see why.

Any suggestions?
TIA
-Bart
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top