:Base bde32.HLP :Title Borland Database Engine Online Reference :Link bdecfg32.hlp :Link datapump.hlp :Link localsql.hlp :Link sqllnk32.hlp 1 Introduction to Borland Database Engine 2 Introduction to Borland Database Engine=introduction>main 2 Features=features>main 2 BDE components=bdecomponents>main 2 Core BDE files=corebdefiles>main 2 Tools and examples=toolsandexamples>main 2 Initialization=initialization>main 2 Configuration management=configurationmanagement>main 1 What's New for BDE 5? 2 Overview of new features and enhancements=Whatsnewoverview>main 1 Basic concepts 2 Architectural overview=architecturaloverview>main 2 Shared services=sharedservices>main 2 BDE API functions=bdeapifunctions>main 2 BDE Objects 3 BDE objects=bdeobjects>main 3 System=system>main 3 Clients=clients>main 3 Sessions=sessions>main 3 Database drivers=databasedrivers>main 3 Databases=databases>main 3 Cursors=cursors>main 3 Query statements=querystatements>main 3 Object properties=objectproperties>main 2 Database entities 3 Database entities=databaseentities>main 3 Tables=tables>main 3 Indexes=indexes>main 3 Fields=fields>main 3 Queries=queries>main 3 Transactions=transactions>main 3 Callbacks=callbacks>main 3 Cross-database operations=crossdatabaseoperations>main 1 Application development 2 Introduction to BDE programming=introductiontobdeprogramming>main 2 Project setup=projectsetup>main 2 Basic procedure=basicprocedure>main 2 Improving BDE performance=improvingbdeperformance>main 2 The CHK function=chk>example 2 Template program=templateprogram>example 2 Accessing and updating tables 3 Accessing and updating tables=accessingandupdatingtables>main 3 Preparing to access a table=preparingtoaccessatable>main 3 Positioning the cursor and fetching records=positioningthecursorandfetchingrecords>main 3 Field-level access=fieldlevelaccess>main 3 Working with Blobs=workingwithblobs>main 3 Adding, updating, and deleting records=addingupdatinganddeletingrecords>main 3 Linking tables=linkingtables>main 3 Sorting tables=sortingtables>main 3 Cached updates=cachedupdates>main 2 Locking 3 Locking=locking>main 3 Session layer=sessionlayer>main 3 Database handle layer=databasehandlelayer>main 3 Table cursor layer=tablecursorlayer>main 3 Acquired locks=acquiredlocks>main 3 Table lock coexistence=tablelockcoexistence>main 3 Locking strategy=lockingstrategy>main 3 SQL-specific locking behavior=sqlspecificlockingbehavior>main 2 Transactions 3 SQL Transactions=sqltransactions>main 3 Transactions on Paradox, dBASE, FoxPro, and Access=transactionsonparadoxanddbase>main 3 Transactions and cached updates=transactionsandcachedupdates>main 3 Degree of transaction isolation=degreeoftransactionisolation>main 3 Using transactions=usingtransactions>main 2 Querying databases 3 Querying databases=queryingdatabases>main 3 Querying Paradox and dBASE tables=queryingparadoxanddbasetables>main 3 Querying different databases=queryingdifferentdatabases>main 3 Executing queries directly=executingqueriesdirectly>main 3 Executing queries in stages=Executingqueriesinstages>main 2 Getting and setting properties 3 Getting and setting properties=gettingandsettingproperties>main 3 Object properties=objectproperties>main 2 Retrieving schema and system information 3 Retrieving schema and system information=retrievingschemaandsysteminformation>main 3 DbiOpenList functions=dbiopenlistfunctions>main 3 DbiGetDescs functions=dbigetdescsfunctions>main 2 Creating tables 3 Creating tables=creatingtables>main 3 Integrity constraints=integrityconstraints>main 3 Modifying table structure=modifyingtablestructure>main 2 Using callbacks 3 Using callbacks=usingcallbacks>main 3 Data source independence=datasourceindependence>main 2 Filtering records 3 Filtering records=filteringrecords>main 3 Using an expression tree=usinganexpressiontree>main 3 Expression tree header=expressiontreeheader>main 3 Literal pool area=literalpoolarea>main 2 Database driver characteristics 3 Database driver characteristics=databasedrivercharacteristics>main 3 SQL drivers 4 Informix driver=informixdriver>main 4 DB2 driver=DB2driver>main 4 Sybase CT-Lib driver=sybasectlibdriver>main 4 Passthrough SQL=passthroughsql>main 4 SQL transaction control=sqltransactioncontrol>main 4 SQL connection=sqlconnection>main 4 SQL record caching=sqlrecordcaching>main 4 SQL record modification requirements=sqlrecordmodificationrequirements>main 4 SQL record modification behavior=sqlrecordmodificationbehavior>main 4 SQL record-locking behavior=sqlrecordlockingbehavior>main 4 SQL table-locking behavior=sqltablelockingbehavior>main 4 SQL asynchronous queries=sqlasynchronousqueries>main 4 SQL performance tips=sqlperformancetips>main 3 Standard drivers 4 Paradox driver=paradoxdriver>main 4 FoxPro driver=foxprodriver>main 3 Access driver 4 Access driver=accessdriver>main 3 Text driver 4 Text driver=textdriver>main 4 Field maps=fieldmaps>main 4 Binding external schema to text tables=bindingexternalschematotexttables>main 2 Error handling 3 Using DbiGetErrorEntry to access the error stack=usingdbigeterrorentrytoaccesstheerrorstack>main 3 Using DbiGetErrorString to get a detailed error message=usingdbigeterrorstringtogetadetailederrormessage>main 3 Using DbiGetErrorContext to get more specific information=usingdbigeterrorcontexttogetmorespecificinformation>main 3 Using DbiGetErrorInfo to get immediate information=usingdbigeterrorinfotogetimmediateinformation>main 2 Debugging 3 Using the debug layer=usingthedebuglayer>main 3 SQL Trace=sqltrace>main 1 Using the Function Reference 2 Using the function reference=usingthefunctionreference>main 2 Syntax conventions=syntaxconventions>main 2 Variable names=variablenames>main 2 Constants=constants>main 2 #Defines=defines>main 2 Typedefs=typedefs>main 2 Object definitions=objectdefinitions>main 2 Buffer typedefs=buffertypedefs>main 1 BDE Function Reference 2 Alphabetical list of all BDE functions=functionreferencealphabetical>main 2 Environment functions=environmentfunctions>main 2 Session functions=sessionfunctions>main 2 Error handling functions=errorhandlingfunctions>main 2 Locking functions=lockingfunctions>main 2 Cursor functions=cursorfunctions>main 2 Index functions=indexfunctions>main 2 Query functions=queryfunctions>main 2 Database functions=databasefunctions>main 2 Table functions=tablefunctions>main 2 Data access functions=dataaccessfunctions>main 2 Capability or schema functions=capabilityorschemafunctions>main 2 Date/Time/Number functions=datetimenumberfunctions>main 2 Transaction functions=transactionfunctions>main 1 Data Structures 2 Data structures: overview=datastructures>main 2 Callback definitions=callbackdefinitions>main 2 Paradox and dBASE physical types=paradoxanddbasephysicaltypes>main 2 Data type translations=datatypetranslations>main 2 Logical types and driver-specific physical types=logicaltypesanddriverspecificphysicaltypes>main 1 International compatibility 2 Character sets=charactersets>main 2 Sorting and uppercasing rules=sortinganduppercasingrules>main 2 Language drivers=languagedrivers>main 2 Date, time, and number formats=datetimeandnumberformats>main 1 Other Borland online guides 2 Borland SQL Links Guide=borlandsqllinks@sqllnk32.hlp>main 2 Borland Local SQL Guide=overview@localsql.hlp>main 2 BDE Configuration Utility Help=idh_idapi_configutil@bdecfg32.hlp>main