ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/branches/udr/client/IBHeader.pas
Revision: 45
Committed: Tue Dec 6 10:33:46 2016 UTC (7 years, 11 months ago) by tony
Content type: text/x-pascal
Original Path: ibx/trunk/fbintf/client/2.5/IBHeader.pas
File size: 97854 byte(s)
Log Message:
Committing updates for Release R2-0-0

File Contents

# User Rev Content
1 tony 45 {************************************************************************}
2     { }
3     { Borland Delphi Visual Component Library }
4     { InterBase Express core components }
5     { }
6     { Copyright (c) 1998-2000 Inprise Corporation }
7     { }
8     { InterBase Express is based in part on the product }
9     { Free IB Components, written by Gregory H. Deatz for }
10     { Hoagland, Longo, Moran, Dunst & Doukas Company. }
11     { Free IB Components is used under license. }
12     { }
13     { The contents of this file are subject to the InterBase }
14     { Public License Version 1.0 (the "License"); you may not }
15     { use this file except in compliance with the License. You }
16     { may obtain a copy of the License at http://www.Inprise.com/IPL.html }
17     { Software distributed under the License is distributed on }
18     { an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either }
19     { express or implied. See the License for the specific language }
20     { governing rights and limitations under the License. }
21     { The Original Code was created by InterBase Software Corporation }
22     { and its successors. }
23     { Portions created by Inprise Corporation are Copyright (C) Inprise }
24     { Corporation. All Rights Reserved. }
25     { Contributor(s): Jeff Overcash }
26     { }
27     { IBX For Lazarus (Firebird Express) }
28     { Contributor: Tony Whyman, MWA Software http://www.mwasoftware.co.uk }
29     { Portions created by MWA Software are copyright McCallum Whyman }
30     { Associates Ltd 2011 }
31     { }
32     {************************************************************************}
33    
34     unit IBHeader;
35    
36     {$IFDEF FPC}
37     {$mode objfpc}{$H+}
38     {$ENDIF}
39    
40     interface
41    
42     uses
43     IBExternals, IB;
44    
45    
46     const
47     ISC_TRUE = 1;
48     ISC_FALSE = 0;
49     DSQL_close = 1;
50     DSQL_drop = 2;
51    
52     const
53     SQLDA_VERSION1 = 1; (* pre V6.0 SQLDA *)
54     SQLDA_VERSION2 = 2; (* V6.0 SQLDA *)
55     SQL_DIALECT_V5 = 1; (* meaning is same as DIALECT_xsqlda *)
56     SQL_DIALECT_V6_TRANSITION = 2; (* flagging anything that is delimited
57     by double quotes as an error and
58     flagging keyword DATE as an error *)
59     SQL_DIALECT_V6 = 3; (* supports SQL delimited identifier,
60     SQLDATE/DATE, TIME, TIMESTAMP,
61     CURRENT_DATE, CURRENT_TIME,
62     CURRENT_TIMESTAMP, and 64-bit exact
63     numeric type *)
64     SQL_DIALECT_CURRENT = SQL_DIALECT_V6; (* latest IB DIALECT *)
65    
66    
67     type
68     (**********************************)
69     (** InterBase Handle Definitions **)
70     (**********************************)
71     TISC_ATT_HANDLE = FB_API_HANDLE;
72     PISC_ATT_HANDLE = ^TISC_ATT_HANDLE;
73     TISC_BLOB_HANDLE = FB_API_HANDLE;
74     PISC_BLOB_HANDLE = ^TISC_BLOB_HANDLE;
75     TISC_DB_HANDLE = FB_API_HANDLE;
76     PISC_DB_HANDLE = ^TISC_DB_HANDLE;
77     TISC_FORM_HANDLE = FB_API_HANDLE;
78     PISC_FORM_HANDLE = ^TISC_FORM_HANDLE;
79     TISC_REQ_HANDLE = FB_API_HANDLE;
80     PISC_REQ_HANDLE = ^TISC_REQ_HANDLE;
81     TISC_STMT_HANDLE = FB_API_HANDLE;
82     PISC_STMT_HANDLE = ^TISC_STMT_HANDLE;
83     TISC_SVC_HANDLE = FB_API_HANDLE;
84     PISC_SVC_HANDLE = ^TISC_SVC_HANDLE;
85     TISC_TR_HANDLE = FB_API_HANDLE;
86     PISC_TR_HANDLE = ^TISC_TR_HANDLE;
87     TISC_WIN_HANDLE = FB_API_HANDLE;
88     PISC_WIN_HANDLE = ^TISC_WIN_HANDLE;
89     TISC_CALLBACK = procedure;
90     ISC_SVC_HANDLE = ISC_LONG;
91    
92     (*******************************************************************)
93     (* Time & Date Support *)
94     (*******************************************************************)
95     const
96     TIME_SECONDS_PRECISION = 10000;
97     TIME_SECONDS_PRECISION_SCALE = -4;
98    
99     type
100     ISC_DATE = Long;
101     PISC_DATE = ^ISC_DATE;
102     ISC_TIME = ULong;
103     PISC_TIME = ^ISC_TIME;
104     TISC_TIMESTAMP = record
105     timestamp_date: ISC_DATE;
106     timestamp_time: ISC_TIME;
107     end;
108     PISC_TIMESTAMP = ^TISC_TIMESTAMP;
109    
110     TISC_ARRAY_BOUND = record
111     array_bound_lower : short;
112     array_bound_upper : short;
113     end;
114     PISC_ARRAY_BOUND = ^TISC_ARRAY_BOUND;
115     TISC_ARRAY_DESC = record
116     array_desc_dtype : UChar;
117     array_desc_scale : Char;
118     array_desc_length : UShort;
119     array_desc_field_name : array[0..31] of Char;
120     array_desc_relation_name : array[0..31] of Char;
121     array_desc_dimensions : Short;
122     array_desc_flags : Short;
123     array_desc_bounds : array[0..15] of TISC_ARRAY_BOUND;
124     end; // TISC_ARRAY_DESC
125     PISC_ARRAY_DESC = ^TISC_ARRAY_DESC;
126    
127     TISC_BLOB_DESC = record
128     blob_desc_subtype : Short;
129     blob_desc_charset : Short;
130     blob_desc_segment_size : Short;
131     blob_desc_field_name : array[0..31] of Char;
132     blob_desc_relation_name : array[0..31] of Char;
133     end; // TISC_BLOB_DESC
134     PISC_BLOB_DESC = ^TISC_BLOB_DESC;
135    
136     (*****************************)
137     (** Blob control structure **)
138     (*****************************)
139     TISC_BLOB_CTL_SOURCE_FUNCTION = function: ISC_STATUS; // ISC_FAR
140     PISC_BLOB_CTL = ^TISC_BLOB_CTL; // ISC_FAR
141     TISC_BLOB_CTL = record
142     (** Source filter **)
143     ctl_source : TISC_BLOB_CTL_SOURCE_FUNCTION;
144     (** Argument to pass to source filter **)
145     ctl_source_handle : PISC_BLOB_CTL;
146     ctl_to_sub_type : Short; (** Target type **)
147     ctl_from_sub_type : Short; (** Source type **)
148     ctl_buffer_length : UShort; (** Length of buffer **)
149     ctl_segment_length : UShort; (** Length of current segment **)
150     ctl_bpb_length : UShort; (** Length of blob parameter **)
151     (** block **)
152     ctl_bpb : PChar; (** Address of blob parameter **)
153     (** block **)
154     ctl_buffer : PUChar; (** Address of segment buffer **)
155     ctl_max_segment : ISC_LONG; (** Length of longest segment **)
156     ctl_number_segments : ISC_LONG; (** Total number of segments **)
157     ctl_total_length : ISC_LONG; (** Total length of blob **)
158     ctl_status : PISC_STATUS; (** Address of status vector **)
159     ctl_data : array[0..7] of long; (** Application specific data **)
160     end;
161     (*****************************)
162     (** Blob stream definitions **)
163     (*****************************)
164     TBSTREAM = record
165     bstr_blob : PVoid; (** Blob handle **)
166     bstr_buffer : PChar; (** Address of buffer **)
167     bstr_ptr : PChar; (** Next character **)
168     bstr_length : Short; (** Length of buffer **)
169     bstr_cnt : Short; (** Characters in buffer **)
170     bstr_mode : Char; (** (mode) ? OUTPUT : INPUT **)
171     end;
172     PBSTREAM = ^TBSTREAM;
173    
174     (*****************************)
175     (** Dynamic SQL definitions **)
176     (*****************************)
177     {$IFDEF IB5_ONLY}
178     TSQLVAR = record
179     sqltype : Short;
180     sqllen : Short;
181     sqldata : PChar;
182     sqlind : PShort;
183     sqlname_length : Short;
184     sqlname : array[0..29] of Char;
185     end;
186     PSQLVAR = ^TSQLVAR;
187    
188     TSQLDA = record
189     sqldaid : array[0..7] of Char;
190     sqldabc : ISC_LONG;
191     sqln : Short;
192     sqld : Short;
193     sqlvar : array[0..0] of TSQLVAR;
194     end;
195     PSQLDA = ^TSQLDA;
196     {$ENDIF}
197    
198     (********************************)
199     (** Declare the extended SQLDA **)
200     (********************************)
201     TXSQLVAR = record
202     sqltype : Short; (** datatype of field **)
203     sqlscale : Short; (** scale factor **)
204     sqlsubtype : Short; (** datatype subtype - BLOBs **)
205     (** & text types only **)
206     sqllen : Short; (** length of data area **)
207     sqldata : PChar; (** address of data **)
208     sqlind : PShort; (** address of indicator **)
209     (** variable **)
210     sqlname_length : Short; (** length of sqlname field **)
211     (** name of field, name length + space for NULL **)
212     sqlname : array[0..31] of Char;
213     relname_length : Short; (** length of relation name **)
214     (** field's relation name + space for NULL **)
215     relname : array[0..31] of Char;
216     ownname_length : Short; (** length of owner name **)
217     (** relation's owner name + space for NULL **)
218     ownname : array[0..31] of Char;
219     aliasname_length : Short; (** length of alias name **)
220     (** relation's alias name + space for NULL **)
221     aliasname : array[0..31] of Char;
222     end; // TXSQLVAR
223     PXSQLVAR = ^TXSQLVAR;
224    
225     TXSQLDA = record
226     version : Short; (** version of this XSQLDA **)
227     (** XSQLDA name field **)
228     sqldaid : array[0..7] of Char;
229     sqldabc : ISC_LONG; (** length in bytes of SQLDA **)
230     sqln : Short; (** number of fields allocated **)
231     sqld : Short; (** actual number of fields **)
232     (** first field address **)
233     sqlvar : array[0..0] of TXSQLVAR;
234     end; // TXSQLDA
235     PXSQLDA = ^TXSQLDA;
236    
237     (********************************************************)
238     (** This record type is for passing arguments to **)
239     (** isc_start_transaction (See docs) **)
240     (********************************************************)
241     TISC_START_TRANS = record
242     db_handle : PISC_DB_HANDLE;
243     tpb_length : UShort;
244     tpb_address : PChar;
245     end;
246    
247     (********************************************************)
248     (** This record type is for passing arguments to **)
249     (** isc_start_multiple (see docs) **)
250     (********************************************************)
251     TISC_TEB = record
252     db_handle : PISC_DB_HANDLE;
253     tpb_length : Long;
254     tpb_address : PChar;
255     end;
256     PISC_TEB = ^TISC_TEB;
257     TISC_TEB_ARRAY = array[0..0] of TISC_TEB;
258     PISC_TEB_ARRAY = ^TISC_TEB_ARRAY;
259    
260     (*****************************)
261     (** OSRI database functions **)
262     (*****************************)
263    
264     Tisc_attach_database = function (status_vector : PISC_STATUS;
265     db_name_length : Short;
266     db_name : PChar;
267     db_handle : PISC_DB_HANDLE;
268     parm_buffer_length : Short;
269     parm_buffer : PChar): ISC_STATUS;
270     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
271    
272     Tisc_array_gen_sdl = function (status_vector : PISC_STATUS;
273     isc_array_desc : PISC_ARRAY_DESC;
274     isc_arg3 : PShort;
275     isc_arg4 : PChar;
276     isc_arg5 : PShort): ISC_STATUS;
277     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
278    
279     Tisc_array_get_slice = function (status_vector : PISC_STATUS;
280     db_handle : PISC_DB_HANDLE;
281     trans_handle : PISC_TR_HANDLE;
282     array_id : PISC_QUAD;
283     descriptor : PISC_ARRAY_DESC;
284     dest_array : PVoid;
285     slice_length : PISC_LONG): ISC_STATUS;
286     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
287    
288     Tisc_array_lookup_bounds = function (status_vector : PISC_STATUS;
289     db_handle : PISC_DB_HANDLE;
290     trans_handle : PISC_TR_HANDLE;
291     table_name,
292     column_name : PChar;
293     descriptor : PISC_ARRAY_DESC): ISC_STATUS;
294     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
295    
296     Tisc_array_lookup_desc = function (status_vector : PISC_STATUS;
297     db_handle : PISC_DB_HANDLE;
298     trans_handle : PISC_TR_HANDLE;
299     table_name,
300     column_name : PChar;
301     descriptor : PISC_ARRAY_DESC): ISC_STATUS;
302     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
303    
304     Tisc_array_set_desc = function (status_vector : PISC_STATUS;
305     table_name : PChar;
306     column_name : PChar;
307     sql_dtype,
308     sql_length,
309     sql_dimensions : PShort;
310     descriptor : PISC_ARRAY_DESC): ISC_STATUS;
311     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
312    
313     Tisc_array_put_slice = function (status_vector : PISC_STATUS;
314     db_handle : PISC_DB_HANDLE;
315     trans_handle : PISC_TR_HANDLE;
316     array_id : PISC_QUAD;
317     descriptor : PISC_ARRAY_DESC;
318     source_array : PVoid;
319     slice_length : PISC_LONG): ISC_STATUS;
320     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
321    
322     Tisc_blob_default_desc = procedure (descriptor : PISC_BLOB_DESC;
323     table_name : PUChar;
324     column_name : PUChar);
325     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
326    
327     Tisc_blob_gen_bpb = function (status_vector : PISC_STATUS;
328     to_descriptor,
329     from_descriptor : PISC_BLOB_DESC;
330     bpb_buffer_length : UShort;
331     bpb_buffer : PUChar;
332     bpb_length : PUShort): ISC_STATUS;
333     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
334    
335     Tisc_blob_info = function (status_vector : PISC_STATUS;
336     blob_handle : PISC_BLOB_HANDLE;
337     item_list_buffer_length : Short;
338     item_list_buffer : PChar;
339     result_buffer_length : Short;
340     result_buffer : PChar): ISC_STATUS;
341     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
342    
343     Tisc_blob_lookup_desc = function (status_vector : PISC_STATUS;
344     db_handle : PISC_DB_HANDLE;
345     trans_handle : PISC_TR_HANDLE;
346     table_name,
347     column_name : PChar;
348     descriptor : PISC_BLOB_DESC;
349     global : PUChar): ISC_STATUS;
350     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
351    
352     Tisc_blob_set_desc = function (status_vector : PISC_STATUS;
353     table_name,
354     column_name : PChar;
355     subtype,
356     charset,
357     segment_size : Short;
358     descriptor : PISC_BLOB_DESC): ISC_STATUS;
359     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
360    
361     Tisc_cancel_blob = function (status_vector : PISC_STATUS;
362     blob_handle : PISC_BLOB_HANDLE): ISC_STATUS;
363     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
364    
365     Tisc_cancel_events = function (status_vector : PISC_STATUS;
366     db_handle : PISC_DB_HANDLE;
367     event_id : PISC_LONG): ISC_STATUS;
368     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
369    
370     Tisc_close_blob = function (status_vector : PISC_STATUS;
371     blob_handle : PISC_BLOB_HANDLE): ISC_STATUS;
372     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
373    
374     Tisc_commit_retaining = function (status_vector : PISC_STATUS;
375     tran_handle : PISC_TR_HANDLE): ISC_STATUS;
376     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
377    
378     Tisc_commit_transaction = function (status_vector : PISC_STATUS;
379     tran_handle : PISC_TR_HANDLE): ISC_STATUS;
380     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
381    
382     Tisc_create_blob = function (status_vector : PISC_STATUS;
383     db_handle : PISC_DB_HANDLE;
384     tran_handle : PISC_TR_HANDLE;
385     blob_handle : PISC_BLOB_HANDLE;
386     blob_id : PISC_QUAD): ISC_STATUS;
387     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
388    
389     Tisc_create_blob2 = function (status_vector : PISC_STATUS;
390     db_handle : PISC_DB_HANDLE;
391     tran_handle : PISC_TR_HANDLE;
392     blob_handle : PISC_BLOB_HANDLE;
393     blob_id : PISC_QUAD;
394     bpb_length : Short;
395     bpb_address : PChar): ISC_STATUS;
396     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
397    
398     Tisc_create_database = function (status_vector : PISC_STATUS;
399     isc_arg2 : Short;
400     isc_arg3 : PChar;
401     db_handle : PISC_DB_HANDLE;
402     isc_arg5 : Short;
403     isc_arg6 : PChar;
404     isc_arg7 : Short): ISC_STATUS;
405     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
406    
407     Tisc_database_info = function (status_vector : PISC_STATUS;
408     db_handle : PISC_DB_HANDLE;
409     item_list_buffer_length : Short;
410     item_list_buffer : PChar;
411     result_buffer_length : Short;
412     result_buffer : PChar): ISC_STATUS;
413     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
414    
415     Tisc_decode_date = procedure (ib_date: PISC_QUAD;
416     tm_date: PCTimeStructure);
417     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
418    
419     Tisc_decode_sql_date = procedure (ib_date: PISC_DATE;
420     tm_date: PCTimeStructure);
421     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
422    
423     Tisc_decode_sql_time = procedure (ib_time: PISC_TIME;
424     tm_date: PCTimeStructure);
425     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
426    
427     Tisc_decode_timestamp = procedure (ib_timestamp: PISC_TIMESTAMP;
428     tm_date: PCTimeStructure);
429     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
430    
431     Tisc_detach_database = function (status_vector : PISC_STATUS;
432     db_handle : PISC_DB_HANDLE): ISC_STATUS;
433     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
434    
435     Tisc_drop_database = function (status_vector : PISC_STATUS;
436     db_handle : PISC_DB_HANDLE): ISC_STATUS;
437     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
438    
439     Tisc_dsql_allocate_statement = function (status_vector : PISC_STATUS;
440     db_handle : PISC_DB_HANDLE;
441     stmt_handle : PISC_STMT_HANDLE): ISC_STATUS;
442     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
443    
444     Tisc_dsql_alloc_statement2 = function (status_vector : PISC_STATUS;
445     db_handle : PISC_DB_HANDLE;
446     stmt_handle : PISC_STMT_HANDLE): ISC_STATUS;
447     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
448    
449     Tisc_dsql_describe = function (status_vector : PISC_STATUS;
450     stmt_handle : PISC_STMT_HANDLE;
451     dialect : UShort;
452     xsqlda : PXSQLDA): ISC_STATUS;
453     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
454    
455     Tisc_dsql_describe_bind = function (status_vector : PISC_STATUS;
456     stmt_handle : PISC_STMT_HANDLE;
457     dialect : UShort;
458     xsqlda : PXSQLDA): ISC_STATUS;
459     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
460    
461     Tisc_dsql_exec_immed2 = function (status_vector : PISC_STATUS;
462     db_handle : PISC_DB_HANDLE;
463     tran_handle : PISC_TR_HANDLE;
464     length : UShort;
465     statement : PChar;
466     dialect : UShort;
467     in_xsqlda,
468     out_xsqlda : PXSQLDA): ISC_STATUS;
469     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
470    
471     Tisc_dsql_execute = function (status_vector : PISC_STATUS;
472     tran_handle : PISC_TR_HANDLE;
473     stmt_handle : PISC_STMT_HANDLE;
474     dialect : UShort;
475     xsqlda : PXSQLDA): ISC_STATUS;
476     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
477    
478     Tisc_dsql_execute2 = function (status_vector : PISC_STATUS;
479     tran_handle : PISC_TR_HANDLE;
480     stmt_handle : PISC_STMT_HANDLE;
481     dialect : UShort;
482     in_xsqlda,
483     out_xsqlda : PXSQLDA): ISC_STATUS;
484     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
485    
486     Tisc_dsql_execute_immediate = function (status_vector : PISC_STATUS;
487     db_handle : PISC_DB_HANDLE;
488     tran_handle : PISC_TR_HANDLE;
489     length : UShort;
490     statement : PChar;
491     dialect : UShort;
492     xsqlda : PXSQLDA): ISC_STATUS;
493     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
494    
495     Tisc_dsql_fetch = function (status_vector : PISC_STATUS;
496     stmt_handle : PISC_STMT_HANDLE;
497     dialect : UShort;
498     xsqlda : PXSQLDA): ISC_STATUS;
499     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
500    
501     (*$ifdef SCROLLABLE_CURSORS*)
502     Tisc_dsql_fetch2 = function (status_vector : PISC_STATUS;
503     stmt_handle : PISC_STMT_HANDLE;
504     dialect : UShort;
505     xsqlda : PXSQLDA;
506     isc_arg5 : UShort;
507     isc_arg6 : Long): ISC_STATUS;
508     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
509     (*$endif*)
510    
511     Tisc_dsql_finish = function (db_handle : PISC_DB_HANDLE): ISC_STATUS;
512     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
513    
514     Tisc_dsql_free_statement = function (status_vector : PISC_STATUS;
515     stmt_handle : PISC_STMT_HANDLE;
516     options : UShort): ISC_STATUS;
517     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
518    
519     Tisc_dsql_insert = function (status_vector : PISC_STATUS;
520     stmt_handle : PISC_STMT_HANDLE;
521     arg3 : UShort;
522     xsqlda : PXSQLDA): ISC_STATUS;
523     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
524    
525     Tisc_dsql_prepare = function (status_vector : PISC_STATUS;
526     tran_handle : PISC_TR_HANDLE;
527     stmt_handle : PISC_STMT_HANDLE;
528     length : UShort;
529     statement : PChar;
530     dialect : UShort;
531     xsqlda : PXSQLDA): ISC_STATUS;
532     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
533    
534     Tisc_dsql_set_cursor_name = function (status_vector : PISC_STATUS;
535     stmt_handle : PISC_STMT_HANDLE;
536     cursor_name : PChar;
537     _type : UShort): ISC_STATUS;
538     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
539    
540     Tisc_dsql_sql_info = function (status_vector : PISC_STATUS;
541     stmt_handle : PISC_STMT_HANDLE;
542     item_length : Short;
543     items : PChar;
544     buffer_length : Short;
545     buffer : PChar): ISC_STATUS;
546     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
547    
548     Tisc_encode_date = procedure (tm_date : PCTimeStructure;
549     ib_date : PISC_QUAD);
550     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
551    
552     Tisc_encode_sql_date = procedure (tm_date : PCTimeStructure;
553     ib_date : PISC_DATE);
554     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
555    
556     Tisc_encode_sql_time = procedure (tm_date : PCTimeStructure;
557     ib_time : PISC_TIME);
558     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
559    
560     Tisc_encode_timestamp = procedure (tm_date : PCTimeStructure;
561     ib_timestamp : PISC_TIMESTAMP);
562     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
563    
564     Tisc_event_block = function (event_buffer : PPChar;
565     result_buffer : PPChar;
566     id_count : UShort):ISC_LONG;
567     varargs; cdecl;
568    
569     Tisc_event_counts = procedure (status_vector : PISC_LONG;
570     buffer_length : Short;
571     event_buffer : PChar;
572     result_buffer : PChar);
573     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
574    
575     Tisc_expand_dpb = procedure (dpb : PPChar;
576     dpb_length : PShort;
577     item_list : array of Pointer);
578     cdecl;
579    
580     Tisc_modify_dpb = function (dpb : PPChar;
581     isc_arg2,
582     isc_arg3 : PShort;
583     isc_arg4 : UShort;
584     isc_arg5 : PChar;
585     isc_arg6 : Short): Int;
586     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
587    
588     Tisc_free = function (isc_arg1 : PChar): ISC_LONG;
589     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
590    
591     Tisc_get_segment = function (status_vector : PISC_STATUS;
592     blob_handle : PISC_BLOB_HANDLE;
593     actual_seg_length : PUShort;
594     seg_buffer_length : UShort;
595     seg_buffer : PChar): ISC_STATUS;
596     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
597    
598     Tisc_get_slice = function (status_vector : PISC_STATUS;
599     db_handle : PISC_DB_HANDLE;
600     tran_handle : PISC_TR_HANDLE;
601     isc_arg4 : PISC_QUAD;
602     isc_arg5 : Short;
603     isc_arg6 : PChar;
604     isc_arg7 : Short;
605     isc_arg8 : PISC_LONG;
606     isc_arg9 : ISC_LONG;
607     isc_arg10 : PVoid;
608     isc_arg11 : PISC_LONG): ISC_STATUS;
609     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
610    
611     Tisc_interprete = function (buffer : PChar;
612     status_vector : PPISC_STATUS): ISC_STATUS;
613     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
614    
615     Tisc_open_blob = function (status_vector : PISC_STATUS;
616     db_handle : PISC_DB_HANDLE;
617     tran_handle : PISC_TR_HANDLE;
618     blob_handle : PISC_BLOB_HANDLE;
619     blob_id : PISC_QUAD): ISC_STATUS;
620     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
621    
622     Tisc_open_blob2 = function (status_vector : PISC_STATUS;
623     db_handle : PISC_DB_HANDLE;
624     tran_handle : PISC_TR_HANDLE;
625     blob_handle : PISC_BLOB_HANDLE;
626     blob_id : PISC_QUAD;
627     bpb_length : Short;
628     bpb_buffer : PChar): ISC_STATUS;
629     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
630    
631     Tisc_prepare_transaction2 = function (status_vector : PISC_STATUS;
632     tran_handle : PISC_TR_HANDLE;
633     msg_length : Short;
634     msg : PChar): ISC_STATUS;
635     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
636    
637     Tisc_print_sqlerror = procedure (sqlcode : Short;
638     status_vector : PISC_STATUS);
639     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
640    
641     Tisc_print_status = function (status_vector : PISC_STATUS): ISC_STATUS;
642     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
643    
644     Tisc_put_segment = function (status_vector : PISC_STATUS;
645     blob_handle : PISC_BLOB_HANDLE;
646     seg_buffer_len : UShort;
647     seg_buffer : PChar): ISC_STATUS;
648     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
649    
650     Tisc_put_slice = function (status_vector : PISC_STATUS;
651     db_handle : PISC_DB_HANDLE;
652     tran_handle : PISC_TR_HANDLE;
653     isc_arg4 : PISC_QUAD;
654     isc_arg5 : Short;
655     isc_arg6 : PChar;
656     isc_arg7 : Short;
657     isc_arg8 : PISC_LONG;
658     isc_arg9 : ISC_LONG;
659     isc_arg10 : PVoid): ISC_STATUS;
660     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
661    
662     Tisc_que_events = function (status_vector : PISC_STATUS;
663     db_handle : PISC_DB_HANDLE;
664     event_id : PISC_LONG;
665     length : Short;
666     event_buffer : PChar;
667     event_function : TISC_CALLBACK;
668     event_function_arg : PVoid): ISC_STATUS;
669     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
670    
671     Tisc_rollback_retaining = function (status_vector : PISC_STATUS;
672     tran_handle : PISC_TR_HANDLE): ISC_STATUS;
673     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
674    
675     Tisc_rollback_transaction = function (status_vector : PISC_STATUS;
676     tran_handle : PISC_TR_HANDLE): ISC_STATUS;
677     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
678    
679     Tisc_start_multiple = function (status_vector : PISC_STATUS;
680     tran_handle : PISC_TR_HANDLE;
681     db_handle_count : Short;
682     teb_vector_address : PISC_TEB): ISC_STATUS;
683     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
684    
685     Tisc_start_transaction = function (status_vector : PISC_STATUS;
686     tran_handle : PISC_TR_HANDLE;
687     db_handle_count : Short;
688     db_handle : PISC_DB_HANDLE;
689     tpb_length : UShort;
690     tpb_address : PChar): ISC_STATUS;
691     cdecl;
692    
693     Tisc_sqlcode = function (status_vector : PISC_STATUS): ISC_LONG;
694     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
695    
696    
697     Tisc_sql_interprete = procedure (sqlcode : Short;
698     buffer : PChar;
699     buffer_length : Short);
700     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
701    
702     Tisc_transaction_info = function (status_vector : PISC_STATUS;
703     tran_handle : PISC_TR_HANDLE;
704     item_list_buffer_length : Short;
705     item_list_buffer : PChar;
706     result_buffer_length : Short;
707     result_buffer : PChar): ISC_STATUS;
708     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
709    
710     Tisc_transact_request = function (status_vector : PISC_STATUS;
711     db_handle : PISC_DB_HANDLE;
712     tran_handle : PISC_TR_HANDLE;
713     isc_arg4 : UShort;
714     isc_arg5 : PChar;
715     isc_arg6 : UShort;
716     isc_arg7 : PChar;
717     isc_arg8 : UShort;
718     isc_arg9 : PChar): ISC_STATUS;
719     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
720    
721     Tisc_vax_integer = function (buffer : PChar;
722     length : Short): ISC_LONG;
723     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
724    
725     Tisc_portable_integer = function (buffer : PChar;
726     length : Short): ISC_INT64;
727     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
728    
729     (***************************************)
730     (** Security Functions and structures **)
731     (***************************************)
732    
733     const
734     sec_uid_spec = $01;
735     sec_gid_spec = $02;
736     sec_server_spec = $04;
737     sec_password_spec = $08;
738     sec_group_name_spec = $10;
739     sec_first_name_spec = $20;
740     sec_middle_name_spec = $40;
741     sec_last_name_spec = $80;
742     sec_dba_user_name_spec = $100;
743     sec_dba_password_spec = $200;
744    
745     sec_protocol_tcpip = 1;
746     sec_protocol_netbeui = 2;
747     sec_protocol_spx = 3;
748     sec_protocol_local = 4;
749    
750     type
751     TUserSecData = record
752     sec_flags: Short; (** which fields are specified **)
753     uid: Int; (** the user's id **)
754     gid: int; (** the user's group id **)
755     protocol: Int; (** protocol to use for connection **)
756     server: PChar; (** server to administer **)
757     user_name: PChar; (** the user's name **)
758     password: PChar; (** the user's password **)
759     group_name: PChar; (** the group name **)
760     first_name: PChar; (** the user's first name **)
761     middle_name: PChar; (** the user's middle name **)
762     last_name: PChar; (** the user's last name **)
763     dba_user_name: PChar; (** the dba user name **)
764     dba_password: PChar; (** the dba password **)
765     end;
766     PUserSecData = ^TUserSecData;
767    
768     Tisc_add_user = function (status_vector : PISC_STATUS;
769     user_sec_data : PUserSecData): ISC_STATUS;
770     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
771    
772     Tisc_delete_user = function (status_vector : PISC_STATUS;
773     user_sec_data : PUserSecData): ISC_STATUS;
774     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
775    
776     Tisc_modify_user = function (status_vector : PISC_STATUS;
777     user_sec_data : PUserSecData): ISC_STATUS;
778     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
779    
780     (************************************)
781     (** Other OSRI functions **)
782     (************************************)
783    
784     Tisc_compile_request = function (status_vector : PISC_STATUS;
785     db_handle : PISC_DB_HANDLE;
786     request_handle : PISC_REQ_HANDLE;
787     isc_arg4 : Short;
788     isc_arg5 : PChar): ISC_STATUS;
789     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
790    
791     Tisc_compile_request2 = function (status_vector : PISC_STATUS;
792     db_handle : PISC_DB_HANDLE;
793     request_handle : PISC_REQ_HANDLE;
794     isc_arg4 : Short;
795     isc_arg5 : PChar): ISC_STATUS;
796     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
797    
798     Tisc_ddl = function (status_vector : PISC_STATUS;
799     db_handle : PISC_DB_HANDLE;
800     tran_handle : PISC_TR_HANDLE;
801     isc_arg4 : Short;
802     isc_arg5 : PChar): ISC_STATUS;
803     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
804    
805     Tisc_prepare_transaction = function (status_vector : PISC_STATUS;
806     tran_handle : PISC_TR_HANDLE): ISC_STATUS;
807     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
808    
809    
810     Tisc_receive = function (status_vector : PISC_STATUS;
811     request_handle : PISC_REQ_HANDLE;
812     isc_arg3,
813     isc_arg4 : Short;
814     isc_arg5 : PVoid;
815     isc_arg6 : Short): ISC_STATUS;
816     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
817    
818     Tisc_receive2 = function (status_vector : PISC_STATUS;
819     request_handle : PISC_REQ_HANDLE;
820     isc_arg3,
821     isc_arg4 : Short;
822     isc_arg5 : PVoid;
823     isc_arg6,
824     isc_arg7 : Short;
825     isc_arg8 : Long): ISC_STATUS;
826     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
827    
828     Tisc_reconnect_transaction = function (status_vector : PISC_STATUS;
829     db_handle : PISC_DB_HANDLE;
830     tran_handle : PISC_TR_HANDLE;
831     isc_arg4 : Short;
832     isc_arg5 : PChar): ISC_STATUS;
833     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
834    
835     Tisc_release_request = function (status_vector : PISC_STATUS;
836     request_handle : PISC_REQ_HANDLE): ISC_STATUS;
837     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
838    
839     Tisc_request_info = function (status_vector : PISC_STATUS;
840     request_handle : PISC_REQ_HANDLE;
841     isc_arg3 : Short;
842     isc_arg4 : Short;
843     isc_arg5 : PChar;
844     isc_arg6 : Short;
845     isc_arg7 : PChar): ISC_STATUS;
846     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
847    
848     Tisc_seek_blob = function (status_vector : PISC_STATUS;
849     blob_handle : PISC_BLOB_HANDLE;
850     isc_arg3 : Short;
851     isc_arg4 : ISC_LONG;
852     isc_arg5 : PISC_LONG): ISC_STATUS;
853     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
854    
855     Tisc_send = function (status_vector : PISC_STATUS;
856     request_handle : PISC_REQ_HANDLE;
857     isc_arg3,
858     isc_arg4 : Short;
859     isc_arg5 : PVoid;
860     isc_arg6 : Short): ISC_STATUS;
861     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
862    
863     Tisc_start_and_send = function (status_vector : PISC_STATUS;
864     request_handle : PISC_REQ_HANDLE;
865     tran_handle : PISC_TR_HANDLE;
866     isc_arg4,
867     isc_arg5 : Short;
868     isc_arg6 : PVoid;
869     isc_arg7 : Short): ISC_STATUS;
870     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
871    
872     Tisc_start_request = function (status_vector : PISC_STATUS;
873     request_handle : PISC_REQ_HANDLE;
874     tran_handle : PISC_TR_HANDLE;
875     isc_arg4 : Short): ISC_STATUS;
876     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
877    
878     Tisc_unwind_request = function (status_vector : PISC_STATUS;
879     tran_handle : PISC_TR_HANDLE;
880     isc_arg3 : Short): ISC_STATUS;
881     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
882    
883     Tisc_wait_for_event = function (status_vector : PISC_STATUS;
884     db_handle : PISC_DB_HANDLE;
885     length : Short;
886     event_buffer,
887     result_buffer : PChar): ISC_STATUS;
888     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
889    
890     (*******************************)
891     (** Other Sql functions **)
892     (*******************************)
893     {$IFDEF IB5_ONLY}
894     Tisc_close = function (status_vector : PISC_STATUS;
895     isc_arg2 : PChar): ISC_STATUS;
896     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
897    
898     Tisc_declare = function (status_vector : PISC_STATUS;
899     isc_arg2,
900     isc_arg3 : PChar): ISC_STATUS;
901     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
902    
903     Tisc_describe = function (status_vector : PISC_STATUS;
904     isc_arg2 : PChar;
905     isc_arg3 : PSQLDA): ISC_STATUS;
906     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
907    
908     Tisc_describe_bind = function (status_vector : PISC_STATUS;
909     isc_arg2 : PChar;
910     isc_arg3 : PSQLDA): ISC_STATUS;
911     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
912    
913     Tisc_execute = function (status_vector : PISC_STATUS;
914     tran_handle : PISC_TR_HANDLE;
915     isc_arg3 : PChar;
916     isc_arg4 : PSQLDA): ISC_STATUS;
917     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
918    
919     Tisc_execute_immediate = function (status_vector : PISC_STATUS;
920     db_handle : PISC_DB_HANDLE;
921     tran_handle : PISC_TR_HANDLE;
922     isc_arg4 : PShort;
923     isc_arg5 : PChar): ISC_STATUS;
924     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
925    
926     Tisc_fetch = function (status_vector : PISC_STATUS;
927     isc_arg2 : PChar;
928     isc_arg3 : PSQLDA): ISC_STATUS;
929     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
930    
931     Tisc_open = function (status_vector : PISC_STATUS;
932     tran_handle : PISC_TR_HANDLE;
933     isc_arg3 : PChar;
934     isc_arg4 : PSQLDA): ISC_STATUS;
935     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
936    
937     Tisc_prepare = function (status_vector : PISC_STATUS;
938     db_handle : PISC_DB_HANDLE;
939     tran_handle : PISC_TR_HANDLE;
940     isc_arg4 : PChar;
941     isc_arg5 : PShort;
942     isc_arg6 : PChar;
943     isc_arg7 : PSQLDA): ISC_STATUS;
944     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
945     {$ELSE}
946     Tisc_close = function (status_vector : PISC_STATUS;
947     isc_arg2 : PChar): ISC_STATUS;
948     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
949    
950     Tisc_declare = function (status_vector : PISC_STATUS;
951     isc_arg2,
952     isc_arg3 : PChar): ISC_STATUS;
953     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
954    
955     Tisc_describe = function (status_vector : PISC_STATUS;
956     isc_arg2 : PChar;
957     isc_arg3 : PXSQLDA): ISC_STATUS;
958     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
959    
960     Tisc_describe_bind = function (status_vector : PISC_STATUS;
961     isc_arg2 : PChar;
962     isc_arg3 : PXSQLDA): ISC_STATUS;
963     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
964    
965     Tisc_execute = function (status_vector : PISC_STATUS;
966     tran_handle : PISC_TR_HANDLE;
967     isc_arg3 : PChar;
968     isc_arg4 : PXSQLDA): ISC_STATUS;
969     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
970    
971     Tisc_execute_immediate = function (status_vector : PISC_STATUS;
972     db_handle : PISC_DB_HANDLE;
973     tran_handle : PISC_TR_HANDLE;
974     isc_arg4 : PShort;
975     isc_arg5 : PChar): ISC_STATUS;
976     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
977    
978     Tisc_fetch = function (status_vector : PISC_STATUS;
979     isc_arg2 : PChar;
980     isc_arg3 : PXSQLDA): ISC_STATUS;
981     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
982    
983     Tisc_open = function (status_vector : PISC_STATUS;
984     tran_handle : PISC_TR_HANDLE;
985     isc_arg3 : PChar;
986     isc_arg4 : PXSQLDA): ISC_STATUS;
987     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
988    
989     Tisc_prepare = function (status_vector : PISC_STATUS;
990     db_handle : PISC_DB_HANDLE;
991     tran_handle : PISC_TR_HANDLE;
992     isc_arg4 : PChar;
993     isc_arg5 : PShort;
994     isc_arg6 : PChar;
995     isc_arg7 : PXSQLDA): ISC_STATUS;
996     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
997     {$ENDIF}
998    
999     (***************************************)
1000     (** Other Dynamic sql functions **)
1001     (***************************************)
1002    
1003     Tisc_dsql_execute_m = function (status_vector : PISC_STATUS;
1004     tran_handle : PISC_TR_HANDLE;
1005     statement_handle : PISC_STMT_HANDLE;
1006     isc_arg4 : UShort;
1007     isc_arg5 : PChar;
1008     isc_arg6 : UShort;
1009     isc_arg7 : UShort;
1010     isc_arg8 : PChar): ISC_STATUS;
1011     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1012    
1013     Tisc_dsql_execute2_m = function (status_vector : PISC_STATUS;
1014     tran_handle : PISC_TR_HANDLE;
1015     statement_handle : PISC_STMT_HANDLE;
1016     isc_arg4 : UShort;
1017     isc_arg5 : PChar;
1018     isc_arg6 : UShort;
1019     isc_arg7 : UShort;
1020     isc_arg8 : PChar;
1021     isc_arg9 : UShort;
1022     isc_arg10 : PChar;
1023     isc_arg11 : UShort;
1024     isc_arg12 : UShort;
1025     isc_arg13 : PChar): ISC_STATUS;
1026     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1027    
1028     Tisc_dsql_execute_immediate_m = function (status_vector : PISC_STATUS;
1029     db_handle : PISC_DB_HANDLE;
1030     tran_handle : PISC_TR_HANDLE;
1031     isc_arg4 : UShort;
1032     isc_arg5 : PChar;
1033     isc_arg6 : UShort;
1034     isc_arg7 : UShort;
1035     isc_arg8 : PChar;
1036     isc_arg9 : UShort;
1037     isc_arg10 : UShort;
1038     isc_arg11 : PChar): ISC_STATUS;
1039     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1040    
1041     Tisc_dsql_exec_immed3_m = function (status_vector : PISC_STATUS;
1042     db_handle : PISC_DB_HANDLE;
1043     tran_handle : PISC_TR_HANDLE;
1044     isc_arg4 : UShort;
1045     isc_arg5 : PChar;
1046     isc_arg6 : UShort;
1047     isc_arg7 : UShort;
1048     isc_arg8 : PChar;
1049     isc_arg9 : UShort;
1050     isc_arg10 : UShort;
1051     isc_arg11 : PChar;
1052     isc_arg12 : UShort;
1053     isc_arg13 : PChar;
1054     isc_arg14 : UShort;
1055     isc_arg15 : UShort;
1056     isc_arg16 : PChar): ISC_STATUS;
1057     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1058    
1059     Tisc_dsql_fetch_m = function (status_vector : PISC_STATUS;
1060     statement_handle : PISC_STMT_HANDLE;
1061     isc_arg3 : UShort;
1062     isc_arg4 : PChar;
1063     isc_arg5 : UShort;
1064     isc_arg6 : UShort;
1065     isc_arg7 : PChar): ISC_STATUS;
1066     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1067    
1068     (*$ifdef SCROLLABLE_CURSORS*)
1069     Tisc_dsql_fetch2_m = function (status_vector : PISC_STATUS;
1070     statement_handle : PISC_STMT_HANDLE;
1071     isc_arg3 : UShort;
1072     isc_arg4 : PChar;
1073     isc_arg5 : UShort;
1074     isc_arg6 : UShort;
1075     isc_arg7 : PChar;
1076     isc_arg8 : UShort;
1077     isc_arg9 : Long): ISC_STATUS;
1078     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1079     (*$endif*)
1080    
1081     Tisc_dsql_insert_m = function (status_vector : PISC_STATUS;
1082     statement_handle : PISC_STMT_HANDLE;
1083     isc_arg3 : UShort;
1084     isc_arg4 : PChar;
1085     isc_arg5 : UShort;
1086     isc_arg6 : UShort;
1087     isc_arg7 : PChar): ISC_STATUS;
1088     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1089    
1090     Tisc_dsql_prepare_m = function (status_vector : PISC_STATUS;
1091     tran_handle : PISC_TR_HANDLE;
1092     statement_handle : PISC_STMT_HANDLE;
1093     isc_arg4 : UShort;
1094     isc_arg5 : PChar;
1095     isc_arg6 : UShort;
1096     isc_arg7 : UShort;
1097     isc_arg8 : PChar;
1098     isc_arg9 : UShort;
1099     isc_arg10 : PChar): ISC_STATUS;
1100     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1101    
1102     Tisc_dsql_release = function (status_vector : PISC_STATUS;
1103     isc_arg2 : PChar): ISC_STATUS;
1104     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1105    
1106     Tisc_embed_dsql_close = function(status_vector : PISC_STATUS;
1107     isc_arg2 : PChar): ISC_STATUS;
1108     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1109    
1110     Tisc_embed_dsql_declare = function (status_vector : PISC_STATUS;
1111     isc_arg2 : PChar;
1112     isc_arg3 : PChar): ISC_STATUS;
1113     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1114    
1115     Tisc_embed_dsql_describe = function (status_vector : PISC_STATUS;
1116     isc_arg2 : PChar;
1117     isc_arg3 : UShort;
1118     isc_arg4 : PXSQLDA): ISC_STATUS;
1119     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1120    
1121     Tisc_embed_dsql_describe_bind = function (status_vector : PISC_STATUS;
1122     isc_arg2 : PChar;
1123     isc_arg3 : UShort;
1124     isc_arg4 : PXSQLDA): ISC_STATUS;
1125     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1126    
1127     Tisc_embed_dsql_execute = function (status_vector : PISC_STATUS;
1128     tran_handle : PISC_TR_HANDLE;
1129     isc_arg3 : PChar;
1130     isc_arg4 : UShort;
1131     isc_arg5 : PXSQLDA): ISC_STATUS;
1132     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1133    
1134     Tisc_embed_dsql_execute2 = function (status_vector : PISC_STATUS;
1135     tran_handle : PISC_TR_HANDLE;
1136     isc_arg3 : PChar;
1137     isc_arg4 : UShort;
1138     isc_arg5 : PXSQLDA;
1139     isc_arg6 : PXSQLDA): ISC_STATUS;
1140     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1141    
1142     Tisc_embed_dsql_execute_immed = function (status_vector : PISC_STATUS;
1143     db_handle : PISC_DB_HANDLE;
1144     tran_handle : PISC_TR_HANDLE;
1145     isc_arg4 : UShort;
1146     isc_arg5 : PChar;
1147     isc_arg6 : UShort;
1148     isc_arg7 : PXSQLDA): ISC_STATUS;
1149     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1150    
1151     Tisc_embed_dsql_fetch = function(status_vector : PISC_STATUS;
1152     isc_arg2 : PChar;
1153     isc_arg3 : UShort;
1154     isc_arg4 : PXSQLDA): ISC_STATUS;
1155     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1156    
1157     (*$ifdef SCROLLABLE_CURSORS*)
1158     Tisc_embed_dsql_fetch2 = function (status_vector : PISC_STATUS;
1159     isc_arg2 : PChar;
1160     isc_arg3 : UShort;
1161     isc_arg4 : PXSQLDA;
1162     isc_arg5 : UShort;
1163     isc_arg6 : Long): ISC_STATUS;
1164     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1165     (*$endif*)
1166    
1167     Tisc_embed_dsql_open = function (status_vector : PISC_STATUS;
1168     tran_handle : PISC_TR_HANDLE;
1169     isc_arg3 : PChar;
1170     isc_arg4 : UShort;
1171     isc_arg5 : PXSQLDA): ISC_STATUS;
1172     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1173    
1174     Tisc_embed_dsql_open2 = function (status_vector : PISC_STATUS;
1175     tran_handle : PISC_TR_HANDLE;
1176     isc_arg3 : PChar;
1177     isc_arg4 : UShort;
1178     isc_arg5 : PXSQLDA;
1179     isc_arg6 : PXSQLDA): ISC_STATUS;
1180     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1181    
1182     Tisc_embed_dsql_insert = function (status_vector : PISC_STATUS;
1183     isc_arg2 : PChar;
1184     isc_arg3 : UShort;
1185     isc_arg4 : PXSQLDA): ISC_STATUS;
1186     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1187    
1188     Tisc_embed_dsql_prepare = function (status_vector : PISC_STATUS;
1189     db_handle : PISC_DB_HANDLE;
1190     tran_handle : PISC_TR_HANDLE;
1191     isc_arg4 : PChar;
1192     isc_arg5 : UShort;
1193     isc_arg6 : PChar;
1194     isc_arg7 : UShort;
1195     isc_arg8 : PXSQLDA): ISC_STATUS;
1196     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1197    
1198     Tisc_embed_dsql_release = function (status_vector : PISC_STATUS;
1199     isc_arg2 : PChar): ISC_STATUS;
1200     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1201    
1202     (********************************)
1203     (** Other Blob functions **)
1204     (********************************)
1205    
1206     TBLOB_open = function (blob_handle : TISC_BLOB_HANDLE;
1207     isc_arg2 : PChar;
1208     isc_arg3 : int): PBSTREAM;
1209     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1210    
1211     TBLOB_put = function (isc_arg1 : char;
1212     isc_arg2 : PBSTREAM): Int;
1213     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1214    
1215     TBLOB_close = function (isc_arg1 : PBSTREAM): Int;
1216     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1217    
1218     TBLOB_get = function (isc_arg1 : PBSTREAM): Int;
1219     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1220    
1221     TBLOB_display = function (isc_arg1 : PISC_QUAD;
1222     db_handle : TISC_DB_HANDLE;
1223     tran_handle : TISC_TR_HANDLE;
1224     isc_arg4 : PChar): Int;
1225     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1226    
1227     TBLOB_dump = function (isc_arg1 : PISC_QUAD;
1228     db_handle : TISC_DB_HANDLE;
1229     tran_handle : TISC_TR_HANDLE;
1230     isc_arg4 : PChar): Int;
1231     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1232    
1233     TBLOB_edit = function (isc_arg1 : PISC_QUAD;
1234     db_handle : TISC_DB_HANDLE;
1235     tran_handle : TISC_TR_HANDLE;
1236     isc_arg4 : PChar): Int;
1237     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1238    
1239     TBLOB_load = function (isc_arg1 : PISC_QUAD;
1240     db_handle : TISC_DB_HANDLE;
1241     tran_handle : TISC_TR_HANDLE;
1242     isc_arg4 : PChar): Int;
1243     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1244    
1245     TBLOB_text_dump = function (isc_arg1 : PISC_QUAD;
1246     db_handle : TISC_DB_HANDLE;
1247     tran_handle : TISC_TR_HANDLE;
1248     isc_arg4 : PChar): Int;
1249     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1250    
1251     TBLOB_text_load = function (isc_arg1 : PISC_QUAD;
1252     db_handle : TISC_DB_HANDLE;
1253     tran_handle : TISC_TR_HANDLE;
1254     isc_arg4 : PChar): Int;
1255     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1256    
1257     TBopen = function (isc_arg1 : PISC_QUAD;
1258     db_handle : TISC_DB_HANDLE;
1259     tran_handle : TISC_TR_HANDLE;
1260     isc_arg4 : PChar): Int;
1261     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1262    
1263     TBopen2 = function (isc_arg1 : PISC_QUAD;
1264     db_handle : TISC_DB_HANDLE;
1265     tran_handle : TISC_TR_HANDLE;
1266     isc_arg4 : PChar;
1267     isc_arg5 : UShort): PBSTREAM;
1268     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1269    
1270     (********************************)
1271     (** Other Misc functions **)
1272     (********************************)
1273    
1274     Tisc_ftof = function (isc_arg1 : PChar;
1275     isc_arg2 : UShort;
1276     isc_arg3 : PChar;
1277     isc_arg4 : UShort): ISC_LONG;
1278     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1279    
1280     Tisc_print_blr = function (isc_arg1 : PChar;
1281     isc_arg2 : TISC_CALLBACK;
1282     isc_arg3 : PVoid;
1283     isc_arg4 : Short): ISC_STATUS;
1284     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1285    
1286     Tisc_set_debug = procedure (isc_arg1 : Int);
1287     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1288    
1289     Tisc_qtoq = procedure (isc_arg1 : PISC_QUAD;
1290     isc_arg2 : PISC_QUAD);
1291     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1292    
1293     Tisc_vtof = procedure (isc_arg1 : PChar;
1294     isc_arg2 : PChar;
1295     isc_arg3 : UShort);
1296     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1297    
1298     Tisc_vtov = procedure (isc_arg1 : PChar;
1299     isc_arg2 : PChar;
1300     isc_arg3 : Short);
1301     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1302    
1303     Tisc_version = function (db_handle : PISC_DB_HANDLE;
1304     isc_arg2 : TISC_CALLBACK;
1305     isc_arg3 : PVoid): Int;
1306     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1307    
1308     Tisc_reset_fpe = function (isc_arg1 : UShort): ISC_LONG;
1309     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1310    
1311     (*******************************************)
1312     (** Service manager functions **)
1313     (*******************************************)
1314    
1315     Tisc_service_attach = function (status_vector : PISC_STATUS;
1316     isc_arg2 : UShort;
1317     isc_arg3 : PChar;
1318     service_handle : PISC_SVC_HANDLE;
1319     isc_arg5 : UShort;
1320     isc_arg6 : PChar): ISC_STATUS;
1321     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1322    
1323     Tisc_service_detach = function (status_vector : PISC_STATUS;
1324     service_handle : PISC_SVC_HANDLE): ISC_STATUS;
1325     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1326    
1327     Tisc_service_query = function (status_vector : PISC_STATUS;
1328     service_handle : PISC_SVC_HANDLE;
1329     recv_handle : PISC_SVC_HANDLE;
1330     isc_arg4 : UShort;
1331     isc_arg5 : PChar;
1332     isc_arg6 : UShort;
1333     isc_arg7 : PChar;
1334     isc_arg8 : UShort;
1335     isc_arg9 : PChar): ISC_STATUS;
1336     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1337    
1338     Tisc_service_start = function (status_vector : PISC_STATUS;
1339     service_handle : PISC_SVC_HANDLE;
1340     recv_handle : PISC_SVC_HANDLE;
1341     isc_arg4 : UShort;
1342     isc_arg5 : PChar): ISC_STATUS;
1343     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1344    
1345     (*********************************)
1346     (** Forms functions **)
1347     (*********************************)
1348    
1349     Tisc_compile_map = function (status_vector : PISC_STATUS;
1350     form_handle : PISC_FORM_HANDLE;
1351     request_handle : PISC_REQ_HANDLE;
1352     isc_arg4 : PShort;
1353     isc_arg5 : PChar): ISC_STATUS;
1354     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1355    
1356     Tisc_compile_menu = function (status_vector : PISC_STATUS;
1357     form_handle : PISC_FORM_HANDLE;
1358     request_handle : PISC_REQ_HANDLE;
1359     isc_arg4 : PShort;
1360     isc_arg5 : PChar): ISC_STATUS;
1361     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1362    
1363     Tisc_compile_sub_map = function (status_vector : PISC_STATUS;
1364     win_handle : PISC_WIN_HANDLE;
1365     request_handle : PISC_REQ_HANDLE;
1366     isc_arg4 : PShort;
1367     isc_arg5 : PChar): ISC_STATUS;
1368     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1369    
1370     Tisc_create_window = function (status_vector : PISC_STATUS;
1371     win_handle : PISC_WIN_HANDLE;
1372     isc_arg3 : PShort;
1373     isc_arg4 : PChar;
1374     isc_arg5 : PShort;
1375     isc_arg6 : PShort): ISC_STATUS;
1376     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1377    
1378     Tisc_delete_window = function (status_vector : PISC_STATUS;
1379     win_handle : PISC_WIN_HANDLE): ISC_STATUS;
1380     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1381    
1382     Tisc_drive_form = function (status_vector : PISC_STATUS;
1383     db_handle : PISC_DB_HANDLE;
1384     tran_handle : PISC_TR_HANDLE;
1385     win_handle : PISC_WIN_HANDLE;
1386     request_handle : PISC_REQ_HANDLE;
1387     isc_arg6 : PUChar;
1388     isc_arg7 : PUChar): ISC_STATUS;
1389     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1390    
1391     Tisc_drive_menu = function (status_vector : PISC_STATUS;
1392     win_handle : PISC_WIN_HANDLE;
1393     request_handle : PISC_REQ_HANDLE;
1394     isc_arg4 : PShort;
1395     isc_arg5 : PChar;
1396     isc_arg6 : PShort;
1397     isc_arg7 : PChar;
1398     isc_arg8 : PShort;
1399     isc_arg9 : PShort;
1400     isc_arg10 : PChar;
1401     isc_arg11 : PISC_LONG): ISC_STATUS;
1402     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1403    
1404     Tisc_form_delete = function (status_vector : PISC_STATUS;
1405     form_handle : PISC_FORM_HANDLE): ISC_STATUS;
1406     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1407    
1408     Tisc_form_fetch = function (status_vector : PISC_STATUS;
1409     db_handle : PISC_DB_HANDLE;
1410     tran_handle : PISC_TR_HANDLE;
1411     request_handle : PISC_REQ_HANDLE;
1412     isc_arg5 : PUChar): ISC_STATUS;
1413     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1414    
1415     Tisc_form_insert = function (status_vector : PISC_STATUS;
1416     db_handle : PISC_DB_HANDLE;
1417     tran_handle : PISC_TR_HANDLE;
1418     request_handle : PISC_REQ_HANDLE;
1419     isc_arg5 : PUChar): ISC_STATUS;
1420     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1421    
1422     Tisc_get_entree = function (status_vector : PISC_STATUS;
1423     request_handle : PISC_REQ_HANDLE;
1424     isc_arg3 : PShort;
1425     isc_arg4 : PChar;
1426     isc_arg5 : PISC_LONG;
1427     isc_arg6 : PShort): ISC_STATUS;
1428     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1429    
1430     Tisc_initialize_menu = function (status_vector : PISC_STATUS;
1431     request_handle : PISC_REQ_HANDLE): ISC_STATUS;
1432     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1433    
1434     Tisc_menu = function (status_vector : PISC_STATUS;
1435     win_handle : PISC_WIN_HANDLE;
1436     request_handle : PISC_REQ_HANDLE;
1437     isc_arg4 : PShort;
1438     isc_arg5 : PChar): ISC_STATUS;
1439     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1440    
1441     Tisc_load_form = function (status_vector : PISC_STATUS;
1442     db_handle : PISC_DB_HANDLE;
1443     tran_handle : PISC_TR_HANDLE;
1444     form_handle : PISC_FORM_HANDLE;
1445     isc_arg5 : PShort;
1446     isc_arg6 : PChar): ISC_STATUS;
1447     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1448    
1449     Tisc_pop_window = function (status_vector : PISC_STATUS;
1450     win_handle : PISC_WIN_HANDLE): ISC_STATUS;
1451     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1452    
1453     Tisc_put_entree = function (status_vector : PISC_STATUS;
1454     request_handle : PISC_REQ_HANDLE;
1455     isc_arg3 : PShort;
1456     isc_arg4 : PChar;
1457     isc_arg5 : PISC_LONG): ISC_STATUS;
1458     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1459    
1460     Tisc_reset_form = function (status_vector : PISC_STATUS;
1461     request_handle : PISC_REQ_HANDLE): ISC_STATUS;
1462     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1463    
1464     Tisc_suspend_window = function (status_vector : PISC_STATUS;
1465     win_handle : PISC_WIN_HANDLE): ISC_STATUS;
1466     {$IFDEF WINDOWS} stdcall; {$ELSE} cdecl; {$ENDIF}
1467    
1468     (** Constants!!! **)
1469     (*****************************************************)
1470     (** Actions to pass to the blob filter (ctl_source) **)
1471     (*****************************************************)
1472    
1473     const
1474     isc_blob_filter_open = 0;
1475     isc_blob_filter_get_segment = 1;
1476     isc_blob_filter_close = 2;
1477     isc_blob_filter_create = 3;
1478     isc_blob_filter_put_segment = 4;
1479     isc_blob_filter_alloc = 5;
1480     isc_blob_filter_free = 6;
1481     isc_blob_filter_seek = 7;
1482    
1483     (*********************)
1484     (** Blr definitions **)
1485     (*********************)
1486    
1487     // In pascal, how does one deal with the below "#define"?
1488     // blr_word(n) ((n) % 256), ((n) / 256)
1489     blr_text = 14;
1490     blr_text2 = 15;
1491     blr_short = 7;
1492     blr_long = 8;
1493     blr_quad = 9;
1494     blr_float = 10;
1495     blr_double = 27;
1496     blr_d_float = 11;
1497     blr_timestamp = 35;
1498     blr_varying = 37;
1499     blr_varying2 = 38;
1500     blr_blob = 261;
1501     blr_cstring = 40;
1502     blr_cstring2 = 41;
1503     blr_blob_id = 45;
1504     blr_sql_date = 12;
1505     blr_sql_time = 13;
1506     blr_int64 = 16;
1507     blr_date = blr_timestamp;
1508     blr_bool = 23;
1509    
1510    
1511     blr_inner = 0;
1512     blr_left = 1;
1513     blr_right = 2;
1514     blr_full = 3;
1515    
1516     blr_gds_code = 0;
1517     blr_sql_code = 1;
1518     blr_exception = 2;
1519     blr_trigger_code = 3;
1520     blr_default_code = 4;
1521    
1522     blr_version4 = 4;
1523     blr_version5 = 5;
1524     blr_eoc = 76;
1525     blr_end = -1;
1526    
1527     blr_assignment = 1;
1528     blr_begin = 2;
1529     blr_dcl_variable = 3;
1530     blr_message = 4;
1531     blr_erase = 5;
1532     blr_fetch = 6;
1533     blr_for = 7;
1534     blr_if = 8;
1535     blr_loop = 9;
1536     blr_modify = 10;
1537     blr_handler = 11;
1538     blr_receive = 12;
1539     blr_select = 13;
1540     blr_send = 14;
1541     blr_store = 15;
1542     blr_label = 17;
1543     blr_leave = 18;
1544     blr_store2 = 19;
1545     blr_post = 20;
1546    
1547     blr_literal = 21;
1548     blr_dbkey = 22;
1549     blr_field = 23;
1550     blr_fid = 24;
1551     blr_parameter = 25;
1552     blr_variable = 26;
1553     blr_average = 27;
1554     blr_count = 28;
1555     blr_maximum = 29;
1556     blr_minimum = 30;
1557     blr_total = 31;
1558     blr_add = 34;
1559     blr_subtract = 35;
1560     blr_multiply = 36;
1561     blr_divide = 37;
1562     blr_negate = 38;
1563     blr_concatenate = 39;
1564     blr_substring = 40;
1565     blr_parameter2 = 41;
1566     blr_from = 42;
1567     blr_via = 43;
1568     blr_user_name = 44;
1569     blr_null = 45;
1570    
1571     blr_eql = 47;
1572     blr_neq = 48;
1573     blr_gtr = 49;
1574     blr_geq = 50;
1575     blr_lss = 51;
1576     blr_leq = 52;
1577     blr_containing = 53;
1578     blr_matching = 54;
1579     blr_starting = 55;
1580     blr_between = 56;
1581     blr_or = 57;
1582     blr_and = 58;
1583     blr_not = 59;
1584     blr_any = 60;
1585     blr_missing = 61;
1586     blr_unique = 62;
1587     blr_like = 63;
1588    
1589     blr_stream = 65;
1590     blr_set_index = 66;
1591     blr_rse = 67;
1592     blr_first = 68;
1593     blr_project = 69;
1594     blr_sort = 70;
1595     blr_boolean = 71;
1596     blr_ascending = 72;
1597     blr_descending = 73;
1598     blr_relation = 74;
1599     blr_rid = 75;
1600     blr_union = 76;
1601     blr_map = 77;
1602     blr_group_by = 78;
1603     blr_aggregate = 79;
1604     blr_join_type = 80;
1605    
1606     blr_agg_count = 83;
1607     blr_agg_max = 84;
1608     blr_agg_min = 85;
1609     blr_agg_total = 86;
1610     blr_agg_average = 87;
1611     blr_parameter3 = 88;
1612     blr_run_count = 118;
1613     blr_run_max = 89;
1614     blr_run_min = 90;
1615     blr_run_total = 91;
1616     blr_run_average = 92;
1617     blr_agg_count2 = 93;
1618     blr_agg_count_distinct = 94;
1619     blr_agg_total_distinct = 95;
1620     blr_agg_average_distinct = 96;
1621    
1622     blr_function = 100;
1623     blr_gen_id = 101;
1624     blr_prot_mask = 102;
1625     blr_upcase = 103;
1626     blr_lock_state = 104;
1627     blr_value_if = 105;
1628     blr_matching2 = 106;
1629     blr_index = 107;
1630     blr_ansi_like = 108;
1631     blr_bookmark = 109;
1632     blr_crack = 110;
1633     blr_force_crack = 111;
1634     blr_seek = 112;
1635     blr_find = 113;
1636    
1637     blr_continue = 0;
1638     blr_forward = 1;
1639     blr_backward = 2;
1640     blr_bof_forward = 3;
1641     blr_eof_backward = 4;
1642    
1643     blr_lock_relation = 114;
1644     blr_lock_record = 115;
1645     blr_set_bookmark = 116;
1646     blr_get_bookmark = 117;
1647     blr_rs_stream = 119;
1648     blr_exec_proc = 120;
1649     blr_begin_range = 121;
1650     blr_end_range = 122;
1651     blr_delete_range = 123;
1652     blr_procedure = 124;
1653     blr_pid = 125;
1654     blr_exec_pid = 126;
1655     blr_singular = 127;
1656     blr_abort = 128;
1657     blr_block = 129;
1658     blr_error_handler = 130;
1659     blr_cast = 131;
1660     blr_release_lock = 132;
1661     blr_release_locks = 133;
1662     blr_start_savepoint = 134;
1663     blr_end_savepoint = 135;
1664     blr_find_dbkey = 136;
1665     blr_range_relation = 137;
1666     blr_delete_ranges = 138;
1667    
1668     blr_plan = 139;
1669     blr_merge = 140;
1670     blr_join = 141;
1671     blr_sequential = 142;
1672     blr_navigational = 143;
1673     blr_indices = 144;
1674     blr_retrieve = 145;
1675    
1676     blr_relation2 = 146;
1677     blr_rid2 = 147;
1678     blr_reset_stream = 148;
1679     blr_release_bookmark = 149;
1680     blr_set_generator = 150;
1681     blr_ansi_any = 151;
1682     blr_exists = 152;
1683     blr_cardinality = 153;
1684    
1685     blr_record_version = 154; (** get tid of record **)
1686     blr_stall = 155; (** fake server stall **)
1687     blr_seek_no_warn = 156;
1688     blr_find_dbkey_version = 157;
1689     blr_ansi_all = 158;
1690    
1691     blr_extract = 159;
1692    
1693     (* sub parameters for blr_extract *)
1694    
1695     blr_extract_year = 0;
1696     blr_extract_month = 1;
1697     blr_extract_day = 2;
1698     blr_extract_hour = 3;
1699     blr_extract_minute = 4;
1700     blr_extract_second = 5;
1701     blr_extract_weekday = 6;
1702     blr_extract_yearday = 7;
1703    
1704     blr_current_date = 160;
1705     blr_current_timestamp = 161;
1706     blr_current_time = 162;
1707    
1708     (* These verbs were added in 6.0,
1709     primarily to support 64-bit integers *)
1710    
1711     blr_add2 = 163;
1712     blr_subtract2 = 164;
1713     blr_multiply2 = 165;
1714     blr_divide2 = 166;
1715     blr_agg_total2 = 167;
1716     blr_agg_total_distinct2 = 168;
1717     blr_agg_average2 = 169;
1718     blr_agg_average_distinct2 = 170;
1719     blr_average2 = 171;
1720     blr_gen_id2 = 172;
1721     blr_set_generator2 = 173;
1722    
1723     (****************************************)
1724     (** Bit assignments in RDB$SYSTEM_FLAG **)
1725     (****************************************)
1726    
1727     RDB_system = 1;
1728     RDB_id_assigned = 2;
1729    
1730    
1731     (*******************************)
1732     (** Service information items **)
1733     (*******************************)
1734    
1735     {$IFDEF IB5_ONLY }
1736     (* This defines are not there in version 6.0 *)
1737     { isc_info_svc_version = 4;
1738     isc_info_svc_message = 5;
1739     isc_info_svc_total_length = 6;
1740     isc_info_svc_response = 7;
1741     isc_info_svc_response_more = 8;
1742     isc_info_svc_line = 9;
1743     isc_info_svc_to_eof = 10;
1744     isc_info_svc_timeout = 11;
1745     isc_info_svc_server_version = 12;
1746     isc_info_svc_implementation = 13;
1747     isc_info_svc_capabilities = 14;
1748     isc_info_svc_user_dbpath = 15;
1749     isc_info_svc_svr_db_info = 16;
1750     isc_info_svc_svr_online = 17;
1751     isc_info_svc_svr_offline = 18;
1752     isc_info_svc_get_config = 19;
1753     isc_info_svc_set_config = 20;
1754     isc_info_svc_default_config = 21;
1755     isc_info_svc_get_env = 22;
1756     isc_info_svc_get_env_lock = 23;
1757     isc_info_svc_get_env_msg = 24; }
1758     {$ENDIF}
1759    
1760    
1761    
1762     (*****************)
1763     (** Error codes **)
1764     (*****************)
1765    
1766     isc_facility = 20;
1767     isc_err_base = 335544320;
1768     isc_err_factor = 1;
1769     isc_arg_end = 0;
1770     isc_arg_gds = 1;
1771     isc_arg_string = 2;
1772     isc_arg_cstring = 3;
1773     isc_arg_number = 4;
1774     isc_arg_interpreted = 5;
1775     isc_arg_vms = 6;
1776     isc_arg_unix = 7;
1777     isc_arg_domain = 8;
1778     isc_arg_dos = 9;
1779     isc_arg_mpexl = 10;
1780     isc_arg_mpexl_ipc = 11;
1781     isc_arg_next_mach = 15;
1782     isc_arg_netware = 16;
1783     isc_arg_win32 = 17;
1784     isc_arg_warning = 18;
1785    
1786     (**********************************************)
1787     (** International text interpretation values **)
1788     (**********************************************)
1789    
1790     isc_interp_eng_ascii = 0;
1791     isc_interp_jpn_sjis = 5;
1792     isc_interp_jpn_euc = 6;
1793    
1794     (******************************************)
1795     (** Scroll direction for isc_dsql_fetch2 **)
1796     (******************************************)
1797    
1798     isc_fetch_next = 0;
1799     isc_fetch_prior = 1;
1800     isc_fetch_first = 2;
1801     isc_fetch_last = 3;
1802     isc_fetch_absolute = 4;
1803     isc_fetch_relative = 5;
1804    
1805    
1806    
1807     {$IFDEF IB5_ONLY}
1808     (** SQLDA_LENGTH is defined in C as a macro, but in Pascal we must defined it
1809     as a function... **)
1810     function SQLDA_LENGTH(n: Long): Long;
1811     {$ENDIF}
1812    
1813     (** XSQLDA_LENGTH is defined in C as a macro, but in Pascal we must defined it
1814     as a function... **)
1815     function XSQLDA_LENGTH(n: Long): Long;
1816    
1817     (** getb, putb, putbx are all defined in C as macros.
1818     Use functions and procedures for the functionality **)
1819     {function getb (p: PBSTREAM): Char;
1820     function putb (x: Char; p: PBSTREAM): Int;
1821     function putbx (x: Char; p: PBSTREAM): Int;}
1822    
1823     (*
1824     #define ADD_SPB_LENGTH(p, length) {*(p)++ = (length); \
1825     *(p)++ = (length) >> 8;}
1826    
1827     #define ADD_SPB_NUMERIC(p, data) {*(p)++ = (data); \
1828     *(p)++ = (data) >> 8; \
1829     *(p)++ = (data) >> 16; \
1830     *(p)++ = (data) >> 24;}
1831     *)
1832     procedure add_spb_length(var p: PChar; length: integer);
1833     procedure add_spb_numeric(var p: PChar; data: integer);
1834    
1835    
1836     implementation
1837    
1838    
1839     {$IFDEF IB5_ONLY}
1840     function SQLDA_LENGTH(n: Long): Long;
1841     (* The C-macro reads like this:
1842     SQLDA_LENGTH(n) (sizeof (SQLDA) + (n-1) * sizeof (SQLVAR)) *)
1843     begin
1844     result := sizeof(TSQLDA) + ((n - 1) * sizeof(TSQLVAR));
1845     end;
1846     {$ENDIF}
1847    
1848    
1849     function XSQLDA_LENGTH(n: Long): Long;
1850     (* The C-macro reads like this:
1851     XSQLDA_LENGTH(n) (sizeof (XSQLDA) + (n-1) * sizeof (XSQLVAR)) *)
1852     begin
1853     result := SizeOf(TXSQLDA) + ((n - 1) * SizeOf(TXSQLVAR));
1854     end;
1855    
1856     {function getb(p: PBSTREAM): Char;
1857     (* The C-macro reads like this:
1858     getb(p) (--(p)->bstr_cnt >= 0 ? *(p)->bstr_ptr++ & 0377: BLOB_get (p)) *)
1859     begin
1860     Dec(p^.bstr_cnt);
1861     if (p^.bstr_cnt >= 0) then begin
1862     result := Char(Int(p^.bstr_ptr^) and Int(0377));
1863     Inc(p^.bstr_ptr);
1864     end else
1865     result := Char(BLOB_get(p));
1866     end;}
1867    
1868     //function putb(x: Char; p: PBSTREAM): Int;
1869     (* The C-macro reads like this:
1870     putb(x,p) ((x == '\n' || (!(--(p)->bstr_cnt))) ? // then
1871     BLOB_put (x,p) : // else
1872     ((int) (*(p)->bstr_ptr++ = (unsigned) (x)))) *)
1873     begin
1874     Dec(p^.bstr_cnt);
1875     if (x = Chr(Int('n') - Int('a'))) or (p^.bstr_cnt = 0) then
1876     result := BLOB_put(x, p)
1877     else begin
1878     p^.bstr_ptr^ := Char(x);
1879     result := UInt(x);
1880     Inc(p^.bstr_ptr^);
1881     end;
1882     end;
1883    
1884     function putbx(x: Char; p: PBSTREAM): Int;
1885     (* The C-macro reads like this:
1886     putbx(x,p) ((!(--(p)->bstr_cnt)) ? // then
1887     BLOB_put (x,p) : // else
1888     ((int) (*(p)->bstr_ptr++ = (unsigned) (x)))) *)
1889     begin
1890     Dec(p^.bstr_cnt);
1891     if (p^.bstr_cnt = 0) then
1892     result := BLOB_put(x, p)
1893     else begin
1894     p^.bstr_ptr^ := Char(x);
1895     Inc(p^.bstr_ptr^);
1896     result := UInt(x);
1897     end;
1898     end;
1899    
1900     (*******************************************)
1901     (** Service manager functions **)
1902     (*******************************************)
1903    
1904    
1905     procedure add_spb_length(var p: PChar; length: integer);
1906     (*
1907     #define ADD_SPB_LENGTH(p, length) {*(p)++ = (length); \
1908     *(p)++ = (length) >> 8;}
1909     *)
1910     begin
1911     p^ := char(length);
1912     Inc (p);
1913     p^ := char(length shr 8);
1914     Inc (p);
1915     end;
1916    
1917     procedure add_spb_numeric(var p: PChar; data: integer);
1918     (*
1919     #define ADD_SPB_NUMERIC(p, data) {*(p)++ = (data); \
1920     *(p)++ = (data) >> 8; \
1921     *(p)++ = (data) >> 16; \
1922     *(p)++ = (data) >> 24;}
1923     *)
1924     begin
1925     p^ := char(data);
1926     Inc (p);
1927     p^ := char(data shr 8);
1928     Inc (p);
1929     p^ := char(data shr 16);
1930     Inc (p);
1931     p^ := char(data shr 24);
1932     Inc (p);
1933     end;
1934    
1935     end.
1936