Parent - Child BO and Trying to Update Child

StrataFrame Forum

Back

Parent - Child BO and Trying to Update Child

Author	Message
Terry Bottorff	Terry Bottorff posted 15 Years Ago HOT Topic Details Share Topic
Group: Forum Members Posts: 448, Visits: 12K	If EventEntriesRodeoBO1.MoveFirst Then For Each loRodeo As EventEntriesRodeoBO In Me.EventEntriesRodeoBO1.GetEnumerable Select Case EventEntriesRodeoBO1.eventCD Case "BB" ContestantsRodeoBO1.EventBB = EventEntriesRodeoBO1.eventCD Case "BR" ContestantsRodeoBO1.EventBR = EventEntriesRodeoBO1.eventCD End Select Next End If ContestantsRodeoBO1.Save()ContestantsRodeoBO1.Save() I am trying to iterate thru the parent(evententriesrodeobo1) and update a column in the child(contestantrodeobo1). This code is called from the click of a button on a form. Please note the attached screenshots. The parent child relationship works on the form so what am I missing in the code? I have traced the code and it seems to be doing what I need it to do except the data does not end up in the child in the database????? I must be brain dead since this seems to be trivial BUT.?????? TIA Attachments ScreenShot003.gif (165 views, 21.00 KB) ScreenShot004.gif (174 views, 14.00 KB)
	Reply Like 0
Replies
Greg McGuffey	Greg McGuffey posted 15 Years Ago Post Details Share Post
Group: Forum Members Posts: 2K, Visits: 6.6K	Hmmm....this didn't work for me. I typed in some text into notepad, selected all, copied into codesnippet (tried a quote too)...indentation was lost. You have some fancy-mancy notepad?
	Reply Like 0
Ivan George Borges	Ivan George Borges posted 15 Years Ago Post Details Share Post
Group: StrataFrame MVPs Posts: 1.9K, Visits: 21K	Oh, never thought of that... I use Notepad2.exe (http://www.flos-freeware.ch/notepad2.html). It was recommended to me by Sir Steve Taylor.
	Reply Like 0
Greg McGuffey	Greg McGuffey posted 15 Years Ago Post Details Share Post
Group: Forum Members Posts: 2K, Visits: 6.6K	I just tried out notepad2 and it's not keeping tabs/extra spaces either. Could there be some setting I'm missing? Or maybe this works with Vista/Win7 and not XP?
	Reply Like 0
Bill Cunnien	Bill Cunnien posted 15 Years Ago Post Details Share Post
Group: Forum Members Posts: 785, Visits: 3.6K	I went the notepad2 route, also. Here is my pasting of code from notepad2 which was originally from VS2k8: public partial class Invoicing_Export : Aspire.UI.Windows.Forms.AspireBaseForm { public Invoicing_Export() { InitializeComponent(); } } How does that look?
	Reply Like 0
Bill Cunnien	Bill Cunnien posted 15 Years Ago Post Details Share Post
Group: Forum Members Posts: 785, Visits: 3.6K	Not so good... I am on W7 64bit. public partial class Invoicing_Export : Aspire.UI.Windows.Forms.AspireBaseForm { public Invoicing_Export() { InitializeComponent(); } } This is the same code with the non-breaking spaces included.
	Reply Like 0
Bill Cunnien	Bill Cunnien posted 15 Years Ago Post Details Share Post
Group: Forum Members Posts: 785, Visits: 3.6K	Annoyingly pragmatic.
	Reply Like 0
Ivan George Borges	Ivan George Borges posted 15 Years Ago Post Details Share Post
Group: StrataFrame MVPs Posts: 1.9K, Visits: 21K	I can sell copies of mine... non-refundable.
	Reply Like 0
Greg McGuffey	Greg McGuffey posted 15 Years Ago Post Details Share Post
Group: Forum Members Posts: 2K, Visits: 6.6K	Oh, I bet I know the diff. Yours is probably in Portuguese.
	Reply Like 0
Bill Cunnien	Bill Cunnien posted 15 Years Ago Post Details Share Post
Group: Forum Members Posts: 785, Visits: 3.6K	Narf!
	Reply Like 0
Terry Bottorff	Terry Bottorff posted 15 Years Ago Post Details Share Post
Group: Forum Members Posts: 448, Visits: 12K	I want to thank everyone for their help on my parent - child problem. It was great help and I learned a great deal. Thanks again I have it working and I understand how to do it next time.
	Reply Like 0
Trent Taylor	Trent Taylor posted 15 Years Ago Post Details Share Post
Group: StrataFrame Developers Posts: 6.6K, Visits: 7K	This is a great community out here. Thanks for all of your contributions!
	Reply Like 0
Greg McGuffey	Greg McGuffey posted 15 Years Ago Post Details Share Post
Group: Forum Members Posts: 2K, Visits: 6.6K	Related to formatting code in the forum. I just found another method. Not as pretty as using Ivan's Portuguese Notepad2, but it saves having to use non-breaking spaces. just put <pre> tags just inside the codesnippet tags. This also doesn't completely fubar your formatting if you use preview. //-- code just typed in via forum editor public class BetterForumEditing : SF.WickedCoolEditor public BetterForumEditing() { this.Property1 = "No reason to set this here..."; } } As you can see, it indents nicely, but there lines are spaces a bit far apart. Not sure which I like best: using non-breaking spaces, using the <pre> tag (which also works without codesnippet too) or learning Portuguese.
	Reply Like 0

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

Threaded View

Parent - Child BO and Trying to Update Child

Terry Bottorff - 15 Years Ago

Have you tried moving the Save() method inside the Select/Case...

Bill Cunnien - 15 Years Ago

Wait...one other thing...

[b]Select Case...

Bill Cunnien - 15 Years Ago

Hi Bill,

There is no need to Edit/Save the BO in each case...

Edhy Rijo - 15 Years Ago

[quote]There is no need to Edit/Save the BO in each case option. The...

Bill Cunnien - 15 Years Ago

Your are welcome Bill. :)

