Visual Basic 6.0 Example

From CometWiki

Latest revision as of 12:24, 24 May 2009

Cometlib -- The Open Interface to the Comet File System.

VB6.0 Sample.

This document will show you how to build a small VB program that:

• Establishes a connection with CFAM through CometLib.

• Erases and creates a keyed file.

• Writes some records to the file.

• Gets some information about the file such as first and last key.

• Reads some records from the file.

• Closes the file and terminates the connection with CometLib.

Comet MUST be running on the same computer as the Visual Basic program. The ONLY directories that are accessible are those designated as type C directories in the Comet INI file.

Here is a step-by-step guide that will get a sample program running on your own system.

• 1 Open Visual Basic 6.0
• 2 Click on New Project
• 3 Click on Standard EXE and click OK
• 4 You should get a small dialog grid on your screen.
• 5 Click on the menu item view, and click toolbox to bring up the control builder.
• 6 In the toolbox, click on Button.
• 7 On the dialog grid, drag your mouse to make a button in the center. By default it should be called Command1 when you let go of the mouse.
• 9 Double click on the button you created. You should see a window with code in it. In particular, you should see this:

Private Sub Command1_Click() 
End Sub 

• 10 Under the project menu, click References.
• 11 Scroll down and check “CometLib 1.0 Type Library”, and click OK.

Use the clipboard to copy the following code between the Private Sub line and the End Sub line.

Dim f As CometLib.CometFiles 
On Error GoTo CantInit 
Set f = New CometLib.CometFiles 
f.Initialize ("Hello") 
On Error Resume Next 
Dim lun As Integer 
Dim file As String 
Dim fdir As String 
Dim record As String 
Dim key As String 
Dim func As String 
Dim i As Integer 
Dim last As String 
Dim Output As String 
lun = 43 
file = "hello" 
fdir = "tmp" 
' Create the file 
f.Erase file, fdir 
If f.CreateKeyedFile(file, fdir, 65, 34) = False Then 
func = "Create " 
GoTo Bad 
End If 
f.Close (lun) 
If f.Open(lun, file, fdir) = False Then 
func = "Open " 
GoTo Bad 
End If 
' Build the file 
For i = 111 To 222 
f.WriteInit (lun) 
record = "Hello World, this is record " 
f.PutRecField lun, record, 0, 30 
f.PutRecField lun, i, 30, 5 
key = "** " & i 
f.Write lun, key 
Next i 
    ' Test the file -- get some info from it 
f.Position lun, "** 140" 
key = f.FirstKey(lun) 
Output = Output & "First key = " & key & vbNewLine 
key = f.NextKey(lun) 
Output = Output & "Next key = " & key & vbNewLine 
key = f.PrevKey(lun) 
Output = Output & "Prev key = " & key & vbNewLine 
key = f.LastKey(lun) 
Output = Output & "Last key = " & key & vbNewLine 
For i = 1 To 10 
key = f.NextKey(lun) 
If key = "" Then 
func = "Nextkey" 
GoTo Bad 
End If 
If f.ReadNext(lun) = False Then 
func = "Read " 
GoTo Bad 
End If 
record = f.GetRecField(lun, 0, 65) 
Output = Output & RTrim(key) & " -- " & RTrim(record) & vbNewLine 
Next i 
MsgBox (Output) 
On Error Resume Next ' No errors allowed here 
f.Close (lun) 
f.Terminate 
set f = Nothing 
End 
Bad: 
last = f.GetCometExcpString(f.LastCometError) 
MsgBox (func & "got func " & f.LastCometError & " -- " & last) 
End 
CantInit: 
If MsgBox("Error loading CometLib, make sure Comet is loaded and click Retry. Click Cancel to exit.", vbRetryCancel, "Is Comet Loaded?") = vbRetry Then Resume 
End 

That is the whole program.

On the Build Menu, select Build solution. This will compile the project.

Now, let’s go through this program in some finer detail.

The first two lines make a Comet File System object.

Dim f As CometLib.CometFiles 
Set f = New CometLib.CometFiles 

You only need one of these objects in your program. I just called the object f, but you could call it anything you want. From this point on, anything you want to do with the Comet File System, you proceed with “f.”. These two statements really belong outside of a click event. They really establish the connection to the object and this should happen when the application starts up. I put them inside of a click event for clarity only. The next line:

f.Initialize("Hello-World") 

Tells CometLib to actually make the connection with CFAM and uses the string “Hello-World” to identify this connection. Any short string of characters will do, but don’t use embedded blanks in the name.

Most of the code from here should be easy to decipher. If you use the object browser, you can see all of the methods that are available. We think it is rather complete.

Most methods return a Boolean. This may be used as an indication of a comet error. If the call is not placed in an if statement, the result is thrown away as in the erase call.

f.Erase file, fdir 

In this case I chose to ignore errors. The following create call

If f.CreateKeyedFile(file, fdir, 65, 34) = False Then 
excp = "Create " 
GoTo Bad 
End If

Will Goto the label “Bad:” if there were some sort of comet error on the create.

Other methods such as the key methods return strings.

key = f.FirstKey(lun) 
Output = Output & "First key = " & key & vbNewLine 
key = f.NextKey(lun) 
Output = Output & "Next key = " & key & vbNewLine 
key = f.PrevKey(lun) 
Output = Output & "Prev key = " & key & vbNewLine 
key = f.LastKey(lun) 
Output = Output & "Last key = " & key & vbNewLine 

If the string is empty, It may be assumed that the program has reached the end of file, or beginning of file, or there are no keys in the file depending on which method is called.

The last section to understand is how to properly shutdown the program. This is accomplished at the label “Done:”

Done: 

On Error Resume Next       ' No errors allowed here 
f.Close(lun) 
f.Terminate 
set f = Nothing 
End 

Here your program should close all open files, Terminate the CometLib connection and clear the value of the object. This code should be executed when your application ends.