Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
autonumber / sequence / identity column problems (Read 2892 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
autonumber / sequence / identity column problems
01.06.06 at 10:00:53
Problems inserting into tables with autonumber / sequence / identity columns
SQL*XL user Kimmo from Finland asked the following question.
Inserting data using SQL*XL's multiple rows insert feature I got this error:  
"Value error in field INSPECTIONJOB_ID".  
This field is first and also key (autonumber) field so during insertion it must be empty.
Auto number or sequence columns should not be included when doing inserts. The database will assign a new number for you. You cannot include the column and leave it blank.
When running the multiple rows insert feature of SQL*XL, make sure you do not include any autonumber or sequence columns in the column list.
Back to top
« Last Edit: 06.12.08 at 13:56:44 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1