TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Kumar AU
1.1k
320
63.2k
Read the XML and insert into SQL Table using stored procedur
Dec 13 2014 8:22 AM
Read the XML and insert into SQL Table using stored procedure If record already exist than do not insert - Only through Stored Procedure
My Query :- In this query it works only If the entire XML is parsed again, than it will not insert duplicate records , But If you change the 1 record out of 3 records in XML than it will insert all there records again, that means again duplicate records in table, Could any one please help me how can I avoid this problem.
looks like I need to traverse each records in XML using curser or forloop, please help me
Attachment:
updatedsqlquery2.zip
Reply
Answers (
0
)
How to use sqlite3_update_hook
problem in inserting multiple images to the database.