Re: [dba-dev] SetBlob.... ( was Re: setBlog not implemented for preparedStatement in HSQLdb SDBC driver)
Hi Ocke, I thought that I fixed that one in a DEV320 but that doesn't seem to be. So please submit an issue for it. Thanks. Wasn't that in one of the dba33? CWS', i.e. for 3.3 only? Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] SetBlob.... ( was Re: setBlog not implemented for preparedStatement in HSQLdb SDBC driver)
Hi all, Ezzel a dátummal: Tuesday 09 February 2010 19.00.32 Drew Jensen ezt írta: On 2/9/2010 11:53 AM, Frank Schoenheit, Sun Microsystems Germany wrote: Hi Ocke, I thought that I fixed that one in a DEV320 but that doesn't seem to be. So please submit an issue for it. Thanks. Wasn't that in one of the dba33? CWS', i.e. for 3.3 only? If so it hasn't integrated yet - tried with dev300_m70 same error. I think the issue according to issue tracker and eis is fixed in cws dba33b and integrated into m70: http://qa.openoffice.org/issues/show_bug.cgi?id=105086 Then it is a not fully solved issue. Zoltan - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Question 1: Finding the actual column name for an aliased field?
Hi Drew, I have a query: SELECT COL1 AS ALIAS FROM TABLE Now I am handed a dataform in a routine and I need to find the column names in the table, not the alias. depending on which column object you have ... there might be a property RealName, though I do not know, out of my head, at which col objects it is available. So, try ControlModel.BoundField.RealName. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] ResultsetColumn.Typename inconsistent between drivers?
Hi Drew, for cntr = 1 to oDataForm.Columns.count CurrentColumn = oDataForm.Columns(cntr -1 ) if UCASE( CurrentColumn.Typename) = UCASE(longvarbinary) then because under HSQLdb it is LONGVARBINARY under MySQL Native it is longvarbinary. Shouldn't this be consistent? Issue? This name is completely driver-controlled, so each and every database can do what it wants here, OOo just routes through, without interfering. The only thing you can interpret is the css.sdbc.DataType. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Question 1: Finding the actual column name for an aliased field?
On 2/9/2010 5:03 PM, Frank Schoenheit, Sun Microsystems Germany wrote: Hi Drew, I have a query: SELECT COL1 AS ALIAS FROM TABLE Now I am handed a dataform in a routine and I need to find the column names in the table, not the alias. depending on which column object you have ... there might be a property RealName, though I do not know, out of my head, at which col objects it is available. So, try ControlModel.BoundField.RealName. Nope - realname doesn't show up as a property for anything I can find. That includes the query composer. I thought there was a way to get this and realname sounds like it, but its gone as far as I can see. Drew - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] SetBlob.... ( was Re: setBlog not implemented for preparedStatement in HSQLdb SDBC driver)
Hi all, Reizinger Zoltán wrote: Hi all, Ezzel a dátummal: Tuesday 09 February 2010 19.00.32 Drew Jensen ezt írta: On 2/9/2010 11:53 AM, Frank Schoenheit, Sun Microsystems Germany wrote: Hi Ocke, I thought that I fixed that one in a DEV320 but that doesn't seem to be. So please submit an issue for it. Thanks. Wasn't that in one of the dba33? CWS', i.e. for 3.3 only? If so it hasn't integrated yet - tried with dev300_m70 same error. I think the issue according to issue tracker and eis is fixed in cws dba33b and integrated into m70: http://qa.openoffice.org/issues/show_bug.cgi?id=105086 Then it is a not fully solved issue. That's the part which I don't understand. I have to check the history of some files later on. Hopefully I simply forget it and it isn't no merge problem. - oj Zoltan - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com D-20097 Hamburg http://www.sun.com/staroffice Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB 161028 Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels Vorsitzender des Aufsichtsrates: Martin Haering - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Question 1: Finding the actual column name for an aliased field?
Hi Drew, Drew Jensen wrote: On 2/9/2010 5:03 PM, Frank Schoenheit, Sun Microsystems Germany wrote: Hi Drew, I have a query: SELECT COL1 AS ALIAS FROM TABLE Now I am handed a dataform in a routine and I need to find the column names in the table, not the alias. depending on which column object you have ... there might be a property RealName, though I do not know, out of my head, at which col objects it is available. So, try ControlModel.BoundField.RealName. Nope - realname doesn't show up as a property for anything I can find. That includes the query composer. I thought there was a way to get this and realname sounds like it, but its gone as far as I can see. When you use the SingleSelectQueryCompser and ask for the SelectColumns each column in that collection has a property RealName as well as a TableName property. - oj Drew - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com D-20097 Hamburg http://www.sun.com/staroffice Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB 161028 Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels Vorsitzender des Aufsichtsrates: Martin Haering - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org