| record dont show as user entered in form. [message #471535] |
Mon, 16 August 2010 01:20  |
kame
Messages: 69
Registered: July 2009
|
Member |
|
|
User Enter 100 Records in tabular Block
when click on save button , records save successful but when user close form and open again that particular record,
this record dont show as user entered in form.
the records are not displaying the order what user saved while user query back the form.
what is the reason? and how to correct it?
|
|
|
|
| Re: record dont show as user entered in form. [message #471545 is a reply to message #471535] |
Mon, 16 August 2010 01:57  |
 |
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
|
Senior Member |
|
|
Quote:what is the reason? It is the expected behavior.
SELECT doesn't give in the same order, in which you have inserted.Quote:and how to correct it? You need to have sorting column.
Check this.
While entering the records, also populate that column with a sequence, so that you can use the same column in the order by later.
By
Vamsi
[Updated on: Mon, 16 August 2010 01:57] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
