[dba-issues] [Issue 110323] Conversion problem in Bas e : variant/double to variant/integer in Forma ttedField
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110323 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED Target milestone|--- |OOo 3.4 --- Additional comments from o...@openoffice.org Tue Dec 14 08:18:24 + 2010 --- Fixed in cws dba34c. - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 110323] Conversion problem in Bas e : variant/double to variant/integer in Forma ttedField
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110323 User msc changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from m...@openoffice.org Wed Mar 31 12:16:52 + 2010 --- I can reproduce the issue with the second bug doc. - oj: can you please have a look. - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 110323] Conversion problem in Bas e : variant/double to variant/integer in Forma ttedField
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110323 --- Additional comments from m...@openoffice.org Tue Mar 23 10:06:56 + 2010 --- *** Issue 110322 has been marked as a duplicate of this issue. *** - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 110323] Conversion problem in Bas e : variant/double to variant/integer in Forma ttedField
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110323 --- Additional comments from rack...@openoffice.org Mon Mar 22 20:53:01 + 2010 --- Created an attachment (id=68492) Clients file - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 110323] Conversion problem in Bas e : variant/double to variant/integer in Forma ttedField
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110323 Issue #|110323 Summary|Conversion problem in Base : variant/double to variant |/integer in FormattedField Component|Database access Version|OOO320m9 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|rackham --- Additional comments from rack...@openoffice.org Mon Mar 22 20:51:01 + 2010 --- Hi, In Base, I've created a Form with FormattedField fields. I want to use the value of a field (CAmensuel) to update the value of another field (CAannuel). I use the following macro : Sub MajCAannuel dim PysCtrlCAmensuel as object dim PysCtrlCAannuel as object PysCtrlCAmensuel = ThisComponent.DrawPage.Forms.getByName(Clients).getByName(fmtCA mensuel) PysCtrlCAannuel = ThisComponent.DrawPage.Forms.getByName(Clients).getByName(fmtCA annuel) PysCtrlCAannuel.EffectiveValue = PysCtrlCAannuel.EffectiveValue + PysCtrlCAmensuel.EffectiveValue PysCtrlCAannuel.commit End Sub If the result is a number with decimales like 123.45, the macro works well. If the result is a number like 123.00, then, the field in the Form and the column in the Table are both reset to zero at the time of the commit. The reason seems to be the following : the assignment of the result to the proprety EffectiveValue (variant/double) is converted to an integer (variant/integer) and placed as such in the object. I've tried to assign the result to a variable defined as double, but the problem is the same. There is a conversion to variant/integer. If I use a NumericField instead, the property Value keeps the variant/double type after the assignment and in this case, it works every time. Open the Rackam, Macro.Base1.odb file. Open the Client Form. On the 1rst record, modify the CAmensuel field with the value 10.00. Click with the mouse on the Update record button in the scrolling bar. It doesn't work. The field Caannuel is reset to zero. Repeat the operation with the value 10.05. It works. - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 110323] Conversion problem in Bas e : variant/double to variant/integer in Forma ttedField
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110323 --- Additional comments from rack...@openoffice.org Mon Mar 22 21:10:43 + 2010 --- Created an attachment (id=68493) Macro assign to a button - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 110323] Conversion problem in Bas e : variant/double to variant/integer in Forma ttedField
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110323 --- Additional comments from rack...@openoffice.org Mon Mar 22 21:17:06 + 2010 --- For the Formatted.odb. Open the file. Open Formulaire1 Form. Select the 2nd record. Click on the button. 1rst time, it resets the field to zero 2nd time, it resets the field to zero 3rd time, it works (it adds 13.00 to the FormattedField. - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org