[SOLVED]Browse behaviour using MySQL

[Rene Simons]

Hi,

I have a Browse (wizzard generated) on a MySQL table.
There are more than 700 rows in the table.
When I open the browse from the menu, only the first record is shown.
When I click the menu again to open/refresh the browse it opens okay.
Using the locator (contains) is also not without problems.
Only one result line is shown, even though there are known more results.
Resetting the locator does not work as smoothly as with TPS.
Anyone having the same problems?

Cheers,
Rene

[Devan]

Hi Rene,

I have problems with MySQL tables if I don't specify a truly unique index in the Browse procedure.  Sometimes I've tried using a non unique index and get some crazy things happening, so always have to resort to a unique primary index in the properties screen and do my other sorting under the 'Sort' tab.

Cheers,
Devan

[Rene Simons]

Hello Devan,

Thanks for your input.
As I am working with NTWS, I know I must have a Primary Unique key in all tables.
After I read your message I did a check on the keys. And they are all as required.
Also in the browse I have selected this key for the Unique key.

So I'll try ODBC example 26 of FM3 and see what else I can do.
I'll report back as soon as I have made any progress.

Cheers,
Rene

[markster]

I had a weird error after updating a record where the parent browse would not properly refresh. I tried everything, until I finally traced it down to a view error in the browse SetView. My work around (see code below) was to add a manual next as soon as the view was opened. If I got an error 78 (which was because of an unknown problem), I closed the view, then reopened it with the same settings as per the template code just before that embed point. If there was no error, I issued a Previous(View) to restore the correct starting point for the display.

  ! Start of "After SetView"
  ! [Priority 5000]
  Next(ThisView)
  CASE ErrorCode()
  OF 78 ! Invalid number of parameters error appears for unknown reason
    IF p_web.GetSessionLevel() = 1 and FileErrorCode()
      stop('fileerror='&Clip(FileError())&' fileerrorcode='&fileerrorcode())
    END
    Close(ThisView)

Good luck,

Mark
    Open(ThisView)
    ThisView{prop:Filter} = loc:FilterWas
     p_web.SetView(ThisView,InvoiceCustomerSQL,INC:KeyInvoiceCustomerID,loc:PageRows,'BrowseInvoice',left(Loc:LocateOnFields),left(Loc:LocateField),loc:FileLoading,loc:LocatorType,clip(loc:LocatorValue),Loc:SortDirection,loc:ViewOptions,Loc:FillBack,Loc:Direction,loc:NextDisabled,loc:PreviousDisabled,Loc:LocatorCase,loc:RandomBrowseId)
  ELSE
    Previous(ThisView)
  END

[Rene Simons]

Hi Mark,

I'll see if this works for me to. Thanks a lot for the tip.
Maybe this is something for bruce to look into as well?

Rene

[Rene Simons]

Hi,
I am still having problems with the MySql .
Has anyone build an app using MySql without having problems?
Thanks,
René

[Rene Simons]

Hi,
After installing and using MySQL ODBC 5.3.4 my troubles are over.
Thanks,
René