thefear
Technical User
- Mar 24, 2004
- 20
Hello folks,
From what I have read, on this forum and elsewhere, the Shape statement in ADO can be used to create recursive recordsets, where values extracted from a table are used to extract further
values from the same table, and so on, for as many nested statements the user has programmed.
My question is, is it possible to create an ADO Shape query, if that's the proper term for it, in which one doesn't know the number of levels to be extracted prior to run time.
Background...
I have a table of [Equipment], each of which has a unique reference Equip_No.
Each piece of equipment may be physically dependant on another piece of equipment. The Equip_No of the parent equipment is stored in the field Parent_Equip_No. So each piece of equipment points to it's parent, which points to it's parent, and so on. The parent-to-child could be two pieces of equipment long, it could be 50, (we've gotta lotta assets)
The company's DB platform is Oracle, which has the Recursive Query functionality that appeared to be what I need, however we can't submit such queries through Business Objects for business reasons, (psst! - the reason is we've literally no IT management, ! They get in consultants, buy their recommendations, one of which is never 'training for your staff', and they wonder why they're still paying the same consultants 10 years later. Good Grief!). So, I'm trying to emulate that functionality in Access so I can simulate what I think I want to create in BO.
Thanks for reading folks, and have a nice weekend.
From what I have read, on this forum and elsewhere, the Shape statement in ADO can be used to create recursive recordsets, where values extracted from a table are used to extract further
values from the same table, and so on, for as many nested statements the user has programmed.
My question is, is it possible to create an ADO Shape query, if that's the proper term for it, in which one doesn't know the number of levels to be extracted prior to run time.
Background...
I have a table of [Equipment], each of which has a unique reference Equip_No.
Each piece of equipment may be physically dependant on another piece of equipment. The Equip_No of the parent equipment is stored in the field Parent_Equip_No. So each piece of equipment points to it's parent, which points to it's parent, and so on. The parent-to-child could be two pieces of equipment long, it could be 50, (we've gotta lotta assets)
The company's DB platform is Oracle, which has the Recursive Query functionality that appeared to be what I need, however we can't submit such queries through Business Objects for business reasons, (psst! - the reason is we've literally no IT management, ! They get in consultants, buy their recommendations, one of which is never 'training for your staff', and they wonder why they're still paying the same consultants 10 years later. Good Grief!). So, I'm trying to emulate that functionality in Access so I can simulate what I think I want to create in BO.
Thanks for reading folks, and have a nice weekend.
