> 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]
