Why If I use this code it always return that the data is not finded?

        If BoReport1.Seek("report_nbr='12'") Then
            '-- Ensure the product is active
            MsgBox("Report 11 found")
            'ProductsBO1.prod_isactive = True
        Else
            MsgBox("Report 11 not founded")

        End If

Even the record exist in the table

Hi Javier.

If report_nbr is a character type, it should work, if it is an integer, for example, you should use:

        If BoReport1.Seek("report_nbr = 12") Then
            MsgBox("Report 12 found")
        Else
            MsgBox("Report 12 not found")
        End If

Thanks, the field is a string....But Edhy show me that the BO has to be filled before it can be used, I thought the BO look for the data directly to the table.

Thanks

In VFP, yes, but not in SF BO.  StrataFrame Business Objects are very well though and designed and when used properly you can do miracles.  Some of their methods are designed to manipulate their internal data table (you could compare this to a VFP table alias), so the Seek() method is one of them that will look for the first record that matches the WHERE condition, so its name may be familiar to VFP developers but in reality is not the same.

For more detail explanation, please take a look at the StrataFrame help file topic from where you got the sample code.

Edhy Rijo

Ok Thanks Edhy,

I will do that.