General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only