Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>>Actually I want to use codes to EDIT sale invoice
>>>
>>>current sale invoice is as follows
>>>
>>>vou_no--code---Product---qty---rate--Amount
>>>---1-------1401----Apple------10----15----150
>>>---1-------1402----mango-----20----15----300
>>>
>>>
>>>Now I want to edit current invoice as
>>>
>>>vou_no--code---Product---qty---rate--Amount
>>>---1-------1401----Apple------10----17----170
>>>---1-------1403----Banana----30----22----660
>>>
>>>After editing, I delete current invoice and insert new one on its place with same vou_no.
>>
>>What is the Primary Key column in the Invoice table? Why do you need to delete and insert instead of simply using UPDATE command?
>
>There is no Primary key becuase this is a products detail table and every product have vou_no reference like this
>
>vou_no--code---Product---qty---rate--Amount
>---1-------1401----Apple------10----17----170
>---1-------1403----Banana----30----22----6
If no PK than either change your table or if you have problems with that show us how you have constructed that ProductDetailTable, maybe we can assist to extend your table with a PK
Regards,
Koen
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement