SQL Statement returns no rows

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ccmcbride
Posts: 101
Joined: Tue 01 May 2007 16:36

SQL Statement returns no rows

Post by ccmcbride » Thu 25 Sep 2014 18:58

using MSSQL 2012, sdac 6.11.22, Delphi XE6
Cannot recreate at will, as restoring, restarting, and following same exact steps returns no errors.
Also, shouldn't it be 'okay' to not return rows? doesn't that just mean the result is empty?

exception message : SQL statement doesn't return rows.

main thread ($56c0):
0088310e +0de SME5.exe Data.DB 3245 +10 DatabaseError
00c24d9d +191 SME5.exe OLEDBAccess TOLEDBRecordSet.CreateFieldDescs
00b310cb +073 SME5.exe MemData TData.InternalInitFieldDescs
00bbdc2f +023 SME5.exe CRAccess TCRRecordSet.InternalInitFieldDescs
0040f420 +010 SME5.exe System 35702 +10 @IntfClear
00b302a3 +007 SME5.exe MemData TData.InitFields
00b3a275 +005 SME5.exe MemData TMemData.InitFields
00bbd3b8 +030 SME5.exe CRAccess TCRRecordSet.CheckFieldDescs
00bbd5f6 +036 SME5.exe CRAccess TCRRecordSet.ExecFetch
00bbb75b +11f SME5.exe CRAccess TCRRecordSet.InternalOpen
00c20dec +0a0 SME5.exe OLEDBAccess TOLEDBRecordSet.InternalOpen
00b2ffa4 +034 SME5.exe MemData TData.Open
00b300b8 +00c SME5.exe MemData TData.Reopen
00b3a215 +005 SME5.exe MemData TMemData.Reopen
00bbb98a +06e SME5.exe CRAccess TCRRecordSet.Reopen
00c2152f +067 SME5.exe OLEDBAccess TOLEDBRecordSet.Reopen
00be2770 +044 SME5.exe DBAccess TCustomDADataSet.DataReopen
00c5b2ac +07c SME5.exe MSAccess TCustomMSDataSet.DataReopen
00be4cbc +18c SME5.exe DBAccess TCustomDADataSet.RefreshDetail
00b55c89 +06d SME5.exe MemDS TMemDataSet.MasterRecordChanged
00b4f83d +05d SME5.exe MemDS TDADetailDataLink.RecordChanged
00892f80 +004 SME5.exe Data.DB 10496 +0 TDataLink.DataSetChanged
00892f3a +0ba SME5.exe Data.DB 10472 +19 TDataLink.DataEvent
008932eb +043 SME5.exe Data.DB 10743 +3 TDataSource.NotifyLinkTypes
00893311 +011 SME5.exe Data.DB 10749 +2 TDataSource.NotifyDataLinks
0089334b +023 SME5.exe Data.DB 10758 +4 TDataSource.DataEvent
0089a57c +17c SME5.exe Data.DB 13669 +46 TDataSet.DataEvent
00b58af0 +020 SME5.exe MemDS TMemDataSet.DataEvent
00be7872 +00a SME5.exe DBAccess TCustomDADataSet.DataEvent
0089a623 +04f SME5.exe Data.DB 13697 +7 TDataSet.EnableControls
00be4d88 +258 SME5.exe DBAccess TCustomDADataSet.RefreshDetail
00b55c89 +06d SME5.exe MemDS TMemDataSet.MasterRecordChanged
00b4f83d +05d SME5.exe MemDS TDADetailDataLink.RecordChanged
00892f80 +004 SME5.exe Data.DB 10496 +0 TDataLink.DataSetChanged
00892f3a +0ba SME5.exe Data.DB 10472 +19 TDataLink.DataEvent
008932eb +043 SME5.exe Data.DB 10743 +3 TDataSource.NotifyLinkTypes
00893311 +011 SME5.exe Data.DB 10749 +2 TDataSource.NotifyDataLinks
0089334b +023 SME5.exe Data.DB 10758 +4 TDataSource.DataEvent
0089a57c +17c SME5.exe Data.DB 13669 +46 TDataSet.DataEvent
00b58af0 +020 SME5.exe MemDS TMemDataSet.DataEvent
00be7872 +00a SME5.exe DBAccess TCustomDADataSet.DataEvent
0089b139 +0b1 SME5.exe Data.DB 14215 +23 TDataSet.First
00eff3b0 +0e4 SME5.exe AdvGlowButton 6860 +14 TDBAdvGlowButton.DoAction
00eff27c +014 SME5.exe AdvGlowButton 6824 +2 TDBAdvGlowButton.Click
005c7939 +065 SME5.exe Vcl.Controls 7487 +7 TControl.WMLButtonUp
00ef8c2e +39a SME5.exe AdvGlowButton 3726 +125 TAdvCustomGlowButton.WMLButtonUp
005c6f39 +2bd SME5.exe Vcl.Controls 7232 +91 TControl.WndProc
005cba51 +5c9 SME5.exe Vcl.Controls 10047 +153 TWinControl.WndProc
005cb098 +02c SME5.exe Vcl.Controls 9759 +3 TWinControl.MainWndProc
0077efdb +007 SME5.exe cxControls TcxWindowProcLinkedObject.DefaultProc
00e119ed +019 SME5.exe dxLayoutContainer TdxLayoutItem.ControlWndProc
0077f25b +007 SME5.exe cxControls TcxWindowProcLinkedObjectList.WndProc
005cb098 +02c SME5.exe Vcl.Controls 9759 +3 TWinControl.MainWndProc
005485d4 +014 SME5.exe System.Classes 17066 +8 StdWndProc
75727885 +00a USER32.dll DispatchMessageW
006e3f53 +0f3 SME5.exe Vcl.Forms 10351 +23 TApplication.ProcessMessage
006e3f96 +00a SME5.exe Vcl.Forms 10381 +1 TApplication.HandleMessage
006e42c9 +0c9 SME5.exe Vcl.Forms 10519 +26 TApplication.Run
024aa5f9 +069 SME5.exe SME5 193 +7 initialization
76b43388 +010 kernel32.dll BaseThreadInitThunk

azyk
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: SQL Statement returns no rows

Post by azyk » Fri 26 Sep 2014 07:54

We couldn't reproduce the problem. Please try to compose a small sample to demonstrate the problem and send it to andreyz*devart*com.

Post Reply