Error filling a child business object

Author	Message
PeterA	PeterA posted 17 Years Ago Topic Details Share Topic
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 (116 views, 1.00 KB)
	Reply Like 0

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

PeterA - 17 Years Ago

Peter, As much as I would like to give you an answer here, I am...

Trent L. Taylor - 17 Years Ago

I'll see what I can do about creating a small sample. Part of the...

PeterA - 17 Years Ago

Ok. Did some more playing around and it seems that it requires that no...

PeterA - 17 Years Ago

[quote]but why is it cutting off the SQL when the parent business...

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

Login
Remember Me Reset Password Resend Validation Email Login