Hello,

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()
With DataEnvironment1.rsRECORDSET
.AddNew
.Fields("FIELD1") = Me.DataCombo1.Text
.Fields("FIELD1") = Me.Text1.Text
.Update
End With
End Sub

As posted elsewhere:

Hello Mirtheil,

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.

Thank you very much for your answers Mirtheil. I am sorry for my english.

Have a good day...