How do I resolve changes with the IBX components with client side SQL ?
This explains how to resolve data from a custom client SQL query back to a backend database server: You need to setup the following on the serverside TkbmMWQueryService: – Set AllowClientStatement to true. This allows the client to send client side SQL statements. – Set AllowClientKeyfields to true. This allows for the client to specify which fields are unique key fields. – Set AllowClientTableName to true. This allows the client to specify which actual table resolving should be done at. It should usually be the same as the table included in the statement. – Set Query to point at your main TkbmMWIBX5PooledQuery component. – Make sure to set the SessionName of the query component. – Add a TkbmMWIBX5Resolver – Set the TkbmMWIBX5PooledQuery.Resolver to point at the TkbmMWIBX5Resolver. – Set TransportStream to point at a TkbmMWBinaryStreamFormat. This component is used for moving the dataset data/deltas between client and server. On the clientside: – Set the TkbmMWClientQuery.EnableVersion
