VisualIB  1.0
IBExpress library for making use of Borland IBExpress outside of C++Builder
 All Classes Files Functions Variables Typedefs Enumerations Enumerator Macros
vibsql.h
Go to the documentation of this file.
1 
9 #ifndef VIBSQL_H__
10 #define VIBSQL_H__
11 
12 #include "vibdefines.h"
13 #include "vibtypes.h"
14 #include "vibdatabase.h"
15 #include "vibtransaction.h"
16 #include "vibstring.h"
17 
22 struct VIBSQL
23 {
24  VIBBOOL isWeak;
25  void *opaque;
26 };
27 
28 #ifdef __cplusplus
29 extern "C" {
30 #endif
31 
33 VIBDLLFUNC VIBSQL * VIBCALL VIBSQL_New();
35 VIBDLLFUNC void VIBCALL VIBSQL_Destroy(VIBSQL *vsql);
37 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_Call(VIBSQL *vsql, int ErrCode, VIBBOOL RaiseError, int *ret);
39 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_CheckClosed(VIBSQL *vsql);
41 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_CheckOpen(VIBSQL *vsql);
43 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_CheckValidStatement(VIBSQL *vsql);
45 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_Close(VIBSQL *vsql);
47 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_ExecQuery(VIBSQL *vsql);
49 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_FreeHandle(VIBSQL *vsql);
51 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_Prepare(VIBSQL *vsql);
53 VIBDLLFUNC VIBString * VIBCALL VIBSQL_GetUniqueRelationName(VIBSQL *vsql);
55 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_Bof(VIBSQL *vsql);
57 VIBDLLFUNC void *** VIBCALL VIBSQL_DBHandle(VIBSQL *vsql);
59 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_Eof(VIBSQL *vsql);
61 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_FieldIndex(VIBSQL *vsql, const char *FieldName, int *ret);
63 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_Open(VIBSQL *vsql);
65 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_Params_ByName_SetIsNull(VIBSQL *vsql, const char *name, VIBBOOL IsNull);
67 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_Params_ByName_SetAsString(VIBSQL *vsql, const char *name, const char *str);
69 VIBDLLFUNC int VIBCALL VIBSQL_Params_ByName_GetSQLType(VIBSQL *vsql, const char *name);
74 VIBDLLFUNC VIBString * VIBCALL VIBSQL_Plan(VIBSQL *vsql);
76 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_Prepared(VIBSQL *vsql);
78 VIBDLLFUNC int VIBCALL VIBSQL_RecordCount(VIBSQL *vsql);
80 VIBDLLFUNC int VIBCALL VIBSQL_RowsAffected(VIBSQL *vsql);
82 VIBDLLFUNC VIBSQLTypes VIBCALL VIBSQL_SQLType(VIBSQL *vsql);
84 VIBDLLFUNC void *** VIBCALL VIBSQL_TRHandle(VIBSQL *vsql);
86 VIBDLLFUNC void ** VIBCALL VIBSQL_Handle(VIBSQL *vsql);
88 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_GetGenerateParamNames(VIBSQL *vsql);
90 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_SetGenerateParamNames(VIBSQL *vsql, VIBBOOL GenerateParamNames);
92 VIBDLLFUNC VIBString * VIBCALL VIBSQL_UniqueRelationName(VIBSQL *vsql);
97 VIBDLLFUNC VIBDatabase * VIBCALL VIBSQL_GetDatabase(VIBSQL *vsql);
99 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_SetDatabase(VIBSQL *vsql, VIBDatabase *Database);
101 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_GetGoToFirstRecordOnExecute(VIBSQL *vsql);
103 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_SetGoToFirstRecordOnExecute(VIBSQL *vsql, VIBBOOL GoToFirstRecordOnExecute);
105 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_GetParamCheck(VIBSQL *vsql);
107 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_SetParamCheck(VIBSQL *vsql, VIBBOOL ParamCheck);
109 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_SQL_SetText(VIBSQL *vsql, const char *Text);
114 VIBDLLFUNC VIBString * VIBCALL VIBSQL_SQL_GetText(VIBSQL *vsql);
119 VIBDLLFUNC VIBTransaction *VIBCALL VIBSQL_GetTransaction(VIBSQL *vsql);
121 VIBDLLFUNC VIBBOOL VIBCALL VIBSQL_SetTransaction(VIBSQL *vsql, VIBTransaction *Transaction);
122 
123 #ifdef __cplusplus
124 }
125 #endif
126 
127 // TIBXSQLVAR type values, from the InterBase API
128 #define VIB_SQL_VARYING 0x1c0
129 #define VIB_SQL_TEXT 0x1c4
130 #define VIB_SQL_DOUBLE 0x1e0
131 #define VIB_SQL_FLOAT 0x1e2
132 #define VIB_SQL_LONG 0x1f0
133 #define VIB_SQL_SHORT 0x1f4
134 #define VIB_SQL_TIMESTAMP 0x1fe
135 #define VIB_SQL_BLOB 0x208
136 #define VIB_SQL_D_FLOAT 0x212
137 #define VIB_SQL_ARRAY 0x21c
138 #define VIB_SQL_QUAD 0x226
139 #define VIB_SQL_TYPE_TIME 0x230
140 #define VIB_SQL_TYPE_DATE 0x23a
141 #define VIB_SQL_INT64 0x244
142 #define VIB_SQL_DATE 0x1fe
143 
144 #endif
145 
146 // EOF
147