Special Notes on Visual Basic

The following are some things to be aware when you are developing Pervasive PSQL applications with Visual Basic.

Visual Basic has a known byte alignment issue with user-defined data types. You can also refer to the section Visual Basic regarding the Btrieve API for information about this issue and using the PAln32.DLL, Pervasive's Btrieve Alignment DLL.

Creating a record class for each type of resulting record will facilitate data access as indicated in the following steps:

Create a class named Record.

Create a structure defining the layout of your record:

Type Byte2 
  field1 byte 
  field2 byte 
End Type 
Type Rec 
  Size As Byte2 
  Name As String*30    `SQL Mask = x30 
  Salary As String*10  `SQL Mask = zzzzzzz.99 
End Type

Use iAsciiFlag = 1 and ispacing=0 to read data into an instance of Rec:

Dim instofRec As New Rec

Use dot notation to access data:

instofRec.Name="Jeff"

Use the record class to handle all the instofRec data manipulation.