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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Filter hierarchical recordsets
- Thread starter aitor
- Start date
hi,
it is possible to do that in the design time itself with the help of data environment and meflexgrid.
suppose i'm having 2 table as follows:
author table:
---------------
1. authorcode
2. name
3. address
4. country
book table:
---------------
1. bookcode
2. book name
3. authorcode
this can be easily related by creating a commnad1 in a data environment, the author table and another command2 as command1's child with book table and relate it with the field authorcode
and in the msflexgrid, select the dataenvironmentas its datasource and command1 as its recordsource
simply execute the program.
have u got what u want, witohut any tension?
bye,
mkbalaji@yahoo.com
it is possible to do that in the design time itself with the help of data environment and meflexgrid.
suppose i'm having 2 table as follows:
author table:
---------------
1. authorcode
2. name
3. address
4. country
book table:
---------------
1. bookcode
2. book name
3. authorcode
this can be easily related by creating a commnad1 in a data environment, the author table and another command2 as command1's child with book table and relate it with the field authorcode
and in the msflexgrid, select the dataenvironmentas its datasource and command1 as its recordsource
simply execute the program.
have u got what u want, witohut any tension?
bye,
mkbalaji@yahoo.com
- Thread starter
- #3
Hi 9283476,
I have test your option with the data environment, but the problem is the same. I can´t use the .filter property of the child recordset. When you create a hierarchical recordset using SHAPE, one of the fields of the parent recordset is a recordset itself, so you cann´t access its value, and so you can not use it´s .filter property to filter it.
Thanks in any case,
Aitor.
I have test your option with the data environment, but the problem is the same. I can´t use the .filter property of the child recordset. When you create a hierarchical recordset using SHAPE, one of the fields of the parent recordset is a recordset itself, so you cann´t access its value, and so you can not use it´s .filter property to filter it.
Thanks in any case,
Aitor.
- Status