Click here to Skip to main content
       

Database

 
Questionoracle error with winserver2008 Pinmemberfares35-Feb-13 1:03 
AnswerRe: oracle error with winserver2008 PinmemberBernhard Hiller5-Feb-13 4:57 
Questionchar(255) vs varchar(255) vs varchar(MAX) Pinmemberdevvvy1-Feb-13 18:22 
AnswerRe: char(255) vs varchar(255) vs varchar(MAX) PinmvpRichard MacCutchan1-Feb-13 23:07 
GeneralRe: char(255) vs varchar(255) vs varchar(MAX) [modified] Pinmemberdevvvy2-Feb-13 15:39 
AnswerRe: char(255) vs varchar(255) vs varchar(MAX) PinmemberPIEBALDconsult2-Feb-13 5:22 
GeneralRe: char(255) vs varchar(255) vs varchar(MAX) Pinmemberdevvvy2-Feb-13 23:30 
GeneralRe: char(255) vs varchar(255) vs varchar(MAX) Pinmemberjschell3-Feb-13 6:36 
QuestionSP Unexpected Behavior Pinmembereddieangel1-Feb-13 7:19 
QuestionEncrypt a field in the database. Pinmembervanikanc1-Feb-13 5:31 
AnswerRe: Encrypt a field in the database. PinmvpEddy Vluggen1-Feb-13 7:02 
Questioncheck before insert Pinmembervanikanc31-Jan-13 4:55 
AnswerRe: check before insert PinmvpEddy Vluggen31-Jan-13 5:00 
GeneralRe: check before insert PinmvpEddy Vluggen31-Jan-13 10:35 
Dude, if he is inserting from a file, then there is no primary key until it is inserted Hmmm | :|
 
--
 
Aah, good point. We don't show the Autoincrement-value to the user, so the user is using a combination of fields to uniquely identify a record. That used to be the primary-key, until we switched to artificial autoincrement-keys.
 
You're reading the file on a line to line basis? Don't want it in memory completely, because it'd have to be restarted completely if the process dies half way. It'd be an option to write the "current amount of processed records" to another file. If it crashes, read that file and see how many lines you can safely skip.
 
A transaction (as said below) is indeed the best idea Smile | :)
 
Also, it'd be wise to load the file in a separate table first, and move it from there to the required structure.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

AnswerRe: check before insert Pinmembermark merrens31-Jan-13 8:10 
GeneralRe: check before insert Pinmembervanikanc31-Jan-13 8:21 
GeneralRe: check before insert Pinmembermark merrens31-Jan-13 10:09 
GeneralRe: check before insert PinmemberChris Meech31-Jan-13 10:24 
GeneralRe: check before insert Pinmembermark merrens31-Jan-13 10:25 
AnswerRe: check before insert Pinmemberdjj551-Feb-13 7:50 
GeneralRe: check before insert Pinmembervanikanc1-Feb-13 7:55 
GeneralRe: check before insert Pinmemberdjj551-Feb-13 8:25 
QuestionIdentify DML changes between two databases PinmemberMember 313707830-Jan-13 20:56 
AnswerRe: Identify DML changes between two databases PinmemberMycroft Holmes30-Jan-13 21:11 
GeneralRe: Identify DML changes between two databases PinmemberMember 313707830-Jan-13 21:26 
QuestionUpdate a flag based on portion of data avialble in other column Pinmemberyuvachandra30-Jan-13 10:20 
AnswerRe: Update a flag based on portion of data avialble in other column PinmemberMycroft Holmes30-Jan-13 11:56 
GeneralRe: Update a flag based on portion of data avialble in other column Pinmemberyuvachandra31-Jan-13 6:08 
GeneralRe: Update a flag based on portion of data avialble in other column PinmemberMycroft Holmes31-Jan-13 11:32 
GeneralRe: Update a flag based on portion of data avialble in other column Pinmemberyuvachandra31-Jan-13 11:45 
GeneralRe: Update a flag based on portion of data avialble in other column Pinmemberyuvachandra1-Feb-13 7:00 
Questionhow to comlex databinding with access database PinmemberAchilles8430-Jan-13 8:48 
AnswerRe: how to comlex databinding with access database PinmemberMycroft Holmes30-Jan-13 11:49 
GeneralRe: how to comlex databinding with access database PinmemberAchilles8430-Jan-13 20:49 
GeneralRe: how to comlex databinding with access database PinmemberMycroft Holmes30-Jan-13 21:06 
GeneralRe: how to comlex databinding with access database PinmemberAchilles841-Feb-13 0:25 
QuestionEnd Case in a Variable Pinmemberberba30-Jan-13 8:47 
AnswerRe: End Case in a Variable PinmemberMycroft Holmes30-Jan-13 11:46 
GeneralRe: End Case in a Variable Pinmemberberba30-Jan-13 18:02 
GeneralRe: End Case in a Variable PinmemberMycroft Holmes30-Jan-13 20:57 
QuestionWhat happens with auto-incremented value on rollback? Pinmemberpiticcotoc29-Jan-13 23:27 
AnswerRe: What happens with auto-incremented value on rollback? PinmemberJörgen Andersson30-Jan-13 1:04 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpiticcotoc30-Jan-13 3:02 
GeneralRe: What happens with auto-incremented value on rollback? Pinmembermark merrens30-Jan-13 5:33 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpiticcotoc30-Jan-13 5:43 
GeneralRe: What happens with auto-incremented value on rollback? PinmemberSimon_Whale30-Jan-13 5:49 
GeneralRe: What happens with auto-incremented value on rollback? Pinmembermark merrens30-Jan-13 5:55 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpiticcotoc30-Jan-13 21:43 
AnswerRe: What happens with auto-incremented value on rollback? PinmvpEddy Vluggen30-Jan-13 22:50 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpiticcotoc30-Jan-13 23:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web03 | 2.8.140821.2 | Last Updated 21 Aug 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid