We have setup a MIDAS app with a midas server containing a TOracleDataSet and TDataSetProvider. The next tier is a COM server, containing a ClientDataSet using the aforementioned Provider.
Now, the code we have written sets the CDS.CommandText property with a parameterized Query for the CLIENT_ID field. We then clear all params on the CDS, create the appropriate ones and call CDS.Execute. When all is said and done, we get a "Field 'CLIENT_ID' can not be found", and the result set is empty.
Any ideas? We've tried what feels like everything...
