To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=61186 Issue #:|61186 Summary:|Make form control values accessible to SQL Component:|Database access Version:|OOo 2.0.1 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|ENHANCEMENT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|moorsider
------- Additional comments from [EMAIL PROTECTED] Thu Jan 26 04:31:14 -0800 2006 ------- One major function of pick lists is to ensure data entry is restricted to meaningful values. Listboxes and combo boxes accept SQL to populate pick lists. A number of posts in the oooforum have raised the issue of directly referencing the value of another control in the select statement so that the choices presented are correct in light of data already entered. Usually SQL expects to see external variables in the form SELECT * FROM atable WHERE col1 = :externalvariable In this case external variable would probably take the form formname.controlname --------------------------------------------------------------------- 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]
