wiki:Docs/Prog/Manual/ApplicationLibraries/Database/SQLite

Table of Contents

  1. 825 Programmer's Manual
  2. Application Libraries
  3. Database Libraries
    1. MySQL Client
    1. About SQLite
    2. SQLite Library (libsql)
      1. Using libsql
    3. SqlBuilder Class
    4. SQLite++ Class
    5. Using SQLite++ with SqlBuilder
  4. Standard 825 Library with Application class (lib825)
    1. Utility Functions
  5. Standard 825 Library with EVENT features (lib825ev)
  6. Communications Functions
  7. CComm
    1. Member Functions
      1. Send
        1. Description
        2. Parameters
        3. Return value
      2. Process
        1. Description
      3. AddRcvEvent
        1. Parameters
        2. Description
        3. Example
      4. SetDebugRawRead
        1. Parameters
        2. Description
        3. Example
    2. See Also
  8. CCommClient
      1. Constructor
        1. Parameters
      2. Member Functions
        1. Description
        2. Example
    1. See Also
  9. CCommSerial
    1. Constructors
        1. Parameters
        2. Remarks
        3. Examples
        4. Example
    2. Member Functions
      1. SetPort
        1. Parameters
        2. Return Value
      2. Open
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      3. Close
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      4. SetParameters
        1. Parameters
        2. Return Value
        3. Remarks
        4. Examples
      5. IsReady
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      6. SetRTS
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
    3. See Also
  10. CCommServer
      1. Constructor
      2. Member Functions
        1. Description
        2. Example
    1. See Also
  11. Analog Output (DAC Digital to Analog Conversion) Functions
    1. Example - Application manually setting DAC output voltage
  12. GetDAC
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  13. GetDACPercent
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  14. GetDACRangeFromIndex
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  15. GetIndexFromDACRange
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  16. SetDACFloat
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  17. SetDACOutputRange
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  18. SetDACPercent
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  19. SetDACReg
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  20. SetDACTrackGrossNet
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  21. SetDACTrackScale
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  22. StopDACTrackScale
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  23. Debug Functions
  24. DEBUG_MSG
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  25. DEBUG_SHOWDATA
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  26. Display Functions
  27. CBitmap
    1. Constructors
        1. Parameters
        2. Examples
    2. Member Functions
      1. LoadBitmp
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      2. DeleteBitmap
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      3. Draw
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      4. GetWidth
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      5. GetHeight
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      6. GetColorCnt
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      7. GetColorsAdded
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      8. GetError
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      9. ReclaimColors
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
  28. CFont 825gen2
    1. Constructors
        1. Parameters
        2. Examples
    2. Member Functions
      1. CFreetypeFont& GetFont(int zoom)
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      2. Load
        1. Parameters
        2. Return Value
      3. SetPixelSize
        1. Parameters
        2. Return Value
      4. GetStrWidth
        1. Parameters
        2. Return Value
      5. DisplayText
        1. Parameters
        2. Return Value
  29. CImage 825gen2
    1. Constructors
        1. Parameters
        2. Examples
    2. Member Functions
      1. LoadImage
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      2. Draw
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
  30. ClearLCD
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  31. DisplayStr DEPRECATED - Replace with DisplayText
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  32. DisplayText
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  33. GetX
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  34. GetY
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  35. InitLCD
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  36. IsFontLoaded
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  37. LocateLCD
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  38. PrintLCD
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  39. PrintLCDbutton
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  40. PrintLCDfont2
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  41. ReadFont
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  42. SetBkColor
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  43. SetCurColor
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  44. File Functions
  45. CFile
    1. Constructors
        1. Parameters
        2. Examples
    2. Member Functions
      1. Open
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      2. Close
        1. Parameters
        2. Retrun Value
        3. Remarks
        4. Example
      3. SetSerial
        1. Parameters
        2. Return Value
        3. Remarks
        4. Examples
      4. ReadLine
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      5. DeleteFile
        1. Parameters
        2. Return value
        3. Remarks
        4. Examples
      6. IsOpen
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      7. IsReady
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      8. SetRTS
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      9. GetFile
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      10. Print
        1. Parameters
        2. Return Value
        3. Remarks
        4. Examples
      11. SetNonBlocking
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      12. Read
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      13. Write
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      14. GetBytesRead
        1. Parameters
        2. Return Value
        3. Example
      15. GetbytesWritten
        1. Parameters
        2. Return Value
        3. Example
      16. Seek
  46. FileCopy
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  47. FindChromiumPath 825gen2
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  48. FindFlashDrive 825gen2
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  49. GetFilesInPathWithExtension
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  50. IsMounted
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  51. MakeDirIfNotExists
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  52. MountDirectory 825gen2
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  53. UnmountDirectory 825gen2
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  54. Form Functions
  55. CForm
    1. Methods
  56. CFormRect 825gen2
  57. EVENT
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  58. EVENT_FLAG_SHOW
    1. Examples
    2. See Also
  59. EVENT_SHOW_BTN_CONTENT
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  60. EnableItem
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
      1. See Also
  61. ExitWithCode
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  62. FORM_ADD_BUTTON
    1. Parameters
    2. Return Value
    3. Remarks
      1. Button Styles
    4. Examples
    5. See Also
  63. FORM_ADD_BUTTON2 825gen2
    1. Parameters
    2. Return Value
    3. Remarks
      1. Button Styles
    4. Examples
    5. See Also
  64. FORM_ADD_INPUT
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  65. FORM_ADD_INPUT2 825gen2
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  66. FORM_DONE_ESCAPE
    1. Example
      1. See Also
  67. FORM_DONE_EVENT_EXTERNAL
    1. Example
      1. See Also
  68. FORM_DONE_LEFT_ARROW
    1. Example
      1. See Also
  69. FORM_HIDE
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  70. FORM_INIT
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  71. FORM_IS_UPDATED
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  72. FORM_RUN
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  73. FORM_SHOW
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  74. FindName
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
  75. GetCurrentItemIndex
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
  76. GetExitCode
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  77. GetItem
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
  78. !GetItemByIDVal
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
  79. GetItemCount
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
  80. GetItemIndex
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
  81. HideItem
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
      1. See Also
  82. IN_EVENT_HIDE_FORM
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  83. IN_EVENT_SHOW_FORM
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  84. IN_EVENT_WRITE_DATA
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  85. IsChanged
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  86. SetInputFont
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  87. SetKeyEvent
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  88. ShowItem
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
      1. See Also
  89. WriteData
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
    6. See Also
  90. Input / Output (Digital I/O) Functions
  91. GetInput
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  92. GetInputMask
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  93. GetOutput
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  94. SetDIOCounter
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  95. SetOutput
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  96. SetOutputMask
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  97. StartDIOPulse
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  98. StartRepeatIO Deprecated
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  99. StopDIOPulse
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  100. StopRepeatIO Deprecated
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  101. Keypad/Sound Functions
  102. ClearKeyBuffer
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  103. KeyPadInsertKey
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  104. KeyPadSetUSBEvent
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  105. OpenBeeper
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  106. PlayNotes
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  107. WaitKeypress
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  108. Process Functions
  109. GetProcessID
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  110. GetProcessIDExcludeSelf
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  111. KillProcess
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  112. ResetPrevGrossWt
  113. ResetPrevNetWt
  114. ResetPrevTareWt
  115. test
  116. String Functions
  117. FloatToStr
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  118. IntToStr
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  119. StrFmt
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  120. StrFmtLen
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  121. StrToFloat
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  122. StrToInt
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  123. StrTrimLeft
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  124. StrTrimRight
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  125. Ticket Functions
  126. CTktFlds
    1. Constructor
        1. Parameters
        2. Examples
    2. Member Functions
      1. Clear
        1. Parameters
        2. Return Value
        3. Remarks
        4. Examples
      2. Set
        1. Parameters
        2. Retrun Value
        3. Remarks
        4. Example
      3. SetEvent
        1. Parameters
        2. Retrun Value
        3. Remarks
        4. Example
      4. PrintTkt
        1. Parameters
        2. Return Value
        3. Remarks
        4. Examples
  127. PrintTkt
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  128. Time and Date Functions
  129. CMillisecondTimer
    1. Constructors
        1. Parameters
        2. Example
    2. Member Functions
      1. Set
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      2. Clear
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
  130. CSleep
    1. Constructor
        1. Parameters
        2. Example
    2. Member Functions
      1. SetTime
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      2. Pause
        1. Parameters
        2. Retrun Value
        3. Remarks
        4. Example
  131. CTimer
    1. Constructors
        1. Parameters
        2. Example
    2. Member Functions
      1. Set
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
      2. Clear
        1. Parameters
        2. Return Value
        3. Remarks
        4. Example
  132. DoSleep
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  133. GetDateStr
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  134. GetLinuxTime
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  135. GetTimeStr
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  136. IsTimeChanged
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  137. ResetPrevTime
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  138. SleepMilliseconds
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  139. SleepSeconds
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  140. Utility Functions
  141. GetKernelVer
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  142. GetKernelVerStr
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  143. GetLoaderVer
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  144. GetLoaderVerStr
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  145. GetMemFree
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  146. GetMnBdVer
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  147. GetMnBdVerStr
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  148. Weighing Functions
    1. Minimal Weight Indicator Sample Program
  149. CheckWIM * DEPRECATED - New apps should use MnBdSetWIM *
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  150. DLCRepeatMultiIncludeCellWts
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  151. FormatGrossWt
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  152. FormatNetWt
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  153. FormatTareWt
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  154. FormatWt
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  155. GetBelowZero
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  156. GetCapacity
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  157. GetCenterZero
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  158. GetCurUnitsLabel
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  159. GetDecimal
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  160. GetGrossWt
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  161. GetInterval
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  162. GetMotion
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  163. GetNetWt
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  164. GetNumScales
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  165. GetOverCap
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  166. GetProcessScale
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  167. GetSecUnitsLabel
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  168. GetTareWt
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  169. GetUnitsLabel
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  170. GetWtError
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  171. IsGrossWtChanged
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  172. IsNetWtChanged
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  173. IsTareWtChanged
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  174. IsWtStatusChanged
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  175. IsWtUnitsChanged
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  176. MnBdClearEvent
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  177. MnBdClose
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  178. MnBdGetErr
  179. MnBdGetErrMsg
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  180. MnBdGetErrMsgStr
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  181. MnBdOpen
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  182. MnBdProcess * DEPRECATED - New apps should use StartRepeatMulti *
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  183. MnBdRead
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  184. MnBdRequest
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  185. MnBdSetEvent
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  186. MnBdSetWIM
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  187. MnBdShutdown
  188. MnBdStartup
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  189. RequestWt * DEPRECATED - New apps should use StartRepeatMulti *
    1. Parameters
    2. Return Value
    3. Remarks
    4. See Also
  190. ResetPrevGrossWt
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  191. ResetPrevNetWt
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  192. ResetPrevTareWt
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  193. ResetPrevWtStatus
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  194. ResetPrevWtUnits
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  195. SetTareCurrent
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  196. SetTareValue
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  197. SetWIM * DEPRECATED - New apps should use MnBdSetWIM *
    1. Parameters
    2. Return Value
    3. Remarks
    4. Example
    5. See Also
  198. StartRepeatMulti
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  199. StartRepeatWt * DEPRECATED - New apps should use StartRepeatMulti *
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  200. StopRepeatMulti
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  201. StopRepeatWt * DEPRECATED - New apps should use StopRepeatMulti *
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  202. ZeroScale
    1. Parameters
    2. Return Value
    3. Remarks
    4. Examples
    5. See Also
  203. Development Environment
  204. Application Signing
  205. Debugging
    1. GDB
  206. Setup for Software Development
      1. About
      2. Features of the Cardinal 825 Programming Environment
      3. Required Files
      4. Installing the Environment
      5. Starting the Environment
      6. Using the Environment
        1. Welcome Screen
        2. Project Explorer
        3. Task Repositories
        4. Task Queries
        5. Subversion
        6. Hyper-V
  207. Version Control
    1. Subversion
      1. About Subversion
      2. Subclipse for Eclipse
        1. Installing Subclipse
          1. Importing Projects Using Subclipse
  208. Device Support
  209. Device Drivers
    1. Overview
  210. Beeper
  211. DIO
    1. Digital I/O
    2. DIO Events
      1. About
      2. The Code
    3. DIO Counting
      1. Description
      2. Example
  212. Display
    1. Fonts
  213. Network
    1. Network File System (NFS)
    2. Weight Server -- Network Access
    3. Network Programming
      1. 825 TCP/IP Server Example
      2. 825 TCP/IP Client Example
    4. Send E-mail from 825
    5. FTP
    6. Batch file to upload a file from a PC to an 825 using the 825 web …
    7. Batch file to download a file from an 825 to a PC using the 825 web …
  214. Serial Ports
    1. Using Serial Ports for Linux Shell
    2. Generic Serial Port Use
  215. USB Support
    1. 825 USB A Ports (2)
      1. USB Mass Storage
        1. Accessing USB storage from a program
      2. USB Keyboards
      3. USB Printing
        1. Compatible USB Printers
      4. USB Hubs
    2. 825 USB B Port (1)
      1. USB to PC communications
  216. Weighing
    1. Get Weight
      1. Command prompt testing
      2. Access the weight data from a program
  217. Foundation
  218. Application Mode Startup
    1. Introduction
    2. Modules
    3. Appmenu Shell Script
    4. Mounts
    5. Support Applications
  219. Shell operations - Linux / Windows command line Reference
  220. Mainboard Protocol
  221. Environment Setup
    1. About
    2. Features of the Cardinal 825 Programming Environment
    3. Required Files
    4. Installing the Environment
    5. Starting the Environment
    6. Using the Environment
      1. Welcome Screen
      2. Project Explorer
      3. Task Repositories
      4. Task Queries
      5. Subversion

