To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=51383 Issue #:|51383 Summary:|Disallowed Implicit Conversion with Money fields in |SQL Server table Component:|Database access Version:|OOo 2.0 Beta Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|jhansonxi
------- Additional comments from [EMAIL PROTECTED] Wed Jun 29 13:10:32 -0700 2005 ------- Client: OOO 1.9.100 Base and Data Source Browser, Windows XP SP2 Server: SQL Server 2000 Connection: ODBC Table: Parts.dbo.Sources (Inventory sources table) Fields: Index: Primary Key, Table Identity (seed 1, inc 1), bigint, length 8 Part Number: nvarchar, length 7 Source: nvarchar, length 50, nulls allowed Source Part Number: nvarchar, length 50, nulls allowed Minimum Quantity: int, length 4, nulls allowed Maximum Cost: money, length 8, nulls allowed Use For Estimates: bit Whenever I try to enter a value into the Maximum Cost field via the DSB or the table editor in Base, I get an error: [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type char to data type money, table 'Parts.dbo.Sources', column 'Maximum Cost'. Use the CONVERT function to run this query. Is this a bug in OOO that it tries to send the wrong data type or is it a problem with ODBC or SQL Server 2000? --------------------------------------------------------------------- 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]
