Hi,
I am creating an example with Grid with 4 columns :-
Col 1 : Item code
Col 2 : Rate
Col 3 : Qty
Col 4 : Amt (i.e., Rate*Qty)
I want to auto calculate col 4. So which event/property I should try?
I already tried ON CHANGE event and COLUMNVALID properties. But calculation occurs only when user goes to the next row and then coming the the previous row.
I used IETM(nIndex) property to store the changes. Should I use ITEM(nIndex) or CELL(r, c)?
With best regards.
Sudip
Grid with Calculated Column
Moderator: Rathinagiri
Grid with Calculated Column
With best regards,
Sudip
Sudip
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: Grid with Calculated Column
Can you kindly provide a sample prg?
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
Re: Grid with Calculated Column
Thanks Rathinagiri,
I just found (by trial and error method) that ON LOSTFOCUS method works fine.
Yes, I am working on one to many form and shall send very soon.
Thank you again for your support
Regards.
Sudip
I just found (by trial and error method) that ON LOSTFOCUS method works fine.
Yes, I am working on one to many form and shall send very soon.
Thank you again for your support
Regards.
Sudip
With best regards,
Sudip
Sudip
Re: Grid with Calculated Column
It seems Sudip ur into Invoice entry - multiple /table entry part where users will add items....
Why ON CHANGE is not working in the rate field?
Why ON CHANGE is not working in the rate field?
Re: Grid with Calculated Column
Hello Swapan,
You are correct.
It's nice to see you here.
I just posted some code in "My HMG Projects" section.
Please check the code and send your comments.
Regards.
Sudip
You are correct.
It's nice to see you here.
I just posted some code in "My HMG Projects" section.
Please check the code and send your comments.
Regards.
Sudip
With best regards,
Sudip
Sudip