On Sep 26, 2006, at 8:38 PM, William Squires wrote:
Is there a way (in RB 5.2 or later - language-wise) to make a
class act like a data source (i.e. it can act as a back-end for an
SQL query, and return a RecordSet (or the modern equivalent)?) Has
anyone filed a feature request for this?
Filed moons ago
I forget when I filed this one it was so long ago
http://www.realsoftware.com/feedback/viewreport.php?reportid=lxgjpfxw
This would separate the implementation from the interface.
Then lots of thins could appear to be "database like" and htne we
could make lots of different things that fit that model.
An LDAP query and a csv parser are at least 2 items on my personal
web site that would fit well but don't because this separation does
not exist.
IMHO, it'd be better if the whole database thing were separated
into two parts; the 'model' back-end which would be provided, or
could be made as a set of classes that implement an interface (or
set of interfaces) that would allow the 'front-end' SQL parser to
'do' the SQL things one would expect. Then, one could use both the
front- and back-ends as provided, write their own back-end, write
their own front-end, or subclass either.
I'm not sure that a "sql parser" adds much.
Each database engine already has one so a front end that had one
doesn't add a lot of value.
The problem now is that all the database solutions are monolithic;
whether it's a plug-in, or a built-in class, they all handle both
the front- and back-ends of the process, making it difficult to get
a byte in edgewise... (okay, bad pun.)
The two-part scheme - it seems - would be more flexible and
extendable from what I can see. You could even hang a set of
classes to interpret a custom file format (XML, or CSV, or
whatever) onto Valentina/RBDB/MySQL/ODBC/etc... in such a way that
they could be "SQL"d (at least in a read-only fashion, if not R/W.)
At the very least, is it feasible to 'hand construct' a RecordSet?
No.
it will crash
http://www.realsoftware.com/feedback/viewreport.php?reportid=apdcftth
http://www.realsoftware.com/feedback/viewreport.php?reportid=yzbmlncg
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
