Click here to Skip to main content
15,610,690 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i have a table
in which i'm having a list of attributes

qId(primarykey),bid, fid(foreignkey) refering to pk),some other attributes

there is sequencer for qid.(which increments by 1)
Now i want to copy all the attribute based on bid.
wt i was doing is changing bid to new bid which solves half of my problem but im having sequencer for qid which is associated with trigger which inserts value on every insert. and due to this fid donot refer to new qid because i haven't updated it.
now i want to update that and link them to new qid generated by sequencer
thanks in advance
Savalia Manoj M 25-Jun-12 23:34pm    
Please explain your question with example.
coded007 25-Sep-13 8:07am    
Try to disabel the trigger and stop sequencer to update it
Herman<T>.Instance 27-Jun-12 5:53am    
based on the too less information it is not clear what your problem is. Please Improve your question.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900