c-treeDB API for VB.Net

Transaction Processing

drivers\vb.nav\tutorials\Tutorial4.vb

Now we will discuss transaction processing as it relates to the c-treeDB .NET Visual Basic NAV Framework.

Transaction processing provides a safe method by which multiple database operations spread across separate tables/files are guaranteed to be atomic. By atomic, we mean that, within a transaction, either all of the operations succeed or none of the operations succeed. This "either all or none" atomicity ensures that the integrity of the data in related tables/files is secure.

Like all other examples in the c-tree tutorial series, this tutorial simplifies the creation and use of a database into four simple steps: Initialize(), Define(), Manage(), and You’re Done()!

Tutorial #4: Transaction Processing

Here we demonstrate transaction control.

• Initialize() - Connects to the FairCom Database Engine.
• Define() - Defines and creates our four tables/files.
• Manage() - Adds rows/records to multiple tables/files under transaction control.
• Done() - Disconnects from FairCom Database Engine.

Note our simple Main() function:

Imports System

Imports FairCom.CtreeDb

Module Tutorial4HL

Dim MySession As CTSession

Dim tableCustOrdr As CTTable

Dim tableOrdrItem As CTTable

Dim tableItemMast As CTTable

Dim tableCustMast As CTTable

Dim recordCustOrdr As CTRecord

Dim recordOrdrItem As CTRecord

Dim recordItemMast As CTRecord

Dim recordCustMast As CTRecord

'

' main()

'

' The main() function implements the concept of "init, define, manage

' and you're done..."

'

Sub Main()

Initialize()

Define()

Manage()

Done()

Console.WriteLine(ControlChars.NewLine + "Press <ENTER> key to exit . . .")

Console.ReadLine()

End Sub

In This Section Init Define Manage Done