Switching From TMySQLDatasource to TWebDataSource

[Timm]

Hi!

I would like to use TWebDataSource instead of TMySQLDatasource, but the Filter-Method results in an error:

Código: Seleccionar todo

WITH OBJECT ::oDataSetProject := ::oWebDataSource1:Table( "project" )
   :lOpen := .t.
   :Filter( ::cFilterProject )  >> #1: Xailer-TMemDataSet: Filter error: [project_active = 1 AND user_id = 'b7ThF64e']
END WITH

Using TMySQLDatasource the code works.

Regards, Timm

[ignacio]

Hi,

TMySqlDatasource uses SQL syntax for the filters, while TWebDataSouce uses Harbour code. Maybe that's the problem.

Regards,

[Timm]

Hi Ignacio,

with Harbour code for the filter it works. Many thanks!
In addition, it seems like oDataSet:cFullName must be taken when filtering.
For example:
:Filter( "project.project_active = 1 .AND. project.project = 'xyz'" )

Regards, Timm

[ignacio]

Hi Timm,

I will take a look. Thanks for the feedback.

Regards