Terry, I just noticed that you...

Edhy Rijo - 15 Years Ago

Edhy beat me to the fix...good job! :D

Bill Cunnien - 15 Years Ago

Hi Terry,

Basically you are not using the correct object...

Edhy Rijo - 15 Years Ago

WOW. Thanks for ALL the QUICK replies...... Let me get a grip on what...

Terry Bottorff - 15 Years Ago

[codesnippet]
If EventEntriesRodeoBO1.MoveFirst Then
...

Terry Bottorff - 15 Years Ago

Interesting. I moved the save() into the loop and it worked. Is that...

Terry Bottorff - 15 Years Ago

Hi Terry,

You have to be very careful when using the...

Edhy Rijo - 15 Years Ago

Sorry I have been so late on this but I have been working on another...

Terry Bottorff - 15 Years Ago

As a follow up. Unless I put the following code after the For each...

Terry Bottorff - 15 Years Ago

Well it is not going to be easy to figure out without a sample, but...

Edhy Rijo - 15 Years Ago

This Child BO is the ContestantsRodeoBO and the parent is the...

Terry Bottorff - 15 Years Ago

Here's what I would do (C#, sorry):

[codesnippet]...

Bill Cunnien - 15 Years Ago

If anyone knows how to get the code spacing/indentation to work...

Bill Cunnien - 15 Years Ago

I just use html non-breaking space code: ampersand nbsp;

Be...

Greg McGuffey - 15 Years Ago

This is what I do: [codesnippet] I usually just edit the code in a...

Ivan George Borges - 15 Years Ago

Hmmm....this didn't work for me. I typed in some text into notepad,...

Greg McGuffey - 15 Years Ago

Oh, never thought of that... I use Notepad2.exe (...

Ivan George Borges - 15 Years Ago

I just tried out notepad2 and it's not keeping tabs/extra spaces...

Greg McGuffey - 15 Years Ago

I went the notepad2 route, also. Here is my pasting of code from...

Bill Cunnien - 15 Years Ago

Not so good... I am on W7 64bit.

[codesnippet]
public...

Bill Cunnien - 15 Years Ago

Annoyingly pragmatic.

Bill Cunnien - 15 Years Ago

I can sell copies of mine... non-refundable. :P

Ivan George Borges - 15 Years Ago

Oh, I bet I know the diff. Yours is probably in Portuguese. :P

Greg McGuffey - 15 Years Ago

Narf!

Bill Cunnien - 15 Years Ago

I want to thank everyone for their help on my parent - child problem....

Terry Bottorff - 15 Years Ago

This is a great community out here. Thanks for all of your...

Trent L. Taylor - 15 Years Ago

Related to formatting code in the forum. I just found another method....

Greg McGuffey - 15 Years Ago

I use Notepad++ which works well with various programming languages....

Russell Scott Brown - 15 Years Ago

Reading This Topic

Login
Remember Me Reset Password Resend Validation Email Login