Sort after insert record problem

[astahl]

I have a date field as the only sort field on a browse and have the "Default to Descending" ticked on.

When returning from adding a new record the sort is not obeyed ie. I want the browse to show the
newly added record as the first record in the browse. How can this be obtained.


Ashley

[Bruce]

I'd need to see an example Ashley.
Can you duplicate this in a shipping example?

cheers
Bruce

[astahl]

Hi Bruce,

This is a SQL table, I will try to get something.


Ashley

[astahl]

Hi Bruce,

Testing different scenarios and here is what I found.

When inserting a record the sort is actually correct, but instead of going to the first page
it goes to the last page of records when saved instead of the first page of records.

How would one make it select the first page on after a insert record?

Ashley

[Bruce]

I'd need to see an example to answer this question Ashley.
Can you duplicate in one of the shipping examples? Maybe the MsSql (73) one?


cheers
Bruce

[astahl]

Hi Bruce,

What MSSQL database should I use or where is it?

I tried the the WebApp 31 and that worked correctly, of course it is using tps files.

From what I can gather this seems to be a problem with SQL.


Ashley

[Bruce]

there's an example in \examples\nettalk\web server\mssql (71)

[astahl]

Hi Bruce,

Yes there is but when I compilied and ran it it was asking me for database which I guess I did not have.

That's fine. I resolved the issue with a design change. I now call the form as a browseless form from the menu using ?insert_btn=insert, and upon save I call the browse as a URL.

This combo works very well and has solved the issue. I do however believe this may be a MySql table problem. If you are saying that the MSSql app works then I confirmed my thought.

This maybe something to look at in the next NetTalk Webinar.


Ashley