Re: ResultSet type default to FORWARD_ONLY with mysql db ?
Frank Schönheit - Sun Microsystems Germa ny <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
Hi Alex, > It seems that the default property type for a ResultSet when connecting since there are several result set implementations, it's important to know how you obtained the one you work with. At least, what does "MsgBox resuQuery.ImplementationName" say? > Although I looked in the API, there doesn't appear to be any mention of > the default values const types that are available for certain dbs. Are > these types obtained from MetaData or are they statically assigned, i.e. > for mysql, statically assigned in the MyODBC driver ? This also depends on the implementation of your result set. Normally, if you obtained it at a higher level (say, by instantiating a css.sdb.RowSet), it should be at least SCROLL_INSENSITIVE (not absolutely sure, might be wrong on this). Other implementations (e.g. obtained directly from the driver) might behave differently. I darkly remember that the MySQL system driver supports only FORWARD_ONLY cursors, so it might well be that this restriction is just inherited by OOo's driver. Ciao Frank PS: Yes, sometimes pinging for an answer works with me, causing me to answer an unanswered message out-of-sequence :) -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -