Visual Basic Notes
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:
a.
Create a class named Record.
b.
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
c.
Use iAsciiFlag = 1 and ispacing=0 to read data into an instance of Rec:
Dim instofRec As New Rec
d.
Use dot notation to access data:
instofRec.Name=”Jeff”
e.
Use the record class to handle all the instofRec data manipulation.