InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumTue, 09 Jun 2026 07:00:29 GMT20http://forum.strataframe.net/FindPost8790.aspxThis may be old news to everyone else, but it caused me enough frustration I thought I'd mention it here :)<br> <br> The samples that come with StrataTrain ( the third party training video series ) not only use SF 1.4 and must be fiddled with before they can run ( by the newbies who are least qualified to do so :w00t: ) but somewhere along the way field names were changed by SF in the sample database so any control bound to cust_lname or cust_fname property will cause an error.<br> <br> For notes on the fiddling see the thread here "Update Training Videos" ( persevere to the end ) There is a mention there of the field name change, but the solution of running the BO mapper only changes the properties created in the partial class. The form controls must be manually set to the correct field names.<br> <br> I know how frustrating it is for everyone when you are in overwhelmed newbie mode and samples don't work, so I thought I share this.<br> <br> I think there may be another vestige of this change, BTW, in the FillbyLastName() method in the VB Winform Tutorial <br> <br> [codesnippet]Public Sub FillByLastName(ByVal LastName As String)<br> '-- Establish locals<br> Dim loCommand As New SqlCommand()<br> '-- Build the query<br> loCommand.CommandText = "SELECT * FROM Customers WHERE cust_lname = @cust_lname"<br> '-- Add the parameter<br> loCommand.Parameters.Add("@cust_lname", SqlDbType.NVarChar)<br> loCommand.Parameters("@cust_lname").Value = LastName<br> '-- Execute the command to fill the business object<br> Me.FillDataTable(loCommand)<br> End Sub<br> [/codesnippet]<br> note the [b]cust_lname [/b]= @cust_lname<br>Tue, 15 May 2007 10:31:08 GMTCharles R Hankeyhttp://forum.strataframe.net/FindPost8808.aspxThanks for the info Charles!Tue, 15 May 2007 10:31:08 GMTGreg McGuffey