Data
Ortogonale Projection
Visual Dorp Filter V.6.1
It showes a sample example of making a form with
application of Visual Dorp Filter(VDF) objects.
Example includes all steps , necessary for making a form with 122 (elim 32) possible views.
The Form with 5 objects.
Part 1 Create a user form
Add some Visual FoxPro objects
Add some Visual DorpFilter primary objects
Add Visual DorpFilter advansed InList object
Modify properties of the Vdf_numAsString object
Modify properties of theVdf_strLike object
Modify properties of the Vdf_logical object
Modify properties of the Vdf_dateTopBottom object
Modify properties of the Vdf_inList object
Modify click method for the close form
Modify click method for the refresh filter
Modify click method for the order/index
Modify methods and properties of the grid
Modify methods and
properties of the form
Modify init method of the form
Sensability of Vdf object(zOsvetlibrowse,zZatamniBrowse)
Program code for SQL
Modify destroy method of the form
Data enviroment of the form
Part 2 Example with primary objects
Where condition request
Activate string as numeric object
Activate string like object
Activate logical object
Refresh where condition
Run form
Part 3 Example with IN list object
Switch all objects
IN list where conditon request
Activate logical object
Activate IN list menu
Select IN list by menu
Enter IN list values
Run IN list form
Part 4 Example with NOT condition
NOT condition request
Actvate string as numeric object
Activate NOT condition
Display object with NOT condition
Activate string object
Run form with NOT condition
Part 5 Example with AND/OR operator
OR conditon request
Activate string as numeric object
Activate date object
AND to OR condition
Display OR operator and object
Run OR filter form
Part 6 Example with NULL value
NULL condition request
Activate NULL operator
Display object with NULL value
Activate logical object
Run form with NULL value
Part 7 Advanced course
Add Visual DorpFilter condesed object
/ Kond_date_ymd
Add Visual DorpFilter special object
/ Spec_12months
Add Visual DorpFilter extended object
/Ext_numAsString
Start of condesed object
Caption of prim object
Caption of cpec object
Property xFilterKey
Caption of special object
Property xFilterKey
Property xFilterKey
Number of decimal
place
Max lenth of field
Caption of extended object
Modify program code for SQL(add
objects)
Part 8 Example with condesed object
Condesed where conditon request
Activate condesed object
Activate m-d
Enter values
Run form with condesed object
Part 9 Example with special object
Special where conditon request
Activate special object
Run form with special object
Part 10 Example with extended object
Extended where conditon request
Activate
Extended object
Activate add option
Add value1
Add value2
Add value3
Run form with extended object
Part 11 Example with print object
Add text print object
Add command botton for Prew/Report
Click method for Prew/Report
Create .frx
Example - print header1
Example - print header2
Part 12 Appendix
Appendix A
Modify main code
Add function to the stored procedure
Modify main code
Appendix B
Copy VDF framework
Add vdf class
Select vdf_custom from vdf_class.vcx
Enter vdf_grafic path for .bmp pictures(folders - "vdf_grafic")
Program
code(methods)
1.
thisform.Init()
2.
thisform.Destroy()
3.
thisform.xSqlExecute()
4.
thisform.zOsvetliBrowse()
5.
thisform.zZatamniBrowse()
6.
thisform.grdDisplay.Destroy()
7.
thisform.cboOrder.Click()
8.
thisform.cmdRefresh.Click()
9.
thisform.cmdClose.Click()
10.
thisform.vdfInList1.uGroupMenu()