[Solved] Record jumping when adding record in web

[SpringBox]

Hi guys

There was a change made recently to keep on the same record after editing in web & that works great.

Is there any chance of having the same when we add a record?

It just looks odd when a user presses save to add a record and then the displayed record jumps to a different one.

We order on name and the interface will normally jump to the last record (based on tag name) after adding a record.

Thanks in advance


Simon

[barrymavin]

If you are ordering the records and you add a record you will need to make sure the record moves to the "last" position and in an afterinsert *delegate* (not trigger) move to the last record.

Records are displayed in the order that you specify.

[SpringBox]

Hi Barry

Thanks. That makes sense and of course exactly what we would have done in VFP.

However, we have tried everything we can think of to achieve this with no success.


We assumed we would make a field into a section search field and use Lianja.showDocument("section:section1?action=searc h&text=" + lcust_id);

It works in dev from Lianja console but cannot make it work in web. Also cannot find the right place to call it from. afterinsert delegate seems too early. We want it when the user presses save, just before the record jumps to the last record in the index - Mr Yoyo.


Our records are displayed in customer name order but we have a section search field set to cust_id which is a guid(). We currently only have two indexes on the table ie lower(name) and lower(cust_id) as guid() seems to be stored as lower case.

So any pointers as to how would we search for the cust_id field using js and then move the current record pointer?

Thanks in advance



Simon

[barrymavin]

This has been handled in 7.2. Its to do with having am "order by" on the section.