Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Eric,
I created a standard exe project then I created a connection( ODBC to an Access database) in the dataenvironment of my main form. Then I created a command ( source is a table called DDA1 from an Access database). Then I drag couple of fields to my main form and I added a command button to advance to the next records :
Private Sub cmdNext_Click()
deEUC.rscmDDA1.MoveNext
End Sub
Then I added the following code to other command button :
Private Sub cmdUpdate_Click()
MsgBox deEUC.rscmDDA1.Fields("account_balance").Value
Do While Not deEUC.rscmDDA1.EOF
If deEUC.rscmDDA1.Fields("account_balance").Value > 50000 Then
deEUC.rscmDDA1.Fields("positive_negative").Value = "Positive"
End If
deEUC.rscmDDA1.MoveNext
Loop
End Sub
I run the form and I get the following error when I click on the cmdUpdate command button:
"Run-time error '3251'
The operation requested by the application is not supported by the provider"
I'm stuck!!!!!!
Thanks,
Sergio
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement