home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a025 / 10.ddi / QUERY.FRM (.txt) < prev    next >
Encoding:
Visual Basic Form  |  1992-03-12  |  3.8 KB  |  184 lines
  1.     QUERYFORM
  2. Query SQL Server
  3. Form1
  4. Label1
  5. &Query:
  6. NEW_QUERY_BUTTON
  7. &New Query
  8. QUERY_FIELD
  9. Text1
  10. SEND_QUERY_BUTTON
  11. &Send Query
  12. CLOSE_BUTTON
  13. Close
  14. Label2
  15.     &Results:
  16. RESULT_FIELD
  17. Text1
  18. Courier
  19. Form_Click
  20. VBSQL1
  21. VBSQL1_Error
  22. SqlConn
  23. Severity
  24. ErrorNum
  25. OSError
  26. ErrorStr
  27. OSErrorStr
  28. RetCode
  29. ErrStr
  30. VBSQL1_Message3
  31. Message@
  32. State}
  33. MsgStr
  34.     SQLErrors/
  35. SQLErrors_Errorb
  36. SQLErrors_Message
  37. Command1
  38. Connect"
  39. Connect_Click
  40. Serverw
  41. SqlOpenConnection\
  42. SqlInitc
  43. SqlCmd
  44. SqlExec
  45. SqlResults
  46. SqlNextRowF
  47. NOMOREROWSW
  48. numcolu
  49. SqlNumColsB
  50. DataV
  51. SqlData
  52. SqlClose
  53. SqlWinExitK
  54. Form1x
  55. Continue
  56. DataStr
  57. CLOSE_BUTTON_Click
  58.     QUERYFORM*
  59. QUERY_FIELD_Change
  60. SEND_QUERY_BUTTON_Click
  61. QUERY_FIELD
  62. rowdata
  63. RESULT_FIELD
  64. RESULTS_FIELD@
  65. ClearFields
  66. Form_GotFocus
  67. NEW_QUERY_BUTTON_Click^
  68. @    Form_Load
  69. RESULTS_FIELD_Change
  70. coldata5
  71. collengths
  72.     SqlColLen
  73. colnameO
  74. SqlColName
  75.     actuallen
  76. colline
  77. TABKEY
  78. DETAIL_FIELD
  79. rowlen
  80.     SqlCancel
  81. resultsG    
  82. tmplen 
  83. colvalue
  84. nextline
  85.     underline
  86. rowcntj
  87. tmplenx
  88. templenh
  89. RESULTS_LIST_Clicke
  90. Result_list
  91. RESULTS_list4
  92.     ListCount
  93. Check
  94. GotFocus
  95. FocusC
  96. ResultP
  97. REGROW:
  98. NOMORERESULTS
  99. Process_SQL_queryt
  100. SubProcess_SQL_query-
  101. WhileResult
  102. RowProcess
  103.     owProcess
  104. value
  105. SqlAData]
  106.     Calculate
  107. length
  108. colpositions
  109. colwidth
  110. index
  111. altcol
  112. SqlAltColId
  113. db_nameF
  114. dbidR
  115.     sysusagesS
  116. order7
  117. computer
  118. colnum
  119. altop
  120. SqlAltOp}
  121. numalts
  122. SqlNumAltsL
  123. number
  124. columnsp
  125.     altstring}
  126.     SqlPrType
  127. altvalue
  128. psychology
  129.     SqlDatLen
  130. SqlCount
  131. coluline$
  132. SqlGetAltColInfo*
  133. AltColDetail
  134. Status
  135. AltColumnDataO    
  136. colid
  137.     aggopname
  138. ColInfod
  139. SqlGetColumnInfo
  140. ColDetails
  141. Collen]
  142.     ColDetailq
  143. ColumnData
  144. numcompy
  145. SqlNumCompute
  146. numorder
  147. SqlNumOrders
  148. ResultProcess
  149. ordercol
  150. SqlOrderColK
  151. RemColName
  152. even^
  153. column?
  154. headings
  155. displays
  156. program
  157. anyway
  158. would;    
  159. Form_KeyDown
  160. KeyCode
  161. Shift
  162. Form_DragOver
  163. Source
  164. Process_SQL_query1
  165. OutputData)    
  166. ClearResultArray
  167. HEADING_LABEL
  168. HEADINGS_LABEL
  169. Caption
  170. HEADINGS_FIELD
  171. DataLine
  172. numrows 
  173. CLOSE_BUTTON_Click
  174. SEND_QUERY_BUTTON_Click
  175.  Get the query.  Make sure there is ones
  176. There is no query in the Query field
  177.  Clear the result array, and result controls first
  178.  Fill the result array with the data
  179.  Fill the results field
  180. ClearFields
  181. NEW_QUERY_BUTTON_Click
  182. Form_Load
  183.  Call routine to clear the fieldsy
  184.