Visual Extend CPickField Builder

1
Visual ExtendCPickField Builder
VFX 13 E

• German FoxPro User Group
• Venelina Jordanova

2
VFX CPickField Builder

• Pick list (Lookup tables)
• Values, entered by the user
• Select a value from a list form
• Many settings

3
Pick Field

• Maintenance form
• Index
• Description textbox
• Controlsource
• Return value
• Field titles

• Pick dialog caption
• Pick table
• Input textbox
• Controlsource
• Return value
• Field list

• Input textbox
• Format, Input Mask, Status Bar Text

4
Update

• Source fields
• Target table
• Target fields
• Example See the video about CPickTextbox

5
Work on View

• Validation
• Using SELECT command
• Use view
• Example VFX90Test, Xvchild.scx, cntParentid
• Use SQL Pass Through
• Pick dialog form

6
Options

• User Refresh Code
• Property lUserRefresh
• Method OnUserRefresh
• Example VFX90Test, Child.scx, cntItemid
• Various settings

7

• Thank you!
• In next video tutorial you will see pick list
  based on primary keys using CPickAlternate class
• Visit our websites http//www.visualextend.comh
  ttp//store.esellerate.net/s.aspx?sSTR5180737559
  http//forum.dfpug.de or news//news.dfpug.dehttp
  //devcon.dfpug.de, http//sqlnet.dfpug.dehttp//
  www.dfpug.com, http//portal.dfpug.de