Re: Database error code: 515

Hello,

Just see if you insert NULL into Contact_ID field. Please take a look into
table schema using SP_HELP <TableName> and verify the data you
are trying to insert..

Thanks
Hari


"Yigedeb" <Yigedeb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2FBF9D1C-F344-48AA-8172-0FF3E00A00BA@xxxxxxxxxxxxxxxx
We have MS SQL 2000 server. Recently, on our database application we gate
"Databse error code: 515" It says: Cannot insert the value NULL into
cilumn
"contact_id", table name, column doesn't allow nulls. INSERT fails. No
changes made to databse. ....

A recent action on this table was, we exported the contact table to Excel,
updated, and imported from Excel.

Would you please advise us what the problem could be and how we can
address
this.

Thanks,
Yigedeb.
CBI


.

Relevant Pages

  • Excel Outlook Attachments opening after several errors everytime
    ... and verify that the file locatation is correct. ... myfilename.xls FINALLY opens. ... We are using Office 2002 SP3, including Outlook and Excel. ...
    (microsoft.public.excel.setup)
  • Re: xml import
    ... mir das file in mehrere Tabellen aufsplittet, ... Excel wird ein Schema erstellen, ... als XLS speichern und dieses in Access importieren oder verlinken. ...
    (microsoft.public.de.access)
  • Re: Creating an Excel Spreadsheet from code on a computer that does not have Excel installed
    ... Private Sub CreateXLSFromDt(ByVal ds As DataSet, ByVal tablename As String, ... converted by Excel when openned ...
    (microsoft.public.dotnet.languages.vb)
  • Re: VB6 and Excel question
    ... And it's better to verify than to guess. ... Robert wrote: ... I'm using VB6 and Excel 2007. ... Dave Peterson ...
    (microsoft.public.excel.programming)
  • Re: XML Mapping
    ... I just realized that "Excel" was misspelled in his link. ... "Chip Pearson" wrote: ... Download the schema and the workbook that creates the DOM and saves the XML ...
    (microsoft.public.excel.misc)
Loading