Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need 2 distinct cursors using same view...HOW?
Message
From
29/12/1998 09:13:25
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00170395
Message ID:
00171113
Views:
47
>Dragan,
>
>I tihnk you may have it with the AGAIN keyword...maybe I just need to leave that off. I might have been getting errors without that, but that was before I added the ALIAS deal...

OK, I've done some more tests - and AGAIN uses the same recordset. Without it, it opens a separate recordset (this sounds logical) but you either have to use a different alias or a different datasession. Of course, the parameters (if it's a p-view) should be fairly local to the procedures which open and requery them, otherwise we're into trouble requerying - I'm not sure if requerying one of them does (or doesn't) requery the other. I've tried it (without the Again), and nothing bad happened as long as I put the alias of the view in the Requery("alias") - it requeried only that one and didn't touch the other.

This is actually nice. You may have, say, case histories for two parties in the two instances of the same view, from the same table, at once.

>I actually got it working with the AGAIN by opening it in a different data session, then bringing it back to the form's data session and using it...I will try simple without the again!
>
>Well, I just tried it...and IT WORKS...I am sure I was getting errors, but that ALIAS fixes all that, and I just forgot that I didn't need the again any more!

>I must really be losing it! Thanks for your time...I think VFP is right as rain, it is I who keed further looking into! *smile*

Thank you for inspiring me to make things clear for myself :). I'd never dig into this without your puzzle.

>Joe Kaufman

And this is another puzzle - UT says I'm answering to Terry Miller...

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform