Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Can I display the record No. in the client GUI?

 
long lingyu
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can I display the record No. in the client GUI? or I should hide the column.
 
Satish Avadhanam
Ranch Hand
Posts: 697
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by long lingyu:
Can I display the record No. in the client GUI? or I should hide the column.

Hi long, its upto you. You can hide the details from the CSR and just show him actual data or else you can show record number. The second case can be used if you want to allow the CSR to book using record number.
 
Nicholas Cheung
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In case you want to show your record ID, you may have to handle (or not to handle) the numbering.
For example, if the database contains 3 records, and 1 is mark deleted, the GUI shows only 2 records. But, which of the following you want to have:
option 1:

option 2:

If you choose option 1, it is easier to implement, although the record number is not in sequence.
If you choose option 2, it looks better than option 1, but you may need extra afford to re-order the record number.
Thus, I simply not to show the record number, as in fact, the CSR does not need to know this info.
Nick.
 
long lingyu
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
When I book a record, I want to find the record through recNo, if I haven't get the record number,should I find the record through the field first? I think showing the number in JTable is more easier to handle. But the requirement?
 
George Marinkovich
Ranch Hand
Posts: 619
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Long,
Originally posted by long lingyu:
When I book a record, I want to find the record through recNo, if I haven't get the record number,should I find the record through the field first? I think showing the number in JTable is more easier to handle. But the requirement?

The assignment instructions are silent on whether you can show record numbers in the JTable. Since it isn't prohibited by any requirement I think you are free to do so. The record number does have a meaning (it's the records's physical order in the database file) so I would strongly recommend Nick's option 1 if you decide to show the record numbers in the JTable. Option 2 doesn't make any sense to me and it seems to violate the inherent meaning of the record number. I displayed record numbers to the user in the JTable, so I was able to get the record number for a record from the JTable.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic