To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=44541 Issue #:|44541 Summary:|Can not coerce argument type during coreflection for |a NULL to an array. Component:|framework Version:|OOo 2.0 Beta Platform:|All URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|scripting Assigned to:|npower Reported by:|pitonyak
------- Additional comments from [EMAIL PROTECTED] Tue Mar 8 19:49:05 -0800 2005 ------- While using meta data from a flat file database connection to a CSV file http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XDatabaseMetaData.html#getTables I tried to use code similar to the following code (assuming that oMeta is the meta data from the connection and oNull has not changed): Dim oNull As Object oMeta.getTables(oNull, "%", "%", oNull) oMeta.getUDTS(oNull, "%", "%", oNull) This works in Windows, but on Linux it generates the following error: Can not coerce argument type during coreflection In both instances, the error is in the final argument. For getTables, the final argument is a string array. The API indicates that if I pass a NULL, then the criteria is ignored and all values are returned. For getUDTs, the final argument is an array of longs. Note that the following does work: oResult = oMeta.getTables(oNull, "%", "%", Array("TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM")) Also note that BOTH work on windows. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
