SDAC 6.9.17 problem

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Alexander_73
Posts: 52
Joined: Mon 24 Mar 2008 13:22

SDAC 6.9.17 problem

Post by Alexander_73 » Fri 27 Dec 2013 12:10

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
Posts: 21
Joined: Fri 09 Nov 2007 23:29

Re: SDAC 6.9.17 problem

Post by hmelihkara » Fri 27 Dec 2013 14:22

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

Re: SDAC 6.9.17 problem

Post by AndreyZ » Mon 30 Dec 2013 08:02

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

Re: SDAC 6.9.17 problem

Post by AndreyZ » Mon 30 Dec 2013 08:02

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
Posts: 4
Joined: Tue 07 Jan 2014 12:20

Re: SDAC 6.9.17 problem

Post by Andre@Solit » Tue 07 Jan 2014 12:33

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
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Re: SDAC 6.9.17 problem

Post by Dimon » Wed 08 Jan 2014 17:58

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

skydvrz
Posts: 32
Joined: Tue 23 Feb 2010 23:49
Location: Kissimmee, Florida USA
Contact:

Re: SDAC 6.9.17 problem

Post by skydvrz » Tue 28 Jan 2014 21:33

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
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: SDAC 6.9.17 problem

Post by AlexP » Wed 29 Jan 2014 08:53

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
Posts: 4
Joined: Tue 07 Jan 2014 12:20

Re: SDAC 6.9.17 problem

Post by Andre@Solit » Fri 21 Feb 2014 08:09

Andre@Solit wrote: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
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: SDAC 6.9.17 problem

Post by AlexP » Fri 21 Feb 2014 13:01

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
Posts: 4
Joined: Tue 07 Jan 2014 12:20

Re: SDAC 6.9.17 problem

Post by Andre@Solit » Tue 25 Feb 2014 10:23

AlexP wrote: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
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: SDAC 6.9.17 problem

Post by AlexP » Tue 25 Feb 2014 13:32

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

Andre@Solit
Posts: 4
Joined: Tue 07 Jan 2014 12:20

Re: SDAC 6.9.17 problem

Post by Andre@Solit » Fri 07 Mar 2014 08:27

AlexP wrote: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
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: SDAC 6.9.17 problem

Post by AlexP » Fri 07 Mar 2014 09:38

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

Post Reply