Xailer professional forum in English
Timm
Mensajes: 136 Registrado: Lun Jun 21, 2010 11:01 am
Mensaje
por Timm » Mar Mar 28, 2023 4:00 pm
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
Site Admin
Mensajes: 9256 Registrado: Lun Abr 06, 2015 8:00 pm
Ubicación: Madrid, Spain
Contactar:
Mensaje
por ignacio » Mié Mar 29, 2023 9:25 am
Hi,
TMySqlDatasource uses SQL syntax for the filters, while TWebDataSouce uses Harbour code. Maybe that's the problem.
Regards,
Timm
Mensajes: 136 Registrado: Lun Jun 21, 2010 11:01 am
Mensaje
por Timm » Mié Mar 29, 2023 4:30 pm
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
Site Admin
Mensajes: 9256 Registrado: Lun Abr 06, 2015 8:00 pm
Ubicación: Madrid, Spain
Contactar:
Mensaje
por ignacio » Jue Mar 30, 2023 7:29 pm
Hi Timm,
I will take a look. Thanks for the feedback.
Regards