ok will try sql method
Moderators: Dorian (MJT support), JRL
ok will try sql method
Well I will try the sql method then, thanks
-
Bob Hansen
- Automation Wizard
- Posts: 2475
- Joined: Tue Sep 24, 2002 3:47 am
- Location: Salem, New Hampshire, US
- Contact:
Hi mfauzim....
No need to make another thread on this same subject.
It is desired to keep all responses in the original subject when practical.
Re your problem, you may find that error is being by the database, not by the ODBC. If well designed, the database should prevent records from being added if they would create a duplicate key value. You may want to keep the error and use it to change the key value on the record you are trying to add.
No need to make another thread on this same subject.
It is desired to keep all responses in the original subject when practical.
Re your problem, you may find that error is being by the database, not by the ODBC. If well designed, the database should prevent records from being added if they would create a duplicate key value. You may want to keep the error and use it to change the key value on the record you are trying to add.
Hope this was helpful..................good luck,
Bob
A humble man and PROUD of it!
Bob
A humble man and PROUD of it!
Type error
Sorry , type error. Suposed to be on previous thread