About SQLite

The Cardinal 825 comes fully equipped with an open source relational database known as SQLite. SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain. SQLite is used by companies such as Adobe, Bloomberg, mozilla, symbian, Skype, and Google (Android OS).

SQLite Library (libsql)

Cardinal supplies a library that allows usage of the SQLite database as well as a wrapper class to make generating queries and using the database as easy as possible. You can get the latest library from this wiki or by checking out the latest source from the repository.

Using libsql

Once you have the latest source you will need to include it in your project by modifying your project settings. Follow the steps listed below to get up and running.

  1. Right-click on your project and choose properties from the drop-down menu.

No image "screenshot.1.jpeg" attached to Docs/Prog/Manual/ApplicationLibraries/Database/SQLite

  1. Choose C/C++ Build and then Settings from the next screen. Click on Directories under Sourcery G++ C++ Compiler.

No image "screenshot.2.jpeg" attached to Docs/Prog/Manual/ApplicationLibraries/Database/SQLite

  1. Click on the add button and choose Workspace and the libsql project from the popup.

No image "screenshot.3.jpeg" attached to Docs/Prog/Manual/ApplicationLibraries/Database/SQLite

  1. Click OK, OK and then observed the Include paths. It should have ${workspace_loc/libsql}.

No image "screenshot.4.jpeg" attached to Docs/Prog/Manual/ApplicationLibraries/Database/SQLite

  1. Next, click on Libraries under Sourcery G++ C++ Linker.

