To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=50377
Issue #:|50377
Summary:|Recordset object in OO Base macros
Component:|Database access
Version:|1.0.0
Platform:|PC
URL:|
OS/Version:|Windows 2000
Status:|NEW
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|FEATURE
Priority:|P3
Subcomponent:|none
Assigned to:|dbaneedsconfirm
Reported by:|valdisvi
------- Additional comments from [EMAIL PROTECTED] Mon Jun 6 06:28:10 -0700
2005 -------
OO Base macro features should be extended to support Resordset object similarly
to MS Access with basic methods:
.AddNew ' adds new record
!a = "val" ' sets val for field a, shortcut for .Fields(0).Value=..
.Update ' update (save) record
.Delete ' delete current record
.MoveFirst
.MoveLast
.MoveNext
.MovePrevious
.Index = "pk" ' sets index to pk
.Seek (pkValue, adSeekFirstEQ) ' seek for pkvalue using index on pk
Such possibility is extremely important for not trivial data operations when
each record should be processed, but usage of SQL database with stored
procedures is too complicated.
---------------------------------------------------------------------
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]
