Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Write String with Comma doesn't work
Message
De
26/06/2000 02:58:06
 
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Divers
Thread ID:
00383549
Message ID:
00384518
Vues:
33
Thanks Eric for your help. It is my Table definition that was declared
30 Chars, and the input was about 32 Chars. Thank you once again. Cheers...

>>Anyone could help? I encountered "Error occurred" message when
>>trying to write a String of data with Comma in it into a table.
>>I recorded the error description as "Microsoft Cursor Engine".
>
>This is really curious. I just tried your code with the NWIND database, and it is working!!! Try it too!
>
>This error may have relation to your field definition. Are you sure that your field is long enough?
>
>
Option Explicit
>
>Private cnn1 As ADODB.Connection
>Private rsCust As ADODB.Recordset
>
>Private Sub Command1_Click()
>    rsCust.Open "Select * from employees", cnn1, adOpenKeyset, adLockOptimistic
>    Set DataGrid1.DataSource = rsCust
>    DataGrid1.Refresh
>End Sub
>
>Private Sub Command2_Click()
>    With rsCust
>        .AddNew
>        !LastName = "Moreau"
>        !FirstName = "Eric"
>        !Title = "Analyst, programmer"
>    End With
>End Sub
>
>Private Sub Form_Load()
>    Set cnn1 = New ADODB.Connection
>    Set rsCust = New ADODB.Recordset
>
>    cnn1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Projets VB\NWIND.mdb;Persist Security Info=False;"
>    cnn1.CursorLocation = adUseClient
>    cnn1.Open
>End Sub
>
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform