Thanks Ben.

Tim

The latest DLLs have been posted here: http://forum.strataframe.net/FindPost11975.aspx

Yes, it should be fixed in the current version.   It's checking on parent.IsEmpty and either clearing or returning the data table according to whether it is a Get or a Fill.  Should be in 6.2.

Did this problem get resolved in the latest release?  I'm getting an error using FillByParent when the Parent business object is empty. 

Thanks,
Tim

Yes, if there are no rows in the parent business object then a FillByParent() should just clear the child business object (since there are no rows to match the parent).  Thanks for the info... I'll make sure that gets fixed.

If a business object calls its FillByParent() method and the parent's CurrentView contains no rows, the SQL statement that is built will not be properly formatted and a SQLException will be thrown ("incorrect syntax...").  If the parent business object's CurrentDataTable has at least one row, the problem can be worked around by blanking out the RowFilter property of the parent's CurrentView before calling FillByParent() and then reestablishing it after FillByParent() completes.  If you have any questions, let me know.