|
| Order Entry line item table best practices |
| Iniciado por priv!8ynqvzv4+vywv0+ppM176y11x+p1z, 12,nov. 2024 15:13 - No hay respuesta |
| |
| | | |
|
| |
| Publicado el 12,noviembre 2024 - 15:13 |
Greetings,
As there are many ways to achieve one goal, I would like to ask your advice on best practices for Order’s line item table.
Lets imagine the table which will be entered by sales person:
1. When order is created, sales person will enter order
2. When sales person will enter to the order once again, they might modify any of the column
Windev possibility to populate table:
Data read thoughts:
What I currently understand, the best value for me is File/Query because I can easily read OrderLineItem table and add any join from another table by few clicks.
In case I have setup Loaded in memory, I can even color the table and each cell separately which again good thing.
Do you agree with it ? Query + Loaded in memory gives me performance (usually less than 200 line items per order) , less programming
Data write thoughts:
Again, what would be the best way to get proper speed, adequate maintenance ?
I know we can update DB using query too, but is it a good practice ?
What would be the best way to update only modified line items ?
Thanks in advance!! |
| |
| |
| | | |
|
| | | | |
| | |
|