namwan
27th February 2007, 04:43
Dear all,

Now i want to insert the t_item and description in 9 tables, cprpd100, cprpd120,tcibd001,tcibd200,tdipu001,tdisa001,ticpr007,tiipd001,whwmd400.
the 2 tables(tdisa001,tcibd001) have problem, the t_item can't insert in them
but another tables can insert it. How i can solve this problem?



P.S. I use VB application to import item and description to database.



Namwan
mr_suleyman
27th February 2007, 07:54
Did you check table 's field relations and domains.


Good Luck!
namwan
27th February 2007, 07:58
after i check the field relations and domains, what i should do ??
mr_suleyman
27th February 2007, 10:22
If you know DB structure you could understand what I mean. It is very important for db operations. If you send your table relations structure , I can suggest somethings about it.
namwan
27th February 2007, 11:32
I check in every table, the DB structure is same. But the 2 tables ( ttcibd001 and ttdia001) can't be inserted. How it different from another table?
Han Brinkman
27th February 2007, 12:50
Did you checked the eventlog?
en@frrom
27th February 2007, 13:10
Also, what is the sequence you used? Logically as for reference checks, you should first add the record to tcibd001...

Regards,
Eli Nager