Please help!!!!
See code below:
Code: Select all
EnableExplicit
UseSQLiteDatabase()
Define wndEvent.i
Global quitApp.i,workingdb.s
;Settings and colors
#textHeight = 25
#wndColor = $D5E6E5
#errorColor = $C0C1F0
#correctEntry = $D4EDC0
;Main objects enumerations
Enumeration
  #db
  #wndMain
  #mainContainer
  #wndQueryView
  #listResults
EndEnumeration
;Gadgets enumeration
Enumeration
  #header
  #strDBPath
  #txtDBPath
  #btnGetDB
  #txtField
  #listFields
  #txtContains
  #frame
  #strLike
  #btnView
  #courier15
  #courier12
EndEnumeration
;Gadgets for Window query view
Enumeration
  #viewHeader
  #btnCheck
  #btnUncheck
EndEnumeration
Procedure queryView(query.s)
  ;If it can open the database and can query it
  ;Then the Query Result window will show.
  
  Define recsmsg.s
   
       recsmsg = "Tickets found: 0"
    
      ; Open window to show results of query
      If OpenWindow(#wndQueryView,0,0,700,600,"Query Results",#PB_Window_SystemMenu|#PB_Window_WindowCentered,WindowID(#wndMain))
        SetWindowColor(#wndQueryView,#wndColor)
        
        TextGadget(#viewHeader,250,20,200,#textHeight,recsmsg,#PB_Text_Center)
        SetGadgetFont(#viewHeader,FontID(#courier15))
        
        ;Create listicongadget
        ListIconGadget(#listResults,10,40,680,500,"ID",50,#PB_ListIcon_CheckBoxes|#PB_ListIcon_ThreeState|#PB_ListIcon_FullRowSelect|#PB_ListIcon_AlwaysShowSelection)
        AddGadgetColumn(#listResults,1,"Summary",250)
        AddGadgetColumn(#listResults,2,"Description",380)
        
        ;Add buttons check and uncheck
        ButtonGadget(#btnUncheck,20,545,105,#textHeight,"Uncheck All")
        SetGadgetFont(#btnUncheck,FontID(#courier12))
        
        
        ButtonGadget(#btnCheck,135,545,100,#textHeight,"Check All")
        SetGadgetFont(#btnCheck,FontID(#courier12))
  
  EndIf
  
EndProcedure
Procedure wndMain()
  ;Open main window and create all the needed gadgets
  
  If OpenWindow(#wndMain,0,0,800,350,"Ticket Management",#PB_Window_SystemMenu|#PB_Window_ScreenCentered) 
    SetWindowColor(#wndMain,#wndColor)
    
    TextGadget(#header,250,20,300,#textHeight,"Spiceworks Bulk Ticket Delete",#PB_Text_Center)
    
    FrameGadget(#frame,25,50,750,150,"",#PB_Frame_Flat)
    
    TextGadget(#txtdbPath,60,60,80,#textHeight,"DB Path:",#PB_Text_Right)
    StringGadget(#strDBPath,145,60,350,#textHeight,"")
    
    ButtonGadget(#btnGetDB,500,60,100,#textHeight,"Get DB")
    ;BindGadgetEvent(#btnGetDB,@getDBPath())                 ; Call Back
    
    TextGadget(#txtField,50,120,100,#textHeight,"Where Field:")
    ComboBoxGadget(#listFields,160,120,125,25)
    AddGadgetItem(#listFields,0,"Summary")
    AddGadgetItem(#listFields,1,"Description")
    SetGadgetState(#listFields,0)         ; Set the first text in combo box
    
    TextGadget(#txtContains,280,120,80,#textHeight,"Contains",#PB_Text_Center)
    
    StringGadget(#strLike,365,120,300,#textHeight,"")
    
    ButtonGadget(#btnView,670,120,75,#textHeight,"View")
    BindGadgetEvent(#btnView,@queryView())                 ; Callback
    
    ;Load fonts And apply To gadgets
    If LoadFont(#courier15,"Courier",15,#PB_Font_Bold)
      SetGadgetFont(#header,FontID(#courier15))
    EndIf
    
    If LoadFont(#courier12,"Courier",12)
      SetGadgetFont(#txtDBPath,FontID(#courier12))
      SetGadgetFont(#strDBPath,FontID(#courier12))
      SetGadgetFont(#btnGetDB,FontID(#courier12))
      SetGadgetFont(#txtField,FontID(#courier12))
      SetGadgetFont(#txtContains,FontID(#courier12))
      SetGadgetFont(#strLike,FontID(#courier12))
    EndIf
    
   
  EndIf
  
EndProcedure
;-------------- Main Program -------------------
wndMain()
Repeat
  wndEvent = WindowEvent()
  
  Select wndEvent
      
    Case #PB_Event_CloseWindow
      
      Select EventWindow()
        Case #wndMain
          quitApp = 1
        Case #wndQueryView
          CloseWindow(#wndQueryView)
          
      EndSelect
      
  EndSelect
    
Until quitApp = 1

