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