[dba-issues] [Issue 108377] The insertRow() method ra ises an exception

2010-01-18 Thread chrisbrand
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108377





--- Additional comments from chrisbr...@openoffice.org Mon Jan 18 11:25:13 
+ 2010 ---
I am using XPPro (SP3), OOO320_RC2 and MySQL Connector 1.0.0
Print ThisForm.isNew() gives the message box with TRUE then ThisForm.insertRow()
produces the exception. As I said, it still inserts the record into the database
OK but stops program execution.
I uninstalled OOO320_RC2 and installed OOO311 and the same form operates
perfectly with no exceptions.
I did find one form, the stock control form, does save the parts data record
successfully with no exception generated. I have no idea what the difference is
with these two forms as I have scanned the properties settings and they all
appear the same. Every table has one primary key which is of type Integer[INT]
and auto incrementing.


-
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 108377] The insertRow() method ra ises an exception

2010-01-18 Thread atjensen
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108377





--- Additional comments from atjen...@openoffice.org Mon Jan 18 12:32:24 
+ 2010 ---
@ chrisbrand well drat - of course it has to works sometimes for you...

OK - well the door for 3.2 is shutting pretty quickly, given you have a work
around and that so far I can't reproduce the bug I hope you would agree that it
appears not to be a showstopper for 3.2?

So - I will work with you to try and narrow this down for sure, but it will be a
few days before I can really do so - mind if I contact you direct via email
about this, then?





-
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 108377] The insertRow() method ra ises an exception

2010-01-18 Thread chrisbrand
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108377





--- Additional comments from chrisbr...@openoffice.org Mon Jan 18 20:55:06 
+ 2010 ---
I wouldn't dream of standing in the way of the full release of 3.2. Please, just
concentrate on getting the full release out there.

Feel free to contact me by email as this is the fastest, I would dearly like to
sort this out. It's probably a bit of slack coding on my part and 3.2 is a
little less forgiving that 3.1.1.

I'd like to know just where it is a little less forgiving.

-
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 108377] The insertRow() method ra ises an exception

2010-01-17 Thread chrisbrand
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108377





--- Additional comments from chrisbr...@openoffice.org Sun Jan 17 11:19:28 
+ 2010 ---
Created an attachment (id=67241)
Basic code and description of error


-
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 108377] The insertRow() method ra ises an exception

2010-01-17 Thread atjensen
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108377





--- Additional comments from atjen...@openoffice.org Sun Jan 17 16:24:15 
+ 2010 ---
@chrisbrand  Using XP (SP3), OOO320_RC2 and MySQL Connector 1.0.0 I have not
been able to reproduce the problem. Tried some simple test cases and an existing
form with some basic for inserts/update.

Are you using the most recent MySQL connector on both machines?

Would you, on the 3.2 machine, add this line:
print ThisForm.isNew()
just before the line ThisForm.InsertRow()

It should put up a message box with TRUE, but let me know if you could.

-
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 108377] The insertRow() method ra ises an exception

2010-01-16 Thread chrisbrand
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108377
 Issue #|108377
 Summary|The insertRow() method raises an exception
   Component|Database access
 Version|OOo 3.2 RC2
Platform|PC
 URL|
  OS/Version|Windows XP
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|DEFECT
Priority|P3
Subcomponent|MySQL Connector/OOo
 Assigned to|dbaneedsconfirm
 Reported by|chrisbrand





--- Additional comments from chrisbr...@openoffice.org Sat Jan 16 10:45:19 
+ 2010 ---
The Form.insertRow() method in OOo Basic raises an exception
'MySQL_Prepared_ResultSet::getInt: can't fetch because not on result set' using
MYSQL(Native) connector. When using MSQL(JDBC) the exception is 'Illegal
operation on empty result set'.
The same code works OK in version 3.1.1, it just started when I installed 3.2
RC1 then RC2.
It is also raised when using the 'save record' action in a form 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 108377] The insertRow() method ra ises an exception

2010-01-16 Thread chrisbrand
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108377





--- Additional comments from chrisbr...@openoffice.org Sat Jan 16 10:56:30 
+ 2010 ---
If I use 'On Error Resume Next' in the code the routine returns and the row is
inserted OK. However this is not possible with the save record action in a 
button.
It is also not good practise.

-
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 108377] The insertRow() method ra ises an exception

2010-01-16 Thread atjensen
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108377


User atjensen changed the following:

What|Old value |New value

  CC|''|'atjensen'





--- Additional comments from atjen...@openoffice.org Sun Jan 17 00:35:55 
+ 2010 ---
@chrisbrand Would it be possible for you to attach a text file with the basic
code where this happens, and enough info so that I could try to reproduce here.
Thanks

-
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