On Fri, 2 Dec 2005, Luiz Americo wrote:
> > De: Michael Van Canneyt <[EMAIL PROTECTED]> > > >> How about sqliteds? > > > > I'm still working on that; I'm using the components for an article, > > so you can be sure that. > > Fixing it's easy. I can do that. > > > But there were some more problems with > > sqliteds. It doesn't recognize VARCHAR fields, for instance. > > This issue was discussed ealier in this list. > See http://article.gmane.org/gmane.comp.ide.lazarus.general/1401 > > Anyway i'd like to know your thoughs Well, I have the following SQL CREATE TABLE PUPIL ( PU_ID INTEGER NOT NULL, PU_FIRSTNAME VARCHAR(50) NOT NULL, PU_LASTNAME VARCHAR(50) NOT NULL, CONSTRAINT PUPIL_PK PRIMARY KEY (PU_ID) ); And TSQliteDataset doesn't eat SELECT * FROM PUPIL; I fixed TSQLIteDataset already so it works with this and with CHAR(10) definitions as well. Changing the creation SQL to something Sqlite-Specific was not an option, it must be used for various other databases as well. > > > I also patched the lazsqlite package so it can install sqlite3 > > support. As soon as everything works to satisfaction, I'll commit the > > stuff. > > I already upgraded the sqlite package to use sqlite3 among other > improvements. > See http://article.gmane.org/gmane.comp.ide.lazarus.general/1379. > Since it's necessary fpc201 or newer this would break fpc200 support. > I'm waiting for fpc202 to send to Lazarus Excellent. > > > > But I'm open for reverting the patch, if we have a solution for all > > these datasets out there... > > The only issue i have is the overhead, but if there's no other solution > we ca live with that. For the FPC specific datasets, there is no overhead. The overhead is only there for older TDataset implementations, For me this is is acceptable. They should use modern implementations if they want to speed things up a bit. Michael. _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
