Data Browsing problem in an Auto-Incremented UDO-Form

[Former Member]

I have an UDO form, whose Code value in master table should be automatically incremented.

So, when the user switches to ADD Mode, I find the next Code value with a query and update the related field on the form. ( SQl Select max (code) from .... etc )

Untill here everything is ok. When Add button is clicked, data is saved to database.

<b>BUT</b> when I navigate through the records using the Next and Previous buttons, that added record is not listed.

It exists in related table, since

1. I can see it in SQL Server.

2. It's listed with the details just as I entered, when I use <b>Find</b> button on the form <b>with "*"</b>.

<b>What may be the reason why these records aren't shown with prev & next buttons ?</b>

[former_member185703 · Accepted solution]

Hi Gül,

I remember such a problem, but not the solution

Could you tell me what you assigned to the BrowseBy property (or XML element) of the form?

Maybe you would also want to report this issue to Support?

Regards,

Frank

[Former Member · Accepted solution]

Hi Frank !

I had assigned "Name" to the BrowseBy property.

But found out that it was my fault. For each record, I was saving the Name field as logged in user name. So it was not a unique field, that was why it was not navigating.

Now I save the record with an auto unique value in Name field and seems ok.

Thanks for your help

Gü