home *** CD-ROM | disk | FTP | other *** search
Text File | 1996-09-15 | 40.8 KB | 1,285 lines |
- object MainDemoFm: TMainDemoFm
- Left = 18
- Top = 36
- BorderStyle = bsDialog
- Caption = 'FormulaBuilder 1.0 Main Demo'
- ClientHeight = 508
- ClientWidth = 763
- Font.Color = clWindowText
- Font.Height = -16
- Font.Name = 'System'
- Font.Pitch = fpVariable
- Font.Style = []
- PixelsPerInch = 120
- Position = poScreenCenter
- OnCreate = FormCreate
- TextHeight = 20
- object Notebook: TTabbedNotebook
- Left = 0
- Top = 51
- Width = 763
- Height = 457
- Align = alClient
- TabsPerRow = 5
- TabFont.Color = clBtnText
- TabFont.Height = -12
- TabFont.Name = 'MS Sans Serif'
- TabFont.Style = []
- TabOrder = 0
- object TTabPage
- Left = 5
- Top = 26
- Caption = 'Basic Functions'
- object ResultsPanel: TPanel
- Left = 0
- Top = 337
- Width = 753
- Height = 89
- Align = alBottom
- Alignment = taLeftJustify
- BevelInner = bvRaised
- BevelOuter = bvNone
- BorderStyle = bsSingle
- TabOrder = 0
- object GroupBox1: TGroupBox
- Left = 1
- Top = 1
- Width = 749
- Height = 85
- Align = alClient
- Caption = 'Result'
- TabOrder = 0
- object ResultMemo: TMemo
- Left = 2
- Top = 22
- Width = 745
- Height = 61
- Align = alClient
- Lines.Strings = (
- '')
- TabOrder = 0
- end
- end
- end
- object Panel1: TPanel
- Left = 0
- Top = 0
- Width = 753
- Height = 337
- Align = alClient
- Caption = 'Panel1'
- TabOrder = 1
- object SpeedButton2: TSpeedButton
- Left = 698
- Top = 210
- Width = 31
- Height = 31
- Glyph.Data = {
- 78010000424D7801000000000000760000002800000020000000100000000100
- 04000000000000000000120B0000120B00000000000000000000000000000000
- 800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
- FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00555555555555
- 555555555555555555555555555555555555555555FF55555555555559055555
- 55555555577FF5555555555599905555555555557777F5555555555599905555
- 555555557777FF5555555559999905555555555777777F555555559999990555
- 5555557777777FF5555557990599905555555777757777F55555790555599055
- 55557775555777FF5555555555599905555555555557777F5555555555559905
- 555555555555777FF5555555555559905555555555555777FF55555555555579
- 05555555555555777FF5555555555557905555555555555777FF555555555555
- 59905555555555555777555555555555555555555555555555550000}
- NumGlyphs = 2
- end
- object ExpressionListbox: TListBox
- Left = 1
- Top = 61
- Width = 751
- Height = 275
- Align = alClient
- Font.Color = clWindowText
- Font.Height = -17
- Font.Name = 'MS Sans Serif'
- Font.Pitch = fpVariable
- Font.Style = []
- ItemHeight = 20
- Items.Strings = (
- '; FORMULABUILDER Test Expression Set'
- '; Lines starting with a semicolon are ignored;'
- ';'
- ';'
- '" Tan(90)/Cos(90) = " + Str( TAN(90) / COS(90) )'
- #39'A'#39' > '#39'B'#39
-
- #39'Current Balance '#39'+padright( '#39'$'#39'+Str(weekday(today()) * 10)+'#39'.50' +
- #39', 10,'#39'*'#39')'
-
- #39'Days this month '#39'+str(choose(month(today()),31,28,31,30,31,30,3' +
- '1,31,30,31,30,31) )'
- #39'The fractional value of Cos(10) = '#39'+Str(Frac(Cos(10)))'
- #39'The square root of 89 is '#39'+str( sqrt(89) )'
- #39'This tests the error-trapping ability of FB '#39'+Str(1/0)'
-
- #39'Today is '#39'+Choose(weekday(Today()),"Sun","Mon","Tue","Wed","Thu' +
- '","Fri","Sat")'
- '1 and 13'
- '10^2'
- '13 mod 3'
- '7 or 8'
- '17 div 2'
- 'ABS( Cos(90) )'
- 'ABS(-10)'
- 'ACOS(-0.5)'
- 'ACOSH(6)'
- 'ACOT(.70)'
- 'ACOTH(4)'
- 'ACSC(1.0)'
- 'CSC(0.75)'
- 'ACSCH(2)'
- 'ASC('#39'z'#39')'
- 'ASEC(-1)'
- 'ASECH(-2)'
- 'ASIN(1)'
- 'ASINH(1.5)'
- 'ATAN(1.75)'
- 'ATANH(0.5)'
- 'ATAN2(-1,-1)'
- 'AVG(1,2,3,4,5,6,7, MAX(1,2,3,4,5) )'
- 'CEILING(10.22)'
- 'Char(32) <= '#39'$'#39
- 'char(74)'
- 'CLEAN(char(90)+char(194)+char(178)+'#39' clean string '#39'+char(180))'
- 'CODE('#39'm'#39')'
- 'COS( PI )'
- 'COSH(1.5)'
- 'COT(pi)'
- 'COTH(1)'
- 'CSCH(1)'
- 'DATE( month(today()), day(Today()), year(today()) )'
- 'DATETOSTR( Today() + 7)'
- 'DEGREES(1.75)'
- 'EXP( ln(e) )'
- 'EXP(-1.25)'
- 'EXTRACT(4,'#39'returned should be returned'#39')'
- 'FACT(10)'
- 'FIND('#39'.'#39',str(cos(45)))'
- 'FIRST(8,'#39'The rain in Spain'#39')'
- 'HOUR( TimeNow() )'
-
- 'IIF(dayname(today())='#39'Monday'#39','#39'Whered the weekend go'#39',Str(6-Week' +
- 'day(today()))+'#39' days till friday !'#39')'
- 'INT(10.9)'
- 'ISEVEN(57)'
- 'ISODD(57)'
- 'LENGTH('#39'The length of this string is 31'#39')'
- 'LOG(100)'
- 'LOG(100,10)'
- 'LOG(8,2)'
- 'LOWER('#39'JUST SO YOU WONT SHOUT AT ME'#39')'
- 'LTRIM('#39'******$99.00'#39','#39'*'#39')'
- 'MAX( Cos(PI) , SIN(PI) , ATAN(PI) , CSC(PI) , COT(PI) )'
- 'MID("Test is what this should return",4)'
- 'MID("This should return Test",20,4)'
- 'MINUTE( TimeNow() )'
- 'NOW()'
- 'PADCENTER('#39'Centered String'#39',45,'#39'*'#39')'
- 'PRODUCT(1,80,6,5,4,3,2,2)'
- 'PROPER('#39'SAMuEL wooDSON'#39')'
- 'RADIANS(90)'
- 'REPLACE('#39'Please send the IRS your taxes'#39','#39'the IRS'#39','#39'me'#39')'
- 'REPLICATE(char(196),30)'
- 'RTRIM('#39'I hate trailing spaces '#39','#39' '#39')'
- 'SECH(0)'
- 'SGN(-9)'
- 'SIN( radians(90) )'
- 'SINH(1)'
- 'SOUNDALIKE('#39'dead'#39','#39'head'#39')'
- 'SOUNDEX('#39'haywood'#39')'
- 'SOUNDEX('#39'Wayward'#39')'
- 'SQR(10)'
- 'SQRT(144)'
- 'STR(1024.678)'
- 'INSERT('#39' NOT '#39','#39'The moon is made of green cheese'#39',12)'
-
- 'STRMAX('#39'Daniel'#39','#39'Mary'#39','#39'Ian'#39','#39'Alicia'#39','#39'Paul'#39','#39'Barbara'#39','#39'Lushena'#39 +
- ')'
- 'STRMIN('#39'well'#39','#39'trained'#39','#39'horsemen'#39','#39'ride'#39','#39'swiftly'#39')'
- 'SUM(1,10,19,25,36,18)'
- 'TAN(PI)'
- 'TANH(1)'
- 'TIME(10,10,10)'
- 'TODAY() + 10'
- 'TODAY() > {10/10/95}'
- 'TRIM('#39' both leading and trailing strings trimmed '#39')'
- 'TRUE & FALSE'
- 'TRUE | FALSE'
- 'UPPER('#39'just so you dont feel so down..'#39')'
- 'VAL("100.678")'
- 'WORDCOUNT('#39'This function, if successful, should return 7'#39','#39' ,'#39')'
- 'DATEDIFF(today(), {10/10/2001})'
- 'DATEVALUE()'
- 'DAY( Today() )'
- 'DAYNAME( today() )'
- 'DB(10000,1200,8,5)'
- 'DEGREES( 10.0245 )'
- 'FLOOR(25.43)'
- 'INT(499.99)'
- 'LN( e )'
- 'MIN(10, 6, month(today), cos(pi) )'
- 'MONTH( Today() )'
- 'MONTHNAME( Today() + 45 )'
- 'PADLEFT("I hate the right",40,"*")'
- '"Check Amount "+PADRIGHT("$"+Str(10000,2),10,"*")'
- 'RAND()'
- 'RAND(5)'
- 'RAND(1,10)'
- 'LAST(6,"Reading is fundamental")'
- 'ROUND(134.578)'
- 'SEC(1.23)'
- 'SECOND( timenow() )'
- 'SGN( cos(pi) )'
- 'TERM(300,.06,5000)'
- 'TIME(10,10,35)'
- 'TIMENOW()'
- 'TIMETOSTR( Today() + 365 )'
- 'TIMEVALUE( "10/10/96" )'
- 'TODAY()'
- 'VAL("365" + ".456")'
- 'WEEKDAY(Today() + 5)'
- 'YEAR( Today() )'
- '; Thanks to JW Rider for the financial routines'
- '; FORMULABUILDER Financial Functions are, for the most part,'
- '; compatible with those of Quattro Pro 3.0'
- '; The examples are derived from the Quattro Pro 3.0 @Functions'
- '; and Macros manual'
- ';'
- '; page 29 (CTERM)'
- ';'
- ' str(cterm(0.07,5000,3000) , 2)'
- ' str(nper(0.07,0,-3000,5000,0), 2) + '#39'(nper)'#39
- ' str(cterm(0.1,5000,3000), 6)'
- ' str(cterm(0.12,5000,3000), 6)'
- ' str(cterm(0.12,10000,7000), 6)'
- ';'
- '; pages 35-36 (DDB):'
- ';'
- ' ddb(4000,350,8,2)'
- ' ddb(15000,3000,10,1)'
- ' ddb(15000,3000,10,2)'
- ' ddb(15000,3000,10,3)'
- ' ddb(15000,3000,10,4)'
- ' ddb(15000,3000,10,5)'
- ';'
- '; '#39'page 48 (FV):'
- ';'
- ' str(fv(500,0.15,6),2)'
- ' str(fval(0.15,6,-500,0,0),2)'
- ' str(fv(200,0.12,5),2)'
- ' str(fv(500,0.9,4),2)'
- ' str(fv(800,0.9,3),2)'
- ' str(fv(800,0.9,6),2)'
- ';'
- '; '#39'page 49 (FVAL):'#39
- ' str(fval(0.15,6,-500,0,1),2)'
- ' str(fval(0.15,6,-500,-340,1),2)'
- ';'
- '; page 57 (IPAYMT):'
- ';'
- ' str( ipaymt(0.1/12,2*12,30*12,100000,0,0),2 )'
- ';'
- '; pages 57-58 (IRATE):'
- ';'
- ' str( irate(5*12,-500,15000,0,0),5)'
- ' str( irate(5,-2000,-2.38,15000,0) , 4)'
- ';'
- '; pages 60-61 (IRR):'
- ';'
- ' str( irr(0,-10,150,-145)*100 , 2) +'#39'%'#39
- ' str( irr(10,-10,150,-145)*100, 0) +'#39'%'#39
- ' str( irr(0,-10,150.1,-145)*100 , 2) +'#39'%'#39
- ' str( irr(10,-10,150.1,-145)*100, 0 ) + '#39'%'#39
- ' str( irr(0,-3000,700,600,750,900,1000,1400)*100 , 2) +'#39'%'#39
-
- ' str( irr(0,-50000,-8000,2000,4000,6000,5000,4500)*100 , 2) +'#39'%' +
- #39
- ' str( irr(0,-10000,1000,1000,1200,2000,3000,4000)*100 , 2) +'#39'%'#39
- ';'
- '; page 73 (NPER):'
- ';'
- ' str( nper(0.115,-2000,-633,50000,0),2 )'
- ';'
- '; page 75 (NPV):'
- ';'
- ' str( npv(0.1,-5000,2000,2000,2000,2000, 0)'
- ' str( -5000 + npv(0.1,2000,2000,2000,2000,0), 2 )'
- ' str( npv(0.0125, 8000,9000,8500,9500,10000,11000,10000) ,2 )'
- ' npv(0.15/12, 200,350,-300,600,700,1000,1200)'
- ' npv(0.15/12,3500,4000,3000,5000,4000,6500,7000)'
- ';'
- '; page 77 (PAYMT):'
- ';'
- ' str(paymt(0.175/12,12*30,175000,0,0),2)'
- ' str(paymt(0.175/12,12*30,175000,0,1),2)'
- ' str(paymt(0.175/12,12*30,175000,-80000,0),2)'
- ';'
- '; pages 78-79 (PMT)'
- ';'
- ' str(PMT(10000,0.15/12,3*12),2)'
- ' str( PAYMT(0.15/12,3*12,10000,0,0), 2) + '#39'(paymt)'#39
- ' str(pmt(1000,0.12,5) ,2 )'
- ' str(pmt(500,0.16,12), 2)'
- ' str(pmt(5000,0.16/12,12) ,2)'
- ' str(pmt(12000,0.11,15) ,2 )'
- ';'
- '; page 79 (PPAYMT):'
- ';'
- ' str(ppaymt(0.1/12,2*12,30*12,100000,0,0), 2)'
- ' str(ppaymt(0.15/4,24,40,10000,0,1), 2)'
- ';'
- '; page 81 (PV)'
- ';'
- ' str(pv(350,0.07/12,5*12),2)'
- ' str(pval(0.07/12,5*12,-350,0,0), 2)'
- ' str(pv(277,0.12,5),2)'
- ' str(pv(600,0.17,10),2)'
- ' str(pv(100,0.11,12),2)'
- ';'
- '; page 82 (PVAL)'
- ';'
- ' str(pval(0.1,12,2000,0,0),2)'
- ' str(pval(0.1,15,0,30000,0),2)'
- ';'
- '; page 84 (RATE)'
- ';'
- ' str( rate(4000,2000,10)*100, 2) + '#39'%'#39
- ' str( rate(10000,7000,6*12)*100, 2) + '#39'%'#39
- ' str( rate(1200,1000,3)*100, 2) + '#39'%'#39
- ' str( rate(500,100,25)*100, 2) + '#39'%'#39
- ';'
- '; page 89 (SLN)'
- ';'
- ' str(sln(4000,350,8),2)'
- ' str(sln(15000,3000,10), 0)'
- ' sln(5000,500,5)'
- ' sln(1800,0,3)'
- ';'
- '; pages 94-95 (SYD)'
- ';'
- ' str( syd(4000,350,8,2),2)'
- ' syd(12000,1000,5,1)'
- ' syd(12000,1000,5,2)'
- ' syd(12000,1000,5,3)'
- ' syd(12000,1000,5,4)'
- ' syd(12000,1000,5,5)'
- ';'
- ' ddb(12000,1000,5,1)'
- ' ddb(12000,1000,5,2)'
- ' ddb(12000,1000,5,3)'
- ' ddb(12000,1000,5,4)'
- ' ddb(12000,1000,5,5)'
- ';'
- '; page 96 (TERM)'
- ';'
- ' str( term(2000,0.11,50000),2)'
- ' str( nper(0.11,-2000,0,50000,0) , 2)'
- ' str( term(300,0.06,5000) , 1)'
- ' str( term(500,0.07,1000) , 2)'
- ' str( term(500,0.07,1000) , 2)'
- ' str( term(1000,0.10,50000) , 1)'
- ' str( term(100,0.05,1000) ,1)'
- '')
- ParentFont = False
- TabOrder = 0
- OnDblClick = ExpressionListboxDblClick
- end
- object ExpressionGroupBox: TGroupBox
- Left = 1
- Top = 1
- Width = 751
- Height = 60
- Align = alTop
- Caption = 'Expression'
- TabOrder = 1
- object VariablesBtn: TSpeedButton
- Left = 660
- Top = 20
- Width = 69
- Height = 31
- Hint = 'Click here to edit expression variables'
- Caption = 'Vars'
- Font.Color = clWindowText
- Font.Height = -15
- Font.Name = 'Arial'
- Font.Pitch = fpVariable
- Font.Style = []
- Glyph.Data = {
- 76010000424D7601000000000000760000002800000020000000100000000100
- 04000000000000010000130B0000130B00000000000000000000000000000000
- 800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
- FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
- 3333333333333333333333333333333333333333FFF33FFFFF33333300033000
- 00333337773377777333333330333300033333337FF33777F333333330733300
- 0333333377FFF777F33333333700000073333333777777773333333333033000
- 3333333337FF777F333333333307300033333333377F777F3333333333703007
- 33333333377F7773333333333330000333333333337777F33333333333300003
- 33333333337777F3333333333337007333333333337777333333333333330033
- 3333333333377333333333333333033333333333333733333333333333333333
- 3333333333333333333333333333333333333333333333333333}
- NumGlyphs = 2
- ParentFont = False
- OnClick = VariablesBtnClick
- end
- object CalcBtn: TSpeedButton
- Left = 608
- Top = 20
- Width = 46
- Height = 31
- Hint = 'Click Here to Evaluate'
- Glyph.Data = {
- 78010000424D7801000000000000760000002800000020000000100000000100
- 04000000000000000000120B0000120B00000000000000000000000000000000
- 800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
- FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00555555555555
- 555555555555555555555555555555555555555555FF55555555555559055555
- 55555555577FF5555555555599905555555555557777F5555555555599905555
- 555555557777FF5555555559999905555555555777777F555555559999990555
- 5555557777777FF5555557990599905555555777757777F55555790555599055
- 55557775555777FF5555555555599905555555555557777F5555555555559905
- 555555555555777FF5555555555559905555555555555777FF55555555555579
- 05555555555555777FF5555555555557905555555555555777FF555555555555
- 59905555555555555777555555555555555555555555555555550000}
- NumGlyphs = 2
- OnClick = CalcBtnClick
- end
- object ExpressionCombo: TComboBox
- Left = 8
- Top = 20
- Width = 586
- Height = 24
- Font.Color = clWindowText
- Font.Height = -15
- Font.Name = 'System'
- Font.Pitch = fpVariable
- Font.Style = []
- ItemHeight = 16
- ParentFont = False
- TabOrder = 0
- end
- end
- end
- end
- object TTabPage
- Left = 5
- Top = 26
- Caption = 'Data-Aware Demo'
- object CustomerGrid: TDBGrid
- Left = 0
- Top = 41
- Width = 753
- Height = 152
- Align = alTop
- DataSource = CustomerDataSource
- Font.Color = clBlack
- Font.Height = -17
- Font.Name = 'Arial'
- Font.Style = []
- ParentFont = False
- TabOrder = 0
- TitleFont.Color = clWindowText
- TitleFont.Height = -13
- TitleFont.Name = 'System'
- TitleFont.Style = []
- end
- object Panel5: TPanel
- Left = 0
- Top = 367
- Width = 753
- Height = 59
- Align = alBottom
- TabOrder = 1
- object OrdersResultPanel: TPanel
- Left = 13
- Top = 10
- Width = 588
- Height = 41
- Alignment = taLeftJustify
- Font.Color = clBlack
- Font.Height = -15
- Font.Name = 'MS Sans Serif'
- Font.Pitch = fpVariable
- Font.Style = []
- ParentFont = False
- TabOrder = 0
- end
- object Formula: TBitBtn
- Left = 615
- Top = 10
- Width = 106
- Height = 41
- Caption = 'Formula'
- TabOrder = 1
- OnClick = FormulaClick
- Glyph.Data = {
- 78010000424D7801000000000000760000002800000020000000100000000100
- 04000000000000000000120B0000120B00000000000000000000000000000000
- 800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
- FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00337000000000
- 73333337777777773F333308888888880333337F3F3F3FFF7F33330808089998
- 0333337F737377737F333308888888880333337F3F3F3F3F7F33330808080808
- 0333337F737373737F333308888888880333337F3F3F3F3F7F33330808080808
- 0333337F737373737F333308888888880333337F3F3F3F3F7F33330808080808
- 0333337F737373737F333308888888880333337F3FFFFFFF7F33330800000008
- 0333337F7777777F7F333308000E0E080333337F7FFFFF7F7F33330800000008
- 0333337F777777737F333308888888880333337F333333337F33330888888888
- 03333373FFFFFFFF7333337000000000733333377777777733330000}
- NumGlyphs = 2
- Style = bsNew
- end
- end
- object OrdersGrid: TDBGrid
- Left = 0
- Top = 231
- Width = 753
- Height = 136
- Align = alClient
- DataSource = OrdersDataSource
- Font.Color = clBlack
- Font.Height = -17
- Font.Name = 'Arial'
- Font.Pitch = fpVariable
- Font.Style = []
- Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit]
- ParentFont = False
- TabOrder = 2
- TitleFont.Color = clWindowText
- TitleFont.Height = -13
- TitleFont.Name = 'System'
- TitleFont.Pitch = fpVariable
- TitleFont.Style = []
- end
- object Panel8: TPanel
- Left = 0
- Top = 193
- Width = 753
- Height = 38
- Align = alTop
- Font.Color = clNavy
- Font.Height = -23
- Font.Name = 'Arial'
- Font.Pitch = fpVariable
- Font.Style = [fsBold]
- ParentFont = False
- TabOrder = 3
- object lblOrdersGrid: TLabel
- Left = 5
- Top = 5
- Width = 90
- Height = 32
- Caption = 'Orders'
- Font.Color = clGray
- Font.Height = -27
- Font.Name = 'Arial'
- Font.Pitch = fpVariable
- Font.Style = [fsBold]
- ParentFont = False
- end
- object btnOrdersFilter: TBitBtn
- Tag = 1
- Left = 481
- Top = 5
- Width = 102
- Height = 31
- Caption = '&Filter'
- Font.Color = clBlack
- Font.Height = -17
- Font.Name = 'Arial'
- Font.Pitch = fpVariable
- Font.Style = []
- ParentFont = False
- TabOrder = 0
- OnClick = btnOrdersFilterClick
- Glyph.Data = {
- 4E010000424D4E01000000000000760000002800000012000000120000000100
- 040000000000D800000000000000000000001000000010000000000000000000
- BF0000BF000000BFBF00BF000000BF00BF00BFBF0000C0C0C000808080000000
- FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00DDDDDDDDDDDD
- DDDDDD000000DDDDDDDDDDDDDDDDDD000000D000000000000DD00D000000D0FF
- FFFFFFFF0D000D000000D0FFFFFFF0000800DD000000D0FFFFFF0877808DDD00
- 0000D0FFFFF0877E880DDD000000D0FFFFF07777870DDD000000D0FFFFF07E77
- 870DDD000000D0FFFFF08EE7880DDD000000D0FFFFFF087780DDDD000000D0FF
- FFFFF0000DDDDD000000D0FFFFFFFFFF0DDDDD000000D0FFFFFFF0000DDDDD00
- 0000D0FFFFFFF070DDDDDD000000D0FFFFFFF00DDDDDDD000000DD00000000DD
- DDDDDD000000DDDDDDDDDDDDDDDDDD000000}
- Style = bsNew
- end
- object cbxApplyOrdersFilter: TCheckBox
- Left = 600
- Top = 9
- Width = 121
- Height = 17
- Caption = '&Apply Filter'
- Font.Color = clBlack
- Font.Height = -17
- Font.Name = 'Arial'
- Font.Pitch = fpVariable
- Font.Style = []
- ParentFont = False
- TabOrder = 1
- OnClick = cbxApplyOrdersFilterClick
- end
- end
- object Panel9: TPanel
- Left = 0
- Top = 0
- Width = 753
- Height = 41
- Align = alTop
- Font.Color = clBlack
- Font.Height = -17
- Font.Name = 'Arial'
- Font.Pitch = fpVariable
- Font.Style = []
- ParentFont = False
- TabOrder = 4
- object lblCustomerGrid: TLabel
- Left = 10
- Top = 5
- Width = 145
- Height = 32
- Caption = 'Customers'
- Font.Color = clGray
- Font.Height = -27
- Font.Name = 'Arial'
- Font.Pitch = fpVariable
- Font.Style = [fsBold]
- ParentFont = False
- end
- object cbxApplyCustomerFilter: TCheckBox
- Left = 585
- Top = 9
- Width = 121
- Height = 17
- Caption = '&Apply Filter'
- TabOrder = 0
- OnClick = cbxApplyCustomerFilterClick
- end
- object btnCustomerFilter: TBitBtn
- Tag = 1
- Left = 474
- Top = 5
- Width = 101
- Height = 31
- Caption = '&Filter'
- TabOrder = 1
- OnClick = FilterBtnClick
- Glyph.Data = {
- 4E010000424D4E01000000000000760000002800000012000000120000000100
- 040000000000D800000000000000000000001000000010000000000000000000
- BF0000BF000000BFBF00BF000000BF00BF00BFBF0000C0C0C000808080000000
- FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00DDDDDDDDDDDD
- DDDDDD000000DDDDDDDDDDDDDDDDDD000000D000000000000DD00D000000D0FF
- FFFFFFFF0D000D000000D0FFFFFFF0000800DD000000D0FFFFFF0877808DDD00
- 0000D0FFFFF0877E880DDD000000D0FFFFF07777870DDD000000D0FFFFF07E77
- 870DDD000000D0FFFFF08EE7880DDD000000D0FFFFFF087780DDDD000000D0FF
- FFFFF0000DDDDD000000D0FFFFFFFFFF0DDDDD000000D0FFFFFFF0000DDDDD00
- 0000D0FFFFFFF070DDDDDD000000D0FFFFFFF00DDDDDDD000000DD00000000DD
- DDDDDD000000DDDDDDDDDDDDDDDDDD000000}
- Style = bsNew
- end
- end
- end
- object TTabPage
- Left = 5
- Top = 26
- Caption = 'Graphing Demo'
- object ChartFX1: TChartFX
- Left = 0
- Top = 65
- Width = 751
- Height = 356
- pType = 164359937
- LeftGap = 50
- RightGap = 50
- TopGap = 40
- BottomGap = 40
- Decimals = 2
- PointType = 6
- Scheme = 0
- Stacked = 2
- Grid = 3
- WallWidth = 8
- LineWidth = 1
- LineStyle = 0
- LineColor = clBlack
- LineBkColor = clBlack
- FixedGap = 0
- DblClkDlg = 1
- RigClkDlg = 2
- RGBBarHorz = clAqua
- RGBBk = clSilver
- RGB2DBk = clSilver
- RGB3DBk = clWhite
- CustTool = 534738482
- VertGridGap = 1
- about = 'Click on "..."'
- NSeries_Data = {}
- NValues_Data = {
- 020004000000000000000000000000000000F03F000000000000000000000000
- 00005940}
- ThisColor_Data = {000000000000}
- ThisBkColor_Data = {}
- AdmDlg_Data = {}
- ViewRot3D_Data = {000000000000}
- FontDlg_Data = {
- 08000020080000600C0100000800000008000000080000000800000008000000
- 0000000000000000808080000000000000000000000000000000000000000000}
- TitleDlg_Data = {00000000000000000000000000000000}
- ChartType_Data = {}
- Chart3D_Data = {}
- ToolBar_Data = {}
- PaletteBar_Data = {}
- PatternBar_Data = {}
- ZReserved1 = 'Click on "..."'
- ZReserved2 = 'Click on "..."'
- ZReserved3 = 'Click on "..."'
- end
- object Panel3: TPanel
- Left = 0
- Top = 0
- Width = 753
- Height = 66
- Align = alTop
- TabOrder = 1
- object btnDrawGraph: TSpeedButton
- Left = 700
- Top = 25
- Width = 46
- Height = 29
- Hint = 'Plot the graph'
- Glyph.Data = {
- 78010000424D7801000000000000760000002800000020000000100000000100
- 04000000000000000000120B0000120B00000000000000000000000000000000
- 800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
- FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00337333733373
- 3373337F3F7F3F7F3F7F33737373737373733F7F7F7F7F7F7F7F770000000000
- 000077777777777777773303333333333333337FF333333F33333709333333C3
- 333337773F3FF373F333330393993C3C33333F7F7F77F7F7FFFF77079797977C
- 77777777777777777777330339339333C333337FF73373F37F33370C333C3933
- 933337773F3737F37FF33303C3C33939C9333F7F7F7FF7F777FF7707C7C77797
- 7C97777777777777777733033C3333333C33337F37F33333373F37033C333333
- 33C3377F37333333337333033333333333333F7FFFFFFFFFFFFF770777777777
- 77777777777777777777333333333333333333333333333333330000}
- NumGlyphs = 2
- OnClick = btnDrawGraphClick
- end
- object Label1: TLabel
- Left = 10
- Top = 5
- Width = 65
- Height = 20
- Caption = '&Formula'
- FocusControl = FormulaEdit
- end
- object Label2: TLabel
- Left = 485
- Top = 5
- Width = 39
- Height = 20
- Caption = 'XMin'
- end
- object Label3: TLabel
- Left = 570
- Top = 5
- Width = 43
- Height = 20
- Caption = 'XMax'
- end
- object Label4: TLabel
- Left = 645
- Top = 5
- Width = 39
- Height = 20
- Caption = '# Pts'
- end
- object FormulaEdit: TEdit
- Left = 10
- Top = 25
- Width = 466
- Height = 29
- TabOrder = 0
- end
- object XMinEdit: TEdit
- Left = 485
- Top = 25
- Width = 81
- Height = 29
- TabOrder = 1
- end
- object XMaxEdit: TEdit
- Left = 570
- Top = 25
- Width = 71
- Height = 29
- TabOrder = 2
- end
- object NumPtsEdit: TEdit
- Left = 645
- Top = 25
- Width = 46
- Height = 29
- TabOrder = 3
- end
- end
- end
- object TTabPage
- Left = 5
- Top = 26
- Caption = 'Extensibility Demo'
- object Bevel1: TBevel
- Left = 8
- Top = 10
- Width = 466
- Height = 391
- Shape = bsFrame
- end
- object RunBtn: TSpeedButton
- Left = 420
- Top = 30
- Width = 31
- Height = 31
- Glyph.Data = {
- 78010000424D7801000000000000760000002800000020000000100000000100
- 04000000000000000000120B0000120B00000000000000000000000000000000
- 800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
- FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00555555555555
- 555555555555555555555555555555555555555555FF55555555555559055555
- 55555555577FF5555555555599905555555555557777F5555555555599905555
- 555555557777FF5555555559999905555555555777777F555555559999990555
- 5555557777777FF5555557990599905555555777757777F55555790555599055
- 55557775555777FF5555555555599905555555555557777F5555555555559905
- 555555555555777FF5555555555559905555555555555777FF55555555555579
- 05555555555555777FF5555555555557905555555555555777FF555555555555
- 59905555555555555777555555555555555555555555555555550000}
- NumGlyphs = 2
- OnClick = RunBtnClick
- end
- object newFuncsCombo: TComboBox
- Left = 23
- Top = 30
- Width = 391
- Height = 29
- ItemHeight = 20
- TabOrder = 0
- end
- object NewFuncsListbox: TListBox
- Left = 23
- Top = 70
- Width = 428
- Height = 191
- Enabled = False
- ItemHeight = 20
- Items.Strings = (
- ' Copy("exprlist.txt","newfil.txt") '
- ' Rename("newfil.txt","newtxt.old")'
- ' exec("calc.exe", SW_SHOWNORMAL) '
- ' execwait("notepad.exe",SW_MAXIMIZE)'
- ' delete("myfile.fil")'
- ' errormsg("This is an error box")'
- ' msgbox("This is a message box") '
- ' beep( MB_ICONHAND )'
- ' yesno("Have you made a backup ?")'
- ' yesnocancel("Would you like to save your work ?")'
- ' inputstring("What is your name","Name","Bob")')
- TabOrder = 1
- OnClick = NewFuncsListboxClick
- end
- object runmemo: TMemo
- Left = 23
- Top = 270
- Width = 428
- Height = 61
- Lines.Strings = (
- '')
- TabOrder = 2
- end
- object RegisterFuncBtn: TBitBtn
- Left = 218
- Top = 350
- Width = 111
- Height = 41
- Caption = 'Register'
- TabOrder = 3
- OnClick = RegisterFuncBtnClick
- Style = bsNew
- end
- object UnregisterBtn: TBitBtn
- Left = 338
- Top = 350
- Width = 111
- Height = 41
- Caption = 'Unregister'
- TabOrder = 4
- OnClick = UnregisterBtnClick
- Style = bsNew
- end
- end
- object TTabPage
- Left = 5
- Top = 26
- Caption = 'RTTI Demo'
- object BitBtn1: TBitBtn
- Left = 265
- Top = 345
- Width = 256
- Height = 41
- Caption = 'Click Here For The RTTI Demo'
- Font.Color = clBlack
- Font.Height = -17
- Font.Name = 'Arial'
- Font.Pitch = fpVariable
- Font.Style = []
- ParentFont = False
- TabOrder = 0
- OnClick = BitBtn1Click
- end
- object Panel4: TPanel
- Left = 0
- Top = 0
- Width = 753
- Height = 31
- Align = alTop
- Color = clTeal
- TabOrder = 1
- end
- object Panel6: TPanel
- Left = 10
- Top = 40
- Width = 726
- Height = 276
- BevelInner = bvRaised
- BorderWidth = 2
- Caption = 'Panel6'
- TabOrder = 2
- object Memo2: TMemo
- Left = 4
- Top = 4
- Width = 718
- Height = 268
- Align = alClient
- BorderStyle = bsNone
- Color = clBtnFace
- Font.Color = clBlack
- Font.Height = -17
- Font.Name = 'Arial'
- Font.Pitch = fpVariable
- Font.Style = []
- Lines.Strings = (
-
- 'Much of FormulaBuilder'#39's flexibility derives from the fact that ' +
- 'the programmer may handle '
-
- 'variables and functions external to the core engine. A powerful ' +
- 'example of this feature is '
-
- 'the TRTTIExpression class, which gives the programmer/user runti' +
- 'me access to the published'
-
- 'properties of a given component (and its contained components) u' +
- 'sing familiar syntax. For '
- 'example :'
- ''
- '[Form1.Font.Style] := [fsBold,fsItalic]'
- '[Form1.Caption] := [Form2.Caption] + Str( TimeNow() )'
- ''
-
- 'This opens many possibilites, like scripted testing and demonstr' +
- 'ations, and ultra-flexible '
- 'user-configuration.')
- ParentFont = False
- TabOrder = 0
- end
- end
- end
- end
- object Panel2: TPanel
- Left = 0
- Top = 0
- Width = 763
- Height = 51
- Align = alTop
- Color = clTeal
- TabOrder = 1
- object btnAbout: TSpeedButton
- Left = 405
- Top = 10
- Width = 46
- Height = 31
- Glyph.Data = {
- 78010000424D7801000000000000760000002800000020000000100000000100
- 04000000000000000000120B0000120B00000000000000000000000000000000
- 800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
- FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF0033333CCCCC33
- 33333FFFF77777FFFFFFCCCCCC808CCCCCC3777777F7F777777F008888070888
- 8003777777777777777F0F0770F7F0770F0373F33337F333337370FFFFF7FFFF
- F07337F33337F33337F370FFFB99FBFFF07337F33377F33337F330FFBF99BFBF
- F033373F337733333733370BFBF7FBFB0733337F333FF3337F33370FBF98BFBF
- 0733337F3377FF337F333B0BFB990BFB03333373FF777FFF73333FB000B99000
- B33333377737777733333BFBFBFB99FBF33333333FF377F333333FBF99BF99BF
- B333333377F377F3333333FB99FB99FB3333333377FF77333333333FB9999FB3
- 333333333777733333333333FBFBFB33333333333333333333330000}
- NumGlyphs = 2
- OnClick = btnAboutClick
- end
- object lblDemo: TLabel
- Left = 310
- Top = 10
- Width = 90
- Height = 38
- Caption = 'Demo'
- Font.Color = clMaroon
- Font.Height = -33
- Font.Name = 'Arial'
- Font.Pitch = fpVariable
- Font.Style = [fsBold]
- ParentFont = False
- end
- object MainLabel: TLabel
- Left = 10
- Top = 10
- Width = 295
- Height = 38
- Caption = 'FormulaBuilder 1.0'
- Font.Color = clNavy
- Font.Height = -33
- Font.Name = 'Arial'
- Font.Pitch = fpVariable
- Font.Style = [fsBold]
- ParentFont = False
- end
- object btnFunctions: TBitBtn
- Left = 458
- Top = 9
- Width = 98
- Height = 31
- Hint = 'Click here for a list of functions'
- Caption = '&Functions'
- Font.Color = clWindowText
- Font.Height = -15
- Font.Name = 'MS Sans Serif'
- Font.Pitch = fpVariable
- Font.Style = []
- ParentFont = False
- TabOrder = 0
- OnClick = btnFunctionsClick
- Glyph.Data = {
- 78010000424D7801000000000000760000002800000020000000100000000100
- 04000000000000000000120B0000120B00000000000000000000000000000000
- 800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
- FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
- 333333333333333333333333333333333333333FFFFFFFFFFF33330000000000
- 03333377777777777F33333003333330033333377FF333377F33333300333333
- 0333333377FF33337F3333333003333303333333377FF3337333333333003333
- 333333333377FF3333333333333003333333333333377FF33333333333330033
- 3333333333337733333333333330033333333333333773333333333333003333
- 33333333337733333F3333333003333303333333377333337F33333300333333
- 03333333773333337F33333003333330033333377FFFFFF77F33330000000000
- 03333377777777777333333333333333333333333333333333330000}
- NumGlyphs = 2
- Style = bsNew
- end
- object HelpBtn: TBitBtn
- Left = 563
- Top = 9
- Width = 83
- Height = 31
- TabOrder = 1
- OnClick = HelpBtnClick
- Kind = bkHelp
- Style = bsNew
- end
- object CancelBtn: TBitBtn
- Left = 650
- Top = 9
- Width = 94
- Height = 31
- Font.Color = clBlack
- Font.Height = -15
- Font.Name = 'MS Sans Serif'
- Font.Style = [fsBold]
- ParentFont = False
- TabOrder = 2
- Kind = bkClose
- Margin = 2
- Style = bsNew
- Spacing = -1
- end
- end
- object CustomerTable: TTable
- Active = True
- DatabaseName = 'DBDEMOS'
- ReadOnly = True
- TableName = 'CUSTOMER.DB'
- Left = 212
- Top = 87
- object CustomerTableCustNo: TFloatField
- DisplayWidth = 6
- FieldName = 'CustNo'
- end
- object CustomerTableCompany: TStringField
- DisplayWidth = 30
- FieldName = 'Company'
- Size = 30
- end
- object CustomerTableAddr1: TStringField
- DisplayWidth = 29
- FieldName = 'Addr1'
- Size = 30
- end
- object CustomerTableCity: TStringField
- DisplayWidth = 11
- FieldName = 'City'
- Size = 15
- end
- object CustomerTableState: TStringField
- DisplayWidth = 10
- FieldName = 'State'
- end
- object CustomerTableZip: TStringField
- DisplayWidth = 10
- FieldName = 'Zip'
- Size = 10
- end
- object CustomerTableCountry: TStringField
- DisplayWidth = 20
- FieldName = 'Country'
- end
- object CustomerTablePhone: TStringField
- DisplayWidth = 15
- FieldName = 'Phone'
- Size = 15
- end
- object CustomerTableFAX: TStringField
- DisplayWidth = 15
- FieldName = 'FAX'
- Size = 15
- end
- object CustomerTableTaxRate: TFloatField
- DisplayWidth = 7
- FieldName = 'TaxRate'
- end
- object CustomerTableContact: TStringField
- DisplayWidth = 16
- FieldName = 'Contact'
- end
- object CustomerTableLastInvoiceDate: TDateTimeField
- DisplayWidth = 12
- FieldName = 'LastInvoiceDate'
- end
- end
- object CustomerDataSource: TDataSource
- DataSet = CustomerTable
- OnDataChange = CustomerDataSourceDataChange
- Left = 182
- Top = 87
- end
- object OrdersTable: TTable
- Active = True
- DatabaseName = 'DBDEMOS'
- IndexFieldNames = 'CustNo'
- MasterFields = 'CustNo'
- MasterSource = CustomerDataSource
- TableName = 'ORDERS.DB'
- Left = 116
- Top = 277
- object OrdersTableOrderNo: TFloatField
- DisplayWidth = 8
- FieldName = 'OrderNo'
- end
- object OrdersTableCustNo: TFloatField
- DisplayWidth = 7
- FieldName = 'CustNo'
- Required = True
- Visible = False
- end
- object OrdersTableSaleDate: TDateTimeField
- DisplayWidth = 10
- FieldName = 'SaleDate'
- end
- object OrdersTableShipDate: TDateTimeField
- DisplayWidth = 9
- FieldName = 'ShipDate'
- end
- object OrdersTableEmpNo: TIntegerField
- DisplayWidth = 8
- FieldName = 'EmpNo'
- Required = True
- Visible = False
- end
- object OrdersTableTerms: TStringField
- DisplayWidth = 6
- FieldName = 'Terms'
- Size = 6
- end
- object OrdersTablePaymentMethod: TStringField
- DisplayWidth = 13
- FieldName = 'PaymentMethod'
- Size = 7
- end
- object OrdersTableItemsTotal: TCurrencyField
- DisplayWidth = 10
- FieldName = 'ItemsTotal'
- Currency = True
- end
- object OrdersTableTaxRate: TFloatField
- DisplayWidth = 7
- FieldName = 'TaxRate'
- end
- object OrdersTableFreight: TCurrencyField
- DisplayWidth = 10
- FieldName = 'Freight'
- Currency = True
- end
- object OrdersTableAmountPaid: TCurrencyField
- DisplayWidth = 11
- FieldName = 'AmountPaid'
- Currency = True
- end
- end
- object OrdersDataSource: TDataSource
- DataSet = OrdersTable
- OnDataChange = OrdersDataSourceDataChange
- Left = 146
- Top = 277
- end
- object SimpleExpression: TExpression
- UseExceptions = False
- Left = 28
- Top = 53
- end
- object CustomersFilter: TDSFilter
- Lines.Strings = (
- 'Country <> "US"')
- UseExceptions = False
- Active = False
- AutoRefresh = False
- Datasource = CustomerDataSource
- LoadActivated = True
- Priority = 1
- Left = 241
- Top = 90
- end
- object OrdersFilter: TDSFilter
- UseExceptions = False
- Active = False
- AutoRefresh = False
- Datasource = OrdersDataSource
- LoadActivated = True
- Priority = 1
- Left = 176
- Top = 277
- end
- object OrdersExpression: TDBExpression
- UseExceptions = False
- Left = 663
- Top = 461
- end
- end
-