NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Rene Simons on August 26, 2014, 01:26:59 PM

Title: [SOLVED]Browse behaviour using MySQL
Post by: Rene Simons on August 26, 2014, 01:26:59 PM

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

Title: Re: Browse behaviour using MySQL
Post by: Devan on August 27, 2014, 11:33:50 PM

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

Title: Re: Browse behaviour using MySQL
Post by: Rene Simons on August 28, 2014, 10:38:25 AM

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

Title: Re: Browse behaviour using MySQL
Post by: markster on August 29, 2014, 03:15:36 PM

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

Title: Re: Browse behaviour using MySQL
Post by: Rene Simons on August 29, 2014, 10:55:04 PM

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

Title: Re: Browse behaviour using MySQL
Post by: Rene Simons on September 04, 2014, 12:10:17 PM

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

Title: [SOLVED]Browse behaviour using MySQL
Post by: Rene Simons on September 08, 2014, 08:25:21 PM

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