/*
* The contents of this file are subject to the Interbase Public
* License Version 1.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy
* of the License at http://www.Inprise.com/IPL.html
*
* Software distributed under the License is distributed on an
* "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express
* or implied. See the License for the specific language governing
* rights and limitations under the License.
*
* The Original Code was created by Inprise Corporation
* and its predecessors. Portions created by Inprise Corporation are
* Copyright (C) Inprise Corporation.
*
* All Rights Reserved.
* Contributor(s): ______________________________________.
*/
The following example programs demonstrate a number of useful features of
the Firebird programming interface.
Note that the following environment variables need to be set before running
the examples:
ISC_USER - A valid username on the server.
ISC_PASSWORD - The password for the above user.
ISC_DATABASE - The path to the employee.gdb example database, including
server name. For example, to connect to the NT server
named "NTserver" via NetBEUI:
ISC_DATABASE=\\NTserver\c:\firebird\examples
This assumes that Firebird was installed to the
firebird directory on the c: drive.
In addition, a guest account should be created with the username "guest"
and password "guest" before running api15 and winevent.
Embedded Static SQL
Program Description
--------- ------------------------------------------------------------------
stat1.e Illustrates a simple update to an existing table, commit, rollback.
stat2.e Illustrates singleton select.
stat3.e Illustrates a simple cursor -- declare/open/close/fetch.
stat4.e Show 'declare table' and 'create table'.
stat5.e Demonstrate 'update where current of'.
stat6.e Select an array.
stat7.e Illustrate blob cursor for select.
stat8.e Illustrate blob cursor for insert.
stat9.e Execute and select from a stored procedure.
stat10.e Demonstrate 'set database', 'connect' and 'set transaction'.
stat11.e Demonstrate 'set transaction' with various isolation options.
stat12.e Event wait and signaling.
stat12t.e
WHENEVER SQLERROR and BASED_ON clause are illustrated by many programs.
^L
Embedded Dynamic SQL
Program Description
--------- ------------------------------------------------------------------
dyn1.e Execute 'create database' statement as a static string.
dyn2.e 'Execute immediate', and 'prepare' and 'execute'.
dyn3.e Dynamic cursor for select with output SQLDA allocated.
dyn4.e Execute an update query with parameter markers and input SQLDA.
dyn5.e Demonstrate dynamic reallocation of SQLDA and 'describe' statement.
dynfull.e A full_dsql program (process unknown statements).
VARY struct is used by dyn3.e, dynfull.e.
^L
API Interface
Program Description
--------- ------------------------------------------------------------------
api1.c Execute 'create dabatabase' statement as a static string.
Demonstrates zero database handle.
api2.c 'Execute immediate', and 'prepare' and 'execute'.
api3.c Dynamic cursor for select with output SQLDA allocated.
api4.c Execute an update query with parameter markers and input SQLDA.
api5.c Demonstrate dynamic reallocation of SQLDA and 'describe' statement.
apifull.c A full_dsql program (process unknown statements).
Demonstrates stmt_info calls and numeric scale.
api6.c Assemble an update current of statement, based on a dynamic
cursor name. Free a statement handle and re-use it as the cursor.
api7.c Demonstrate blob_open, get_segment.
api8.c Demonstrate create_blob, put_segment.
api9.c Demonstrate blob_open2 (using blob filter).
api9f.c Filter for api9.c. (Not part of Windows 3.1 clients)
api10.c Update an array using get_slice/put_slice.
api11.c Execute and select from a stored procedure.
api12.c A program with several active transactions.
api13.c A multi-database transaction with 2-phase commit.
api14.e Combine the three programming styles in one program.
api15.c Construct a database parameter buffer. db_info calls.
api16.c Demonstrate asynchronous event trapping
(Not available on Windows 3.1 clients)
winevent.c Demonstrate asynchronous event trapping
(Replacement for api16.c on Windows 3.1 Client)
api16t.c Identical to stat12t, this triggers the event for api16.
VARY struct is used by api3.c, apifull.c, and api14.e.
SQLCODE extraction from status is covered by several programs.
Zero transaction handle is covered in several programs, ex. api14.e.
没有合适的资源?快使用搜索试试~ 我知道了~
firebird数据库&管理工具&delphi用数据库控件(支持firebird)
共232个文件
txt:93个
c:21个
e:20个
3星 · 超过75%的资源 需积分: 9 16 下载量 31 浏览量
2013-07-19
10:27:14
上传
评论
收藏 8.97MB RAR 举报
温馨提示
firebird数据库&管理工具&delphi用数据库控件(支持firebird)
资源推荐
资源详情
资源评论
收起资源包目录
firebird数据库&管理工具&delphi用数据库控件(支持firebird) (232个子文件)
make_stat.bat 3KB
make_api.bat 2KB
make_dyn.bat 2KB
setenvvar.bat 875B
clean_api.bat 319B
install_superclassic.bat 318B
install_super.bat 315B
install_classic.bat 303B
uninstall.bat 273B
clean_stat.bat 195B
clean_dyn.bat 191B
clean_all.bat 83B
make_all.bat 77B
make_udf.bat 67B
clean_udf.bat 63B
apifull.c 14KB
winevent.c 13KB
udflib.c 12KB
api12.c 11KB
api6.c 7KB
api9f.c 7KB
api15.c 7KB
api16.c 7KB
api10.c 6KB
api11.c 6KB
api13.c 6KB
api7.c 6KB
api16t.c 5KB
api9.c 5KB
api8.c 5KB
api2.c 5KB
api3.c 5KB
api4.c 5KB
api1.c 4KB
functions.c 4KB
api5.c 4KB
firebird.conf 27KB
fbintl.conf 7KB
fbtrace.conf 5KB
aliases.conf 133B
Firebird2Control.cpl 452KB
fbudf.cpp 20KB
ib_udf.cpp 9KB
stdafx.cpp 1KB
winevent.def 1KB
udflib.def 1KB
example.def 1001B
api9f.def 841B
icudt30.dll 1.5MB
fbintl.dll 900KB
icuuc30.dll 660KB
msvcr80.dll 612KB
fbclient.dll 540KB
msvcp80.dll 536KB
fbtrace.dll 424KB
icuin30.dll 408KB
fbrmclib.dll 84KB
fbudf.dll 13KB
ib_udf.dll 11KB
ib_util.dll 8KB
dynfull.e 10KB
api14.e 6KB
stat10.e 4KB
stat11.e 4KB
dyn4.e 4KB
dyn2.e 4KB
stat9.e 4KB
stat4.e 4KB
dyn3.e 3KB
stat8.e 3KB
stat12.e 3KB
dyn5.e 3KB
dyn1.e 3KB
stat5.e 3KB
stat6.e 3KB
stat7.e 3KB
stat3.e 3KB
stat1.e 2KB
stat12t.e 2KB
stat2.e 2KB
fb_inet_server.exe 3.64MB
fbserver.exe 3.61MB
gpre.exe 532KB
qli.exe 352KB
isql.exe 304KB
gbak.exe 300KB
gdef.exe 300KB
fb_lock_print.exe 260KB
gstat.exe 188KB
gsec.exe 188KB
nbackup.exe 168KB
gfix.exe 144KB
fbsvcmgr.exe 136KB
fbtracemgr.exe 128KB
instsvc.exe 100KB
fbguard.exe 96KB
instclient.exe 53KB
gsplit.exe 51KB
instreg.exe 47KB
EMPLOYEE.FDB 1.14MB
共 232 条
- 1
- 2
- 3
资源评论
- thanmail2014-01-19比较老的版本了,不用了
xiaogen1122
- 粉丝: 2
- 资源: 7
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功