Record duplication
Closed
mikeoe2003
Posts
24
Registration date
Thursday November 1, 2012
Status
Member
Last seen
March 27, 2014
-
Nov 1, 2012 at 05:11 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Nov 1, 2012 at 05:20 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Nov 1, 2012 at 05:20 AM
Related:
- Record duplication
- Messenger voice record downloader - Guide
- How to send voice record in messenger - Guide
- Record youtube live stream vlc - Guide
- How to record 60fps video on snapchat - Guide
- Offline patient record software free download - Download - Organisation and teamwork
2 responses
mikeoe2003
Posts
24
Registration date
Thursday November 1, 2012
Status
Member
Last seen
March 27, 2014
2
Nov 1, 2012 at 05:20 AM
Nov 1, 2012 at 05:20 AM
sorry guy i have spotted my mistake thanks
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Nov 1, 2012 at 05:20 AM
Nov 1, 2012 at 05:20 AM
Hi mikeoe2003,
If you notice, you have two instances of:
myCommand.ExecuteNonQuery()
Remove the last instance and the data will be entered only once.
Your original code:
myCommand.ExecuteNonQuery()
myCommand = New OleDbCommand(mySQLString, myConnection)
myCommand.ExecuteNonQuery()
Catch ex As Exception
Replace the above with:
myCommand.ExecuteNonQuery()
myCommand = New OleDbCommand(mySQLString, myConnection)
Catch ex As Exception
Please reply if you have any further questions.
If you notice, you have two instances of:
myCommand.ExecuteNonQuery()
Remove the last instance and the data will be entered only once.
Your original code:
myCommand.ExecuteNonQuery()
myCommand = New OleDbCommand(mySQLString, myConnection)
myCommand.ExecuteNonQuery()
Catch ex As Exception
Replace the above with:
myCommand.ExecuteNonQuery()
myCommand = New OleDbCommand(mySQLString, myConnection)
Catch ex As Exception
Please reply if you have any further questions.