Glen,
I understand the concept and the need for working with limited dataset. I just have to educate my customers that they no longer can browse through the entire 200,000 records table <g>.
I was wondering if I could ask you another question. Here is how I plan to use CA's to create cursors for the database tables:
1. Add a property .oCaCollection to the form. Object reference to each CA should be in scope for the life of the form so I want to use the form property for that.
2. Add element to collection .oCaCollection for every CA/table I need to open in the form.
3. In LOAD method of the form create all CA's/cursors keeping the reference of each CA to an element in .oCaCollection.
4. When form is closed, in UNLOAD method, release all CA objects.
Does this make sense?
Dmitry
>Hi Dimitry.
> With CA's you are going to have to get use to only populating the Cursor with limited datasets, rather than the whole table. It is different mindset.
>Regards,
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham