Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Visual Basic ( VB ) (http://www.go4expert.com/forums/visual-basic/)
-   -   need help about vb sql please urgent (http://www.go4expert.com/forums/help-vb-sql-urgent-t18397/)

efuzone 7Jul2009 11:36

need help about vb sql please urgent
 
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

Regards
Faizan Ahmed

naimish 7Jul2009 11:41

Re: need help about vb sql please urgent
 
Sorry, my mistake.

naimish 7Jul2009 11:42

Re: need help about vb sql please urgent
 
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

efuzone 7Jul2009 12:34

Re: need help about vb sql please urgent
 
i dont have source file for visual basic soft so what should i do please :(

naimish 7Jul2009 12:38

Re: need help about vb sql please urgent
 
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 ;)


All times are GMT +5.5. The time now is 17:02.