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 INCIDENCIASCLIENTE where idcliente=:id;
idcliente is link field in icli id is primary key in clientes
The error is:
Clientes: Field not found: "idcliente"
weird, because field idclientes is not in dataset clientes (master), it's
in detail
2013/3/21 Julio Jiménez <juj...@gmail.com>
> 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 try again... may be I did some
> mistake...
>
>
> 2013/3/21 Martin Schreiber <mse00...@gmail.com>
>
>> 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" clause of the detail dataset OK? Field names
>> of
>> the master dataset and the detail params must match.
>> Example synchronize the "pk" fields of master and detail:
>> "
>> select * from table1 where pk = :pk
>> "
>>
>> Martin
>>
>>
>> ------------------------------------------------------------------------------
>> Everyone hates slow websites. So do we.
>> Make your web apps faster with AppDynamics
>> Download AppDynamics Lite for free today:
>> http://p.sf.net/sfu/appdyn_d2d_mar
>> _______________________________________________
>> mseide-msegui-talk mailing list
>> mseide-msegui-talk@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
>>
>
>
>
> --
> Julio Jiménez Borreguero
>
--
Julio Jiménez Borreguero
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
_______________________________________________
mseide-msegui-talk mailing list
mseide-msegui-talk@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
