Unsupport data type mapping :"unknown" to "single"

[dreamnyj1]

Code: Select all

       UniQrySaleGoods.Close;
       UniQrySaleGoods.sql.Clear;
       
       {A complex SQL join query}
       UniQrySaleGoods.sql.add(strSQLtmp);
       
       
       UniQrySaleGoods.Open;

If the query returns the correct result, no error will be reported.
If the query result is not found, an exception will be reported.
I wonder if there is a problem with the dev CXGRID that receives the dataset?

[pavelpd]

Hi there,
Thanks for your request!

Please describe your issue in more detail and send us the screenshot demonstrating the issue.
Also, kindly send us the exact list of actions (steps) after which this error appeared.

Additionally, please clarify what database you are working with and its version?

Kindly note that we are not aware of any issues related to the use of our components and visual components such as CxGrig.

You can create a sample using the standard TClientDataSet component and CXGrid, and in case of a similar problem, ask the CXGrid developers a question.

Also, please check if the issue is reproducible using UniDAC and the standard TDBGrid component?

[George121]

Uniface detected an unknown data type. Check that the data type is entered correctly and try again..FMWhatsapp