Error filling a child business object


Author
Message
PeterA
PeterA
StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)
Group: Forum Members
Posts: 72, Visits: 235
I'm working on a new application and I have two business objects: PurchaseOrders and PurchaseOrderSchedules. I want to fill the schedules based on all the POs in the parent object, but only for the selected vendor. So I have a drop down populated with vendors for which the user can view POs and in the SelectedIndexChanged event, I have the following:



DataLayer.DataSources[Global.Config["DataSourceKey"]].SetDebugOn("i:\\PSS Design\\Logs\\PO.html", true);

PurchaseOrders.FillByVendorAndTimePeriod(mnuVendor.SelectedValue, 91);

PurchaseOrderSchedules.FillByParent();

DataLayer.DataSources[Global.Config["DataSourceKey"]].SetDebugOff();





I get an IBM DB2 exception because the SQL being generated for the schedule object isn't correct. Attached is the debug file output. It's the second statement that is all wonky. Any suggestions?



Thanks!

Attachments
PO.zip (132 views, 1.00 KB)
Replies
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
but why is it cutting off the SQL when the parent business object is empty?

I am not sure.  If you are using Enterprise Server then I could potentially see some type of network issue.  But if this is all client side, then I really don't know.  I would have to have some type of reproducable sample.  Like anything else, if we can reproduce it we can fix it Smile

PeterA
PeterA
StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)
Group: Forum Members
Posts: 72, Visits: 235
Well, I have a workaround and it involves putting a check I would normally have in there anyway (I'm just in initial stages or writing this program). If I get the chance to write a smaller sample, I'll do that and post it so you all can try and reproduce the same problem.



Thanks!

Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Thanks.  Let me know Smile
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
PeterA - 17 Years Ago
Trent L. Taylor - 17 Years Ago
PeterA - 17 Years Ago
PeterA - 17 Years Ago
Trent L. Taylor - 17 Years Ago
                         Well, I have a workaround and it involves putting a check I would...
PeterA - 17 Years Ago
                             Thanks. Let me know :)
Trent L. Taylor - 17 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search