accessing btreive .dat file via an activex dll (vb6)

I have a "legacy" product(vb6 .exe) that I maintain.  It uses btrieve data files for the database and uses
Declare Function BTRCALL Lib "w3btrv7.dll" (ByVal OP, ByVal pb$, Db As Any, DL As Integer, ByRef Kb As Any, ByVal Kl, ByVal Kn) As Integer
to access the data.  I have written an dll that updates some of my tables using sql calls and have ran into a problem.  One of my tables has a field in it that is defined as a string and has 48 characters in it.  In the vb code a custom type is defined and the 48 character string is placed into that type.  Within that type one of the items is defined as an integer so before the btrieve record is updated that integer is converted into part of the 48 character string with this code:
temp = temp & MKI$(TempPropOVR.OVRSummary(i).SUMMinMaxTotPlayers)

with that done I try to update the btreive(pervasive) table using a sql statement and the statement will fail because the characters converted into a string make it syntacticly incorrect or if it does pass syntax the results will not e useable once i read them back out of the record because it is written out as a string in sql and can't be converted back correctly.

My problem is that i have thus far been unable to put the same code that I use in my vb6 .exe into an activex dll and get it to work.   Has anyone used the btrieve functions to update btreive data files via a function called from a dll they have written?

Thanks in advance for any advice.

Howard
Start Free Trial