On Thursday 08 September 2016 15:56:48 mohamed hamza wrote: > Hi Martin, > > I created a temporary table :tsqlresult1 using tmsesqlresult DB > Object. > > I wonder if there is a trick to join tsqlresult1 with a tmsesqlquery?
Select the tsqlresult in the "source" property of a TSQLLookupBuffer from component tab 'DB'. Now it is possible to use the TSQLLookupBuffer as lookup source for the T*EditLB edit widgets from tab 'DBe' or the TDB*LB display widgets from tab 'DBl'. It is also possible to use additional TmseSQLQuery with local indices in order to store the lookupdata and lookup the data by fields with "FieldKind" = "fkLookup" in master query. Don't activate "LookupCache", the MSEgui lookup mechanism with local indices has better performance. In order to fetch lookupdata directly from server a TFieldParamLink from tab 'DBf' can be used to synchronise the lookup dataset. Martin ------------------------------------------------------------------------------ _______________________________________________ mseide-msegui-talk mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
