Unanswered: vb6 recordset update function for mkd database
I have created a recordset from Pervasive sql control center and a vb6 form. After that I have add a save button and typed this codes. LockType is BatchOptimistic and Cursor Location Use Client-side Cursor. I can see added records from datagrid when I push the save button. But when I close and reopen the form there isnt any record. It is not saving records to database(mkd file). There is no any error message. Thats very strange.
Is there anyone experienced a problem like that?
Private Sub cmdSave_Click()
.Fields("FIELD1") = Me.DataCombo1.Text
.Fields("FIELD1") = Me.Text1.Text
I have used DataEnvironment for connection. I looked to DataEnvironment settings for finding how can i see connection string but I cant find the string. If you want, I can send you the vb6 project.
Before I typed the dbforums forum, I changed my program codes to field1 for easy understand by forum users. But I have made a mistake during copy paste field1 to two field name. I forget to change second field name to field2. The two field names are different in the orjinal codes
In my quick test, I can't get the DataEvironment to update fields at all but I get errors.
I usually don't use the DataEnvironment preferring the control coding the connection and recordset code myself.
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.