If you don't link the biz objects, you select unfiltered from the DB. View the link as Inner Join-operation on the database tables, or a relation in foxpro terms if you come from that area.
HTH thomas Vineet Deodhar schrieb: >> 0 1 stat1 1 >> 1 25 stat2 1 >> (actually there are 31 recored in the MySQL DB) >> That is correct. What this is saying is >> table stat is on the record with statid = 1 >> Therefore, table dist is filtered to only the records where >> > <dist.statid = 1. Even if there are 31 records in dist you will only see the > >> records that relate to the stat table PK. So whatever record you are on in >> stat will filter the records in dist. >> If you changed the stat table (moved the record pointer) so that the table >> stat had a record where statid = 2 then the dist table would be filtered to >> all the records where dist.statid = 2 would appear (there may or may not be >> records with dist.statid=2) >> > > ============================ > Thanks John. Very nice & helpful explanation indeed. > Now I can set the record pointer to any statid & then grab matching records > in 'dist' table. > > Another query in this regard -- How do I get all the records from 'dist' > table? (without getting filtered by statid=somevalue?) > ============================ > > >> And now I am getting all the 'stat' bizobj contents. >> I can seek() and setFieldVal() and save() it. >> When your program did >> "statBizObj.requery()" it retrieved the 'all' records for the table stat. If >> you add the following just below "statBizObj.requery()" >> print statBizObj.RowCount >> Please tell me what that prints - because that is the number of records that >> were retrieved. >> > ============== > it prints 13 > ============== > > Thanks, > Vineet > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > _______________________________________________ > Post Messages to: [email protected] > Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users > Searchable Archives: http://leafe.com/archives/search/dabo-users > This message: > http://leafe.com/archives/byMID/[email protected] > > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
