StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » FillDataTable returning no records cause an errorInstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumThu, 02 Jul 2026 01:42:26 GMT20FillDataTable returning no records cause an errorhttp://forum.strataframe.net/FindPost29518.aspxI have changed a section of my code recently where I have a this.FillDataTable(loCommand);&nbsp; Now , in some scenarios, this returns no records.&nbsp; This has now caused an error saying currentRowIndex is out of range. I traced this to the get method in the Business Object column.<br/><br/>Why I am I geting this error and what do I need to do to avoid it. I realise it is something to do with zero records being returned Wed, 09 Feb 2011 00:40:50 GMTGer CannollRE: FillDataTable returning no records cause an errorhttp://forum.strataframe.net/FindPost29523.aspxThanks Eddie for the confirmation. <br/><br/>I originally had wriiten the Data Extraction bits months ago and recently changed my searching mecahanism so that no records could be returned. I had forgotten completely about the Navigated Event and was not looking there initially.Wed, 09 Feb 2011 00:40:50 GMTGer CannollRE: FillDataTable returning no records cause an errorhttp://forum.strataframe.net/FindPost29522.aspxHi Gerarld,<br/><br/><div>Yeap, you are right, whenever you use any of the BO properties if there is no record, then it will error out, you should always check for BO.Count &gt;0 to be on the safe side.Tue, 08 Feb 2011 19:39:14 GMTEdhy RijoRE: FillDataTable returning no records cause an errorhttp://forum.strataframe.net/FindPost29521.aspxOK&nbsp; Got this sorted.<br/><br/>I have code in the Navigated Event of the business object which uses one of the properties to fill a child table. I coded around this with an if MyBo.Count &gt; 0 and it seems to have sorted itTue, 08 Feb 2011 09:44:45 GMTGer CannollRE: FillDataTable returning no records cause an errorhttp://forum.strataframe.net/FindPost29519.aspxI set up a brand new project with the same Business Object and issued the same command&nbsp; (this.FilldataTable(locCommand) , which returns no records, but in this project, it behaves as expected, and even though no records are returned, no error message is given.<br/><br/>So there maybe is&nbsp; a property of the BO, or something else on the form is casuing the error ????Tue, 08 Feb 2011 08:23:50 GMTGer Cannoll