Issue 61186

Summary: Make form control values accessible to SQL
Product: Base Reporter: moorsider <mikeoo>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.0.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description moorsider 2006-01-26 12:31:14 UTC
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
Comment 1 marc.neumann 2006-01-26 12:49:42 UTC
Hi,

I reassign this enhancement to the User Experience team for evaluating.

Bye Marc