Sql syntext

Results 1 to 4 of 4

Thread: Sql syntext

  1. #1
    Join Date
    Dec 1969
    Posts
    257

    Default Sql syntext

    W, R01, Bill Insert into hr_rep_assignment (division_id,location_id,user_id) values (&#039W, &#039,&#039R01, &#039,&#039Bill&#039) <BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e14&#039 <BR><BR>[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted with COLUMN FOREIGN KEY constraint &#039FK__hr_rep_as__locat__55F4C372&#039. The conflict occurred in database &#039cool&#039, table &#039location&#039, column &#039location_id&#039. <BR><BR>/Cool_admin/viewuser.asp, line 183 <BR>This is the error i am getting when i trying to insert i dont know from where i am getting all extra commas and spaces<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    34

    Default RE: Sql syntext

    would need to see the code

  3. #3
    Join Date
    Dec 1969
    Posts
    18

    Default RE: Sql syntext

    I this the ur query string is having the problem!.....

  4. #4
    ISmail Ahmed Guest

    Default RE: Sql syntext

    First ur sql sytax have error if it is mistakenly written by u then See the related tables i think u r using SQLSERVER <BR>i think u didnt enter this location_id in master table from where table &#039location&#039 is related


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •