SDAC 6.9.17 problem

[Alexander_73]

RAD Studio XE5, after installing SDAC 6.9.17 the x64-program crashes on TMSQuery.Locate method (no properties changed) with first exception EOLEDBERROR "All string descriptors must be..." and next exceptions "Access Violation...". This crash raises with MSQuery.Options.Nonblocking=true and MSQuery.CursorType=ctDefaultResultSet. When I change property MSQuery.CursorType to ctDynamic, a first call of Locate takes about 30 seconds and every next call takes 3 minutes more, and with ctStatic or ctKeySet only it works slowly but correct. Without NonBlocking=true it works well.

What must I do, change all of nonblocking for all of TMSQuery objects to false or all of these CursorType to ctStatic? It's terrible for project with 380 forms and 600 static&dynamic objects of TMSQuery and TMSStoredProc...

[hmelihkara]

I've another (may be the same still investigating) problem connected to non-blocking.
My queries do not return any records back, datagrid is empty (may be I have to wait minutes like Alexander said but records must return under a second!). Prior version works perfect. Now as Alexander said, do I have to change or disable all non-blocking options in my all queries on hundreds of forms?

IDE: Delphi XE4

[AndreyZ]

To Alexander_73:
We cannot reproduce this problem. Please try creating a small sample that demonstrates this problem and send it to support*devart*com , including a script to create all needed server objects (tables, stored procedures, etc.). Also please specify the exact version of SQL Server server and client you are using. You can learn it from the Info sheet of TMSConnection Editor.

[AndreyZ]

To hmelihkara:
Thank you for the information. We have reproduced and fixed this problem. This fix will be included in the next SDAC build. As a temporary workaround, you can call the EnableControls method after opening a dataset. Please note, that the NonBlocking=True mode did not work in the previous SDAC version, that is why there was no problem with it.

[Andre@Solit]

Delphi 2007:
The buttons "Execute" and "Code editor..." in the SQL editor are not shown correctly. Looks like there's a 3td button under them.

I keep getting the same assertion error for some time now when I close the SQL editor by hitting the ESC key (the SQL text needs to be focussed):
Assertion failure (D:\Projects\Delphi\Dac\Common\Source\Design\DADesignUtils.pas, line 337)
When an other component, like the OK button, has focus the assert error does not appear with the ESC key.

Regards,
Andre

[Dimon]

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next SDAC build.

[skydvrz]

I have the same problem in MyDAC v8.2.5. Will this fix cover both component sets?

Code: Select all

