Insert data from table1 to table2 depending on user_id and record_id

So I need to insert some records from table1 to table2 depending on their user_id (PVKEY) and record_id (CNKEY). Just to explain better, every user has his own unique user_id (PVKEY) and every record has his own record_id (CNKEY). One user can have couple of records but everytime when the new record is added it needs to get new record_id (CNKEY) Everytime I try to insert I get message:

"Cannot insert the value NULL into column 'CNKEY', table 'Progress.dbo.CONTHIST'; column does not allow...

Insert data from table1 to table2 depending on user_id and record_id

from Databases http://ift.tt/24F1eiG
via IFTTT

Share :

Tweet

✚

Related Post

• Selecting Current Date Datahi, im not sure if this is a simple question but it makes me wonder. i have a field on my database
• ElectroCRUD - Young MySQL CRUD AppNo coding is required; Create basic CRUD (Create, Read, Update, Delete) for your MySQL Database in
• 2016 Updated RU webmasters and affiliates 60 000 Email/skype DatabaseAt the database: 60,000 email + skype Database update: 11 April 2016 Source: Large Russian affiliat
• Daily Registered Domain Name DatabaseIs anybody interested in a database of registered domain names daily? These domain names are separa
• Database design questionI have an app with the posibility for users to login( I created a table users, set the columns and
• MySQL CONCAT, HAVING and JOINhi can this be use all together? here is my query: SELECT CONCAT(fullname," ",address1," ",city,"