ibase60.inc 123 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808
  1. {
  2. }
  3. {$MODE objfpc}
  4. {$MACRO on}
  5. interface
  6. {$IFDEF LinkDynamically}
  7. {$IFDEF FPC_DOTTEDUNITS}
  8. uses System.DynLibs, System.SysUtils, System.CTypes;
  9. {$ELSE FPC_DOTTEDUNITS}
  10. uses Dynlibs, sysutils,ctypes;
  11. {$ENDIF FPC_DOTTEDUNITS}
  12. Var
  13. UseEmbeddedFirebird : Boolean = False;
  14. {$ELSE}
  15. {$IFDEF FPC_DOTTEDUNITS}
  16. uses System.DynLibs, System.CTypes;
  17. {$ELSE FPC_DOTTEDUNITS}
  18. uses Dynlibs,ctypes;
  19. {$ENDIF FPC_DOTTEDUNITS}
  20. {$ENDIF}
  21. {$IFDEF Unix}
  22. {$DEFINE extdecl:=cdecl}
  23. const
  24. gdslib = 'libgds.'+sharedsuffix; // Needs completion ?
  25. libfc = 'libfbclient.'+sharedsuffix;
  26. libem = 'libfbembed.'+sharedsuffix;
  27. v2 = {$ifndef darwin}'.2'{$else}''{$endif};
  28. v21 = {$ifndef darwin}'.2.1'{$else}''{$endif};
  29. v25 = {$ifndef darwin}'.2.5'{$else}''{$endif};
  30. v251 = {$ifndef darwin}'.2.5.1'{$else}''{$endif};
  31. fbclib2 = libfc+v2;
  32. fbembedlib2 = libem+v2;
  33. fbclib21 = libfc+v21;
  34. fbembedlib21 = libem+v21;
  35. fbclib25 = libfc+v25;
  36. fbembedlib25 = libem+v25;
  37. fbclib251 = libfc+v251;
  38. fbembedlib251 = libem+v25;
  39. // Set default here
  40. fbclib = fbclib251;
  41. fbembedlib = fbembedlib251;
  42. {$ENDIF}
  43. {$IFDEF Windows}
  44. {$DEFINE extdecl:=stdcall}
  45. const
  46. gdslib = 'gds32.dll';
  47. fbclib = 'fbclient.dll';
  48. fbembedlib = 'fbembed.dll';
  49. libfc = fbclib;
  50. libem = fbembedlib;
  51. {$ENDIF}
  52. type
  53. { Unsigned types }
  54. UChar = Byte;
  55. UShort = Word;
  56. UInt = DWord;
  57. ULong = DWord;
  58. { Signed types }
  59. Int = LongInt;
  60. Long = LongInt;
  61. Short = SmallInt;
  62. Float = Single;
  63. { Pointers to basic types }
  64. PInt = ^Int;
  65. PShort = ^Short;
  66. PUShort = ^UShort;
  67. PLong = ^Long;
  68. PULong = ^ULong;
  69. PFloat = ^Float;
  70. PUChar = ^UChar;
  71. PVoid = ^Pointer;
  72. {$PACKRECORDS C}
  73. const
  74. ISC_TRUE = 1;
  75. ISC_FALSE = 0;
  76. const
  77. ISC__TRUE = ISC_TRUE;
  78. ISC__FALSE = ISC_FALSE;
  79. Type
  80. ISC_USHORT = word;
  81. ISC_STATUS = ptrint; { CLong according the sources but they ifdef
  82. for win64, the only significant platform
  83. where clong<>ptrint}
  84. ISC_INT64 = int64;
  85. ISC_UINT64 = qword;
  86. ISC_LONG = Longint;
  87. ISC_ULONG = dword;
  88. PISC_USHORT = ^ISC_USHORT;
  89. PISC_STATUS = ^ISC_STATUS;
  90. PPISC_STATUS = ^PISC_STATUS;
  91. PISC_INT64 = ^ISC_INT64;
  92. PISC_UINT64 = ^ISC_UINT64;
  93. PISC_LONG = ^ISC_LONG;
  94. {$IFDEF CPU64}
  95. FB_API_HANDLE = cuint;
  96. {$ELSE}
  97. FB_API_HANDLE = pointer;
  98. {$ENDIF}
  99. const
  100. {$IFDEF CPU64}
  101. FB_API_NULLHANDLE = 0;
  102. {$ELSE}
  103. FB_API_NULLHANDLE = nil;
  104. {$ENDIF}
  105. DSQL_close = 1;
  106. DSQL_drop = 2;
  107. {!!MVC
  108. Removed all ISC_FAR, ISC_EXPORT_VARARG and ISC_EXPORT
  109. macros.
  110. They confuse h2pas...
  111. !!MVC }
  112. { }
  113. { Time & Date Support }
  114. { }
  115. {$ifndef _ISC_TIMESTAMP_}
  116. type
  117. ISC_DATE = longint;
  118. ISC_TIME = dword;
  119. ISC_TIMESTAMP = record
  120. timestamp_date : ISC_DATE;
  121. timestamp_time : ISC_TIME;
  122. end;
  123. TISC_DATE = ISC_DATE;
  124. TISC_TIME = ISC_TIME;
  125. TISC_TIMESTAMP = ISC_TIMESTAMP;
  126. PISC_DATE = ^ISC_DATE;
  127. PISC_TIME = ^ISC_TIME;
  128. PISC_TIMESTAMP = ^ISC_TIMESTAMP;
  129. const
  130. _ISC_TIMESTAMP_ = 1;
  131. {$endif}
  132. const
  133. ISC_TIME_SECONDS_PRECISION = 10000;
  134. ISC_TIME_SECONDS_PRECISION_SCALE = -4;
  135. { }
  136. { Blob id structure }
  137. { }
  138. Type
  139. GDS_QUAD = record
  140. gds_quad_high : ISC_LONG;
  141. gds_quad_low : ISC_ULONG;
  142. end;
  143. TGDS_QUAD = GDS_QUAD;
  144. PGDS_QUAD = ^GDS_QUAD;
  145. Type
  146. ISC_QUAD = GDS_QUAD;
  147. TISC_QUAD = ISC_QUAD;
  148. PISC_QUAD = ^ISC_QUAD;
  149. { !!field redefinitions !!
  150. isc_quad_high = gds_quad_high;
  151. isc_quad_low = gds_quad_low;
  152. }
  153. type
  154. ISC_ARRAY_BOUND = record
  155. array_bound_lower : smallint;
  156. array_bound_upper : smallint;
  157. end;
  158. TISC_ARRAY_BOUND = ISC_ARRAY_BOUND;
  159. PISC_ARRAY_BOUND = ^ISC_ARRAY_BOUND;
  160. ISC_ARRAY_DESC = record
  161. array_desc_dtype : byte;
  162. array_desc_scale : AnsiChar;
  163. array_desc_length : word;
  164. array_desc_field_name : array[0..31] of AnsiChar;
  165. array_desc_relation_name : array[0..31] of AnsiChar;
  166. array_desc_dimensions : smallint;
  167. array_desc_flags : smallint;
  168. array_desc_bounds : array[0..15] of ISC_ARRAY_BOUND;
  169. end;
  170. TISC_ARRAY_DESC = ISC_ARRAY_DESC;
  171. PISC_ARRAY_DESC = ^ISC_ARRAY_DESC;
  172. ISC_BLOB_DESC = record
  173. blob_desc_subtype : smallint;
  174. blob_desc_charset : smallint;
  175. blob_desc_segment_size : smallint;
  176. blob_desc_field_name : array[0..31] of byte;
  177. blob_desc_relation_name : array[0..31] of byte;
  178. end;
  179. TISC_BLOB_DESC = ISC_BLOB_DESC;
  180. PISC_BLOB_DESC = ^ISC_BLOB_DESC ;
  181. { }
  182. { Blob control structure }
  183. { }
  184. {!!MVC
  185. !!MVC }
  186. { Source filter }
  187. {!!MVC
  188. !!MVC }
  189. { Argument to pass to source }
  190. { filter }
  191. { Target type }
  192. { Source type }
  193. { Length of buffer }
  194. { Length of current segment }
  195. { Length of blob parameter }
  196. { block }
  197. { Address of blob parameter }
  198. { block }
  199. { Address of segment buffer }
  200. { Length of longest segment }
  201. { Total number of segments }
  202. { Total length of blob }
  203. { Address of status vector }
  204. { Application specific data }
  205. TCTLSourceFunction = function : isc_long;
  206. PISC_BLOB_CTL = ^ISC_BLOB_CTL ;
  207. ISC_BLOB_CTL = record
  208. ctl_source : TCTLSourceFunction; // was ISC_STATUS ( *ctl_source)();
  209. ctl_source_handle : pisc_blob_ctl ; // was struct isc_blob_ctl * ctl_source_handle;
  210. ctl_to_sub_type : smallint;
  211. ctl_from_sub_type : smallint;
  212. ctl_buffer_length : word;
  213. ctl_segment_length : word;
  214. ctl_bpb_length : word;
  215. ctl_bpb : PAnsiChar;
  216. ctl_buffer : Pbyte;
  217. ctl_max_segment : ISC_LONG;
  218. ctl_number_segments : ISC_LONG;
  219. ctl_total_length : ISC_LONG;
  220. ctl_status : PISC_STATUS;
  221. ctl_data : array[0..7] of longint;
  222. end;
  223. TISC_BLOB_CTL = ISC_BLOB_CTL;
  224. { }
  225. { Blob stream definitions }
  226. { }
  227. { Blob handle }
  228. { Address of buffer }
  229. { Next character }
  230. { Length of buffer }
  231. { Characters in buffer }
  232. { (mode) ? OUTPUT : INPUT }
  233. BSTREAM = record
  234. bstr_blob : pointer;
  235. bstr_buffer : PAnsiChar;
  236. bstr_ptr : PAnsiChar;
  237. bstr_length : smallint;
  238. bstr_cnt : smallint;
  239. bstr_mode : AnsiChar;
  240. end;
  241. TBSTREAM = BSTREAM;
  242. PBstream = ^BSTREAM;
  243. {!!MVC
  244. #define getb(p) (--(p)->bstr_cnt >= 0 ? (p)->bstr_ptr++ & 0377: BLOB_get (p))
  245. #define putb(x,p) (((x) == '\n' || (!(--(p)->bstr_cnt))) ? BLOB_put ((x),p) : ((int) ( (p)->bstr_ptr++ = (unsigned) (x))))
  246. #define putbx(x,p) ((!(--(p)->bstr_cnt)) ? BLOB_put ((x),p) : ((int) ( (p)->bstr_ptr++ = (unsigned) (x))))
  247. !!MVC }
  248. { }
  249. { Dynamic SQL definitions }
  250. { }
  251. { }
  252. { Declare the extended SQLDA }
  253. { }
  254. { datatype of field }
  255. { scale factor }
  256. { datatype subtype - BLOBs & Text }
  257. { types only }
  258. { length of data area }
  259. { address of data }
  260. { address of indicator variable }
  261. { length of sqlname field }
  262. { name of field, name length + space }
  263. { for NULL }
  264. { length of relation name }
  265. { field's relation name + space for }
  266. { NULL }
  267. { length of owner name }
  268. { relation's owner name + space for }
  269. { NULL }
  270. { length of alias name }
  271. { relation's alias name + space for }
  272. { NULL }
  273. XSQLVAR = record
  274. sqltype : smallint;
  275. sqlscale : smallint;
  276. sqlsubtype : smallint;
  277. sqllen : smallint;
  278. sqldata : PAnsiChar;
  279. sqlind : Psmallint;
  280. sqlname_length : smallint;
  281. sqlname : array[0..31] of AnsiChar;
  282. relname_length : smallint;
  283. relname : array[0..31] of AnsiChar;
  284. ownname_length : smallint;
  285. ownname : array[0..31] of AnsiChar;
  286. aliasname_length : smallint;
  287. aliasname : array[0..31] of AnsiChar;
  288. end;
  289. TXSQLVAR = XSQLVAR;
  290. PXSQLVAR =^XSQLVAR;
  291. { version of this XSQLDA }
  292. { XSQLDA name field }
  293. { length in bytes of SQLDA }
  294. { number of fields allocated }
  295. { actual number of fields }
  296. { first field address }
  297. XSQLDA = record
  298. version : smallint;
  299. sqldaid : array[0..7] of AnsiChar;
  300. sqldabc : ISC_LONG;
  301. sqln : smallint;
  302. sqld : smallint;
  303. sqlvar : array[0..0] of XSQLVAR;
  304. end;
  305. TXSQLDA = XSQLDA;
  306. PXSQLDA =^XSQLDA;
  307. function XSQLDA_LENGTH(n: Integer): Integer;
  308. const
  309. SQLDA_VERSION1 = 1;
  310. { meaning is same as DIALECT_xsqlda }
  311. SQL_DIALECT_V5 = 1;
  312. { flagging anything that is delimited
  313. by double quotes as an error and
  314. flagging keyword DATE as an error }
  315. SQL_DIALECT_V6_TRANSITION = 2;
  316. { supports SQL delimited identifier,
  317. SQLDATE/DATE, TIME, TIMESTAMP,
  318. CURRENT_DATE, CURRENT_TIME,
  319. CURRENT_TIMESTAMP, and 64-bit exact
  320. numeric type }
  321. SQL_DIALECT_V6 = 3;
  322. { latest IB DIALECT }
  323. SQL_DIALECT_CURRENT = SQL_DIALECT_V6;
  324. { }
  325. { InterBase Handle Definitions }
  326. { }
  327. type
  328. isc_att_handle = FB_API_HANDLE;
  329. isc_blob_handle = FB_API_HANDLE;
  330. isc_db_handle = FB_API_HANDLE;
  331. isc_form_handle = FB_API_HANDLE; // can't find in 2.5.1
  332. isc_req_handle = FB_API_HANDLE;
  333. isc_stmt_handle = FB_API_HANDLE;
  334. isc_svc_handle = FB_API_HANDLE;
  335. isc_tr_handle = FB_API_HANDLE;
  336. isc_win_handle = pointer; // can't find in 2.5.1
  337. isc_callback = procedure ;extdecl;
  338. isc_resv_handle = ISC_LONG;
  339. tisc_att_handle = isc_att_handle;
  340. tisc_blob_handle = isc_blob_handle;
  341. tisc_db_handle = isc_db_handle;
  342. tisc_form_handle = isc_form_handle;
  343. tisc_req_handle = isc_req_handle;
  344. tisc_stmt_handle = isc_stmt_handle;
  345. tisc_svc_handle = isc_svc_handle;
  346. tisc_tr_handle = isc_tr_handle;
  347. tisc_win_handle = isc_win_handle;
  348. tisc_callback = isc_callback;
  349. tisc_resv_handle = isc_resv_handle;
  350. pisc_att_handle =^isc_att_handle ;
  351. pisc_blob_handle =^isc_blob_handle ;
  352. pisc_db_handle =^isc_db_handle ;
  353. pisc_form_handle =^isc_form_handle ;
  354. pisc_req_handle =^isc_req_handle ;
  355. pisc_stmt_handle =^isc_stmt_handle ;
  356. pisc_svc_handle =^isc_svc_handle ;
  357. pisc_tr_handle =^isc_tr_handle ;
  358. pisc_win_handle =^isc_win_handle ;
  359. pisc_callback = ^isc_callback;
  360. pisc_resv_handle =^isc_resv_handle ;
  361. { }
  362. { Security structures }
  363. { }
  364. const
  365. sec_uid_spec = $01;
  366. sec_gid_spec = $02;
  367. sec_server_spec = $04;
  368. sec_password_spec = $08;
  369. sec_group_name_spec = $10;
  370. sec_first_name_spec = $20;
  371. sec_middle_name_spec = $40;
  372. sec_last_name_spec = $80;
  373. sec_dba_user_name_spec = $100;
  374. sec_dba_password_spec = $200;
  375. sec_protocol_tcpip = 1;
  376. sec_protocol_netbeui = 2;
  377. sec_protocol_spx = 3;
  378. sec_protocol_local = 4;
  379. { which fields are specified }
  380. { the user's id }
  381. { the user's group id }
  382. { protocol to use for connection }
  383. { server to administer }
  384. { the user's name }
  385. { the user's password }
  386. { the group name }
  387. { the user's first name }
  388. { the user's middle name }
  389. { the user's last name }
  390. { the dba user name }
  391. { the dba password }
  392. type
  393. USER_SEC_DATA = record
  394. sec_flags : smallint;
  395. uid : longint;
  396. gid : longint;
  397. protocol : longint;
  398. server : PAnsiChar;
  399. user_name : PAnsiChar;
  400. password : PAnsiChar;
  401. group_name : PAnsiChar;
  402. first_name : PAnsiChar;
  403. middle_name : PAnsiChar;
  404. last_name : PAnsiChar;
  405. dba_user_name : PAnsiChar;
  406. dba_password : PAnsiChar;
  407. end;
  408. TUSER_SEC_DATA = USER_SEC_DATA;
  409. PUSER_SEC_DATA = ^USER_SEC_DATA;
  410. { }
  411. { Actions to pass to the blob filter (ctl_source) }
  412. { }
  413. const
  414. isc_blob_filter_open = 0;
  415. isc_blob_filter_get_segment = 1;
  416. isc_blob_filter_close = 2;
  417. isc_blob_filter_create = 3;
  418. isc_blob_filter_put_segment = 4;
  419. isc_blob_filter_alloc = 5;
  420. isc_blob_filter_free = 6;
  421. isc_blob_filter_seek = 7;
  422. { }
  423. { Blr definitions }
  424. { }
  425. {$ifndef _JRD_BLR_H_}
  426. {!!MVC
  427. #define blr_word(n) ((n) % 256), ((n) / 256)
  428. !!MVC }
  429. const
  430. blr_text = 14;
  431. blr_text2 = 15;
  432. blr_short = 7;
  433. blr_long = 8;
  434. blr_quad = 9;
  435. blr_int64 = 16;
  436. blr_float = 10;
  437. blr_double = 27;
  438. blr_d_float = 11;
  439. blr_timestamp = 35;
  440. blr_varying = 37;
  441. blr_varying2 = 38;
  442. blr_blob = 261;
  443. blr_cstring = 40;
  444. blr_cstring2 = 41;
  445. blr_blob_id = 45;
  446. blr_sql_date = 12;
  447. blr_sql_time = 13;
  448. { Historical alias for pre V6 applications }
  449. blr_date = blr_timestamp;
  450. blr_inner = 0;
  451. blr_left = 1;
  452. blr_right = 2;
  453. blr_full = 3;
  454. blr_gds_code = 0;
  455. blr_sql_code = 1;
  456. blr_exception = 2;
  457. blr_trigger_code = 3;
  458. blr_default_code = 4;
  459. blr_version4 = 4;
  460. blr_version5 = 5;
  461. blr_eoc = 76;
  462. blr_end = 255;
  463. blr_assignment = 1;
  464. blr_begin = 2;
  465. blr_dcl_variable = 3;
  466. blr_message = 4;
  467. blr_erase = 5;
  468. blr_fetch = 6;
  469. blr_for = 7;
  470. blr_if = 8;
  471. blr_loop = 9;
  472. blr_modify = 10;
  473. blr_handler = 11;
  474. blr_receive = 12;
  475. blr_select = 13;
  476. blr_send = 14;
  477. blr_store = 15;
  478. blr_label = 17;
  479. blr_leave = 18;
  480. blr_store2 = 19;
  481. blr_post = 20;
  482. blr_literal = 21;
  483. blr_dbkey = 22;
  484. blr_field = 23;
  485. blr_fid = 24;
  486. blr_parameter = 25;
  487. blr_variable = 26;
  488. blr_average = 27;
  489. blr_count = 28;
  490. blr_maximum = 29;
  491. blr_minimum = 30;
  492. blr_total = 31;
  493. blr_add = 34;
  494. blr_subtract = 35;
  495. blr_multiply = 36;
  496. blr_divide = 37;
  497. blr_negate = 38;
  498. blr_concatenate = 39;
  499. blr_substring = 40;
  500. blr_parameter2 = 41;
  501. blr_from = 42;
  502. blr_via = 43;
  503. blr_user_name = 44;
  504. blr_null = 45;
  505. blr_eql = 47;
  506. blr_neq = 48;
  507. blr_gtr = 49;
  508. blr_geq = 50;
  509. blr_lss = 51;
  510. blr_leq = 52;
  511. blr_containing = 53;
  512. blr_matching = 54;
  513. blr_starting = 55;
  514. blr_between = 56;
  515. blr_or = 57;
  516. blr_and = 58;
  517. blr_not = 59;
  518. blr_any = 60;
  519. blr_missing = 61;
  520. blr_unique = 62;
  521. blr_like = 63;
  522. blr_stream = 65;
  523. blr_set_index = 66;
  524. blr_rse = 67;
  525. blr_first = 68;
  526. blr_project = 69;
  527. blr_sort = 70;
  528. blr_boolean = 71;
  529. blr_ascending = 72;
  530. blr_descending = 73;
  531. blr_relation = 74;
  532. blr_rid = 75;
  533. blr_union = 76;
  534. blr_map = 77;
  535. blr_group_by = 78;
  536. blr_aggregate = 79;
  537. blr_join_type = 80;
  538. blr_agg_count = 83;
  539. blr_agg_max = 84;
  540. blr_agg_min = 85;
  541. blr_agg_total = 86;
  542. blr_agg_average = 87;
  543. blr_parameter3 = 88;
  544. blr_run_count = 118;
  545. blr_run_max = 89;
  546. blr_run_min = 90;
  547. blr_run_total = 91;
  548. blr_run_average = 92;
  549. blr_agg_count2 = 93;
  550. blr_agg_count_distinct = 94;
  551. blr_agg_total_distinct = 95;
  552. blr_agg_average_distinct = 96;
  553. blr_function = 100;
  554. blr_gen_id = 101;
  555. blr_prot_mask = 102;
  556. blr_upcase = 103;
  557. blr_lock_state = 104;
  558. blr_value_if = 105;
  559. blr_matching2 = 106;
  560. blr_index = 107;
  561. blr_ansi_like = 108;
  562. blr_bookmark = 109;
  563. blr_crack = 110;
  564. blr_force_crack = 111;
  565. blr_seek = 112;
  566. blr_find = 113;
  567. blr_continue = 0;
  568. blr_forward = 1;
  569. blr_backward = 2;
  570. blr_bof_forward = 3;
  571. blr_eof_backward = 4;
  572. blr_lock_relation = 114;
  573. blr_lock_record = 115;
  574. blr_set_bookmark = 116;
  575. blr_get_bookmark = 117;
  576. blr_rs_stream = 119;
  577. blr_exec_proc = 120;
  578. blr_begin_range = 121;
  579. blr_end_range = 122;
  580. blr_delete_range = 123;
  581. blr_procedure = 124;
  582. blr_pid = 125;
  583. blr_exec_pid = 126;
  584. blr_singular = 127;
  585. blr_abort = 128;
  586. blr_block = 129;
  587. blr_error_handler = 130;
  588. blr_cast = 131;
  589. blr_release_lock = 132;
  590. blr_release_locks = 133;
  591. blr_start_savepoint = 134;
  592. blr_end_savepoint = 135;
  593. blr_find_dbkey = 136;
  594. blr_range_relation = 137;
  595. blr_delete_ranges = 138;
  596. blr_plan = 139;
  597. blr_merge = 140;
  598. blr_join = 141;
  599. blr_sequential = 142;
  600. blr_navigational = 143;
  601. blr_indices = 144;
  602. blr_retrieve = 145;
  603. blr_relation2 = 146;
  604. blr_rid2 = 147;
  605. blr_reset_stream = 148;
  606. blr_release_bookmark = 149;
  607. blr_set_generator = 150;
  608. blr_ansi_any = 151;
  609. blr_exists = 152;
  610. blr_cardinality = 153;
  611. { get tid of record }
  612. blr_record_version = 154;
  613. { fake server stall }
  614. blr_stall = 155;
  615. blr_seek_no_warn = 156;
  616. blr_find_dbkey_version = 157;
  617. blr_ansi_all = 158;
  618. blr_extract = 159;
  619. { sub parameters for blr_extract }
  620. blr_extract_year = 0;
  621. blr_extract_month = 1;
  622. blr_extract_day = 2;
  623. blr_extract_hour = 3;
  624. blr_extract_minute = 4;
  625. blr_extract_second = 5;
  626. blr_extract_weekday = 6;
  627. blr_extract_yearday = 7;
  628. blr_current_date = 160;
  629. blr_current_timestamp = 161;
  630. blr_current_time = 162;
  631. { These verbs were added in 6.0, primarily to support 64-bit integers }
  632. blr_add2 = 163;
  633. blr_subtract2 = 164;
  634. blr_multiply2 = 165;
  635. blr_divide2 = 166;
  636. blr_agg_total2 = 167;
  637. blr_agg_total_distinct2 = 168;
  638. blr_agg_average2 = 169;
  639. blr_agg_average_distinct2 = 170;
  640. blr_average2 = 171;
  641. blr_gen_id2 = 172;
  642. blr_set_generator2 = 173;
  643. {$endif}
  644. { _JRD_BLR_H_ }
  645. { }
  646. { Database parameter block stuff }
  647. { }
  648. const
  649. isc_dpb_version1 = 1;
  650. isc_dpb_cdd_pathname = 1;
  651. isc_dpb_allocation = 2;
  652. isc_dpb_journal = 3;
  653. isc_dpb_page_size = 4;
  654. isc_dpb_num_buffers = 5;
  655. isc_dpb_buffer_length = 6;
  656. isc_dpb_debug = 7;
  657. isc_dpb_garbage_collect = 8;
  658. isc_dpb_verify = 9;
  659. isc_dpb_sweep = 10;
  660. isc_dpb_enable_journal = 11;
  661. isc_dpb_disable_journal = 12;
  662. isc_dpb_dbkey_scope = 13;
  663. isc_dpb_number_of_users = 14;
  664. isc_dpb_trace = 15;
  665. isc_dpb_no_garbage_collect = 16;
  666. isc_dpb_damaged = 17;
  667. isc_dpb_license = 18;
  668. isc_dpb_sys_user_name = 19;
  669. isc_dpb_encrypt_key = 20;
  670. isc_dpb_activate_shadow = 21;
  671. isc_dpb_sweep_interval = 22;
  672. isc_dpb_delete_shadow = 23;
  673. isc_dpb_force_write = 24;
  674. isc_dpb_begin_log = 25;
  675. isc_dpb_quit_log = 26;
  676. isc_dpb_no_reserve = 27;
  677. isc_dpb_user_name = 28;
  678. isc_dpb_password = 29;
  679. isc_dpb_password_enc = 30;
  680. isc_dpb_sys_user_name_enc = 31;
  681. isc_dpb_interp = 32;
  682. isc_dpb_online_dump = 33;
  683. isc_dpb_old_file_size = 34;
  684. isc_dpb_old_num_files = 35;
  685. isc_dpb_old_file = 36;
  686. isc_dpb_old_start_page = 37;
  687. isc_dpb_old_start_seqno = 38;
  688. isc_dpb_old_start_file = 39;
  689. isc_dpb_drop_walfile = 40;
  690. isc_dpb_old_dump_id = 41;
  691. isc_dpb_wal_backup_dir = 42;
  692. isc_dpb_wal_chkptlen = 43;
  693. isc_dpb_wal_numbufs = 44;
  694. isc_dpb_wal_bufsize = 45;
  695. isc_dpb_wal_grp_cmt_wait = 46;
  696. isc_dpb_lc_messages = 47;
  697. isc_dpb_lc_ctype = 48;
  698. isc_dpb_cache_manager = 49;
  699. isc_dpb_shutdown = 50;
  700. isc_dpb_online = 51;
  701. isc_dpb_shutdown_delay = 52;
  702. isc_dpb_reserved = 53;
  703. isc_dpb_overwrite = 54;
  704. isc_dpb_sec_attach = 55;
  705. isc_dpb_disable_wal = 56;
  706. isc_dpb_connect_timeout = 57;
  707. isc_dpb_dummy_packet_interval = 58;
  708. isc_dpb_gbak_attach = 59;
  709. isc_dpb_sql_role_name = 60;
  710. isc_dpb_set_page_buffers = 61;
  711. isc_dpb_working_directory = 62;
  712. isc_dpb_SQL_dialect = 63;
  713. isc_dpb_set_db_readonly = 64;
  714. isc_dpb_set_db_SQL_dialect = 65;
  715. isc_dpb_gfix_attach = 66;
  716. isc_dpb_gstat_attach = 67;
  717. { }
  718. { isc_dpb_verify specific flags }
  719. { }
  720. isc_dpb_pages = 1;
  721. isc_dpb_records = 2;
  722. isc_dpb_indices = 4;
  723. isc_dpb_transactions = 8;
  724. isc_dpb_no_update = 16;
  725. isc_dpb_repair = 32;
  726. isc_dpb_ignore = 64;
  727. { }
  728. { isc_dpb_shutdown specific flags }
  729. { }
  730. isc_dpb_shut_cache = 1;
  731. isc_dpb_shut_attachment = 2;
  732. isc_dpb_shut_transaction = 4;
  733. isc_dpb_shut_force = 8;
  734. { }
  735. { Bit assignments in RDB$SYSTEM_FLAG }
  736. { }
  737. RDB_system = 1;
  738. RDB_id_assigned = 2;
  739. { }
  740. { Transaction parameter block stuff }
  741. { }
  742. isc_tpb_version1 = 1;
  743. isc_tpb_version3 = 3;
  744. isc_tpb_consistency = 1;
  745. isc_tpb_concurrency = 2;
  746. isc_tpb_shared = 3;
  747. isc_tpb_protected = 4;
  748. isc_tpb_exclusive = 5;
  749. isc_tpb_wait = 6;
  750. isc_tpb_nowait = 7;
  751. isc_tpb_read = 8;
  752. isc_tpb_write = 9;
  753. isc_tpb_lock_read = 10;
  754. isc_tpb_lock_write = 11;
  755. isc_tpb_verb_time = 12;
  756. isc_tpb_commit_time = 13;
  757. isc_tpb_ignore_limbo = 14;
  758. isc_tpb_read_committed = 15;
  759. isc_tpb_autocommit = 16;
  760. isc_tpb_rec_version = 17;
  761. isc_tpb_no_rec_version = 18;
  762. isc_tpb_restart_requests = 19;
  763. isc_tpb_no_auto_undo = 20;
  764. isc_tpb_lock_timeout = 21;
  765. { }
  766. { Blob Parameter Block }
  767. { }
  768. isc_bpb_version1 = 1;
  769. isc_bpb_source_type = 1;
  770. isc_bpb_target_type = 2;
  771. isc_bpb_type = 3;
  772. isc_bpb_source_interp = 4;
  773. isc_bpb_target_interp = 5;
  774. isc_bpb_filter_parameter = 6;
  775. isc_bpb_type_segmented = 0;
  776. isc_bpb_type_stream = 1;
  777. { }
  778. { Service parameter block stuff }
  779. { }
  780. isc_spb_version1 = 1;
  781. isc_spb_current_version = 2;
  782. isc_spb_version = isc_spb_current_version;
  783. isc_spb_user_name = isc_dpb_user_name;
  784. isc_spb_sys_user_name = isc_dpb_sys_user_name;
  785. isc_spb_sys_user_name_enc = isc_dpb_sys_user_name_enc;
  786. isc_spb_password = isc_dpb_password;
  787. isc_spb_password_enc = isc_dpb_password_enc;
  788. isc_spb_command_line = 105;
  789. isc_spb_dbname = 106;
  790. isc_spb_verbose = 107;
  791. isc_spb_options = 108;
  792. isc_spb_connect_timeout = isc_dpb_connect_timeout;
  793. isc_spb_dummy_packet_interval = isc_dpb_dummy_packet_interval;
  794. isc_spb_sql_role_name = isc_dpb_sql_role_name;
  795. { }
  796. { Information call declarations }
  797. { }
  798. { }
  799. { Common, structural codes }
  800. { }
  801. isc_info_end = 1;
  802. isc_info_truncated = 2;
  803. isc_info_error = 3;
  804. isc_info_data_not_ready = 4;
  805. isc_info_flag_end = 127;
  806. { }
  807. { Database information items }
  808. { }
  809. isc_info_db_id = 4;
  810. isc_info_reads = 5;
  811. isc_info_writes = 6;
  812. isc_info_fetches = 7;
  813. isc_info_marks = 8;
  814. isc_info_implementation = 11;
  815. isc_info_version = 12;
  816. isc_info_base_level = 13;
  817. isc_info_page_size = 14;
  818. isc_info_num_buffers = 15;
  819. isc_info_limbo = 16;
  820. isc_info_current_memory = 17;
  821. isc_info_max_memory = 18;
  822. isc_info_window_turns = 19;
  823. isc_info_license = 20;
  824. isc_info_allocation = 21;
  825. isc_info_attachment_id = 22;
  826. isc_info_read_seq_count = 23;
  827. isc_info_read_idx_count = 24;
  828. isc_info_insert_count = 25;
  829. isc_info_update_count = 26;
  830. isc_info_delete_count = 27;
  831. isc_info_backout_count = 28;
  832. isc_info_purge_count = 29;
  833. isc_info_expunge_count = 30;
  834. isc_info_sweep_interval = 31;
  835. isc_info_ods_version = 32;
  836. isc_info_ods_minor_version = 33;
  837. isc_info_no_reserve = 34;
  838. isc_info_logfile = 35;
  839. isc_info_cur_logfile_name = 36;
  840. isc_info_cur_log_part_offset = 37;
  841. isc_info_num_wal_buffers = 38;
  842. isc_info_wal_buffer_size = 39;
  843. isc_info_wal_ckpt_length = 40;
  844. isc_info_wal_cur_ckpt_interval = 41;
  845. isc_info_wal_prv_ckpt_fname = 42;
  846. isc_info_wal_prv_ckpt_poffset = 43;
  847. isc_info_wal_recv_ckpt_fname = 44;
  848. isc_info_wal_recv_ckpt_poffset = 45;
  849. isc_info_wal_grpc_wait_usecs = 47;
  850. isc_info_wal_num_io = 48;
  851. isc_info_wal_avg_io_size = 49;
  852. isc_info_wal_num_commits = 50;
  853. isc_info_wal_avg_grpc_size = 51;
  854. isc_info_forced_writes = 52;
  855. isc_info_user_names = 53;
  856. isc_info_page_errors = 54;
  857. isc_info_record_errors = 55;
  858. isc_info_bpage_errors = 56;
  859. isc_info_dpage_errors = 57;
  860. isc_info_ipage_errors = 58;
  861. isc_info_ppage_errors = 59;
  862. isc_info_tpage_errors = 60;
  863. isc_info_set_page_buffers = 61;
  864. isc_info_db_SQL_dialect = 62;
  865. isc_info_db_read_only = 63;
  866. isc_info_db_size_in_pages = 64;
  867. { }
  868. { Database information return values }
  869. { }
  870. isc_info_db_impl_rdb_vms = 1;
  871. isc_info_db_impl_rdb_eln = 2;
  872. isc_info_db_impl_rdb_eln_dev = 3;
  873. isc_info_db_impl_rdb_vms_y = 4;
  874. isc_info_db_impl_rdb_eln_y = 5;
  875. isc_info_db_impl_jri = 6;
  876. isc_info_db_impl_jsv = 7;
  877. isc_info_db_impl_isc_a = 25;
  878. isc_info_db_impl_isc_u = 26;
  879. isc_info_db_impl_isc_v = 27;
  880. isc_info_db_impl_isc_s = 28;
  881. isc_info_db_impl_isc_apl_68K = 25;
  882. isc_info_db_impl_isc_vax_ultr = 26;
  883. isc_info_db_impl_isc_vms = 27;
  884. isc_info_db_impl_isc_sun_68k = 28;
  885. isc_info_db_impl_isc_os2 = 29;
  886. isc_info_db_impl_isc_sun4 = 30;
  887. isc_info_db_impl_isc_hp_ux = 31;
  888. isc_info_db_impl_isc_sun_386i = 32;
  889. isc_info_db_impl_isc_vms_orcl = 33;
  890. isc_info_db_impl_isc_mac_aux = 34;
  891. isc_info_db_impl_isc_rt_aix = 35;
  892. isc_info_db_impl_isc_mips_ult = 36;
  893. isc_info_db_impl_isc_xenix = 37;
  894. isc_info_db_impl_isc_dg = 38;
  895. isc_info_db_impl_isc_hp_mpexl = 39;
  896. isc_info_db_impl_isc_hp_ux68K = 40;
  897. isc_info_db_impl_isc_sgi = 41;
  898. isc_info_db_impl_isc_sco_unix = 42;
  899. isc_info_db_impl_isc_cray = 43;
  900. isc_info_db_impl_isc_imp = 44;
  901. isc_info_db_impl_isc_delta = 45;
  902. isc_info_db_impl_isc_next = 46;
  903. isc_info_db_impl_isc_dos = 47;
  904. isc_info_db_impl_isc_winnt = 48;
  905. isc_info_db_impl_isc_epson = 49;
  906. isc_info_db_class_access = 1;
  907. isc_info_db_class_y_valve = 2;
  908. isc_info_db_class_rem_int = 3;
  909. isc_info_db_class_rem_srvr = 4;
  910. isc_info_db_class_pipe_int = 7;
  911. isc_info_db_class_pipe_srvr = 8;
  912. isc_info_db_class_sam_int = 9;
  913. isc_info_db_class_sam_srvr = 10;
  914. isc_info_db_class_gateway = 11;
  915. isc_info_db_class_cache = 12;
  916. { }
  917. { Request information items }
  918. { }
  919. isc_info_number_messages = 4;
  920. isc_info_max_message = 5;
  921. isc_info_max_send = 6;
  922. isc_info_max_receive = 7;
  923. isc_info_state = 8;
  924. isc_info_message_number = 9;
  925. isc_info_message_size = 10;
  926. isc_info_request_cost = 11;
  927. isc_info_access_path = 12;
  928. isc_info_req_select_count = 13;
  929. isc_info_req_insert_count = 14;
  930. isc_info_req_update_count = 15;
  931. isc_info_req_delete_count = 16;
  932. { }
  933. { Access path items }
  934. { }
  935. isc_info_rsb_end = 0;
  936. isc_info_rsb_begin = 1;
  937. isc_info_rsb_type = 2;
  938. isc_info_rsb_relation = 3;
  939. isc_info_rsb_plan = 4;
  940. { }
  941. { Rsb types }
  942. { }
  943. isc_info_rsb_unknown = 1;
  944. isc_info_rsb_indexed = 2;
  945. isc_info_rsb_navigate = 3;
  946. isc_info_rsb_sequential = 4;
  947. isc_info_rsb_cross = 5;
  948. isc_info_rsb_sort = 6;
  949. isc_info_rsb_first = 7;
  950. isc_info_rsb_boolean = 8;
  951. isc_info_rsb_union = 9;
  952. isc_info_rsb_aggregate = 10;
  953. isc_info_rsb_merge = 11;
  954. isc_info_rsb_ext_sequential = 12;
  955. isc_info_rsb_ext_indexed = 13;
  956. isc_info_rsb_ext_dbkey = 14;
  957. isc_info_rsb_left_cross = 15;
  958. isc_info_rsb_select = 16;
  959. isc_info_rsb_sql_join = 17;
  960. isc_info_rsb_simulate = 18;
  961. isc_info_rsb_sim_cross = 19;
  962. isc_info_rsb_once = 20;
  963. isc_info_rsb_procedure = 21;
  964. { }
  965. { Bitmap expressions }
  966. { }
  967. isc_info_rsb_and = 1;
  968. isc_info_rsb_or = 2;
  969. isc_info_rsb_dbkey = 3;
  970. isc_info_rsb_index = 4;
  971. isc_info_req_active = 2;
  972. isc_info_req_inactive = 3;
  973. isc_info_req_send = 4;
  974. isc_info_req_receive = 5;
  975. isc_info_req_select = 6;
  976. isc_info_req_sql_stall = 7;
  977. { }
  978. { Blob information items }
  979. { }
  980. isc_info_blob_num_segments = 4;
  981. isc_info_blob_max_segment = 5;
  982. isc_info_blob_total_length = 6;
  983. isc_info_blob_type = 7;
  984. { }
  985. { Transaction information items }
  986. { }
  987. isc_info_tra_id = 4;
  988. {
  989. Service action items
  990. }
  991. { Starts database backup process on the server }
  992. isc_action_svc_backup = 1;
  993. { Starts database restore process on the server }
  994. isc_action_svc_restore = 2;
  995. { Starts database repair process on the server }
  996. isc_action_svc_repair = 3;
  997. { Adds a new user to the security database }
  998. isc_action_svc_add_user = 4;
  999. { Deletes a user record from the security database }
  1000. isc_action_svc_delete_user = 5;
  1001. { Modifies a user record in the security database }
  1002. isc_action_svc_modify_user = 6;
  1003. { Displays a user record from the security database }
  1004. isc_action_svc_display_user = 7;
  1005. { Sets database properties }
  1006. isc_action_svc_properties = 8;
  1007. { Adds a license to the license file }
  1008. isc_action_svc_add_license = 9;
  1009. { Removes a license from the license file }
  1010. isc_action_svc_remove_license = 10;
  1011. { Retrieves database statistics }
  1012. isc_action_svc_db_stats = 11;
  1013. { Retrieves the InterBase log file from the server }
  1014. isc_action_svc_get_ib_log = 12;
  1015. {
  1016. Service information items
  1017. }
  1018. { Retrieves the number of attachments and databases }
  1019. isc_info_svc_svr_db_info = 50;
  1020. { Retrieves all license keys and IDs from the license file }
  1021. isc_info_svc_get_license = 51;
  1022. { Retrieves a bitmask representing licensed options on the server }
  1023. isc_info_svc_get_license_mask = 52;
  1024. { Retrieves the parameters and values for IB_CONFIG }
  1025. isc_info_svc_get_config = 53;
  1026. { Retrieves the version of the services manager }
  1027. isc_info_svc_version = 54;
  1028. { Retrieves the version of the InterBase server }
  1029. isc_info_svc_server_version = 55;
  1030. { Retrieves the implementation of the InterBase server }
  1031. isc_info_svc_implementation = 56;
  1032. { Retrieves a bitmask representing the server's capabilities }
  1033. isc_info_svc_capabilities = 57;
  1034. { Retrieves the path to the security database in use by the server }
  1035. isc_info_svc_user_dbpath = 58;
  1036. { Retrieves the setting of $INTERBASE }
  1037. isc_info_svc_get_env = 59;
  1038. { Retrieves the setting of $INTERBASE_LCK }
  1039. isc_info_svc_get_env_lock = 60;
  1040. { Retrieves the setting of $INTERBASE_MSG }
  1041. isc_info_svc_get_env_msg = 61;
  1042. { Retrieves 1 line of service output per call }
  1043. isc_info_svc_line = 62;
  1044. { Retrieves as much of the server output as will fit in the supplied buffer }
  1045. isc_info_svc_to_eof = 63;
  1046. { Sets / signifies a timeout value for reading service information }
  1047. isc_info_svc_timeout = 64;
  1048. { Retrieves the number of users licensed for accessing the server }
  1049. isc_info_svc_get_licensed_users = 65;
  1050. { Retrieve the limbo transactions }
  1051. isc_info_svc_limbo_trans = 66;
  1052. { Checks to see if a service is running on an attachment }
  1053. isc_info_svc_running = 67;
  1054. { Returns the user information from isc_action_svc_display_users }
  1055. isc_info_svc_get_users = 68;
  1056. {
  1057. Parameters for isc_action_(add|delete|modify)_user
  1058. }
  1059. isc_spb_sec_userid = 5;
  1060. isc_spb_sec_groupid = 6;
  1061. isc_spb_sec_username = 7;
  1062. isc_spb_sec_password = 8;
  1063. isc_spb_sec_groupname = 9;
  1064. isc_spb_sec_firstname = 10;
  1065. isc_spb_sec_middlename = 11;
  1066. isc_spb_sec_lastname = 12;
  1067. {
  1068. Parameters for isc_action_svc_(add|remove)_license,
  1069. isc_info_svc_get_license
  1070. }
  1071. isc_spb_lic_key = 5;
  1072. isc_spb_lic_id = 6;
  1073. isc_spb_lic_desc = 7;
  1074. {
  1075. Parameters for isc_action_svc_backup
  1076. }
  1077. isc_spb_bkp_file = 5;
  1078. isc_spb_bkp_factor = 6;
  1079. isc_spb_bkp_length = 7;
  1080. isc_spb_bkp_ignore_checksums = $01;
  1081. isc_spb_bkp_ignore_limbo = $02;
  1082. isc_spb_bkp_metadata_only = $04;
  1083. isc_spb_bkp_no_garbage_collect = $08;
  1084. isc_spb_bkp_old_descriptions = $10;
  1085. isc_spb_bkp_non_transportable = $20;
  1086. isc_spb_bkp_convert = $40;
  1087. isc_spb_bkp_expand = $80;
  1088. {
  1089. Parameters for isc_action_svc_properties
  1090. }
  1091. isc_spb_prp_page_buffers = 5;
  1092. isc_spb_prp_sweep_interval = 6;
  1093. isc_spb_prp_shutdown_db = 7;
  1094. isc_spb_prp_deny_new_attachments = 9;
  1095. isc_spb_prp_deny_new_transactions = 10;
  1096. isc_spb_prp_reserve_space = 11;
  1097. isc_spb_prp_write_mode = 12;
  1098. isc_spb_prp_access_mode = 13;
  1099. isc_spb_prp_set_sql_dialect = 14;
  1100. isc_spb_prp_activate = $0100;
  1101. isc_spb_prp_db_online = $0200;
  1102. {
  1103. Parameters for isc_spb_prp_reserve_space
  1104. }
  1105. isc_spb_prp_res_use_full = 35;
  1106. isc_spb_prp_res = 36;
  1107. {
  1108. Parameters for isc_spb_prp_write_mode
  1109. }
  1110. isc_spb_prp_wm_async = 37;
  1111. isc_spb_prp_wm_sync = 38;
  1112. {
  1113. Parameters for isc_spb_prp_access_mode
  1114. }
  1115. isc_spb_prp_am_readonly = 39;
  1116. isc_spb_prp_am_readwrite = 40;
  1117. {
  1118. Parameters for isc_action_svc_repair
  1119. }
  1120. isc_spb_rpr_commit_trans = 15;
  1121. isc_spb_rpr_rollback_trans = 34;
  1122. isc_spb_rpr_recover_two_phase = 17;
  1123. isc_spb_tra_id = 18;
  1124. isc_spb_single_tra_id = 19;
  1125. isc_spb_multi_tra_id = 20;
  1126. isc_spb_tra_state = 21;
  1127. isc_spb_tra_state_limbo = 22;
  1128. isc_spb_tra_state_commit = 23;
  1129. isc_spb_tra_state_rollback = 24;
  1130. isc_spb_tra_state_unknown = 25;
  1131. isc_spb_tra_host_site = 26;
  1132. isc_spb_tra_remote_site = 27;
  1133. isc_spb_tra_db_path = 28;
  1134. isc_spb_tra_advise = 29;
  1135. isc_spb_tra_advise_commit = 30;
  1136. isc_spb_tra_advise_rollback = 31;
  1137. isc_spb_tra_advise_unknown = 33;
  1138. isc_spb_rpr_validate_db = $01;
  1139. isc_spb_rpr_sweep_db = $02;
  1140. isc_spb_rpr_mend_db = $04;
  1141. isc_spb_rpr_list_limbo_trans = $08;
  1142. isc_spb_rpr_check_db = $10;
  1143. isc_spb_rpr_ignore_checksum = $20;
  1144. isc_spb_rpr_kill_shadows = $40;
  1145. isc_spb_rpr_full = $80;
  1146. {
  1147. Parameters for isc_action_svc_restore
  1148. }
  1149. isc_spb_res_buffers = 9;
  1150. isc_spb_res_page_size = 10;
  1151. isc_spb_res_length = 11;
  1152. isc_spb_res_access_mode = 12;
  1153. isc_spb_res_fix_fss_data = 13;
  1154. isc_spb_res_fix_fss_metadata = 14;
  1155. isc_spb_res_deactivate_idx = $0100;
  1156. isc_spb_res_no_shadow = $0200;
  1157. isc_spb_res_no_validity = $0400;
  1158. isc_spb_res_one_at_a_time = $0800;
  1159. isc_spb_res_replace = $1000;
  1160. isc_spb_res_create = $2000;
  1161. isc_spb_res_use_all_space = $4000;
  1162. {
  1163. Parameters for isc_spb_res_access_mode
  1164. }
  1165. isc_spb_res_am_readonly = isc_spb_prp_am_readonly;
  1166. isc_spb_res_am_readwrite = isc_spb_prp_am_readwrite;
  1167. {
  1168. Parameters for isc_info_svc_svr_db_info
  1169. }
  1170. isc_spb_num_att = 5;
  1171. isc_spb_num_db = 6;
  1172. {
  1173. Parameters for isc_info_svc_db_stats
  1174. }
  1175. isc_spb_sts_data_pages = $01;
  1176. isc_spb_sts_db_log = $02;
  1177. isc_spb_sts_hdr_pages = $04;
  1178. isc_spb_sts_idx_pages = $08;
  1179. isc_spb_sts_sys_relations = $10;
  1180. isc_spb_sts_record_versions = $20;
  1181. isc_spb_sts_table = $40;
  1182. isc_spb_sts_nocreation = $80;
  1183. { }
  1184. { SQL information items }
  1185. { }
  1186. isc_info_sql_select = 4;
  1187. isc_info_sql_bind = 5;
  1188. isc_info_sql_num_variables = 6;
  1189. isc_info_sql_describe_vars = 7;
  1190. isc_info_sql_describe_end = 8;
  1191. isc_info_sql_sqlda_seq = 9;
  1192. isc_info_sql_message_seq = 10;
  1193. isc_info_sql_type = 11;
  1194. isc_info_sql_sub_type = 12;
  1195. isc_info_sql_scale = 13;
  1196. isc_info_sql_length = 14;
  1197. isc_info_sql_null_ind = 15;
  1198. isc_info_sql_field = 16;
  1199. isc_info_sql_relation = 17;
  1200. isc_info_sql_owner = 18;
  1201. isc_info_sql_alias = 19;
  1202. isc_info_sql_sqlda_start = 20;
  1203. isc_info_sql_stmt_type = 21;
  1204. isc_info_sql_get_plan = 22;
  1205. isc_info_sql_records = 23;
  1206. isc_info_sql_batch_fetch = 24;
  1207. { }
  1208. { SQL information return values }
  1209. { }
  1210. isc_info_sql_stmt_select = 1;
  1211. isc_info_sql_stmt_insert = 2;
  1212. isc_info_sql_stmt_update = 3;
  1213. isc_info_sql_stmt_delete = 4;
  1214. isc_info_sql_stmt_ddl = 5;
  1215. isc_info_sql_stmt_get_segment = 6;
  1216. isc_info_sql_stmt_put_segment = 7;
  1217. isc_info_sql_stmt_exec_procedure = 8;
  1218. isc_info_sql_stmt_start_trans = 9;
  1219. isc_info_sql_stmt_commit = 10;
  1220. isc_info_sql_stmt_rollback = 11;
  1221. isc_info_sql_stmt_select_for_upd = 12;
  1222. isc_info_sql_stmt_set_generator = 13;
  1223. { }
  1224. { Server configuration key values }
  1225. { }
  1226. ISCCFG_LOCKMEM_KEY = 0;
  1227. ISCCFG_LOCKSEM_KEY = 1;
  1228. ISCCFG_LOCKSIG_KEY = 2;
  1229. ISCCFG_EVNTMEM_KEY = 3;
  1230. ISCCFG_DBCACHE_KEY = 4;
  1231. ISCCFG_PRIORITY_KEY = 5;
  1232. ISCCFG_IPCMAP_KEY = 6;
  1233. ISCCFG_MEMMIN_KEY = 7;
  1234. ISCCFG_MEMMAX_KEY = 8;
  1235. ISCCFG_LOCKORDER_KEY = 9;
  1236. ISCCFG_ANYLOCKMEM_KEY = 10;
  1237. ISCCFG_ANYLOCKSEM_KEY = 11;
  1238. ISCCFG_ANYLOCKSIG_KEY = 12;
  1239. ISCCFG_ANYEVNTMEM_KEY = 13;
  1240. ISCCFG_LOCKHASH_KEY = 14;
  1241. ISCCFG_DEADLOCK_KEY = 15;
  1242. ISCCFG_LOCKSPIN_KEY = 16;
  1243. ISCCFG_CONN_TIMEOUT_KEY = 17;
  1244. ISCCFG_DUMMY_INTRVL_KEY = 18;
  1245. { Internal Use only }
  1246. ISCCFG_TRACE_POOLS_KEY = 19;
  1247. ISCCFG_REMOTE_BUFFER_KEY = 20;
  1248. { }
  1249. { Error codes }
  1250. { }
  1251. isc_facility = 20;
  1252. isc_err_base = 335544320;
  1253. isc_err_factor = 1;
  1254. isc_arg_end = 0;
  1255. isc_arg_gds = 1;
  1256. isc_arg_string = 2;
  1257. isc_arg_cstring = 3;
  1258. isc_arg_number = 4;
  1259. isc_arg_interpreted = 5;
  1260. isc_arg_vms = 6;
  1261. isc_arg_unix = 7;
  1262. isc_arg_domain = 8;
  1263. isc_arg_dos = 9;
  1264. isc_arg_mpexl = 10;
  1265. isc_arg_mpexl_ipc = 11;
  1266. isc_arg_next_mach = 15;
  1267. isc_arg_netware = 16;
  1268. isc_arg_win32 = 17;
  1269. isc_arg_warning = 18;
  1270. { }
  1271. { Dynamic Data Definition Language operators }
  1272. { }
  1273. { }
  1274. { Version number }
  1275. { }
  1276. const
  1277. isc_dyn_version_1 = 1;
  1278. isc_dyn_eoc = 255;
  1279. { }
  1280. { Operations (may be nested) }
  1281. { }
  1282. isc_dyn_begin = 2;
  1283. isc_dyn_end = 3;
  1284. isc_dyn_if = 4;
  1285. isc_dyn_def_database = 5;
  1286. isc_dyn_def_global_fld = 6;
  1287. isc_dyn_def_local_fld = 7;
  1288. isc_dyn_def_idx = 8;
  1289. isc_dyn_def_rel = 9;
  1290. isc_dyn_def_sql_fld = 10;
  1291. isc_dyn_def_view = 12;
  1292. isc_dyn_def_trigger = 15;
  1293. isc_dyn_def_security_class = 120;
  1294. isc_dyn_def_dimension = 140;
  1295. isc_dyn_def_generator = 24;
  1296. isc_dyn_def_function = 25;
  1297. isc_dyn_def_filter = 26;
  1298. isc_dyn_def_function_arg = 27;
  1299. isc_dyn_def_shadow = 34;
  1300. isc_dyn_def_trigger_msg = 17;
  1301. isc_dyn_def_file = 36;
  1302. isc_dyn_mod_database = 39;
  1303. isc_dyn_mod_rel = 11;
  1304. isc_dyn_mod_global_fld = 13;
  1305. isc_dyn_mod_idx = 102;
  1306. isc_dyn_mod_local_fld = 14;
  1307. isc_dyn_mod_sql_fld = 216;
  1308. isc_dyn_mod_view = 16;
  1309. isc_dyn_mod_security_class = 122;
  1310. isc_dyn_mod_trigger = 113;
  1311. isc_dyn_mod_trigger_msg = 28;
  1312. isc_dyn_delete_database = 18;
  1313. isc_dyn_delete_rel = 19;
  1314. isc_dyn_delete_global_fld = 20;
  1315. isc_dyn_delete_local_fld = 21;
  1316. isc_dyn_delete_idx = 22;
  1317. isc_dyn_delete_security_class = 123;
  1318. isc_dyn_delete_dimensions = 143;
  1319. isc_dyn_delete_trigger = 23;
  1320. isc_dyn_delete_trigger_msg = 29;
  1321. isc_dyn_delete_filter = 32;
  1322. isc_dyn_delete_function = 33;
  1323. isc_dyn_delete_shadow = 35;
  1324. isc_dyn_grant = 30;
  1325. isc_dyn_revoke = 31;
  1326. isc_dyn_def_primary_key = 37;
  1327. isc_dyn_def_foreign_key = 38;
  1328. isc_dyn_def_unique = 40;
  1329. isc_dyn_def_procedure = 164;
  1330. isc_dyn_delete_procedure = 165;
  1331. isc_dyn_def_parameter = 135;
  1332. isc_dyn_delete_parameter = 136;
  1333. isc_dyn_mod_procedure = 175;
  1334. isc_dyn_def_log_file = 176;
  1335. isc_dyn_def_cache_file = 180;
  1336. isc_dyn_def_exception = 181;
  1337. isc_dyn_mod_exception = 182;
  1338. isc_dyn_del_exception = 183;
  1339. isc_dyn_drop_log = 194;
  1340. isc_dyn_drop_cache = 195;
  1341. isc_dyn_def_default_log = 202;
  1342. { }
  1343. { View specific stuff }
  1344. { }
  1345. isc_dyn_view_blr = 43;
  1346. isc_dyn_view_source = 44;
  1347. isc_dyn_view_relation = 45;
  1348. isc_dyn_view_context = 46;
  1349. isc_dyn_view_context_name = 47;
  1350. { }
  1351. { Generic attributes }
  1352. { }
  1353. isc_dyn_rel_name = 50;
  1354. isc_dyn_fld_name = 51;
  1355. isc_dyn_new_fld_name = 215;
  1356. isc_dyn_idx_name = 52;
  1357. isc_dyn_description = 53;
  1358. isc_dyn_security_class = 54;
  1359. isc_dyn_system_flag = 55;
  1360. isc_dyn_update_flag = 56;
  1361. isc_dyn_prc_name = 166;
  1362. isc_dyn_prm_name = 137;
  1363. isc_dyn_sql_object = 196;
  1364. isc_dyn_fld_character_set_name = 174;
  1365. { }
  1366. { Relation specific attributes }
  1367. { }
  1368. isc_dyn_rel_dbkey_length = 61;
  1369. isc_dyn_rel_store_trig = 62;
  1370. isc_dyn_rel_modify_trig = 63;
  1371. isc_dyn_rel_erase_trig = 64;
  1372. isc_dyn_rel_store_trig_source = 65;
  1373. isc_dyn_rel_modify_trig_source = 66;
  1374. isc_dyn_rel_erase_trig_source = 67;
  1375. isc_dyn_rel_ext_file = 68;
  1376. isc_dyn_rel_sql_protection = 69;
  1377. isc_dyn_rel_constraint = 162;
  1378. isc_dyn_delete_rel_constraint = 163;
  1379. { }
  1380. { Global field specific attributes }
  1381. { }
  1382. isc_dyn_fld_type = 70;
  1383. isc_dyn_fld_length = 71;
  1384. isc_dyn_fld_scale = 72;
  1385. isc_dyn_fld_sub_type = 73;
  1386. isc_dyn_fld_segment_length = 74;
  1387. isc_dyn_fld_query_header = 75;
  1388. isc_dyn_fld_edit_string = 76;
  1389. isc_dyn_fld_validation_blr = 77;
  1390. isc_dyn_fld_validation_source = 78;
  1391. isc_dyn_fld_computed_blr = 79;
  1392. isc_dyn_fld_computed_source = 80;
  1393. isc_dyn_fld_missing_value = 81;
  1394. isc_dyn_fld_default_value = 82;
  1395. isc_dyn_fld_query_name = 83;
  1396. isc_dyn_fld_dimensions = 84;
  1397. isc_dyn_fld_not_null = 85;
  1398. isc_dyn_fld_precision = 86;
  1399. isc_dyn_fld_char_length = 172;
  1400. isc_dyn_fld_collation = 173;
  1401. isc_dyn_fld_default_source = 193;
  1402. isc_dyn_del_default = 197;
  1403. isc_dyn_del_validation = 198;
  1404. isc_dyn_single_validation = 199;
  1405. isc_dyn_fld_character_set = 203;
  1406. { }
  1407. { Local field specific attributes }
  1408. { }
  1409. isc_dyn_fld_source = 90;
  1410. isc_dyn_fld_base_fld = 91;
  1411. isc_dyn_fld_position = 92;
  1412. isc_dyn_fld_update_flag = 93;
  1413. { }
  1414. { Index specific attributes }
  1415. { }
  1416. isc_dyn_idx_unique = 100;
  1417. isc_dyn_idx_inactive = 101;
  1418. isc_dyn_idx_type = 103;
  1419. isc_dyn_idx_foreign_key = 104;
  1420. isc_dyn_idx_ref_column = 105;
  1421. isc_dyn_idx_statistic = 204;
  1422. { }
  1423. { Trigger specific attributes }
  1424. { }
  1425. isc_dyn_trg_type = 110;
  1426. isc_dyn_trg_blr = 111;
  1427. isc_dyn_trg_source = 112;
  1428. isc_dyn_trg_name = 114;
  1429. isc_dyn_trg_sequence = 115;
  1430. isc_dyn_trg_inactive = 116;
  1431. isc_dyn_trg_msg_number = 117;
  1432. isc_dyn_trg_msg = 118;
  1433. { }
  1434. { Security Class specific attributes }
  1435. { }
  1436. isc_dyn_scl_acl = 121;
  1437. isc_dyn_grant_user = 130;
  1438. isc_dyn_grant_proc = 186;
  1439. isc_dyn_grant_trig = 187;
  1440. isc_dyn_grant_view = 188;
  1441. isc_dyn_grant_options = 132;
  1442. isc_dyn_grant_user_group = 205;
  1443. { }
  1444. { Dimension specific information }
  1445. { }
  1446. isc_dyn_dim_lower = 141;
  1447. isc_dyn_dim_upper = 142;
  1448. { }
  1449. { File specific attributes }
  1450. { }
  1451. isc_dyn_file_name = 125;
  1452. isc_dyn_file_start = 126;
  1453. isc_dyn_file_length = 127;
  1454. isc_dyn_shadow_number = 128;
  1455. isc_dyn_shadow_man_auto = 129;
  1456. isc_dyn_shadow_conditional = 130;
  1457. { }
  1458. { Log file specific attributes }
  1459. { }
  1460. isc_dyn_log_file_sequence = 177;
  1461. isc_dyn_log_file_partitions = 178;
  1462. isc_dyn_log_file_serial = 179;
  1463. isc_dyn_log_file_overflow = 200;
  1464. isc_dyn_log_file_raw = 201;
  1465. { }
  1466. { Log specific attributes }
  1467. { }
  1468. isc_dyn_log_group_commit_wait = 189;
  1469. isc_dyn_log_buffer_size = 190;
  1470. isc_dyn_log_check_point_length = 191;
  1471. isc_dyn_log_num_of_buffers = 192;
  1472. { }
  1473. { Function specific attributes }
  1474. { }
  1475. isc_dyn_function_name = 145;
  1476. isc_dyn_function_type = 146;
  1477. isc_dyn_func_module_name = 147;
  1478. isc_dyn_func_entry_point = 148;
  1479. isc_dyn_func_return_argument = 149;
  1480. isc_dyn_func_arg_position = 150;
  1481. isc_dyn_func_mechanism = 151;
  1482. isc_dyn_filter_in_subtype = 152;
  1483. isc_dyn_filter_out_subtype = 153;
  1484. isc_dyn_description2 = 154;
  1485. isc_dyn_fld_computed_source2 = 155;
  1486. isc_dyn_fld_edit_string2 = 156;
  1487. isc_dyn_fld_query_header2 = 157;
  1488. isc_dyn_fld_validation_source2 = 158;
  1489. isc_dyn_trg_msg2 = 159;
  1490. isc_dyn_trg_source2 = 160;
  1491. isc_dyn_view_source2 = 161;
  1492. isc_dyn_xcp_msg2 = 184;
  1493. { }
  1494. { Generator specific attributes }
  1495. { }
  1496. isc_dyn_generator_name = 95;
  1497. isc_dyn_generator_id = 96;
  1498. { }
  1499. { Procedure specific attributes }
  1500. { }
  1501. isc_dyn_prc_inputs = 167;
  1502. isc_dyn_prc_outputs = 168;
  1503. isc_dyn_prc_source = 169;
  1504. isc_dyn_prc_blr = 170;
  1505. isc_dyn_prc_source2 = 171;
  1506. { }
  1507. { Parameter specific attributes }
  1508. { }
  1509. isc_dyn_prm_number = 138;
  1510. isc_dyn_prm_type = 139;
  1511. { }
  1512. { Relation specific attributes }
  1513. { }
  1514. isc_dyn_xcp_msg = 185;
  1515. { }
  1516. { Cascading referential integrity values }
  1517. { }
  1518. isc_dyn_foreign_key_update = 205;
  1519. isc_dyn_foreign_key_delete = 206;
  1520. isc_dyn_foreign_key_cascade = 207;
  1521. isc_dyn_foreign_key_default = 208;
  1522. isc_dyn_foreign_key_null = 209;
  1523. isc_dyn_foreign_key_none = 210;
  1524. { }
  1525. { SQL role values }
  1526. { }
  1527. isc_dyn_def_sql_role = 211;
  1528. isc_dyn_sql_role_name = 212;
  1529. isc_dyn_grant_admin_options = 213;
  1530. isc_dyn_del_sql_role = 214;
  1531. { }
  1532. { Last $dyn value assigned }
  1533. { }
  1534. isc_dyn_last_dyn_value = 216;
  1535. { }
  1536. { Array slice description language (SDL) }
  1537. { }
  1538. isc_sdl_version1 = 1;
  1539. isc_sdl_eoc = 255;
  1540. isc_sdl_relation = 2;
  1541. isc_sdl_rid = 3;
  1542. isc_sdl_field = 4;
  1543. isc_sdl_fid = 5;
  1544. isc_sdl_struct = 6;
  1545. isc_sdl_variable = 7;
  1546. isc_sdl_scalar = 8;
  1547. isc_sdl_tiny_integer = 9;
  1548. isc_sdl_short_integer = 10;
  1549. isc_sdl_long_integer = 11;
  1550. isc_sdl_literal = 12;
  1551. isc_sdl_add = 13;
  1552. isc_sdl_subtract = 14;
  1553. isc_sdl_multiply = 15;
  1554. isc_sdl_divide = 16;
  1555. isc_sdl_negate = 17;
  1556. isc_sdl_eql = 18;
  1557. isc_sdl_neq = 19;
  1558. isc_sdl_gtr = 20;
  1559. isc_sdl_geq = 21;
  1560. isc_sdl_lss = 22;
  1561. isc_sdl_leq = 23;
  1562. isc_sdl_and = 24;
  1563. isc_sdl_or = 25;
  1564. isc_sdl_not = 26;
  1565. isc_sdl_while = 27;
  1566. isc_sdl_assignment = 28;
  1567. isc_sdl_label = 29;
  1568. isc_sdl_leave = 30;
  1569. isc_sdl_begin = 31;
  1570. isc_sdl_end = 32;
  1571. isc_sdl_do3 = 33;
  1572. isc_sdl_do2 = 34;
  1573. isc_sdl_do1 = 35;
  1574. isc_sdl_element = 36;
  1575. { }
  1576. { International text interpretation values }
  1577. { }
  1578. isc_interp_eng_ascii = 0;
  1579. isc_interp_jpn_sjis = 5;
  1580. isc_interp_jpn_euc = 6;
  1581. { }
  1582. { SQL definitions }
  1583. { }
  1584. SQL_TEXT = 452;
  1585. SQL_VARYING = 448;
  1586. SQL_SHORT = 500;
  1587. SQL_LONG = 496;
  1588. SQL_FLOAT = 482;
  1589. SQL_DOUBLE = 480;
  1590. SQL_D_FLOAT = 530;
  1591. SQL_TIMESTAMP = 510;
  1592. SQL_BLOB = 520;
  1593. SQL_ARRAY = 540;
  1594. SQL_QUAD = 550;
  1595. SQL_TYPE_TIME = 560;
  1596. SQL_TYPE_DATE = 570;
  1597. SQL_INT64 = 580;
  1598. { Historical alias for pre V6 applications }
  1599. SQL_DATE = SQL_TIMESTAMP;
  1600. { }
  1601. { Blob Subtypes }
  1602. { }
  1603. { types less than zero are reserved for customer use }
  1604. isc_blob_untyped = 0;
  1605. { internal subtypes }
  1606. isc_blob_text = 1;
  1607. isc_blob_blr = 2;
  1608. isc_blob_acl = 3;
  1609. isc_blob_ranges = 4;
  1610. isc_blob_summary = 5;
  1611. isc_blob_format = 6;
  1612. isc_blob_tra = 7;
  1613. isc_blob_extfile = 8;
  1614. { the range 20-30 is reserved for dBASE and Paradox types }
  1615. isc_blob_formatted_memo = 20;
  1616. isc_blob_paradox_ole = 21;
  1617. isc_blob_graphic = 22;
  1618. isc_blob_dbase_ole = 23;
  1619. isc_blob_typed_binary = 24;
  1620. {$IFNDEF LinkDynamically}
  1621. { }
  1622. { OSRI database functions }
  1623. { }
  1624. function isc_attach_database(_para1:PISC_STATUS; _para2:smallint; _para3:PAnsiChar; _para4:Pisc_db_handle; _para5:smallint;
  1625. _para6:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1626. function isc_array_gen_sdl(_para1:PISC_STATUS; _para2:PISC_ARRAY_DESC; _para3:Psmallint; _para4:PAnsiChar; _para5:Psmallint):ISC_STATUS; extdecl; external gdslib;
  1627. function isc_array_get_slice(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:PISC_QUAD; _para5:PISC_ARRAY_DESC;
  1628. _para6:pointer; _para7:PISC_LONG):ISC_STATUS; extdecl; external gdslib;
  1629. function isc_array_lookup_bounds(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:PAnsiChar; _para5:PAnsiChar;
  1630. _para6:PISC_ARRAY_DESC):ISC_STATUS; extdecl; external gdslib;
  1631. function isc_array_lookup_desc(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:PAnsiChar; _para5:PAnsiChar;
  1632. _para6:PISC_ARRAY_DESC):ISC_STATUS; extdecl; external gdslib;
  1633. function isc_array_set_desc(_para1:PISC_STATUS; _para2:PAnsiChar; _para3:PAnsiChar; _para4:Psmallint; _para5:Psmallint;
  1634. _para6:Psmallint; _para7:PISC_ARRAY_DESC):ISC_STATUS; extdecl; external gdslib;
  1635. function isc_array_put_slice(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:PISC_QUAD; _para5:PISC_ARRAY_DESC;
  1636. _para6:pointer; _para7:PISC_LONG):ISC_STATUS; extdecl; external gdslib;
  1637. procedure isc_blob_default_desc(_para1:PISC_BLOB_DESC; _para2:Pbyte; _para3:Pbyte); extdecl; external gdslib;
  1638. function isc_blob_gen_bpb(_para1:PISC_STATUS; _para2:PISC_BLOB_DESC; _para3:PISC_BLOB_DESC; _para4:word; _para5:Pbyte;
  1639. _para6:Pword):ISC_STATUS; extdecl; external gdslib;
  1640. function isc_blob_info(_para1:PISC_STATUS; _para2:Pisc_blob_handle; _para3:smallint; _para4:PAnsiChar; _para5:smallint;
  1641. _para6:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1642. function isc_blob_lookup_desc(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Pbyte; _para5:Pbyte;
  1643. _para6:PISC_BLOB_DESC; _para7:Pbyte):ISC_STATUS; extdecl; external gdslib;
  1644. function isc_blob_set_desc(_para1:PISC_STATUS; _para2:Pbyte; _para3:Pbyte; _para4:smallint; _para5:smallint;
  1645. _para6:smallint; _para7:PISC_BLOB_DESC):ISC_STATUS; extdecl; external gdslib;
  1646. function isc_cancel_blob(_para1:PISC_STATUS; _para2:Pisc_blob_handle):ISC_STATUS; extdecl; external gdslib;
  1647. function isc_cancel_events(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:PISC_LONG):ISC_STATUS; extdecl; external gdslib;
  1648. function isc_close_blob(_para1:PISC_STATUS; _para2:Pisc_blob_handle):ISC_STATUS; extdecl; external gdslib;
  1649. function isc_commit_retaining(_para1:PISC_STATUS; _para2:Pisc_tr_handle):ISC_STATUS; extdecl; external gdslib;
  1650. function isc_commit_transaction(_para1:PISC_STATUS; _para2:Pisc_tr_handle):ISC_STATUS; extdecl; external gdslib;
  1651. function isc_create_blob(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Pisc_blob_handle; _para5:PISC_QUAD):ISC_STATUS; extdecl; external gdslib;
  1652. function isc_create_blob2(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Pisc_blob_handle; _para5:PISC_QUAD;
  1653. _para6:smallint; _para7:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1654. function isc_create_database(_para1:PISC_STATUS; _para2:smallint; _para3:PAnsiChar; _para4:Pisc_db_handle; _para5:smallint;
  1655. _para6:PAnsiChar; _para7:smallint):ISC_STATUS; extdecl; external gdslib;
  1656. function isc_database_info(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:smallint; _para4:PAnsiChar; _para5:smallint;
  1657. _para6:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1658. procedure isc_decode_date(_para1:PISC_QUAD; _para2:pointer); extdecl; external gdslib;
  1659. procedure isc_decode_sql_date(_para1:PISC_DATE; _para2:pointer); extdecl; external gdslib;
  1660. procedure isc_decode_sql_time(_para1:PISC_TIME; _para2:pointer); extdecl; external gdslib;
  1661. procedure isc_decode_timestamp(_para1:PISC_TIMESTAMP; _para2:pointer); extdecl; external gdslib;
  1662. function isc_detach_database(_para1:PISC_STATUS; _para2:Pisc_db_handle):ISC_STATUS; extdecl; external gdslib;
  1663. function isc_drop_database(_para1:PISC_STATUS; _para2:Pisc_db_handle):ISC_STATUS; extdecl; external gdslib;
  1664. function isc_dsql_allocate_statement(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_stmt_handle):ISC_STATUS; extdecl; external gdslib;
  1665. function isc_dsql_alloc_statement2(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_stmt_handle):ISC_STATUS; extdecl; external gdslib;
  1666. function isc_dsql_describe(_para1:PISC_STATUS; _para2:Pisc_stmt_handle; _para3:word; _para4:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1667. function isc_dsql_describe_bind(_para1:PISC_STATUS; _para2:Pisc_stmt_handle; _para3:word; _para4:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1668. function isc_dsql_exec_immed2(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:word; _para5:PAnsiChar;
  1669. _para6:word; _para7:PXSQLDA; _para8:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1670. function isc_dsql_execute(_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:Pisc_stmt_handle; _para4:word; _para5:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1671. function isc_dsql_execute2(_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:Pisc_stmt_handle; _para4:word; _para5:PXSQLDA;
  1672. _para6:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1673. function isc_dsql_execute_immediate(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:word; _para5:PAnsiChar;
  1674. _para6:word; _para7:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1675. function isc_dsql_fetch(_para1:PISC_STATUS; _para2:Pisc_stmt_handle; _para3:word; _para4:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1676. function isc_dsql_finish(_para1:Pisc_db_handle):ISC_STATUS; extdecl; external gdslib;
  1677. function isc_dsql_free_statement(_para1:PISC_STATUS; _para2:Pisc_stmt_handle; _para3:word):ISC_STATUS; extdecl; external gdslib;
  1678. function isc_dsql_insert(_para1:PISC_STATUS; _para2:Pisc_stmt_handle; _para3:word; _para4:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1679. function isc_dsql_prepare(_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:Pisc_stmt_handle; _para4:word; _para5:PAnsiChar;
  1680. _para6:word; _para7:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1681. function isc_dsql_set_cursor_name(_para1:PISC_STATUS; _para2:Pisc_stmt_handle; _para3:PAnsiChar; _para4:word):ISC_STATUS; extdecl; external gdslib;
  1682. function isc_dsql_sql_info(_para1:PISC_STATUS; _para2:Pisc_stmt_handle; _para3:smallint; _para4:PAnsiChar; _para5:smallint;
  1683. _para6:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1684. procedure isc_encode_date(_para1:pointer; _para2:PISC_QUAD); extdecl; external gdslib;
  1685. procedure isc_encode_sql_date(_para1:pointer; _para2:PISC_DATE); extdecl; external gdslib;
  1686. procedure isc_encode_sql_time(_para1:pointer; _para2:PISC_TIME); extdecl; external gdslib;
  1687. procedure isc_encode_timestamp(_para1:pointer; _para2:PISC_TIMESTAMP); extdecl; external gdslib;
  1688. function isc_event_block(_para1:PPAnsiChar; _para2:PPAnsiChar; _para3:word; args:array of const):ISC_LONG; cdecl; external gdslib;
  1689. procedure isc_event_counts(_para1: PISC_STATUS; _para2: short; _para3: PAnsiChar; _para4: PAnsiChar); extdecl; external gdslib;
  1690. procedure isc_expand_dpb(_para1:PPAnsiChar; _para2:Psmallint; args:array of const); cdecl; external gdslib;
  1691. function isc_modify_dpb(_para1:PPAnsiChar; _para2:Psmallint; _para3:word; _para4:PAnsiChar; _para5:smallint):longint; extdecl; external gdslib;
  1692. function isc_free(_para1:PAnsiChar):ISC_LONG; extdecl; external gdslib;
  1693. function isc_get_segment(_para1:PISC_STATUS; _para2:Pisc_blob_handle; _para3:Pword; _para4:word; _para5:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1694. function isc_get_slice(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:PISC_QUAD; _para5:smallint;
  1695. _para6:PAnsiChar; _para7:smallint; _para8:PISC_LONG; _para9:ISC_LONG; _para10:pointer;
  1696. _para11:PISC_LONG):ISC_STATUS; extdecl; external gdslib;
  1697. function isc_interprete(_para1:PAnsiChar; _para2:PPISC_STATUS):ISC_STATUS; extdecl; external gdslib;
  1698. function isc_open_blob(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Pisc_blob_handle; _para5:PISC_QUAD):ISC_STATUS; extdecl; external gdslib;
  1699. function isc_open_blob2(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Pisc_blob_handle; _para5:PISC_QUAD;
  1700. _para6:smallint; _para7:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1701. function isc_prepare_transaction2(_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:smallint; _para4:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1702. procedure isc_print_sqlerror(_para1:smallint; _para2:PISC_STATUS); extdecl; external gdslib;
  1703. function isc_print_status(_para1:PISC_STATUS):ISC_STATUS; extdecl; external gdslib;
  1704. function isc_put_segment(_para1:PISC_STATUS; _para2:Pisc_blob_handle; _para3:word; _para4:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1705. function isc_put_slice(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:PISC_QUAD; _para5:smallint;
  1706. _para6:PAnsiChar; _para7:smallint; _para8:PISC_LONG; _para9:ISC_LONG; _para10:pointer):ISC_STATUS; extdecl; external gdslib;
  1707. function isc_que_events(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:PISC_LONG; _para4:smallint; _para5:PAnsiChar;
  1708. _para6:isc_callback; _para7:pointer):ISC_STATUS; extdecl; external gdslib;
  1709. function isc_rollback_retaining(_para1:PISC_STATUS; _para2:Pisc_tr_handle):ISC_STATUS; extdecl; external gdslib;
  1710. function isc_rollback_transaction(_para1:PISC_STATUS; _para2:Pisc_tr_handle):ISC_STATUS; extdecl; external gdslib;
  1711. function isc_start_multiple(_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:smallint; _para4:pointer):ISC_STATUS; extdecl; external gdslib;
  1712. function isc_start_transaction(_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:smallint; args:array of const):ISC_STATUS; cdecl; external gdslib;
  1713. function isc_sqlcode(_para1:PISC_STATUS):ISC_LONG; extdecl; external gdslib;
  1714. // Available in Firebird 2.5+
  1715. function fb_sqlstate(_para1: PAnsiChar;_para2:PISC_STATUS): ISC_STATUS ; extdecl; external gdslib;
  1716. procedure isc_sql_interprete(_para1:smallint; _para2:PAnsiChar; _para3:smallint); extdecl; external gdslib;
  1717. function isc_transaction_info(_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:smallint; _para4:PAnsiChar; _para5:smallint;
  1718. _para6:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1719. function isc_transact_request(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:word; _para5:PAnsiChar;
  1720. _para6:word; _para7:PAnsiChar; _para8:word; _para9:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1721. function isc_vax_integer(_para1:PAnsiChar; _para2:smallint):ISC_LONG; extdecl; external gdslib;
  1722. function isc_portable_integer(_para1:Pbyte; _para2:smallint):ISC_INT64; extdecl; external gdslib;
  1723. { }
  1724. { Security Functions }
  1725. { }
  1726. function isc_add_user(_para1:PISC_STATUS; _para2:PUSER_SEC_DATA):longint; extdecl; external gdslib;
  1727. function isc_delete_user(_para1:PISC_STATUS; _para2:PUSER_SEC_DATA):longint; extdecl; external gdslib;
  1728. function isc_modify_user(_para1:PISC_STATUS; _para2:PUSER_SEC_DATA):longint; extdecl; external gdslib;
  1729. { }
  1730. { Other OSRI functions }
  1731. { }
  1732. function isc_compile_request(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_req_handle; _para4:smallint; _para5:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1733. function isc_compile_request2(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_req_handle; _para4:smallint; _para5:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1734. function isc_ddl(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:smallint; _para5:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1735. function isc_prepare_transaction(_para1:PISC_STATUS; _para2:Pisc_tr_handle):ISC_STATUS; extdecl; external gdslib;
  1736. function isc_receive(_para1:PISC_STATUS; _para2:Pisc_req_handle; _para3:smallint; _para4:smallint; _para5:pointer;
  1737. _para6:smallint):ISC_STATUS; extdecl; external gdslib;
  1738. function isc_reconnect_transaction(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:smallint; _para5:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1739. function isc_release_request(_para1:PISC_STATUS; _para2:Pisc_req_handle):ISC_STATUS; extdecl; external gdslib;
  1740. function isc_request_info(_para1:PISC_STATUS; _para2:Pisc_req_handle; _para3:smallint; _para4:smallint; _para5:PAnsiChar;
  1741. _para6:smallint; _para7:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1742. function isc_seek_blob(_para1:PISC_STATUS; _para2:Pisc_blob_handle; _para3:smallint; _para4:ISC_LONG; _para5:PISC_LONG):ISC_STATUS; extdecl; external gdslib;
  1743. function isc_send(_para1:PISC_STATUS; _para2:Pisc_req_handle; _para3:smallint; _para4:smallint; _para5:pointer;
  1744. _para6:smallint):ISC_STATUS; extdecl; external gdslib;
  1745. function isc_start_and_send(_para1:PISC_STATUS; _para2:Pisc_req_handle; _para3:Pisc_tr_handle; _para4:smallint; _para5:smallint;
  1746. _para6:pointer; _para7:smallint):ISC_STATUS; extdecl; external gdslib;
  1747. function isc_start_request(_para1:PISC_STATUS; _para2:Pisc_req_handle; _para3:Pisc_tr_handle; _para4:smallint):ISC_STATUS; extdecl; external gdslib;
  1748. function isc_unwind_request(_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:smallint):ISC_STATUS; extdecl; external gdslib;
  1749. function isc_wait_for_event(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:smallint; _para4:PAnsiChar; _para5:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1750. { }
  1751. { Other Sql functions }
  1752. { }
  1753. function isc_close(_para1:PISC_STATUS; _para2:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1754. function isc_declare(_para1:PISC_STATUS; _para2:PAnsiChar; _para3:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1755. function isc_describe(_para1:PISC_STATUS; _para2:PAnsiChar; _para3:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1756. function isc_describe_bind(_para1:PISC_STATUS; _para2:PAnsiChar; _para3:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1757. function isc_execute(_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:PAnsiChar; _para4:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1758. function isc_execute_immediate(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Psmallint; _para5:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1759. function isc_fetch(_para1:PISC_STATUS; _para2:PAnsiChar; _para3:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1760. function isc_open(_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:PAnsiChar; _para4:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1761. function isc_prepare(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:PAnsiChar; _para5:Psmallint;
  1762. _para6:PAnsiChar; _para7:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1763. { }
  1764. { Other Dynamic sql functions }
  1765. { }
  1766. function isc_dsql_execute_m(_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:Pisc_stmt_handle; _para4:word; _para5:PAnsiChar;
  1767. _para6:word; _para7:word; _para8:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1768. function isc_dsql_execute2_m(_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:Pisc_stmt_handle; _para4:word; _para5:PAnsiChar;
  1769. _para6:word; _para7:word; _para8:PAnsiChar; _para9:word; _para10:PAnsiChar;
  1770. _para11:word; _para12:word; _para13:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1771. function isc_dsql_execute_immediate_m(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:word; _para5:PAnsiChar;
  1772. _para6:word; _para7:word; _para8:PAnsiChar; _para9:word; _para10:word;
  1773. _para11:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1774. function isc_dsql_exec_immed3_m(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:word; _para5:PAnsiChar;
  1775. _para6:word; _para7:word; _para8:PAnsiChar; _para9:word; _para10:word;
  1776. _para11:PAnsiChar; _para12:word; _para13:PAnsiChar; _para14:word; _para15:word;
  1777. _para16:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1778. function isc_dsql_fetch_m(_para1:PISC_STATUS; _para2:Pisc_stmt_handle; _para3:word; _para4:PAnsiChar; _para5:word;
  1779. _para6:word; _para7:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1780. function isc_dsql_insert_m(_para1:PISC_STATUS; _para2:Pisc_stmt_handle; _para3:word; _para4:PAnsiChar; _para5:word;
  1781. _para6:word; _para7:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1782. function isc_dsql_prepare_m(_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:Pisc_stmt_handle; _para4:word; _para5:PAnsiChar;
  1783. _para6:word; _para7:word; _para8:PAnsiChar; _para9:word; _para10:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1784. function isc_dsql_release(_para1:PISC_STATUS; _para2:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1785. function isc_embed_dsql_close(_para1:PISC_STATUS; _para2:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1786. function isc_embed_dsql_declare(_para1:PISC_STATUS; _para2:PAnsiChar; _para3:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1787. function isc_embed_dsql_describe(_para1:PISC_STATUS; _para2:PAnsiChar; _para3:word; _para4:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1788. function isc_embed_dsql_describe_bind(_para1:PISC_STATUS; _para2:PAnsiChar; _para3:word; _para4:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1789. function isc_embed_dsql_execute(_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:PAnsiChar; _para4:word; _para5:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1790. function isc_embed_dsql_execute2(_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:PAnsiChar; _para4:word; _para5:PXSQLDA;
  1791. _para6:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1792. function isc_embed_dsql_execute_immed(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:word; _para5:PAnsiChar;
  1793. _para6:word; _para7:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1794. function isc_embed_dsql_fetch(_para1:PISC_STATUS; _para2:PAnsiChar; _para3:word; _para4:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1795. function isc_embed_dsql_open(_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:PAnsiChar; _para4:word; _para5:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1796. function isc_embed_dsql_open2(_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:PAnsiChar; _para4:word; _para5:PXSQLDA;
  1797. _para6:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1798. function isc_embed_dsql_insert(_para1:PISC_STATUS; _para2:PAnsiChar; _para3:word; _para4:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1799. function isc_embed_dsql_prepare(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:PAnsiChar; _para5:word;
  1800. _para6:PAnsiChar; _para7:word; _para8:PXSQLDA):ISC_STATUS; extdecl; external gdslib;
  1801. function isc_embed_dsql_release(_para1:PISC_STATUS; _para2:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1802. { }
  1803. { Other Blob functions }
  1804. { }
  1805. function BLOB_open(_para1:isc_blob_handle; _para2:PAnsiChar; _para3:longint):PBSTREAM; extdecl; external gdslib;
  1806. function BLOB_put(_para1:AnsiChar; _para2:PBSTREAM):longint; extdecl; external gdslib;
  1807. function BLOB_close(_para1:PBSTREAM):longint; extdecl; external gdslib;
  1808. function BLOB_get(_para1:PBSTREAM):longint; extdecl; external gdslib;
  1809. function BLOB_display(_para1:PISC_QUAD; _para2:isc_db_handle; _para3:isc_tr_handle; _para4:PAnsiChar):longint; extdecl; external gdslib;
  1810. function BLOB_dump(_para1:PISC_QUAD; _para2:isc_db_handle; _para3:isc_tr_handle; _para4:PAnsiChar):longint; extdecl; external gdslib;
  1811. function BLOB_edit(_para1:PISC_QUAD; _para2:isc_db_handle; _para3:isc_tr_handle; _para4:PAnsiChar):longint; extdecl; external gdslib;
  1812. function BLOB_load(_para1:PISC_QUAD; _para2:isc_db_handle; _para3:isc_tr_handle; _para4:PAnsiChar):longint; extdecl; external gdslib;
  1813. function BLOB_text_dump(_para1:PISC_QUAD; _para2:isc_db_handle; _para3:isc_tr_handle; _para4:PAnsiChar):longint; extdecl; external gdslib;
  1814. function BLOB_text_load(_para1:PISC_QUAD; _para2:isc_db_handle; _para3:isc_tr_handle; _para4:PAnsiChar):longint; extdecl; external gdslib;
  1815. function Bopen(_para1:PISC_QUAD; _para2:isc_db_handle; _para3:isc_tr_handle; _para4:PAnsiChar):PBSTREAM; extdecl; external gdslib;
  1816. {$IFDEF Unix}
  1817. function Bopen2(_para1:PISC_QUAD; _para2:isc_db_handle; _para3:isc_tr_handle; _para4:PAnsiChar; _para5:word):PBSTREAM; extdecl; external gdslib;
  1818. {$ENDIF}
  1819. { }
  1820. { Other Misc functions }
  1821. { }
  1822. function isc_ftof(_para1:PAnsiChar; _para2:word; _para3:PAnsiChar; _para4:word):ISC_LONG; extdecl; external gdslib;
  1823. function isc_print_blr(_para1:PAnsiChar; _para2:isc_callback; _para3:pointer; _para4:smallint):ISC_STATUS; extdecl; external gdslib;
  1824. procedure isc_set_debug(_para1:longint); extdecl; external gdslib;
  1825. procedure isc_qtoq(_para1:PISC_QUAD; _para2:PISC_QUAD); extdecl; external gdslib;
  1826. procedure isc_vtof(_para1:PAnsiChar; _para2:PAnsiChar; _para3:word); extdecl; external gdslib;
  1827. procedure isc_vtov(_para1:PAnsiChar; _para2:PAnsiChar; _para3:smallint); extdecl; external gdslib;
  1828. function isc_version(_para1:Pisc_db_handle; _para2:isc_callback; _para3:pointer):longint; extdecl; external gdslib;
  1829. {$IFDEF Unix}
  1830. function isc_reset_fpe(_para1:word):ISC_LONG; extdecl; external gdslib;
  1831. {$ENDIF}
  1832. { }
  1833. { Service manager functions }
  1834. { }
  1835. (*!!MVC
  1836. #define ADD_SPB_LENGTH(p, length) { (p)++ = (length); \
  1837. (p)++ = (length) >> 8;}
  1838. #define ADD_SPB_NUMERIC(p, data) { (p)++ = (data); \
  1839. (p)++ = (data) >> 8; \
  1840. (p)++ = (data) >> 16; \
  1841. (p)++ = (data) >> 24;}
  1842. !!MVC *)
  1843. function isc_service_attach(_para1:PISC_STATUS; _para2:word; _para3:PAnsiChar; _para4:Pisc_svc_handle; _para5:word;
  1844. _para6:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1845. function isc_service_detach(_para1:PISC_STATUS; _para2:Pisc_svc_handle):ISC_STATUS; extdecl; external gdslib;
  1846. function isc_service_query(_para1:PISC_STATUS; _para2:Pisc_svc_handle; _para3:Pisc_resv_handle; _para4:word; _para5:PAnsiChar;
  1847. _para6:word; _para7:PAnsiChar; _para8:word; _para9:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1848. function isc_service_start(_para1:PISC_STATUS; _para2:Pisc_svc_handle; _para3:Pisc_resv_handle; _para4:word; _para5:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1849. { }
  1850. { Shutdown and cancel }
  1851. { }
  1852. // Available in Firebird 2.5+
  1853. function fb_shutdown(_para1: UINT; _para2: integer): int; extdecl; external gdslib;
  1854. // Available in Firebird 2.5+
  1855. //function fb_shutdown_callback{!!!3 unknown typedef}: ISC_EXPORT{ISC_STATUS}{<= !!!4 unknown type};
  1856. // Available in Firebird 2.5+
  1857. //function fb_cancel_operation{!!!3 unknown typedef}: ISC_EXPORT{ISC_STATUS}{<= !!!4 unknown type};
  1858. { }
  1859. { Forms functions }
  1860. { }
  1861. {$IFDEF Unix}
  1862. function isc_compile_map(_para1:PISC_STATUS; _para2:Pisc_form_handle; _para3:Pisc_req_handle; _para4:Psmallint; _para5:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1863. function isc_compile_menu(_para1:PISC_STATUS; _para2:Pisc_form_handle; _para3:Pisc_req_handle; _para4:Psmallint; _para5:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1864. function isc_compile_sub_map(_para1:PISC_STATUS; _para2:Pisc_win_handle; _para3:Pisc_req_handle; _para4:Psmallint; _para5:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1865. function isc_create_window(_para1:PISC_STATUS; _para2:Pisc_win_handle; _para3:Psmallint; _para4:PAnsiChar; _para5:Psmallint;
  1866. _para6:Psmallint):ISC_STATUS; extdecl; external gdslib;
  1867. function isc_delete_window(_para1:PISC_STATUS; _para2:Pisc_win_handle):ISC_STATUS; extdecl; external gdslib;
  1868. function isc_drive_form(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Pisc_win_handle; _para5:Pisc_req_handle;
  1869. _para6:Pbyte; _para7:Pbyte):ISC_STATUS; extdecl; external gdslib;
  1870. function isc_drive_menu(_para1:PISC_STATUS; _para2:Pisc_win_handle; _para3:Pisc_req_handle; _para4:Psmallint; _para5:PAnsiChar;
  1871. _para6:Psmallint; _para7:PAnsiChar; _para8:Psmallint; _para9:Psmallint; _para10:PAnsiChar;
  1872. _para11:PISC_LONG):ISC_STATUS; extdecl; external gdslib;
  1873. function isc_form_delete(_para1:PISC_STATUS; _para2:Pisc_form_handle):ISC_STATUS; extdecl; external gdslib;
  1874. function isc_form_fetch(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Pisc_req_handle; _para5:Pbyte):ISC_STATUS; extdecl; external gdslib;
  1875. function isc_form_insert(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Pisc_req_handle; _para5:Pbyte):ISC_STATUS; extdecl; external gdslib;
  1876. function isc_get_entree(_para1:PISC_STATUS; _para2:Pisc_req_handle; _para3:Psmallint; _para4:PAnsiChar; _para5:PISC_LONG;
  1877. _para6:Psmallint):ISC_STATUS; extdecl; external gdslib;
  1878. function isc_initialize_menu(_para1:PISC_STATUS; _para2:Pisc_req_handle):ISC_STATUS; extdecl; external gdslib;
  1879. function isc_menu(_para1:PISC_STATUS; _para2:Pisc_win_handle; _para3:Pisc_req_handle; _para4:Psmallint; _para5:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1880. function isc_load_form(_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Pisc_form_handle; _para5:Psmallint;
  1881. _para6:PAnsiChar):ISC_STATUS; extdecl; external gdslib;
  1882. function isc_pop_window(_para1:PISC_STATUS; _para2:Pisc_win_handle):ISC_STATUS; extdecl; external gdslib;
  1883. function isc_put_entree(_para1:PISC_STATUS; _para2:Pisc_req_handle; _para3:Psmallint; _para4:PAnsiChar; _para5:PISC_LONG):ISC_STATUS; extdecl; external gdslib;
  1884. function isc_reset_form(_para1:PISC_STATUS; _para2:Pisc_req_handle):ISC_STATUS; extdecl; external gdslib;
  1885. function isc_suspend_window(_para1:PISC_STATUS; _para2:Pisc_win_handle):ISC_STATUS; extdecl; external gdslib;
  1886. {$ENDIF}
  1887. // Available in Firebird 2.5+
  1888. function fb_shutdown:int; extdecl; external gdslib;
  1889. // Available in Firebird 2.5+
  1890. function fb_sqlstate:ISC_STATUS; extdecl;external gdslib;
  1891. function isc_attach_database:ISC_STATUS; extdecl; external gdslib;
  1892. function isc_array_gen_sdl:ISC_STATUS; extdecl; external gdslib;
  1893. function isc_array_get_slice:ISC_STATUS; extdecl; external gdslib;
  1894. function isc_array_lookup_bounds:ISC_STATUS; extdecl; external gdslib;
  1895. function isc_array_lookup_desc:ISC_STATUS; extdecl; external gdslib;
  1896. function isc_array_set_desc:ISC_STATUS; extdecl; external gdslib;
  1897. function isc_array_put_slice:ISC_STATUS; extdecl; external gdslib;
  1898. function isc_blob_gen_bpb:ISC_STATUS; extdecl; external gdslib;
  1899. function isc_blob_info:ISC_STATUS; extdecl; external gdslib;
  1900. function isc_blob_lookup_desc:ISC_STATUS; extdecl; external gdslib;
  1901. function isc_blob_set_desc:ISC_STATUS; extdecl; external gdslib;
  1902. function isc_cancel_blob:ISC_STATUS; extdecl; external gdslib;
  1903. function isc_cancel_events:ISC_STATUS; extdecl; external gdslib;
  1904. function isc_close_blob:ISC_STATUS; extdecl; external gdslib;
  1905. function isc_commit_retaining:ISC_STATUS; extdecl; external gdslib;
  1906. function isc_commit_transaction:ISC_STATUS; extdecl; external gdslib;
  1907. function isc_compile_request:ISC_STATUS; extdecl; external gdslib;
  1908. function isc_compile_request2:ISC_STATUS; extdecl; external gdslib;
  1909. function isc_create_blob:ISC_STATUS; extdecl; external gdslib;
  1910. function isc_create_blob2:ISC_STATUS; extdecl; external gdslib;
  1911. function isc_create_database:ISC_STATUS; extdecl; external gdslib;
  1912. function isc_database_info:ISC_STATUS; extdecl; external gdslib;
  1913. function isc_ddl:ISC_STATUS; extdecl; external gdslib;
  1914. procedure isc_decode_date; extdecl; external gdslib;
  1915. procedure isc_decode_sql_date; extdecl; external gdslib;
  1916. procedure isc_decode_sql_time; extdecl; external gdslib;
  1917. procedure isc_decode_timestamp; extdecl; external gdslib;
  1918. function isc_detach_database:ISC_STATUS; extdecl; external gdslib;
  1919. function isc_drop_database:ISC_STATUS; extdecl; external gdslib;
  1920. procedure isc_encode_date; extdecl; external gdslib;
  1921. procedure isc_encode_sql_date; extdecl; external gdslib;
  1922. procedure isc_encode_sql_time; extdecl; external gdslib;
  1923. procedure isc_encode_timestamp; extdecl; external gdslib;
  1924. function isc_event_block:ISC_LONG; cdecl; external gdslib;
  1925. procedure isc_event_counts; extdecl; external gdslib;
  1926. procedure isc_expand_dpb; cdecl; external gdslib;
  1927. function isc_modify_dpb:longint; extdecl; external gdslib;
  1928. function isc_free:ISC_LONG; extdecl; external gdslib;
  1929. function isc_get_segment:ISC_STATUS; extdecl; external gdslib;
  1930. function isc_get_slice:ISC_STATUS; extdecl; external gdslib;
  1931. function isc_interprete:ISC_STATUS; extdecl; external gdslib;
  1932. function isc_open_blob:ISC_STATUS; extdecl; external gdslib;
  1933. function isc_open_blob2:ISC_STATUS; extdecl; external gdslib;
  1934. function isc_prepare_transaction:ISC_STATUS; extdecl; external gdslib;
  1935. function isc_prepare_transaction2:ISC_STATUS; extdecl; external gdslib;
  1936. procedure isc_print_sqlerror; extdecl; external gdslib;
  1937. function isc_print_status:ISC_STATUS; extdecl; external gdslib;
  1938. function isc_put_segment:ISC_STATUS; extdecl; external gdslib;
  1939. function isc_put_slice:ISC_STATUS; extdecl; external gdslib;
  1940. function isc_que_events:ISC_STATUS; extdecl; external gdslib;
  1941. function isc_receive:ISC_STATUS; extdecl; external gdslib;
  1942. function isc_reconnect_transaction:ISC_STATUS; extdecl; external gdslib;
  1943. function isc_release_request:ISC_STATUS; extdecl; external gdslib;
  1944. function isc_request_info:ISC_STATUS; extdecl; external gdslib;
  1945. {$IFDEF Unix}
  1946. function isc_reset_fpe:ISC_LONG; extdecl; external gdslib;
  1947. {$ENDIF}
  1948. function isc_rollback_transaction:ISC_STATUS; extdecl; external gdslib;
  1949. function isc_rollback_retaining:ISC_STATUS; extdecl; external gdslib;
  1950. function isc_seek_blob:ISC_STATUS; extdecl; external gdslib;
  1951. function isc_send:ISC_STATUS; extdecl; external gdslib;
  1952. function isc_service_attach:ISC_STATUS; extdecl; external gdslib;
  1953. function isc_service_detach:ISC_STATUS; extdecl; external gdslib;
  1954. function isc_service_query:ISC_STATUS; extdecl; external gdslib;
  1955. function isc_service_start:ISC_STATUS; extdecl; external gdslib;
  1956. function isc_start_and_send:ISC_STATUS; extdecl; external gdslib;
  1957. function isc_start_multiple:ISC_STATUS; extdecl; external gdslib;
  1958. function isc_start_request:ISC_STATUS; extdecl; external gdslib;
  1959. function isc_start_transaction:ISC_STATUS; cdecl; external gdslib;
  1960. function isc_sqlcode:ISC_LONG; extdecl; external gdslib;
  1961. function isc_transaction_info:ISC_STATUS; extdecl; external gdslib;
  1962. function isc_transact_request:ISC_STATUS; extdecl; external gdslib;
  1963. function isc_unwind_request:ISC_STATUS; extdecl; external gdslib;
  1964. function isc_wait_for_event:ISC_STATUS; extdecl; external gdslib;
  1965. function isc_ftof:ISC_LONG; extdecl; external gdslib;
  1966. function isc_print_blr:ISC_STATUS; extdecl; external gdslib;
  1967. procedure isc_set_debug; extdecl; external gdslib;
  1968. procedure isc_qtoq; extdecl; external gdslib;
  1969. function isc_vax_integer:ISC_LONG; extdecl; external gdslib;
  1970. procedure isc_vtof; extdecl; external gdslib;
  1971. procedure isc_vtov; extdecl; external gdslib;
  1972. function isc_version:longint; extdecl; external gdslib;
  1973. { }
  1974. { Blob functions }
  1975. { }
  1976. function Bopen:PBSTREAM; extdecl; external gdslib;
  1977. function BLOB_open:PBSTREAM; extdecl; external gdslib;
  1978. {$IFDEF Unix}
  1979. function Bopen2:PBSTREAM; extdecl; external gdslib;
  1980. {$ENDIF}
  1981. {$ELSE} // LinkDynamically
  1982. var
  1983. { }
  1984. { OSRI database functions }
  1985. { }
  1986. isc_attach_database : function (_para1:PISC_STATUS; _para2:smallint; _para3:PAnsiChar; _para4:Pisc_db_handle; _para5:smallint;_para6:PAnsiChar):ISC_STATUS; extdecl;
  1987. isc_array_gen_sdl : function (_para1:PISC_STATUS; _para2:PISC_ARRAY_DESC; _para3:Psmallint; _para4:PAnsiChar; _para5:Psmallint):ISC_STATUS; extdecl;
  1988. isc_array_get_slice : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:PISC_QUAD; _para5:PISC_ARRAY_DESC;_para6:pointer; _para7:PISC_LONG):ISC_STATUS; extdecl;
  1989. isc_array_lookup_bounds : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:PAnsiChar; _para5:PAnsiChar;_para6:PISC_ARRAY_DESC):ISC_STATUS; extdecl;
  1990. isc_array_lookup_desc : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:PAnsiChar; _para5:PAnsiChar;_para6:PISC_ARRAY_DESC):ISC_STATUS; extdecl;
  1991. isc_array_set_desc : function (_para1:PISC_STATUS; _para2:PAnsiChar; _para3:PAnsiChar; _para4:Psmallint; _para5:Psmallint;_para6:Psmallint; _para7:PISC_ARRAY_DESC):ISC_STATUS; extdecl;
  1992. isc_array_put_slice : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:PISC_QUAD; _para5:PISC_ARRAY_DESC;_para6:pointer; _para7:PISC_LONG):ISC_STATUS; extdecl;
  1993. isc_blob_default_desc : procedure (_para1:PISC_BLOB_DESC; _para2:Pbyte; _para3:Pbyte); extdecl;
  1994. isc_blob_gen_bpb : function (_para1:PISC_STATUS; _para2:PISC_BLOB_DESC; _para3:PISC_BLOB_DESC; _para4:word; _para5:Pbyte;_para6:Pword):ISC_STATUS; extdecl;
  1995. isc_blob_info : function (_para1:PISC_STATUS; _para2:Pisc_blob_handle; _para3:smallint; _para4:PAnsiChar; _para5:smallint;_para6:PAnsiChar):ISC_STATUS; extdecl;
  1996. isc_blob_lookup_desc : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Pbyte; _para5:Pbyte;_para6:PISC_BLOB_DESC; _para7:Pbyte):ISC_STATUS; extdecl;
  1997. isc_blob_set_desc : function (_para1:PISC_STATUS; _para2:Pbyte; _para3:Pbyte; _para4:smallint; _para5:smallint;_para6:smallint; _para7:PISC_BLOB_DESC):ISC_STATUS; extdecl;
  1998. isc_cancel_blob : function (_para1:PISC_STATUS; _para2:Pisc_blob_handle):ISC_STATUS; extdecl;
  1999. isc_cancel_events : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:PISC_LONG):ISC_STATUS; extdecl;
  2000. isc_close_blob : function (_para1:PISC_STATUS; _para2:Pisc_blob_handle):ISC_STATUS; extdecl;
  2001. isc_commit_retaining : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle):ISC_STATUS; extdecl;
  2002. isc_commit_transaction : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle):ISC_STATUS; extdecl;
  2003. isc_create_blob : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Pisc_blob_handle; _para5:PISC_QUAD):ISC_STATUS; extdecl;
  2004. isc_create_blob2 : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Pisc_blob_handle; _para5:PISC_QUAD;_para6:smallint; _para7:PAnsiChar):ISC_STATUS; extdecl;
  2005. isc_create_database : function (_para1:PISC_STATUS; _para2:smallint; _para3:PAnsiChar; _para4:Pisc_db_handle; _para5:smallint;_para6:PAnsiChar; _para7:smallint):ISC_STATUS; extdecl;
  2006. isc_database_info : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:smallint; _para4:PAnsiChar; _para5:smallint;_para6:PAnsiChar):ISC_STATUS; extdecl;
  2007. isc_decode_date : procedure (_para1:PISC_QUAD; _para2:pointer); extdecl;
  2008. isc_decode_sql_date : procedure (_para1:PISC_DATE; _para2:pointer); extdecl;
  2009. isc_decode_sql_time : procedure (_para1:PISC_TIME; _para2:pointer); extdecl;
  2010. isc_decode_timestamp : procedure (_para1:PISC_TIMESTAMP; _para2:pointer); extdecl;
  2011. isc_detach_database : function (_para1:PISC_STATUS; _para2:Pisc_db_handle):ISC_STATUS; extdecl;
  2012. isc_drop_database : function (_para1:PISC_STATUS; _para2:Pisc_db_handle):ISC_STATUS; extdecl;
  2013. isc_dsql_allocate_statement : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_stmt_handle):ISC_STATUS; extdecl;
  2014. isc_dsql_alloc_statement2 : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_stmt_handle):ISC_STATUS; extdecl;
  2015. isc_dsql_describe : function (_para1:PISC_STATUS; _para2:Pisc_stmt_handle; _para3:word; _para4:PXSQLDA):ISC_STATUS; extdecl;
  2016. isc_dsql_describe_bind : function (_para1:PISC_STATUS; _para2:Pisc_stmt_handle; _para3:word; _para4:PXSQLDA):ISC_STATUS; extdecl;
  2017. isc_dsql_exec_immed2 : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:word; _para5:PAnsiChar;_para6:word; _para7:PXSQLDA; _para8:PXSQLDA):ISC_STATUS; extdecl;
  2018. isc_dsql_execute : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:Pisc_stmt_handle; _para4:word; _para5:PXSQLDA):ISC_STATUS; extdecl;
  2019. isc_dsql_execute2 : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:Pisc_stmt_handle; _para4:word; _para5:PXSQLDA;_para6:PXSQLDA):ISC_STATUS; extdecl;
  2020. isc_dsql_execute_immediate : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:word; _para5:PAnsiChar;_para6:word; _para7:PXSQLDA):ISC_STATUS; extdecl;
  2021. isc_dsql_fetch : function (_para1:PISC_STATUS; _para2:Pisc_stmt_handle; _para3:word; _para4:PXSQLDA):ISC_STATUS; extdecl;
  2022. isc_dsql_finish : function (_para1:Pisc_db_handle):ISC_STATUS; extdecl;
  2023. isc_dsql_free_statement : function (_para1:PISC_STATUS; _para2:Pisc_stmt_handle; _para3:word):ISC_STATUS; extdecl;
  2024. isc_dsql_insert : function (_para1:PISC_STATUS; _para2:Pisc_stmt_handle; _para3:word; _para4:PXSQLDA):ISC_STATUS; extdecl;
  2025. isc_dsql_prepare : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:Pisc_stmt_handle; _para4:word; _para5:PAnsiChar;_para6:word; _para7:PXSQLDA):ISC_STATUS; extdecl;
  2026. isc_dsql_set_cursor_name : function (_para1:PISC_STATUS; _para2:Pisc_stmt_handle; _para3:PAnsiChar; _para4:word):ISC_STATUS; extdecl;
  2027. isc_dsql_sql_info : function (_para1:PISC_STATUS; _para2:Pisc_stmt_handle; _para3:smallint; _para4:PAnsiChar; _para5:smallint;_para6:PAnsiChar):ISC_STATUS; extdecl;
  2028. isc_encode_date : procedure (_para1:pointer; _para2:PISC_QUAD); extdecl;
  2029. isc_encode_sql_date : procedure (_para1:pointer; _para2:PISC_DATE); extdecl;
  2030. isc_encode_sql_time : procedure (_para1:pointer; _para2:PISC_TIME); extdecl;
  2031. isc_encode_timestamp : procedure (_para1:pointer; _para2:PISC_TIMESTAMP); extdecl;
  2032. isc_event_block : function (_para1:PPAnsiChar; _para2:PPAnsiChar; _para3:word; args:array of const):ISC_LONG; cdecl;
  2033. isc_event_counts: procedure (_para1: PISC_STATUS; _para2: short; _para3: PAnsiChar; _para4: PAnsiChar); extdecl;
  2034. isc_expand_dpb : procedure (_para1:PPAnsiChar; _para2:Psmallint; args:array of const); cdecl;
  2035. isc_modify_dpb : function (_para1:PPAnsiChar; _para2:Psmallint; _para3:word; _para4:PAnsiChar; _para5:smallint):longint; extdecl;
  2036. isc_free : function (_para1:PAnsiChar):ISC_LONG; extdecl;
  2037. isc_get_segment : function (_para1:PISC_STATUS; _para2:Pisc_blob_handle; _para3:Pword; _para4:word; _para5:PAnsiChar):ISC_STATUS; extdecl;
  2038. isc_get_slice : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:PISC_QUAD; _para5:smallint;_para6:PAnsiChar; _para7:smallint; _para8:PISC_LONG; _para9:ISC_LONG; _para10:pointer;_para11:PISC_LONG):ISC_STATUS; extdecl;
  2039. isc_interprete : function (_para1:PAnsiChar; _para2:PPISC_STATUS):ISC_STATUS; extdecl;
  2040. isc_open_blob : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Pisc_blob_handle; _para5:PISC_QUAD):ISC_STATUS; extdecl;
  2041. isc_open_blob2 : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Pisc_blob_handle; _para5:PISC_QUAD;_para6:smallint; _para7:PAnsiChar):ISC_STATUS; extdecl;
  2042. isc_prepare_transaction2 : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:smallint; _para4:PAnsiChar):ISC_STATUS; extdecl;
  2043. isc_print_sqlerror : procedure (_para1:smallint; _para2:PISC_STATUS); extdecl;
  2044. isc_print_status : function (_para1:PISC_STATUS):ISC_STATUS; extdecl;
  2045. isc_put_segment : function (_para1:PISC_STATUS; _para2:Pisc_blob_handle; _para3:word; _para4:PAnsiChar):ISC_STATUS; extdecl;
  2046. isc_put_slice : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:PISC_QUAD; _para5:smallint;_para6:PAnsiChar; _para7:smallint; _para8:PISC_LONG; _para9:ISC_LONG; _para10:pointer):ISC_STATUS; extdecl;
  2047. isc_que_events : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:PISC_LONG; _para4:smallint; _para5:PAnsiChar;_para6:isc_callback; _para7:pointer):ISC_STATUS; extdecl;
  2048. isc_rollback_retaining : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle):ISC_STATUS; extdecl;
  2049. isc_rollback_transaction : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle):ISC_STATUS; extdecl;
  2050. isc_start_multiple : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:smallint; _para4:pointer):ISC_STATUS; extdecl;
  2051. isc_start_transaction : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:smallint; args:array of const):ISC_STATUS; cdecl;
  2052. isc_sqlcode : function (_para1:PISC_STATUS):ISC_LONG; extdecl;
  2053. // Available in Firebird 2.5+
  2054. fb_sqlstate : function(_para1: PAnsiChar;_para2:PISC_STATUS):ISC_STATUS; extdecl;
  2055. isc_sql_interprete : procedure (_para1:smallint; _para2:PAnsiChar; _para3:smallint); extdecl;
  2056. isc_transaction_info : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:smallint; _para4:PAnsiChar; _para5:smallint;_para6:PAnsiChar):ISC_STATUS; extdecl;
  2057. isc_transact_request : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:word; _para5:PAnsiChar;_para6:word; _para7:PAnsiChar; _para8:word; _para9:PAnsiChar):ISC_STATUS; extdecl;
  2058. isc_vax_integer : function (_para1:PAnsiChar; _para2:smallint):ISC_LONG; extdecl;
  2059. isc_portable_integer : function (_para1:Pbyte; _para2:smallint):ISC_INT64; extdecl;
  2060. { }
  2061. { Security Functions }
  2062. { }
  2063. isc_add_user : function (_para1:PISC_STATUS; _para2:PUSER_SEC_DATA):longint; extdecl;
  2064. isc_delete_user : function (_para1:PISC_STATUS; _para2:PUSER_SEC_DATA):longint; extdecl;
  2065. isc_modify_user : function (_para1:PISC_STATUS; _para2:PUSER_SEC_DATA):longint; extdecl;
  2066. { }
  2067. { Other OSRI functions }
  2068. { }
  2069. isc_compile_request : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_req_handle; _para4:smallint; _para5:PAnsiChar):ISC_STATUS; extdecl;
  2070. isc_compile_request2 : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_req_handle; _para4:smallint; _para5:PAnsiChar):ISC_STATUS; extdecl;
  2071. isc_ddl : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:smallint; _para5:PAnsiChar):ISC_STATUS; extdecl;
  2072. isc_prepare_transaction : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle):ISC_STATUS; extdecl;
  2073. isc_receive : function (_para1:PISC_STATUS; _para2:Pisc_req_handle; _para3:smallint; _para4:smallint; _para5:pointer;_para6:smallint):ISC_STATUS; extdecl;
  2074. isc_reconnect_transaction : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:smallint; _para5:PAnsiChar):ISC_STATUS; extdecl;
  2075. isc_release_request : function (_para1:PISC_STATUS; _para2:Pisc_req_handle):ISC_STATUS; extdecl;
  2076. isc_request_info : function (_para1:PISC_STATUS; _para2:Pisc_req_handle; _para3:smallint; _para4:smallint; _para5:PAnsiChar;_para6:smallint; _para7:PAnsiChar):ISC_STATUS; extdecl;
  2077. isc_seek_blob : function (_para1:PISC_STATUS; _para2:Pisc_blob_handle; _para3:smallint; _para4:ISC_LONG; _para5:PISC_LONG):ISC_STATUS; extdecl;
  2078. isc_send : function (_para1:PISC_STATUS; _para2:Pisc_req_handle; _para3:smallint; _para4:smallint; _para5:pointer;_para6:smallint):ISC_STATUS; extdecl;
  2079. isc_start_and_send : function (_para1:PISC_STATUS; _para2:Pisc_req_handle; _para3:Pisc_tr_handle; _para4:smallint; _para5:smallint;_para6:pointer; _para7:smallint):ISC_STATUS; extdecl;
  2080. isc_start_request : function (_para1:PISC_STATUS; _para2:Pisc_req_handle; _para3:Pisc_tr_handle; _para4:smallint):ISC_STATUS; extdecl;
  2081. isc_unwind_request : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:smallint):ISC_STATUS; extdecl;
  2082. isc_wait_for_event : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:smallint; _para4:PAnsiChar; _para5:PAnsiChar):ISC_STATUS; extdecl;
  2083. { }
  2084. { Other Sql functions }
  2085. { }
  2086. isc_close : function (_para1:PISC_STATUS; _para2:PAnsiChar):ISC_STATUS; extdecl;
  2087. isc_declare : function (_para1:PISC_STATUS; _para2:PAnsiChar; _para3:PAnsiChar):ISC_STATUS; extdecl;
  2088. isc_describe : function (_para1:PISC_STATUS; _para2:PAnsiChar; _para3:PXSQLDA):ISC_STATUS; extdecl;
  2089. isc_describe_bind : function (_para1:PISC_STATUS; _para2:PAnsiChar; _para3:PXSQLDA):ISC_STATUS; extdecl;
  2090. isc_execute : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:PAnsiChar; _para4:PXSQLDA):ISC_STATUS; extdecl;
  2091. isc_execute_immediate : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Psmallint; _para5:PAnsiChar):ISC_STATUS; extdecl;
  2092. isc_fetch : function (_para1:PISC_STATUS; _para2:PAnsiChar; _para3:PXSQLDA):ISC_STATUS; extdecl;
  2093. isc_open : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:PAnsiChar; _para4:PXSQLDA):ISC_STATUS; extdecl;
  2094. isc_prepare : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:PAnsiChar; _para5:Psmallint;_para6:PAnsiChar; _para7:PXSQLDA):ISC_STATUS; extdecl;
  2095. { }
  2096. { Other Dynamic sql functions }
  2097. { }
  2098. isc_dsql_execute_m : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:Pisc_stmt_handle; _para4:word; _para5:PAnsiChar;_para6:word; _para7:word; _para8:PAnsiChar):ISC_STATUS; extdecl;
  2099. isc_dsql_execute2_m : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:Pisc_stmt_handle; _para4:word; _para5:PAnsiChar;_para6:word; _para7:word; _para8:PAnsiChar; _para9:word; _para10:PAnsiChar;_para11:word; _para12:word; _para13:PAnsiChar):ISC_STATUS; extdecl;
  2100. isc_dsql_execute_immediate_m : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:word; _para5:PAnsiChar;_para6:word; _para7:word; _para8:PAnsiChar; _para9:word; _para10:word;_para11:PAnsiChar):ISC_STATUS; extdecl;
  2101. isc_dsql_exec_immed3_m : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:word; _para5:PAnsiChar;_para6:word; _para7:word; _para8:PAnsiChar; _para9:word; _para10:word;_para11:PAnsiChar; _para12:word; _para13:PAnsiChar; _para14:word; _para15:word;_para16:PAnsiChar):ISC_STATUS; extdecl;
  2102. isc_dsql_fetch_m : function (_para1:PISC_STATUS; _para2:Pisc_stmt_handle; _para3:word; _para4:PAnsiChar; _para5:word;_para6:word; _para7:PAnsiChar):ISC_STATUS; extdecl;
  2103. isc_dsql_insert_m : function (_para1:PISC_STATUS; _para2:Pisc_stmt_handle; _para3:word; _para4:PAnsiChar; _para5:word;_para6:word; _para7:PAnsiChar):ISC_STATUS; extdecl;
  2104. isc_dsql_prepare_m : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:Pisc_stmt_handle; _para4:word; _para5:PAnsiChar;_para6:word; _para7:word; _para8:PAnsiChar; _para9:word; _para10:PAnsiChar):ISC_STATUS; extdecl;
  2105. isc_dsql_release : function (_para1:PISC_STATUS; _para2:PAnsiChar):ISC_STATUS; extdecl;
  2106. isc_embed_dsql_close : function (_para1:PISC_STATUS; _para2:PAnsiChar):ISC_STATUS; extdecl;
  2107. isc_embed_dsql_declare : function (_para1:PISC_STATUS; _para2:PAnsiChar; _para3:PAnsiChar):ISC_STATUS; extdecl;
  2108. isc_embed_dsql_describe : function (_para1:PISC_STATUS; _para2:PAnsiChar; _para3:word; _para4:PXSQLDA):ISC_STATUS; extdecl;
  2109. isc_embed_dsql_describe_bind : function (_para1:PISC_STATUS; _para2:PAnsiChar; _para3:word; _para4:PXSQLDA):ISC_STATUS; extdecl;
  2110. isc_embed_dsql_execute : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:PAnsiChar; _para4:word; _para5:PXSQLDA):ISC_STATUS; extdecl;
  2111. isc_embed_dsql_execute2 : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:PAnsiChar; _para4:word; _para5:PXSQLDA;_para6:PXSQLDA):ISC_STATUS; extdecl;
  2112. isc_embed_dsql_execute_immed : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:word; _para5:PAnsiChar;_para6:word; _para7:PXSQLDA):ISC_STATUS; extdecl;
  2113. isc_embed_dsql_fetch : function (_para1:PISC_STATUS; _para2:PAnsiChar; _para3:word; _para4:PXSQLDA):ISC_STATUS; extdecl;
  2114. isc_embed_dsql_open : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:PAnsiChar; _para4:word; _para5:PXSQLDA):ISC_STATUS; extdecl;
  2115. isc_embed_dsql_open2 : function (_para1:PISC_STATUS; _para2:Pisc_tr_handle; _para3:PAnsiChar; _para4:word; _para5:PXSQLDA;_para6:PXSQLDA):ISC_STATUS; extdecl;
  2116. isc_embed_dsql_insert : function (_para1:PISC_STATUS; _para2:PAnsiChar; _para3:word; _para4:PXSQLDA):ISC_STATUS; extdecl;
  2117. isc_embed_dsql_prepare : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:PAnsiChar; _para5:word;_para6:PAnsiChar; _para7:word; _para8:PXSQLDA):ISC_STATUS; extdecl;
  2118. isc_embed_dsql_release : function (_para1:PISC_STATUS; _para2:PAnsiChar):ISC_STATUS; extdecl;
  2119. { }
  2120. { Other Blob functions }
  2121. { }
  2122. BLOB_open : function (_para1:isc_blob_handle; _para2:PAnsiChar; _para3:longint):PBSTREAM; extdecl;
  2123. BLOB_put : function (_para1:AnsiChar; _para2:PBSTREAM):longint; extdecl;
  2124. BLOB_close : function (_para1:PBSTREAM):longint; extdecl;
  2125. BLOB_get : function (_para1:PBSTREAM):longint; extdecl;
  2126. BLOB_display : function (_para1:PISC_QUAD; _para2:isc_db_handle; _para3:isc_tr_handle; _para4:PAnsiChar):longint; extdecl;
  2127. BLOB_dump : function (_para1:PISC_QUAD; _para2:isc_db_handle; _para3:isc_tr_handle; _para4:PAnsiChar):longint; extdecl;
  2128. BLOB_edit : function (_para1:PISC_QUAD; _para2:isc_db_handle; _para3:isc_tr_handle; _para4:PAnsiChar):longint; extdecl;
  2129. BLOB_load : function (_para1:PISC_QUAD; _para2:isc_db_handle; _para3:isc_tr_handle; _para4:PAnsiChar):longint; extdecl;
  2130. BLOB_text_dump : function (_para1:PISC_QUAD; _para2:isc_db_handle; _para3:isc_tr_handle; _para4:PAnsiChar):longint; extdecl;
  2131. BLOB_text_load : function (_para1:PISC_QUAD; _para2:isc_db_handle; _para3:isc_tr_handle; _para4:PAnsiChar):longint; extdecl;
  2132. Bopen : function (_para1:PISC_QUAD; _para2:isc_db_handle; _para3:isc_tr_handle; _para4:PAnsiChar):PBSTREAM; extdecl;
  2133. {$IFDEF Unix}
  2134. Bopen2 : function (_para1:PISC_QUAD; _para2:isc_db_handle; _para3:isc_tr_handle; _para4:PAnsiChar; _para5:word):PBSTREAM; extdecl;
  2135. {$ENDIF}
  2136. { }
  2137. { Other Misc functions }
  2138. { }
  2139. isc_ftof : function (_para1:PAnsiChar; _para2:word; _para3:PAnsiChar; _para4:word):ISC_LONG; extdecl;
  2140. isc_print_blr : function (_para1:PAnsiChar; _para2:isc_callback; _para3:pointer; _para4:smallint):ISC_STATUS; extdecl;
  2141. isc_set_debug : procedure (_para1:longint); extdecl;
  2142. isc_qtoq : procedure (_para1:PISC_QUAD; _para2:PISC_QUAD); extdecl;
  2143. isc_vtof : procedure (_para1:PAnsiChar; _para2:PAnsiChar; _para3:word); extdecl;
  2144. isc_vtov : procedure (_para1:PAnsiChar; _para2:PAnsiChar; _para3:smallint); extdecl;
  2145. isc_version : function (_para1:Pisc_db_handle; _para2:isc_callback; _para3:pointer):longint; extdecl;
  2146. {$IFDEF Unix}
  2147. isc_reset_fpe : function (_para1:word):ISC_LONG; extdecl;
  2148. {$ENDIF}
  2149. { }
  2150. { Service manager functions }
  2151. { }
  2152. (*!!MVC
  2153. #define ADD_SPB_LENGTH(p, length) { (p)++ = (length); \
  2154. (p)++ = (length) >> 8;}
  2155. #define ADD_SPB_NUMERIC(p, data) { (p)++ = (data); \
  2156. (p)++ = (data) >> 8; \
  2157. (p)++ = (data) >> 16; \
  2158. (p)++ = (data) >> 24;}
  2159. !!MVC *)
  2160. isc_service_attach : function (_para1:PISC_STATUS; _para2:word; _para3:PAnsiChar; _para4:Pisc_svc_handle; _para5:word;_para6:PAnsiChar):ISC_STATUS; extdecl;
  2161. isc_service_detach : function (_para1:PISC_STATUS; _para2:Pisc_svc_handle):ISC_STATUS; extdecl;
  2162. isc_service_query : function (_para1:PISC_STATUS; _para2:Pisc_svc_handle; _para3:Pisc_resv_handle; _para4:word; _para5:PAnsiChar;_para6:word; _para7:PAnsiChar; _para8:word; _para9:PAnsiChar):ISC_STATUS; extdecl;
  2163. isc_service_start : function (_para1:PISC_STATUS; _para2:Pisc_svc_handle; _para3:Pisc_resv_handle; _para4:word; _para5:PAnsiChar):ISC_STATUS; extdecl;
  2164. { }
  2165. { Shutdown and cancel }
  2166. { }
  2167. // Available in Firebird 2.5+
  2168. fb_shutdown : function(_para1: UINT; _para2: integer):int; extdecl;
  2169. { }
  2170. { Forms functions }
  2171. { }
  2172. {$IFDEF Unix}
  2173. isc_compile_map : function (_para1:PISC_STATUS; _para2:Pisc_form_handle; _para3:Pisc_req_handle; _para4:Psmallint; _para5:PAnsiChar):ISC_STATUS; extdecl;
  2174. isc_compile_menu : function (_para1:PISC_STATUS; _para2:Pisc_form_handle; _para3:Pisc_req_handle; _para4:Psmallint; _para5:PAnsiChar):ISC_STATUS; extdecl;
  2175. isc_compile_sub_map : function (_para1:PISC_STATUS; _para2:Pisc_win_handle; _para3:Pisc_req_handle; _para4:Psmallint; _para5:PAnsiChar):ISC_STATUS; extdecl;
  2176. isc_create_window : function (_para1:PISC_STATUS; _para2:Pisc_win_handle; _para3:Psmallint; _para4:PAnsiChar; _para5:Psmallint;_para6:Psmallint):ISC_STATUS; extdecl;
  2177. isc_delete_window : function (_para1:PISC_STATUS; _para2:Pisc_win_handle):ISC_STATUS; extdecl;
  2178. isc_drive_form : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Pisc_win_handle; _para5:Pisc_req_handle;_para6:Pbyte; _para7:Pbyte):ISC_STATUS; extdecl;
  2179. isc_drive_menu : function (_para1:PISC_STATUS; _para2:Pisc_win_handle; _para3:Pisc_req_handle; _para4:Psmallint; _para5:PAnsiChar;_para6:Psmallint; _para7:PAnsiChar; _para8:Psmallint; _para9:Psmallint; _para10:PAnsiChar;_para11:PISC_LONG):ISC_STATUS; extdecl;
  2180. isc_form_delete : function (_para1:PISC_STATUS; _para2:Pisc_form_handle):ISC_STATUS; extdecl;
  2181. isc_form_fetch : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Pisc_req_handle; _para5:Pbyte):ISC_STATUS; extdecl;
  2182. isc_form_insert : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Pisc_req_handle; _para5:Pbyte):ISC_STATUS; extdecl;
  2183. isc_get_entree : function (_para1:PISC_STATUS; _para2:Pisc_req_handle; _para3:Psmallint; _para4:PAnsiChar; _para5:PISC_LONG;_para6:Psmallint):ISC_STATUS; extdecl;
  2184. isc_initialize_menu : function (_para1:PISC_STATUS; _para2:Pisc_req_handle):ISC_STATUS; extdecl;
  2185. isc_menu : function (_para1:PISC_STATUS; _para2:Pisc_win_handle; _para3:Pisc_req_handle; _para4:Psmallint; _para5:PAnsiChar):ISC_STATUS; extdecl;
  2186. isc_load_form : function (_para1:PISC_STATUS; _para2:Pisc_db_handle; _para3:Pisc_tr_handle; _para4:Pisc_form_handle; _para5:Psmallint;_para6:PAnsiChar):ISC_STATUS; extdecl;
  2187. isc_pop_window : function (_para1:PISC_STATUS; _para2:Pisc_win_handle):ISC_STATUS; extdecl;
  2188. isc_put_entree : function (_para1:PISC_STATUS; _para2:Pisc_req_handle; _para3:Psmallint; _para4:PAnsiChar; _para5:PISC_LONG):ISC_STATUS; extdecl;
  2189. isc_reset_form : function (_para1:PISC_STATUS; _para2:Pisc_req_handle):ISC_STATUS; extdecl;
  2190. isc_suspend_window : function (_para1:PISC_STATUS; _para2:Pisc_win_handle):ISC_STATUS; extdecl;
  2191. {$ENDIF}
  2192. function InitialiseIBase60(Const LibraryName : AnsiString) : integer;
  2193. function InitialiseIBase60 : integer;
  2194. procedure ReleaseIBase60;
  2195. Function IBaseLibraryHandle : TLibHandle;
  2196. Function IBaseLoadedLibrary : AnsiString;
  2197. {$ENDIF}
  2198. implementation
  2199. {$IFDEF LinkDynamically}
  2200. ResourceString
  2201. SErrEmbeddedFailed = 'Can not load embedded Firebird client "%s". Check your installation.';
  2202. SErrDefaultsFailed = 'Can not load default Firebird clients ("%s" or "%s" or "%s"). Check your installation.';
  2203. SErrLoadFailed = 'Can not load Firebird client library "%s". Check your installation.';
  2204. SErrAlreadyLoaded = 'Firebird interface already initialized from library %s.';
  2205. var
  2206. RefCount : integer;
  2207. LoadedLibrary : AnsiString;
  2208. LibHandle : TLibHandle;
  2209. Function IBaseLibraryHandle : TLibHandle;
  2210. begin
  2211. result:=LibHandle;
  2212. end;
  2213. Function IBaseLoadedLibrary : AnsiString;
  2214. begin
  2215. Result:=LoadedLibrary;
  2216. end;
  2217. Function TryInitialiseIBase60(Const LibraryName : AnsiString) : integer;
  2218. begin
  2219. Result := 0;
  2220. if (RefCount=0) then
  2221. begin
  2222. LibHandle:=LoadLibrary(LibraryName);
  2223. if (LibHandle=nilhandle) then
  2224. Exit;
  2225. inc(RefCount);
  2226. LoadedLibrary:=LibraryName;
  2227. // Available in Firebird 2.5+
  2228. pointer(fb_shutdown) := GetProcedureAddress(IBaseLibraryHandle,'fb_shutdown');
  2229. // Available in Firebird 2.5+
  2230. pointer(fb_sqlstate) := GetProcedureAddress(IBaseLibraryHandle,'fb_sqlstate');
  2231. pointer(isc_attach_database) := GetProcedureAddress(IBaseLibraryHandle,'isc_attach_database');
  2232. pointer(isc_array_gen_sdl) := GetProcedureAddress(IBaseLibraryHandle,'isc_array_gen_sdl');
  2233. pointer(isc_array_get_slice) := GetProcedureAddress(IBaseLibraryHandle,'isc_array_get_slice');
  2234. pointer(isc_array_lookup_bounds) := GetProcedureAddress(IBaseLibraryHandle,'isc_array_lookup_bounds');
  2235. pointer(isc_array_lookup_desc) := GetProcedureAddress(IBaseLibraryHandle,'isc_array_lookup_desc');
  2236. pointer(isc_array_set_desc) := GetProcedureAddress(IBaseLibraryHandle,'isc_array_set_desc');
  2237. pointer(isc_array_put_slice) := GetProcedureAddress(IBaseLibraryHandle,'isc_array_put_slice');
  2238. pointer(isc_blob_default_desc) := GetProcedureAddress(IBaseLibraryHandle,'isc_blob_default_desc');
  2239. pointer(isc_blob_gen_bpb) := GetProcedureAddress(IBaseLibraryHandle,'isc_blob_gen_bpb');
  2240. pointer(isc_blob_info) := GetProcedureAddress(IBaseLibraryHandle,'isc_blob_info');
  2241. pointer(isc_blob_lookup_desc) := GetProcedureAddress(IBaseLibraryHandle,'isc_blob_lookup_desc');
  2242. pointer(isc_blob_set_desc) := GetProcedureAddress(IBaseLibraryHandle,'isc_blob_set_desc');
  2243. pointer(isc_cancel_blob) := GetProcedureAddress(IBaseLibraryHandle,'isc_cancel_blob');
  2244. pointer(isc_cancel_events) := GetProcedureAddress(IBaseLibraryHandle,'isc_cancel_events');
  2245. pointer(isc_close_blob) := GetProcedureAddress(IBaseLibraryHandle,'isc_close_blob');
  2246. pointer(isc_commit_retaining) := GetProcedureAddress(IBaseLibraryHandle,'isc_commit_retaining');
  2247. pointer(isc_commit_transaction) := GetProcedureAddress(IBaseLibraryHandle,'isc_commit_transaction');
  2248. pointer(isc_create_blob) := GetProcedureAddress(IBaseLibraryHandle,'isc_create_blob');
  2249. pointer(isc_create_blob2) := GetProcedureAddress(IBaseLibraryHandle,'isc_create_blob2');
  2250. pointer(isc_create_database) := GetProcedureAddress(IBaseLibraryHandle,'isc_create_database');
  2251. pointer(isc_database_info) := GetProcedureAddress(IBaseLibraryHandle,'isc_database_info');
  2252. pointer(isc_decode_date) := GetProcedureAddress(IBaseLibraryHandle,'isc_decode_date');
  2253. pointer(isc_decode_sql_date) := GetProcedureAddress(IBaseLibraryHandle,'isc_decode_sql_date');
  2254. pointer(isc_decode_sql_time) := GetProcedureAddress(IBaseLibraryHandle,'isc_decode_sql_time');
  2255. pointer(isc_decode_timestamp) := GetProcedureAddress(IBaseLibraryHandle,'isc_decode_timestamp');
  2256. pointer(isc_detach_database) := GetProcedureAddress(IBaseLibraryHandle,'isc_detach_database');
  2257. pointer(isc_drop_database) := GetProcedureAddress(IBaseLibraryHandle,'isc_drop_database');
  2258. pointer(isc_dsql_allocate_statement) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_allocate_statement');
  2259. pointer(isc_dsql_alloc_statement2) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_alloc_statement2');
  2260. pointer(isc_dsql_describe) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_describe');
  2261. pointer(isc_dsql_describe_bind) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_describe_bind');
  2262. pointer(isc_dsql_exec_immed2) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_exec_immed2');
  2263. pointer(isc_dsql_execute) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_execute');
  2264. pointer(isc_dsql_execute2) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_execute2');
  2265. pointer(isc_dsql_execute_immediate) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_execute_immediate');
  2266. pointer(isc_dsql_fetch) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_fetch');
  2267. pointer(isc_dsql_finish) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_finish');
  2268. pointer(isc_dsql_free_statement) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_free_statement');
  2269. pointer(isc_dsql_insert) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_insert');
  2270. pointer(isc_dsql_prepare) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_prepare');
  2271. pointer(isc_dsql_set_cursor_name) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_set_cursor_name');
  2272. pointer(isc_dsql_sql_info) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_sql_info');
  2273. pointer(isc_encode_date) := GetProcedureAddress(IBaseLibraryHandle,'isc_encode_date');
  2274. pointer(isc_encode_sql_date) := GetProcedureAddress(IBaseLibraryHandle,'isc_encode_sql_date');
  2275. pointer(isc_encode_sql_time) := GetProcedureAddress(IBaseLibraryHandle,'isc_encode_sql_time');
  2276. pointer(isc_encode_timestamp) := GetProcedureAddress(IBaseLibraryHandle,'isc_encode_timestamp');
  2277. pointer(isc_event_block) := GetProcedureAddress(IBaseLibraryHandle,'isc_event_block');
  2278. pointer(isc_event_counts) := GetProcedureAddress(IBaseLibraryHandle,'isc_event_counts');
  2279. pointer(isc_expand_dpb) := GetProcedureAddress(IBaseLibraryHandle,'isc_expand_dpb');
  2280. pointer(isc_modify_dpb) := GetProcedureAddress(IBaseLibraryHandle,'isc_modify_dpb');
  2281. pointer(isc_free) := GetProcedureAddress(IBaseLibraryHandle,'isc_free');
  2282. pointer(isc_get_segment) := GetProcedureAddress(IBaseLibraryHandle,'isc_get_segment');
  2283. pointer(isc_get_slice) := GetProcedureAddress(IBaseLibraryHandle,'isc_get_slice');
  2284. pointer(isc_interprete) := GetProcedureAddress(IBaseLibraryHandle,'isc_interprete');
  2285. pointer(isc_open_blob) := GetProcedureAddress(IBaseLibraryHandle,'isc_open_blob');
  2286. pointer(isc_open_blob2) := GetProcedureAddress(IBaseLibraryHandle,'isc_open_blob2');
  2287. pointer(isc_prepare_transaction2) := GetProcedureAddress(IBaseLibraryHandle,'isc_prepare_transaction2');
  2288. pointer(isc_print_sqlerror) := GetProcedureAddress(IBaseLibraryHandle,'isc_print_sqlerror');
  2289. pointer(isc_print_status) := GetProcedureAddress(IBaseLibraryHandle,'isc_print_status');
  2290. pointer(isc_put_segment) := GetProcedureAddress(IBaseLibraryHandle,'isc_put_segment');
  2291. pointer(isc_put_slice) := GetProcedureAddress(IBaseLibraryHandle,'isc_put_slice');
  2292. pointer(isc_que_events) := GetProcedureAddress(IBaseLibraryHandle,'isc_que_events');
  2293. pointer(isc_rollback_retaining) := GetProcedureAddress(IBaseLibraryHandle,'isc_rollback_retaining');
  2294. pointer(isc_rollback_transaction) := GetProcedureAddress(IBaseLibraryHandle,'isc_rollback_transaction');
  2295. pointer(isc_start_multiple) := GetProcedureAddress(IBaseLibraryHandle,'isc_start_multiple');
  2296. pointer(isc_start_transaction) := GetProcedureAddress(IBaseLibraryHandle,'isc_start_transaction');
  2297. pointer(isc_sqlcode) := GetProcedureAddress(IBaseLibraryHandle,'isc_sqlcode');
  2298. pointer(isc_sql_interprete) := GetProcedureAddress(IBaseLibraryHandle,'isc_sql_interprete');
  2299. pointer(isc_transaction_info) := GetProcedureAddress(IBaseLibraryHandle,'isc_transaction_info');
  2300. pointer(isc_transact_request) := GetProcedureAddress(IBaseLibraryHandle,'isc_transact_request');
  2301. pointer(isc_vax_integer) := GetProcedureAddress(IBaseLibraryHandle,'isc_vax_integer');
  2302. pointer(isc_portable_integer) := GetProcedureAddress(IBaseLibraryHandle,'isc_portable_integer');
  2303. pointer(isc_add_user) := GetProcedureAddress(IBaseLibraryHandle,'isc_add_user');
  2304. pointer(isc_delete_user) := GetProcedureAddress(IBaseLibraryHandle,'isc_delete_user');
  2305. pointer(isc_modify_user) := GetProcedureAddress(IBaseLibraryHandle,'isc_modify_user');
  2306. pointer(isc_compile_request) := GetProcedureAddress(IBaseLibraryHandle,'isc_compile_request');
  2307. pointer(isc_compile_request2) := GetProcedureAddress(IBaseLibraryHandle,'isc_compile_request2');
  2308. pointer(isc_ddl) := GetProcedureAddress(IBaseLibraryHandle,'isc_ddl');
  2309. pointer(isc_prepare_transaction) := GetProcedureAddress(IBaseLibraryHandle,'isc_prepare_transaction');
  2310. pointer(isc_receive) := GetProcedureAddress(IBaseLibraryHandle,'isc_receive');
  2311. pointer(isc_reconnect_transaction) := GetProcedureAddress(IBaseLibraryHandle,'isc_reconnect_transaction');
  2312. pointer(isc_release_request) := GetProcedureAddress(IBaseLibraryHandle,'isc_release_request');
  2313. pointer(isc_request_info) := GetProcedureAddress(IBaseLibraryHandle,'isc_request_info');
  2314. pointer(isc_seek_blob) := GetProcedureAddress(IBaseLibraryHandle,'isc_seek_blob');
  2315. pointer(isc_send) := GetProcedureAddress(IBaseLibraryHandle,'isc_send');
  2316. pointer(isc_start_and_send) := GetProcedureAddress(IBaseLibraryHandle,'isc_start_and_send');
  2317. pointer(isc_start_request) := GetProcedureAddress(IBaseLibraryHandle,'isc_start_request');
  2318. pointer(isc_unwind_request) := GetProcedureAddress(IBaseLibraryHandle,'isc_unwind_request');
  2319. pointer(isc_wait_for_event) := GetProcedureAddress(IBaseLibraryHandle,'isc_wait_for_event');
  2320. pointer(isc_close) := GetProcedureAddress(IBaseLibraryHandle,'isc_close');
  2321. pointer(isc_declare) := GetProcedureAddress(IBaseLibraryHandle,'isc_declare');
  2322. pointer(isc_describe) := GetProcedureAddress(IBaseLibraryHandle,'isc_describe');
  2323. pointer(isc_describe_bind) := GetProcedureAddress(IBaseLibraryHandle,'isc_describe_bind');
  2324. pointer(isc_execute) := GetProcedureAddress(IBaseLibraryHandle,'isc_execute');
  2325. pointer(isc_execute_immediate) := GetProcedureAddress(IBaseLibraryHandle,'isc_execute_immediate');
  2326. pointer(isc_fetch) := GetProcedureAddress(IBaseLibraryHandle,'isc_fetch');
  2327. pointer(isc_open) := GetProcedureAddress(IBaseLibraryHandle,'isc_open');
  2328. pointer(isc_prepare) := GetProcedureAddress(IBaseLibraryHandle,'isc_prepare');
  2329. pointer(isc_dsql_execute_m) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_execute_m');
  2330. pointer(isc_dsql_execute2_m) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_execute2_m');
  2331. pointer(isc_dsql_execute_immediate_m) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_execute_immediate_m');
  2332. pointer(isc_dsql_exec_immed3_m) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_exec_immed3_m');
  2333. pointer(isc_dsql_fetch_m) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_fetch_m');
  2334. pointer(isc_dsql_insert_m) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_insert_m');
  2335. pointer(isc_dsql_prepare_m) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_prepare_m');
  2336. pointer(isc_dsql_release) := GetProcedureAddress(IBaseLibraryHandle,'isc_dsql_release');
  2337. pointer(isc_embed_dsql_close) := GetProcedureAddress(IBaseLibraryHandle,'isc_embed_dsql_close');
  2338. pointer(isc_embed_dsql_declare) := GetProcedureAddress(IBaseLibraryHandle,'isc_embed_dsql_declare');
  2339. pointer(isc_embed_dsql_describe) := GetProcedureAddress(IBaseLibraryHandle,'isc_embed_dsql_describe');
  2340. pointer(isc_embed_dsql_describe_bind) := GetProcedureAddress(IBaseLibraryHandle,'isc_embed_dsql_describe_bind');
  2341. pointer(isc_embed_dsql_execute) := GetProcedureAddress(IBaseLibraryHandle,'isc_embed_dsql_execute');
  2342. pointer(isc_embed_dsql_execute2) := GetProcedureAddress(IBaseLibraryHandle,'isc_embed_dsql_execute2');
  2343. pointer(isc_embed_dsql_execute_immed) := GetProcedureAddress(IBaseLibraryHandle,'isc_embed_dsql_execute_immed');
  2344. pointer(isc_embed_dsql_fetch) := GetProcedureAddress(IBaseLibraryHandle,'isc_embed_dsql_fetch');
  2345. pointer(isc_embed_dsql_open) := GetProcedureAddress(IBaseLibraryHandle,'isc_embed_dsql_open');
  2346. pointer(isc_embed_dsql_open2) := GetProcedureAddress(IBaseLibraryHandle,'isc_embed_dsql_open2');
  2347. pointer(isc_embed_dsql_insert) := GetProcedureAddress(IBaseLibraryHandle,'isc_embed_dsql_insert');
  2348. pointer(isc_embed_dsql_prepare) := GetProcedureAddress(IBaseLibraryHandle,'isc_embed_dsql_prepare');
  2349. pointer(isc_embed_dsql_release) := GetProcedureAddress(IBaseLibraryHandle,'isc_embed_dsql_release');
  2350. pointer(BLOB_open) := GetProcedureAddress(IBaseLibraryHandle,'BLOB_open');
  2351. pointer(BLOB_put) := GetProcedureAddress(IBaseLibraryHandle,'BLOB_put');
  2352. pointer(BLOB_close) := GetProcedureAddress(IBaseLibraryHandle,'BLOB_close');
  2353. pointer(BLOB_get) := GetProcedureAddress(IBaseLibraryHandle,'BLOB_get');
  2354. pointer(BLOB_display) := GetProcedureAddress(IBaseLibraryHandle,'BLOB_display');
  2355. pointer(BLOB_dump) := GetProcedureAddress(IBaseLibraryHandle,'BLOB_dump');
  2356. pointer(BLOB_edit) := GetProcedureAddress(IBaseLibraryHandle,'BLOB_edit');
  2357. pointer(BLOB_load) := GetProcedureAddress(IBaseLibraryHandle,'BLOB_load');
  2358. pointer(BLOB_text_dump) := GetProcedureAddress(IBaseLibraryHandle,'BLOB_text_dump');
  2359. pointer(BLOB_text_load) := GetProcedureAddress(IBaseLibraryHandle,'BLOB_text_load');
  2360. pointer(Bopen) := GetProcedureAddress(IBaseLibraryHandle,'Bopen');
  2361. {$IFDEF Unix}
  2362. pointer(Bopen2) := GetProcedureAddress(IBaseLibraryHandle,'Bopen2');
  2363. {$ENDIF}
  2364. pointer(isc_ftof) := GetProcedureAddress(IBaseLibraryHandle,'isc_ftof');
  2365. pointer(isc_print_blr) := GetProcedureAddress(IBaseLibraryHandle,'isc_print_blr');
  2366. pointer(isc_set_debug) := GetProcedureAddress(IBaseLibraryHandle,'isc_set_debug');
  2367. pointer(isc_qtoq) := GetProcedureAddress(IBaseLibraryHandle,'isc_qtoq');
  2368. pointer(isc_vtof) := GetProcedureAddress(IBaseLibraryHandle,'isc_vtof');
  2369. pointer(isc_vtov) := GetProcedureAddress(IBaseLibraryHandle,'isc_vtov');
  2370. pointer(isc_version) := GetProcedureAddress(IBaseLibraryHandle,'isc_version');
  2371. {$IFDEF Unix}
  2372. pointer(isc_reset_fpe) := GetProcedureAddress(IBaseLibraryHandle,'isc_reset_fpe');
  2373. {$ENDIF}
  2374. pointer(isc_service_attach) := GetProcedureAddress(IBaseLibraryHandle,'isc_service_attach');
  2375. pointer(isc_service_detach) := GetProcedureAddress(IBaseLibraryHandle,'isc_service_detach');
  2376. pointer(isc_service_query) := GetProcedureAddress(IBaseLibraryHandle,'isc_service_query');
  2377. pointer(isc_service_start) := GetProcedureAddress(IBaseLibraryHandle,'isc_service_start');
  2378. {$IFDEF Unix}
  2379. pointer(isc_compile_map) := GetProcedureAddress(IBaseLibraryHandle,'isc_compile_map');
  2380. pointer(isc_compile_menu) := GetProcedureAddress(IBaseLibraryHandle,'isc_compile_menu');
  2381. pointer(isc_compile_sub_map) := GetProcedureAddress(IBaseLibraryHandle,'isc_compile_sub_map');
  2382. pointer(isc_create_window) := GetProcedureAddress(IBaseLibraryHandle,'isc_create_window');
  2383. pointer(isc_delete_window) := GetProcedureAddress(IBaseLibraryHandle,'isc_delete_window');
  2384. pointer(isc_drive_form) := GetProcedureAddress(IBaseLibraryHandle,'isc_drive_form');
  2385. pointer(isc_drive_menu) := GetProcedureAddress(IBaseLibraryHandle,'isc_drive_menu');
  2386. pointer(isc_form_delete) := GetProcedureAddress(IBaseLibraryHandle,'isc_form_delete');
  2387. pointer(isc_form_fetch) := GetProcedureAddress(IBaseLibraryHandle,'isc_form_fetch');
  2388. pointer(isc_form_insert) := GetProcedureAddress(IBaseLibraryHandle,'isc_form_insert');
  2389. pointer(isc_get_entree) := GetProcedureAddress(IBaseLibraryHandle,'isc_get_entree');
  2390. pointer(isc_initialize_menu) := GetProcedureAddress(IBaseLibraryHandle,'isc_initialize_menu');
  2391. pointer(isc_menu) := GetProcedureAddress(IBaseLibraryHandle,'isc_menu');
  2392. pointer(isc_load_form) := GetProcedureAddress(IBaseLibraryHandle,'isc_load_form');
  2393. pointer(isc_pop_window) := GetProcedureAddress(IBaseLibraryHandle,'isc_pop_window');
  2394. pointer(isc_put_entree) := GetProcedureAddress(IBaseLibraryHandle,'isc_put_entree');
  2395. pointer(isc_reset_form) := GetProcedureAddress(IBaseLibraryHandle,'isc_reset_form');
  2396. pointer(isc_suspend_window) := GetProcedureAddress(IBaseLibraryHandle,'isc_suspend_window');
  2397. {$ENDIF}
  2398. end
  2399. else
  2400. inc(RefCount);
  2401. Result := RefCount;
  2402. end;
  2403. function InitialiseIBase60 : integer;
  2404. begin
  2405. Result := 0;
  2406. if (RefCount<>0) then
  2407. // pretend to load whatever is already loaded, so we do not get a library name conflict.
  2408. Inc(RefCount)
  2409. else If UseEmbeddedFirebird then
  2410. begin
  2411. If (TryInitialiseIBase60(fbembedlib)=0) and (TryInitialiseIBase60(libem)=0) then
  2412. Raise EInOutError.CreateFmt(SErrEmbeddedFailed,[fbembedlib]);
  2413. end
  2414. else
  2415. begin
  2416. If (TryInitialiseIBase60(fbembedlib)=0) and
  2417. (TryInitialiseIBase60(libem)=0) and
  2418. (TryInitialiseIBase60(fbclib)=0) and
  2419. (TryInitialiseIBase60(libfc)=0) and
  2420. (TryInitialiseIBase60(gdslib)=0) then
  2421. Raise EInOutError.CreateFmt(SErrDefaultsFailed,[fbclib,gdslib,fbembedlib]);
  2422. end;
  2423. Result := RefCount;
  2424. end;
  2425. function InitialiseIBase60(Const LibraryName : AnsiString) : integer;
  2426. begin
  2427. Result := TryInitialiseIBase60(LibraryName);
  2428. If Result = 0 then
  2429. Raise EInOutError.CreateFmt(SErrLoadFailed,[LibraryName])
  2430. else If (LibraryName<>IBaseLoadedLibrary) then
  2431. begin
  2432. Dec(RefCount);
  2433. Result := RefCount;
  2434. Raise EInOUtError.CreateFmt(SErrAlreadyLoaded,[IBaseLoadedLibrary]);
  2435. end;
  2436. end;
  2437. Procedure ReleaseIBase60;
  2438. begin
  2439. if RefCount>1 then
  2440. Dec(RefCount)
  2441. else
  2442. begin
  2443. // Shutdown embedded subsystem with timeout 300ms (Firebird 2.5+)
  2444. // Required before unloading library; has no effect on non-embedded client
  2445. if (pointer(fb_shutdown)<>nil) and (fb_shutdown(300,1)<>0) then
  2446. begin
  2447. //todo: log error; still try to unload library below as the timeout may have been insufficient
  2448. end;
  2449. if UnloadLibrary(LibHandle) then
  2450. begin
  2451. Dec(RefCount);
  2452. LibHandle := NilHandle;
  2453. LoadedLibrary:='';
  2454. end;
  2455. end;
  2456. end;
  2457. {$ENDIF}
  2458. function XSQLDA_LENGTH(n: Integer): Integer;
  2459. begin
  2460. Result := SizeOf(XSQLDA) + (n - 1) * SizeOf(XSQLVAR);
  2461. end;