To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115265 Issue #|115265 Summary|Database AutoValue Help Documentation -- should list f |ield types Component|framework Version|OOO320m18 Platform|HP URL| OS/Version|Windows 7 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P5 Subcomponent|ui Assigned to|tm Reported by|dawnepamplin
------- Additional comments from dawnepamp...@openoffice.org Tue Oct 26 21:49:15 +0000 2010 ------- Quote from Help: In the Design view, you can now create the fields for your table. Enter new fields in rows from top to bottom. Click the Field Name cell and enter a field name for each data field. Include a "primary key" data field. Base needs a primary key to be able to edit the table contents. A primary key has unique contents for each data record. For example, insert a numerical field, right-click the first column, and choose Primary Key from the context menu. Set AutoValue to "Yes", so Base can automatically increment the value for each new record. I wanted to set AutoValue to "yes," but couldn't find it anywhere on the table design screen. The AutoValue option isn't available unless you have the correct data field type -- I was using TINYINT and SMALLINT. When I switched over to a regular INTEGER, the AutoValue option appeared. It would be nice if the Help Documentation would tell what field types work with AutoValue. 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...@framework.openoffice.org For additional commands, e-mail: issues-h...@framework.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org