Yeah,
Just found it. Indeed the import didn't set any of the key fields as they were in the source!
I am no expert at SQL or have suitable qualifications to slag of Microsoft but I would have thought that an import wizard would have "at least" imported the properties of the columns.
**Paul ducks and waits for all the reasons why...**
Ok so now i'll spend an hour or so going through the tables .... :(
Thanks - Regards - Paul
From: "Stephen Moretti (cfmaster)" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] SOT - SQL Date: Tue, 06 Jul 2004 11:44:55 +0100
[Macromedia][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column
'Report_ID', table 'schools_performance.dbo.Report_Names'; column does not allow nulls.
Sounds like you might have lost your indexes/keys somewhere in the move.
I'm assuming that Report_ID is a IDENTITY field that autoincrements itself. The error you're getting reminds me of the error you get if you forget to set the field to autoincrement or be a key.
Stephen
--
These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*To unsubscribe, e-mail: [EMAIL PROTECTED]
