I converted a LLBL project from 1.1 version to 2.6 version. During the conversion every datetime fields are converted and the program removes the precision and the scale to the fields. In this situation I have a problem with smalldatetime because during the construction of a RelationPredicateBucket i pass a date with seconds like '20121101 23:59:59' but the filter that you apply to the database is '20121102 00:00:00'. In the LLBL 1.1 this situation doesn't appeare and the filter in the database becomes '20121101 23:59:00' because the field is a smalldatetime and correctly you remove seconds. Is there a solution to this problem or I only have to correct the value of the fields before to pass it at the RelationPredicateBucket? Thanks in advance for your help.

http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=7722

You are right. You need more information obviously. Sorry me for my fault . I'm using Sql Server 2008 R2 as database with the .NET Framework 3.5. In effect now I'm using the new version of LLBL (3.5 Final) with the adapter template, but the problem is shown already in the conversion from 1.1 to 2.6 (I converted before from 1.1 to 2.6, after that from 2.6 to 3.1 and at the end from 3.1 to 3.5 ). I hope I was clear now, but if I can give you some other information I'll be pleased to tell you. Thanks again

Which (v.2.6) llblgen runtime libraries version are you using? That the build no. and/or file number. Pleas echeck the guidelines.

The version is the 2.6 final released on October 6th, 2008

This is an old build, could you please try the latest available one. Thanks.

I already tried with the 3.5 final version but the problems persists.

The table field types are datetime, or do you use 'date' ? When you trace the query (switch DQE tracing on, see 'troubleshooting and debugging' in the docs) does the parameter show without any time or with time?

You are also sure you don't use any typeconverter?