StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Error executing Search code

Error executing Search code

Robert Carl Johnson — Fri, 06 Jul 2007 17:25:17 GMT

Hi all. I have incorporated search in my maintenance forms using the technique from the turorial 6. Upon running I get an error:

{"Invalid object name 'tlbBarelLength'."}

Code under my search button:

Me.BarrelLgtnBO1.FillByLength(Me.txtSearch.Text)

My BO code:

Public Sub FillTop100()
Me.FillDataTable("Select TOP 100 * FROM tblBarelLength")

End Sub

Public Sub FillByLength(ByVal BarrelLength As String)
'-- Estabish Locals
Dim loCommand As New SqlCommand

'-- Build the query
loCommand.CommandText = "SELECT * FROM tlbBarelLength WHERE Length = @length"

'-- Add the parameter
loCommand.Parameters.Add("@length", SqlDbType.VarChar)
loCommand.Parameters("@length").Value = BarrelLength

'-- Execute the command to fill the business object
Me.FillDataTable(loCommand)
End Sub

Now the if the FillTop100 code works which is calling the same table object why is the FillByLength code inop?

Lost In Ventura....:pinch:

Regards,

Robert

RE: Error executing Search code

Robert Carl Johnson — Fri, 06 Jul 2007 17:25:17 GMT

I'm sure he is... Everyone here has been good to me.. helping me along even on weekends. When I get up to speed I'll do my best to help others. In the mean time... lol.

Robert

RE: Error executing Search code

Ben Hayat — Fri, 06 Jul 2007 17:10:42 GMT

[quote][b]Robert Carl Johnson (07/06/2007)[/b][hr]You can count on it Greg, assuming I know the answer.. lol. :D

Robert[/quote]

Greg, is a good man!

RE: Error executing Search code

Robert Carl Johnson — Fri, 06 Jul 2007 16:38:30 GMT

You can count on it Greg, assuming I know the answer.. lol. :D

Robert

RE: Error executing Search code

Greg McGuffey — Fri, 06 Jul 2007 16:22:58 GMT

No problem...I've had a few of those kind of days myself. It's good to have the forum here to help us during those trying times! Hope you'll do the same for me some day! :D

RE: Error executing Search code

Robert Carl Johnson — Fri, 06 Jul 2007 12:43:02 GMT

I gotta tell you, the day started out with dumping coffee on my keyboard and it's been downhill since then.. um thanks Greg for spotting what I would have taken me all day to see.. :blush:

Regards,

Robert

RE: Error executing Search code

Greg McGuffey — Fri, 06 Jul 2007 12:18:10 GMT

Table name is misspelled in second fill method (FillByLength)

[quote]{"Invalid object name 'tlbBarelLength'."}[/quote]
indicates you misspelled the table name.

[codesnippet]Public Sub FillByLength(ByVal BarrelLength As String)
....
'-- Build the query
loCommand.CommandText = "SELECT * FROM tlbBarelLength WHERE Length = @length" <-- should be tbl not tlb
.....
End Sub
[/codesnippet]