Devart Forums

Posted: **Thu 03 Sep 2020 19:28**

If you change some options as described below, a TSmartQuery component freezes when inserting two records.

Create a new VCL application and place the following components on the main form and connect them with each other

TOraSession
TConnectDialog
TSmartQuery
TOraDataSource
TDbGrid
TDbNavigator
TButton

Implement the OnClick method of the button as follows

Code: Select all

  OraSession.Options.StatementCache := True;
  OraSession.Options.EnableLargeint := True;
  OraSession.Options.EnableNumbers := True;
  OraSession.Options.UnicodeEnvironment := True;
  OraSession.Options.UseUnicode := True;
  OraSession.Connect;
  SmartQuery.DMLRefresh := True;
  SmartQuery.Options.ReturnParams := True;
  SmartQuery.KeyFields := 'COUNTRY_ID';
  SmartQuery.SQL.Text := 'SELECT COUNTRY_ID, COUNTRY_NAME, REGION_ID FROM COUNTRIES';

  SmartQuery.Options.CacheCalcFields := True;
  SmartQuery.Options.CacheLobs := True;
  SmartQuery.Options.DefaultValues := True;
  SmartQuery.Options.DeferredLobRead := True;
  SmartQuery.Options.StatementCache := True;
  SmartQuery.Active := True;

Now, run the application and

Click the button, connect to the HR sample schema
On the navigator, click the "+" button, enter some sample data into the data grid record, and post changes
On the navigator, click again the "+" button, enter some other sample data, and post changes
Now the application freezes.

I sent you a sample project using the contact form earlier this week and attached a sample project, but did not yet get an answer. I am afraid you did not get it.

Posted: **Fri 04 Sep 2020 15:41**

We've successfully tested ODAC according to your description. Unfortunately, we haven't received any example from you. Could you send it to us again using the e-support form (https://www.devart.com/company/contactform.html) ?

Posted: **Sun 06 Sep 2020 08:47**

Sample application has been sent again using contact form.

Posted: **Tue 08 Sep 2020 14:31**

Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.

Posted: **Thu 29 Oct 2020 20:04**

Haven't heard anything for almost 2 months.
When do you plan to fix it?

Posted: **Sun 08 Nov 2020 20:12**

We've reproduced the issue and fixed it. The fix will be included in the next build of our product. As a workaround, we can send you a night ODAC build including the required changes. For this provide us with your license number and IDE version you are interested in For your convenience, please use the e-support form https://www.devart.com/company/contactform.html

Devart Forums

ODAC 11.3.1 - TSmartquery freezes on 2nd Insert

ODAC 11.3.1 - TSmartquery freezes on 2nd Insert

Re: ODAC 11.3.1 - TSmartquery freezes on 2nd Insert

Re: ODAC 11.3.1 - TSmartquery freezes on 2nd Insert

Re: ODAC 11.3.1 - TSmartquery freezes on 2nd Insert

Re: ODAC 11.3.1 - TSmartquery freezes on 2nd Insert

Re: ODAC 11.3.1 - TSmartquery freezes on 2nd Insert