Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Local view or cursoradapter?
Message
From
25/02/2005 21:22:42
Alan Harris-Reid
Baseline Data Services
Devon, United Kingdom
 
 
To
25/02/2005 12:20:44
Alan Harris-Reid
Baseline Data Services
Devon, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00990608
Message ID:
00990823
Views:
16
Thanks to all who have replied to this thread so far. Looks like subclassed CAs are the way to go, but before I dive in, I have a few more questions...

How do I get a class-based CA representing a view into a form DE? I created a test CA and stored it in a .vcx class library, but I can't work-out how to get the CA into a form DE. I've tried dragging from the class-browser but that doesn't work. Right-clicking in the DE presents an 'Add cursoradapter' menu option, but this only appears to create a CA from scratch. Once in the form.DE, is the CA automatically opened like any other table or view?

How can I open a CA view in code in the same way as USE MyView NODATA? Are there any examples of class wrapper programs around that simplify things so we can use familiar (ie, old-fashioned) syntax?

If MyCA.SelectCmd='SELECT * FROM MyTable WHERE myField=?lnMyParameter', can I still refresh a view using...
lnMyParameter = nMyValue
SELECT MyView
REQUERY()
If not, what would be the equivalent process using a CA? I've looked at the VFP help file, and can see that the CursorRefresh() method is involved, but can't quite work-out how.

I can see that I can create a CA using the builder called from a form DE, but where is the code that creates this CA stored? If created via. a form DE, can the CA only be used for that form?

Any further help would be appreciated.

Alan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform