Icon View Incident Report

Serious Serious
Reported By: Vidya Sagar
Reported On: 8/14/2003
For: Version 3.24 Build 1
# 1413 ODBC Driver Not Updating Memo Data Correctly Using Visual Basic 6

I declared one variable as memo type, because the text may be larger, but when I save the data into table all other fields are showing up but the memo field is empty.

Dim dbisam As Connection
Dim constr As String

Sub opensam()
DBEngine.DefaultType = dbUseODBC
constr = "ODBC;Driver={DBISAM Database System};CatalogName=" & App.
Set dbisam = OpenConnection("", dbDriverNoPrompt, False, constr)
End Sub

Private Sub cmdexit_Click()
Set dbisam = Nothing
Unload Me
End Sub

Private Sub cmdinsert_Click()
On Error Resume Next
Dim rec As Recordset
Set rec = dbisam.OpenRecordset("emp", dbOpenDynamic, dbExecDirect, 
With rec
!Name = Text1.Text
!Desc = Text2.Text
End With
MsgBox "record inserted"
End Sub

Private Sub Form_Load()
End Sub

Comments Comments
ODBC reference material is a bit fuzzy on the cause of this problem, namely that the length of the incoming BLOB parameter data would be passed in via the indicator function parameter and not the octet length function parameter, which is what VB was doing.

Resolution Resolution
Fixed Problem on 8/25/2003 in version 3.25 build 1