[0EE15BB3]{dcldac150.bpl} Dadesignutils.TDADesignUtils.GetSQL + $37
[0EE20A2D]{dcldac150.bpl} Dasqlframe.TDASQLFrame.GetLocalComponentSQL + $3D
[0EE20C02]{dcldac150.bpl} Dasqlframe.TDASQLFrame.meSQLExit + $1E
[50283C8D]{vcl150.bpl  } Controls.TWinControl.DoExit (Line 10567, "Controls.pas" + 1) + $14
[502848E1]{vcl150.bpl  } Controls.TWinControl.CMExit (Line 11191, "Controls.pas" + 1) + $4
[5027DF6C]{vcl150.bpl  } Controls.TControl.WndProc (Line 7074, "Controls.pas" + 91) + $6
[50282830]{vcl150.bpl  } Controls.TWinControl.WndProc (Line 9831, "Controls.pas" + 144) + $6
[33064912]{SynEdit_RXE.bpl} Synedit.TCustomSynEdit.WndProc + $7E
[5027DB90]{vcl150.bpl  } Controls.TControl.Perform (Line 6852, "Controls.pas" + 10) + $8
[17AED6E4]{cxLibraryRS15.bpl} cxControls.dxPerformMessageByQueue (Line 2518, "cxControls.pas" + 3) + $A
[17B3FB59]{cxLibraryRS15.bpl} cxContainer.cxContainerWndProcHook (Line 6228, "cxContainer.pas" + 14) + $10
[17A852FF]{cxLibraryRS15.bpl} dxHooks.ProcessHookProcs + $53
[17A850E6]{cxLibraryRS15.bpl} dxHooks.dxSystemWndProcHook + $16
[5035222D]{vcl150.bpl  } Forms.TCustomForm.SetWindowFocus (Line 5381, "Forms.pas" + 10) + $8
[503522B3]{vcl150.bpl  } Forms.TCustomForm.SetActive (Line 5396, "Forms.pas" + 9) + $2
[50352D5E]{vcl150.bpl  } Forms.TCustomForm.WMActivate (Line 5772, "Forms.pas" + 6) + $A
[00428F4C]{bds.exe     } Sanctuary.ProductTimer..{Generics.Collections}TList<Sanctuary.ProductTimer.TPair<System.string,System.string>> + $5B8
[5027DF6C]{vcl150.bpl  } Controls.TControl.WndProc (Line 7074, "Controls.pas" + 91) + $6
[21772A27]{vclactnband150.bpl} ActnMenus.CallWindowHook (Line 744, "ActnMenus.pas" + 20) + $F
[50282830]{vcl150.bpl  } Controls.TWinControl.WndProc (Line 9831, "Controls.pas" + 144) + $6
[5034FB28]{vcl150.bpl  } Forms.TCustomForm.WndProc (Line 3961, "Forms.pas" + 191) + $5
[50281ED0]{vcl150.bpl  } Controls.TWinControl.MainWndProc (Line 9552, "Controls.pas" + 3) + $6
[500AFA64]{rtl150.bpl  } Classes.StdWndProc (Line 13491, "Classes.pas" + 8) + $0
[503545CB]{vcl150.bpl  } Forms.TCustomForm.ShowModal (Line 6673, "Forms.pas" + 58) + $4
[0EE1DAF4]{dcldac150.bpl} Crdesign.TCRComponentEditor.ShowEditorEx + $8C
[0EE1DA42]{dcldac150.bpl} Crdesign.TCRComponentEditor.ShowEditor + $32
[0EE1DE0B]{dcldac150.bpl} Crdesign.TCRComponentEditor.Edit + $B
[21086721]{designide150.bpl} ComponentDesigner.TInternalItem.Edit (Line 7094, "ComponentDesigner.pas" + 1) + $F
[2104EFEC]{designide150.bpl} Designer.TDesigner.Edit (Line 964, "Designer.pas" + 0) + $4
[21051263]{designide150.bpl} Designer.TDesigner.MouseDown (Line 1658, "Designer.pas" + 45) + $6
[51B191E1]{vcldesigner150.bpl} VCLSurface.TComponentToolWindow.WndProc (Line 1327, "VCLSurface.pas" + 16) + $32
[51B19C7E]{vcldesigner150.bpl} VCLSurface.TContainer.WndProc (Line 1627, "VCLSurface.pas" + 39) + $6
[17A85345]{cxLibraryRS15.bpl} dxHooks.ProcessHookProcs + $99
[51B19003]{vcldesigner150.bpl} VCLSurface.TDesignerToolWindow.MainWndProc (Line 1262, "VCLSurface.pas" + 2) + $7
[500AFA64]{rtl150.bpl  } Classes.StdWndProc (Line 13491, "Classes.pas" + 8) + $0
[50278AA6]{vcl150.bpl  } Controls.FindControl (Line 3378, "Controls.pas" + 6) + $9
[50358AF7]{vcl150.bpl  } Forms.TApplication.ProcessMessage (Line 9760, "Forms.pas" + 23) + $1
[50358B3A]{vcl150.bpl  } Forms.TApplication.HandleMessage (Line 9790, "Forms.pas" + 1) + $4
[50358E65]{vcl150.bpl  } Forms.TApplication.Run (Line 9927, "Forms.pas" + 26) + $3

[AlexP]

We have fixed the problem with buttons overlay, but couldn't reproduce the problem with Assert on exiting the MSQuery editor. Please describe the steps to reproduce the problem.

[Andre@Solit]

Delphi 2007:
I keep getting the same assertion error for some time now when I close the SQL editor by hitting the ESC key (the SQL text needs to be focussed):
Assertion failure (D:\Projects\Delphi\Dac\Common\Source\Design\DADesignUtils.pas, line 337)
When an other component, like the OK button, has focus the assert error does not appear with the ESC key.

Regards,
Andre

The assertion error is still there in version 6.9.18

[AlexP]

We still cannot reproduce the problem on both Delphi 2007 and the latest Delphi XE5. If the query is modified, then a saving confirmation message is displayed, if it wasn't - it just closes. Please specify the steps to reproduce the issue.

[Andre@Solit]

We still cannot reproduce the problem on both Delphi 2007 and the latest Delphi XE5. If the query is modified, then a saving confirmation message is displayed, if it wasn't - it just closes. Please specify the steps to reproduce the issue.

It does not matter if de query is modified. When I hit the ESC key while the edit box is focused I get the assertion error.

This problem started to appear after installing the latest version of DevExpress VCL.

[AlexP]

Please check the problem occurrence on a clean IDE without 3rd-party components

[Andre@Solit]

We have fixed the problem with buttons overlay, but couldn't reproduce the problem with Assert on exiting the MSQuery editor. Please describe the steps to reproduce the problem.

The button overlay is fixed for TMSQuery, but not for TMSStoredProc.

[AlexP]

Thank you for the information. We have already fixed this problem in TMSStoredProc as well