home *** CD-ROM | disk | FTP | other *** search
/ Microsoft Internet Business Development Kit / PRODUCT_CD.iso / sqlsvr / odbcsdk / samples / admndemo / info.h < prev    next >
Encoding:
C/C++ Source or Header  |  1994-12-07  |  8.6 KB  |  278 lines
  1. //*---------------------------------------------------------------------------------
  2. //|  ODBC System Administrator
  3. //|
  4. //|  This code is furnished on an as-is basis as part of the ODBC SDK and is
  5. //|  intended for example purposes only.
  6. //|
  7. //|    Title:    INFO.H
  8. //|        This file contains the prototypes and defines for executing SQL
  9. //|            statements and displaying their results.
  10. //*---------------------------------------------------------------------------------
  11. #ifndef info_DEFS
  12. #define info_DEFS
  13.  
  14. #include <windows.h>
  15. #include "standard.h"
  16. #include "errcheck.h"
  17. #include "ctl3d.h"
  18. #include "results.h"
  19. #include "child.h"
  20. #include "execute.h"
  21. #include "stdlib.h"
  22.  
  23.  
  24. //*---------------------------------------------------------------------------------
  25. //|    Macros and Defines
  26. //*---------------------------------------------------------------------------------
  27. #define     MAX_QUALIFIER        45
  28. #define    MAX_OWNER            40
  29. #define    MAX_NAME                40
  30. #define    MAX_TYPE                40
  31. #define    MAX_SPEC_VAL        128
  32.  
  33. #define LIST_ALL            0
  34. #define LIST_TABLES        1
  35. #define LIST_VIEWS        2            
  36. #define     USER_SETCHECKSTATE             WM_USER + 1
  37. #define     USER_SETBUTTONSTATE             WM_USER + 2
  38. #define    USER_RESETLIST                 WM_USER + 3
  39. #define    USER_SETSTATES                    WM_USER + 4
  40. #define    USER_SETDEFAULTS                WM_USER + 5
  41.  
  42. #define     IDE_QUALIFIER        151
  43. #define    IDE_OWNER            153
  44. #define    IDE_NAME                155
  45. #define     IDL_LIST                157
  46. #define    IDX_ALL                158
  47. #define    IDX_TABLES            159
  48. #define    IDX_VIEWS            160
  49. #define    IDL_PIPES            162
  50. #define    LIST_WIDTH            184
  51.  
  52.  
  53. //---- Core Conformance -------------------------------------
  54. #define idsSQLAllocConnect                100
  55. #define idsSQLAllocEnv                    101
  56. #define idsSQLAllocStmt                    102
  57. #define idsSQLBindCol                    103
  58. #define idsSQLCancel                        104
  59. #define idsSQLColAttributes            105
  60. #define idsSQLConnect                    106
  61. #define idsSQLDescribeCol                107
  62. #define idsSQLDisconnect                108
  63. #define idsSQLError                        109
  64. #define idsSQLExecDirect                110
  65. #define idsSQLExecute                    111
  66. #define idsSQLFetch                        112
  67. #define idsSQLFreeConnect                113
  68. #define idsSQLFreeEnv                    114
  69. #define idsSQLFreeStmt                    115
  70. #define idsSQLGetCursorName            116
  71. #define idsSQLNumResultCols            117
  72. #define idsSQLPrepare                    118
  73. #define idsSQLRowCount                    119
  74. #define idsSQLSetCursorName            120
  75. #define idsSQLSetParam                    121
  76. #define idsSQLTransact                    122
  77. //---- Level 1 Conformance ----------------------------------    
  78. #define idsSQLColumns                    123
  79. #define idsSQLDriverConnect            124
  80. #define idsSQLGetConnectOption        125
  81. #define idsSQLGetData                    126
  82. #define idsSQLGetFunctions                127
  83. #define idsSQLGetStmtOption            128
  84. #define idsSQLGetTypeInfo                129
  85. #define idsSQLParamData                    130
  86. #define idsSQLPutData                    131
  87. #define idsSQLSetConnectOption        132
  88. #define idsSQLSetStmtOption            133
  89. #define idsSQLSpecialColumns            134
  90. #define idsSQLStatistics                135
  91. #define idsSQLTables                        136
  92. //---- Level 2 Conformance ----------------------------------
  93. #define idsSQLBrowseConnect            137
  94. #define idsSQLColumnPrivileges        138
  95. #define idsSQLDataSources                139
  96. #define idsSQLDescribeParam            140
  97. #define idsSQLExtendedFetch            141
  98. #define idsSQLForeignKeys                142
  99. #define idsSQLMoreResults                143
  100. #define idsSQLNativeSql                    144
  101. #define idsSQLNumParams                    145
  102. #define idsSQLParamOptions                146
  103. #define idsSQLPrimaryKeys                147
  104. #define idsSQLProcedureColumns        148
  105. #define idsSQLProcedures                150
  106. #define idsSQLSetPos                        151
  107. #define idsSQLSetScrollOptions        152
  108. #define idsSQLTablePrivileges            153
  109.  
  110. //
  111. // SQLGetInfo Types
  112. //
  113. #define     idsGetInfoBase                        200
  114.  
  115. #define     idsSQL_FD_FETCH_NEXT          300
  116. #define     idsSQL_FD_FETCH_FIRST         301
  117. #define     idsSQL_FD_FETCH_LAST          302
  118. #define     idsSQL_FD_FETCH_PREV          303
  119. #define     idsSQL_FD_FETCH_ABSOLUTE      304
  120. #define     idsSQL_FD_FETCH_RELATIVE      305
  121. #define     idsSQL_FD_FETCH_RESUME        306
  122.  
  123. #define     idsSQL_CONFORM_NONE                307
  124. #define     idsSQL_LEVEL1_NONE                308
  125. #define     idsSQL_LEVEL2_NONE                309
  126.  
  127. #define     idsSQL_NONSAG                        310
  128. #define     idsSQL_SAG                            311
  129.  
  130. #define    idsCONFORM_MINIMUM                312
  131. #define    idsCONFORM_CORE                    313
  132. #define    idsCONFORM_EXTENDED                314
  133.  
  134. #define    idsCONCAT_0                            315
  135. #define    idsCONCAT_1                            316
  136.  
  137. #define    idsCOMMIT_0                            317
  138. #define    idsCOMMIT_1                            318
  139. #define    idsCOMMIT_2                            319
  140.  
  141. #define    idsROLLBACK_0                        320
  142. #define    idsROLLBACK_1                        321
  143. #define    idsROLLBACK_2                        322
  144.  
  145. #define    idsUPPERCASE                        323
  146. #define    idsLOWERCASE                        324
  147. #define    idsCASESENSITIVE                    325
  148. #define    idsNOTCASESENSITIVE                326
  149.  
  150. #define    idsSQL_TXN_READ_UNCOMMITTED    327
  151. #define    idsSQL_TXN_READ_COMMITTED        328
  152. #define    idsSQL_TXN_REPEATABLE_READ        329
  153. #define    idsSQL_TXN_SERIALIZABLE            330
  154. #define    idsSQL_TXN_VERSIONING            331
  155.  
  156. #define    idsSQL_SCCO_READ_ONLY            332
  157. #define    idsSQL_SCCO_LOCK                    333
  158. #define    idsSQL_SCCO_OPT_TIMESTAMP        334
  159. #define    idsSQL_SCCO_OPT_VALUES            335
  160.  
  161. #define    idsSQL_SO_FORWARD_ONLY            336
  162. #define    idsSQL_SO_KEYSET_DRIVEN            337
  163. #define    idsSQL_SO_DYNAMIC                    338
  164. #define    idsSQL_SO_MIXED                    339
  165.  
  166. #define    idsNOTRANS                            340
  167. #define    idsDMLSUPPORT                        341
  168. #define    idsDDLSUPPORT                        342
  169.  
  170. #define     idsSQL_FN_CVT_CONVERT            343
  171.  
  172. #define    idsSQL_FN_NUM_ABS                    344
  173. #define    idsSQL_FN_NUM_ACOS            345
  174. #define    idsSQL_FN_NUM_ASIN            346
  175. #define    idsSQL_FN_NUM_ATAN            347
  176. #define    idsSQL_FN_NUM_ATAN2           348
  177. #define    idsSQL_FN_NUM_CEILING         349
  178. #define    idsSQL_FN_NUM_COS             350
  179. #define    idsSQL_FN_NUM_COT             351
  180. #define    idsSQL_FN_NUM_EXP             352
  181. #define    idsSQL_FN_NUM_FLOOR           353
  182. #define    idsSQL_FN_NUM_LOG             354
  183. #define    idsSQL_FN_NUM_MOD             355
  184. #define    idsSQL_FN_NUM_RAND            356
  185. #define    idsSQL_FN_NUM_PI              357
  186. #define    idsSQL_FN_NUM_SIGN            358
  187. #define    idsSQL_FN_NUM_SIN             359
  188. #define    idsSQL_FN_NUM_SQRT            360
  189. #define    idsSQL_FN_NUM_TAN             361
  190.  
  191. #define    idsSQL_FN_STR_ASCII                362
  192. #define    idsSQL_FN_STR_CHAR                363
  193. #define    idsSQL_FN_STR_CONCAT                364
  194. #define    idsSQL_FN_STR_INSERT                365
  195. #define    idsSQL_FN_STR_LEFT                366
  196. #define    idsSQL_FN_STR_LTRIM                367
  197. #define    idsSQL_FN_STR_LENGTH                368
  198. #define    idsSQL_FN_STR_LOCATE                369
  199. #define    idsSQL_FN_STR_LCASE                370
  200. #define    idsSQL_FN_STR_REPEAT                371
  201. #define    idsSQL_FN_STR_REPLACE            372
  202. #define    idsSQL_FN_STR_RIGHT                373
  203. #define    idsSQL_FN_STR_RTRIM                374
  204. #define    idsSQL_FN_STR_SUBSTRING            375
  205. #define    idsSQL_FN_STR_UCASE                376
  206.  
  207. #define    idsSQL_FN_SYS_USERNAME            377
  208. #define    idsSQL_FN_SYS_DBNAME                378
  209. #define    idsSQL_FN_SYS_IFNULL                379
  210.  
  211. #define    idsSQL_FN_TD_NOW                    380
  212. #define    idsSQL_FN_TD_CURDATE                381
  213. #define    idsSQL_FN_TD_DAYOFMONTH            382
  214. #define    idsSQL_FN_TD_DAYOFWEEK            383
  215. #define    idsSQL_FN_TD_DAYOFYEAR            384
  216. #define    idsSQL_FN_TD_MONTH                385
  217. #define    idsSQL_FN_TD_QUARTER                386
  218. #define    idsSQL_FN_TD_WEEK                    387
  219. #define    idsSQL_FN_TD_YEAR                    388
  220. #define    idsSQL_FN_TD_CURTIME                389
  221. #define    idsSQL_FN_TD_HOUR                    390
  222. #define    idsSQL_FN_TD_MINUTE                391
  223. #define    idsSQL_FN_TD_SECOND                392
  224.  
  225. #define    idsCVT_BIGINT                        393
  226. #define    idsCVT_BINARY                        394
  227. #define    idsCVT_BIT                            395
  228. #define    idsCVT_CHAR                            396
  229. #define    idsCVT_DATE                            397
  230. #define    idsCVT_DECIMAL                        398
  231. #define    idsCVT_DOUBLE                        399
  232. #define    idsCVT_FLOAT                        400
  233. #define    idsCVT_INTEGER                        401
  234. #define    idsCVT_LONGVARBINARY                402
  235. #define    idsCVT_LONGVARCHAR                403
  236. #define    idsCVT_NUMERIC                        404
  237. #define    idsCVT_REAL                            405
  238. #define    idsCVT_SMALLINT                    406
  239. #define    idsCVT_TIME                            407
  240. #define    idsCVT_TIMESTAMP                    408
  241. #define    idsCVT_TINYINT                        409
  242. #define    idsCVT_VARBINARY                    410
  243. #define    idsCVT_VARCHAR                        411
  244.  
  245. #define    IDD_EDIT_PIPE                        500
  246. #define    IDC_NAME                                501
  247. #define    IDB_NEW                                502
  248. #define    IDB_DELETE                            503
  249. #define    IDE_SQL                                504
  250. #define    IDR_VALUE                            505
  251. #define    IDR_ADDRESS                            506
  252. #define    IDE_PARMS                            507
  253. #define     IDX_DELETE                            508
  254.  
  255. #define    IDD_NEW_PIPE                        530
  256. #define     IDD_DO_PIPE                            550
  257.  
  258.  
  259. //*---------------------------------------------------------------------------------
  260. //|    Global variables
  261. //*---------------------------------------------------------------------------------
  262. extern dCSEG(char) szResultsClass[];
  263. extern dCSEG(char) szODBCFunctions[];
  264.  
  265. //*---------------------------------------------------------------------------------
  266. //|    Function prototypes
  267. //*---------------------------------------------------------------------------------
  268. void EditPipe(CHILDINFO FAR * ci);
  269. BOOL DisplayGetInfo(CHILDINFO FAR * ci);
  270. BOOL DisplayODBCFunctions(CHILDINFO FAR * ci);
  271. BOOL DisplayODBCDataSources(CHILDINFO FAR * ci);
  272. BOOL DisplayODBCDataTypes(CHILDINFO FAR * ci);
  273. void INTFUN HandlePipe(lpCHILDINFO lpci, lpRESULTSINFO lpri);
  274.  
  275.  
  276.  
  277. #endif
  278.