I also vote for adding this code to the contrib lib IMO is possible: add a Driver Structure with ability to be loaded at runtime . And a class for complete access to DMBS merging actual (hbodbc, hbmysql, hbpgsql, hbfbird) contrib libs? About The rdd syntax the insert, update, can be made "Update By Statement generating generic SQL (INSERT INTO .. VALUES ..) If update by recordset is too difficult The locking can be ignored and managed by dbms so only neterr must be implented
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lorenzo Fiorini Sent: Tuesday, October 14, 2008 8:04 AM To: Harbour Project Main Developer List. Subject: Re: [Harbour] A standard for the Harbour's SQL libs On Mon, Oct 13, 2008 at 10:10 PM, Przemyslaw Czerpak <[EMAIL PROTECTED]> wrote: > Very nice peace of code which is also very good start point for > multi RDBMS RDD API. I'll look closer into it in spare time. > Lorenzo asked about common OOP interface for different RDBMS > and this is rather starting code for Harbour SQLRDD which seems > to be much more interesting for people who want to keep existing > Clipper/xBase syntax. I'm not a C developer so I cannot say much about the code. What about adding sdd code to the contrib lib? Fitting SQL in the RDD standard is easy in the "consuming" loop. Pratically every SQL query is processed using do while !eof() ... dbskip() ... enddo so having the possibility to access columns values using alias->field syntax makes code more familiar. I see not so easy apply the RDD syntax to the insert, update, locking and query logic. However as I said we can be a multi-layers and multi-paths approach: C interfaces -> PRG classes -> USRRDDs or C interfaces -> SQLBASE or C interfaces -> C RDDs -> SQLBASE or ... Clearly this also makes things much more complex than I thought when I started the thread. best regards, Lorenzo _______________________________________________ Harbour mailing list Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour _______________________________________________ Harbour mailing list Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour
