pcsoft.us.windevCopyright 2026, PC SOFT22 Mar 2016 08:36:00 Z20 Mar 2016 08:40:00 ZHello, Windev 20. New to WX I plan to use a table control to display the following details from a file (POS system) 1. ItemCode 2. ItemName 3. Quantity 4. Rate 5. Discount % 6. Amount Need to know how to update those details to database, using hAdd, both in insert mode and edit mode. In edit mode, possibility of deleting row(s) is there. How to deal with these deletions ? Every row needs to be added with hAdd, modified rows need to be modified with hModify and deleted rows needs hDelete. Is there any example(s) available with WX ? Or any sample code will be better. Happiness Always BKR Sivaprakash30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56954/read.awp22 Mar 2016 08:36:00 ZThanks Fabrice Harari for your reply. Since I need to use both h* functions and need transactions, the only option is to code…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56954/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56954/read.awpRe: Table Updateguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56948/read.awp21 Mar 2016 16:30:00 ZHello again if you need transaction, you need to code... Everything else (adding, editing, deleting) can be done automaticall…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56948/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56948/read.awpRe: Table Updateguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56946/read.awp21 Mar 2016 15:48:00 ZHello Fabrice Harari, I'vent mentioned CANCELLING option in my question, but I mentioned about hAdd, hModify, etc. Hope we ca…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56946/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56946/read.awpRe: Table Updateguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56945/read.awp21 Mar 2016 15:42:00 ZSteven Sitas, Yes, Powerbuilder's DataWindow is really powerful in this case. FYI, PB development is now took by Novalys (htt…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56945/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56945/read.awpRe: Table Updateguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56934/read.awp21 Mar 2016 12:00:00 ZHi Steven you may be right. But CANCELLING the changes was -NOT- in the original question OR in the followup. So everything t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56934/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56934/read.awpRe: Table Updateguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56929/read.awp21 Mar 2016 10:51:00 ZHi I use the second method stevan mentioned. Ok you have to do some coding but he it is with wlanguage so verry doable compar…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56929/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56929/read.awpRe: Table Updateguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56926/read.awp21 Mar 2016 09:12:00 ZHi Fabrice, I don't think you can do this thing in Windev, without code. Lets say the user is changing (or deleting or inserti…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56926/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56926/read.awpRe: Table Updateguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56922/read.awp21 Mar 2016 02:17:00 ZHi well everything CAN be done automatically, if your table is linked to a file and is in edit mode, with addition. Then you …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56922/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56922/read.awpRe: Table Updateguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56915/read.awp20 Mar 2016 14:57:00 ZHi Steven Sitas, Thanks for your hint Steven Sitas. I'm from Powerbuilder area, where we used to just check the box 'Delete a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56915/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56915/read.awpRe: Table Updateguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56914/read.awp20 Mar 2016 14:55:00 ZHello Guenter Predl, Thanks. Yes, I'm going through the manual, examples, and other stuffs that I get while on the way. Somet…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56914/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56914/read.awpRe: Table Updateguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56912/read.awp20 Mar 2016 13:13:00 ZHi Sivaprakash, If we assume that editing (and deleting) is something RARE in a POS System: (1) INSERT MODE : just loop thro…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56912/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56912/read.awpRe: Table Updateguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56911/read.awp20 Mar 2016 10:48:00 ZDear Sivaprakash, you will find a Tutorial_Windev.pdf in the sub-directory \Tutorial of your installed WINDEV directory. Firs…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56911/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56908-table-update-56911/read.awpRe: Table Update