I am using VS2005 and VB along with version 2.0 of LLBL.

I created a new project and generate the code from my SQL Server DB.

I tried using this code:

        colSavedReports = New SavedReportCollection()
        Dim Filter As IPredicateExpression = New PredicateExpression()
        Filter.Add(Repository.SavedReportFieldIndex.UserID = Functions.User.UserID)
        colSavedReports.GetMulti(Filter)

and I get this error in the designer:

Value of type 'Boolean' cannot be converted to 'SD.LLBLGen.Pro.ORMSupportClasses.IPredicate'.

This error is in the Filter.Add parameter. I am following what I have read in the help file but it's not working. What am I doing wrong?

Can you try

Filter.Add(Repository.SavedReportFields.UserID = Functions.User.UserID)

Note the use of SavedReportFields instead of the FieldIndex. Let us know if this helps.

I tried that and I receive this error:

'SavedReportFields' is not a member of 'Repository'

I can find no collection of fields to use for this form of creating a predicate. I just have the fieldindex like in version 1.

I created this by opening up a Version 1 lgp file, refreshing the catalog, and regenerating fresh code in a new empty directory. I used the Version 1 lgp file to preserve my typed lists.

The *Fields classes are in the <rootnamespace>.HelperClasses namespace, could you please add an Imports statement to the top of the code file which imports that namespace so you can use those classes? Bclubb assumed that Repository is some kind of namespace in your system.

you need 2 equals signs in your predicate, not 1.

colSavedReports = New SavedReportCollection()
Dim Filter As IPredicateExpression = New PredicateExpression()
Filter.Add(Repository.SavedReportFields.UserID == Functions.User.UserID)
colSavedReports.GetMulti(Filter)

jmeckley wrote:

you need 2 equals signs in your predicate, not 1.

colSavedReports = New SavedReportCollection()
Dim Filter As IPredicateExpression = New PredicateExpression()
Filter.Add(Repository.SavedReportFields.UserID == Functions.User.UserID)
colSavedReports.GetMulti(Filter)

The code is VB.NET, which has a single '=' instead of a '==' which is a native C# operator

Yes it's VB so one = works. Thanks, it's working great.

Now I just have to update all my code that creates predicates and does sorting. Shouldn't take too long, I like the new format and I can't wait to try the LLBLGenProDataSource control.