No image "screenshot.5.jpeg" attached to Docs/Prog/Manual/ApplicationLibraries/Database/SQLite

  1. In the Libraries (-l) pane choose the add button and enter pthread. Click the add button again and enter sql. If you're using the lib825 (and you probably are) that pane should look like the screenshot below.

No image "screenshot.6.jpeg" attached to Docs/Prog/Manual/ApplicationLibraries/Database/SQLite

  1. In the Library search path (-L) pane click the green add and choose Workspace. Pick libsql/Debug (or Release for release build) from the dropdown. If you do not have Debug you can either build the debug release of the libsql or manually enter /Debug after the libsql path. The final result should be identical to the image shown below.

No image "screenshot.7.jpeg" attached to Docs/Prog/Manual/ApplicationLibraries/Database/SQLite

  1. The Library search path (-L) should be identical to the image below (Release may say Debug if you're building a Debug build).

No image "screenshot.8.jpeg" attached to Docs/Prog/Manual/ApplicationLibraries/Database/SQLite

  1. Click OK to save your settings.

SqlBuilder Class

A query builder class has been included with the SQLite library to facilitate generation of queries. Using the class is recommended to eliminate query bugs (and debugging time). Below you can find examples of using the class.

// LibSQL Headers
#include "SqlBuilder.h"

int main(int ac, char **av) {
    SqlBuilder Sql;
        
    // Example of a simple query
    Sql.Select("name");
    Sql.From("customers");
    Sql.Print();
    Sql.Reset();

    // Example of using sorting
    Sql.Select("id");
    Sql.From("trucks");
    Sql.Sort(SQL_ORDER_ASC,"name");
    Sql.Print();
    Sql.Reset();
        
    // Example of using multiple arguments with a where clause
    Sql.Select("name","value");
    Sql.From("configuration");
    Sql.Where("name LIKE 'Thomas'", "id > 0");
    Sql.Print();
    Sql.Reset();
        
    // Most complicated example, multiple arguments, multiple sorts, and multiple tables with aliases
    // This also does a simple inner join and then sorts by customer name, truck name, in descending order.
    Sql.Select("c.id,t.id,c.name,t.name");
    Sql.From("trucks", "t"); // trucks table aliased as t, so the id field would be t.id
    Sql.From("customers", "c");
    Sql.Where("c.id > 0", "t.id > 0", "t.name LIKE 'temp'", "c.name LIKE 'kyle'");
    Sql.Sort(SQL_ORDER_DESC,"c.name","t.name");
    Sql.Print();
    Sql.Reset();

    // Using values to bind to the where clause.
    int nTmp = 5;
    Sql.Select("test");
    Sql.From("trucks");
    Sql.Where("id =", nTmp);
    Sql.Print();
        
    return 0;
}

Output:

# ./sqltest
SqlBuilder :: Query Generated = [SELECT name FROM customers]
SqlBuilder :: Query Generated = [SELECT id FROM trucks ORDER BY name ASC]
SqlBuilder :: Query Generated = [SELECT name, value FROM configuration WHERE name LIKE 'Thomas' id > 0]
SqlBuilder :: Query Generated = [SELECT c.id,t.id,c.name,t.name FROM trucks AS t, customers AS c WHERE c.id > 0 AND t.id > 0 AND t.name LIKE 'temp' AND c.name LIKE 'kyle' ORDER BY c.name, t.name DESC]
SqlBuilder :: Query Generated = [SELECT test FROM trucks WHERE id = 5]

SQLite++ Class

A C++ wrapper has been provided that sits on top of the SQLite C functions and aims to make implementation easier. See below for examples.

database db;

// Headers
#include "sq3.hpp"

int main(int ac,char **av) {
    database db;
        
    // Executing a simple query
    db.execute("SELECT * FROM trucks");
        
    // Iterating through rows of a result set
    statement st(db, "SELECT * FROM trucks");
    cursor cur(st.get_cursor());
    
    while(cur.step() == SQLITE_ROW) {
        string name;
        float accum;
        
        // Do stuff with data
        cur.get(0,name);
        cur.get(1,accum);
    }
    
    // Doing multiple inserts using bind and transactions for speed
    bool bError = false;
    
    transaction tr(db);
    st.prepare("INSERT INTO trucks (name,accum) VALUES (?,?);");
    
    for(int i = 0; i < 10; i++) {
        st.bind(1,"truck!");
        st.bind(2,i*1000.0);
        
        if (st.execute() == SQLITE_ERROR) {
                bError = true;
        }
    }
    
    if (bError) {
        tr.rollback();
    } else {
        tr.commit();
    }
}

Using SQLite++ with SqlBuilder

You can easily combine SQLite++ and SqlBuilder to make database access easy.

// LibSQL Headers
#include "sq3.hpp"
#include "SqlBuilder.h"

int main(int ac, char **av) {
    database db;
    SqlBuilder sql;

    // Identical to the select above
    sql.Select("*");
    sql.From("trucks");
    db.execute(sql.GetQuery());

    // Grab a specific row instead of all results
    // Gets the name of truck id 10
    sql.Select("name");
    sql.From("trucks");
    sql.Where("id =",10);
    db.execute(sql.GetQuery());
}
Last modified 19 months ago Last modified on 04/24/23 18:43:20
Note: See TracWiki for help on using the wiki.