|
| | | StrataFrame Beginner
 
Group: Forum Members
Last Login: 08/30/2007 12:05:52 PM
Posts: 31, Visits: 199 |
| | 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. |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: 04/30/2008 4:02:12 PM
Posts: 2,647, Visits: 1,861 |
| 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.
www.bungie.net |
| |
| | | StrataFrame User
Group: StrataFrame Users
Last Login: 05/15/2008 9:43:25 AM
Posts: 304, Visits: 1,198 |
| | 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 |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: 04/30/2008 4:02:12 PM
Posts: 2,647, Visits: 1,861 |
| 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.
www.bungie.net |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: 04/30/2008 4:02:12 PM
Posts: 2,647, Visits: 1,861 |
| | |
| | | StrataFrame User
Group: StrataFrame Users
Last Login: 05/15/2008 9:43:25 AM
Posts: 304, Visits: 1,198 |
| | |
| | | StrataFrame User
Group: StrataFrame Users
Last Login: 05/15/2008 9:43:25 AM
Posts: 304, Visits: 1,198 |
| | Sorry Ben, Just want to clarify. Does the code found in the above link solve this problem or do I have to wait until 1.62. I downloaded and installed the updates (copied to my GAC), but I still get an error with the FillByParent. I'm just wondering if my problem isn't related to this one. Tim |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: 04/30/2008 4:02:12 PM
Posts: 2,647, Visits: 1,861 |
| Hrm, yeah, those DLLs have the fix for FillByParent when the parent is empty. So, if you're still getting the error, then yes, it might be unrelated. Could you post the details for the exception that you're receiving?
www.bungie.net |
| |
| | | StrataFrame User
Group: StrataFrame Users
Last Login: Today @ 2:40:45 PM
Posts: 305, Visits: 1,197 |
| | Hi Ben, Can/should we all download those DLLs, or will it be an official release shortly to keep everybody in synch? Thanks!
Edhy RijoProgytech (Computer Consultants) |
| |
|
|