1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

need help about vb sql please urgent

Discussion in 'Visual Basic ( VB )' started by efuzone, Jul 7, 2009.

  1. efuzone

    efuzone New Member

    Hello sir,
    i am faizan i need your help its realy urgent, i am working in one office as a computer operator and i am nill in VB and SQL they have one software made by one person he just gave them exe file to run and setuped sql database.. now the software is showing all trial balance and ledger in records everything is ok but when i insert any new entry for cash receipt it says

    "Runtime error '2147217873 (80040e2f)'
    [Microsoft] [ODBC SQL Server]INSERT Statement Conflicted with column foreign Key constraint 'FK-GL-Account-Line-GL-Accounts' The conflict occured in DB 'Accounts_2008' table GL_Account' column 'idno'

    please let me know how to solve this problem. i dont have source code file for this software just i have database backup and one mdf file.. to attech database..
    Thanks in advance

    Faizan Ahmed
  2. naimish

    naimish New Member

    Sorry, my mistake.
    Last edited: Jul 7, 2009
  3. naimish

    naimish New Member

    The error message is pretty clear. You have specified key values that doesn't exist in the parent table. The message indicates the constraint and table so you can find out which tables are involved
  4. efuzone

    efuzone New Member

    i dont have source file for visual basic soft so what should i do please :(
  5. naimish

    naimish New Member

    The only thing I can see is, either go ahead and develop new your own code, or do some R&D on database table's structure ;)

Share This Page