Re: [MSEide-MSEgui-talk] About tmsesqlquery datasource propery

2013-03-21 Thread Martin Schreiber
On Wednesday 20 March 2013 21:04:36 Julio Jiménez wrote: What is tmsesqlquery.datasource for? I have read mse db components are a fork of sqldb components. In sqldb, zeos, ibx... this field is used for a master-detail relation but this mode isn't working in mse Works for me. Is the where

Re: [MSEide-MSEgui-talk] About tmsesqlquery datasource propery

2013-03-21 Thread Julio Jiménez
Yes of course. The same code is working in Lazarus. It complains about a field name not existing in master dataset.. when that field is in detail... Detail sql looks liket: Select id, idmaster, name where idmaster=:id and id is the pk in master dataset Because you say it works for you, I'll

Re: [MSEide-MSEgui-talk] About tmsesqlquery datasource propery

2013-03-21 Thread Julio Jiménez
Testing again and not working. Master dataset name is clientes. Sql = select * from clientes order by denominacion asc; primary key is ID Data sourde name for clientes is clientesds One of the details datasets Name: idcli icli.datasource = clientesds Sql = select * FROM

Re: [MSEide-MSEgui-talk] About tmsesqlquery datasource propery

2013-03-21 Thread Martin Schreiber
On Thursday 21 March 2013 09:54:27 Julio Jiménez wrote: Yes of course. The same code is working in Lazarus. It complains about a field name not existing in master dataset.. when that field is in detail... Detail sql looks liket: Select id, idmaster, name where idmaster=:id and id is the

Re: [MSEide-MSEgui-talk] About tmsesqlquery datasource propery

2013-03-21 Thread Martin Schreiber
On Thursday 21 March 2013 10:07:41 Julio Jiménez wrote: Testing again and not working. Master dataset name is clientes. Sql = select * from clientes order by denominacion asc; primary key is ID Data sourde name for clientes is clientesds One of the details datasets Name: idcli

Re: [MSEide-MSEgui-talk] About tmsesqlquery datasource propery

2013-03-21 Thread Julio Jiménez
yes primary key en master is ID The same SQL sentences are working in lazarus/ibx/sqldb/zeoslib I'll try to build a testcase Thank you. 2013/3/21 Martin Schreiber mse00...@gmail.com On Thursday 21 March 2013 10:07:41 Julio Jiménez wrote: Testing again and not working. Master dataset

[MSEide-MSEgui-talk] About tmsesqlquery datasource propery

2013-03-20 Thread Julio Jiménez
What is tmsesqlquery.datasource for? I have read mse db components are a fork of sqldb components. In sqldb, zeos, ibx... this field is used for a master-detail relation but this mode isn't working in mse I know mse has tfieldfieldlink and tfieldparamlink, but simply assigning datasourde of