(Using v 1.0.2005.1 Final, Sql server 2000 and adapter)

Bug:

When producing a dynamic list with a between clause this is the sql created... SELECT xxx FROM [ccc6_skv].[dbo].[shifts] AS [Shift]
WHERE ( [ccc6_skv].[dbo].[shifts].[shift_id] BETWEEN 1 AND 2)

The SQL Server raises an error. The t-sql should use the alias in the where cluase, something like this... SELECT xxx FROM [ccc6_skv].[dbo].[shifts] AS [Shift]
WHERE ( [shift].[shift_id] BETWEEN 1 AND 2)

Could you please tell us what runtime libraries version you are using.

What's the code you've used for the dynamic list and the call ? Because you have to specify the ObjectAlias in the FieldBetweenPredicate if you alias the entity in the relations.

(edit): Either set the field's ObjectAlias to the alias of the entity or the predicate's ObjectAlias to the alias of the entity. But without code it's guesswork

Otis wrote:

What's the code you've used for the dynamic list and the call ? Because you have to specify the ObjectAlias in the FieldBetweenPredicate if you alias the entity in the relations.

(edit): Either set the field's ObjectAlias to the alias of the entity or the predicate's ObjectAlias to the alias of the entity. But without code it's guesswork

Yes. Sorry. I assumed the defineField sub internally would fix it, but obviously I was wrong.

RK wrote:

Otis wrote:

What's the code you've used for the dynamic list and the call ? Because you have to specify the ObjectAlias in the FieldBetweenPredicate if you alias the entity in the relations.

(edit): Either set the field's ObjectAlias to the alias of the entity or the predicate's ObjectAlias to the alias of the entity. But without code it's guesswork

Yes. Sorry. I assumed the defineField sub internally would fix it, but obviously I was wrong.

Yes, because there you define the entity alias you specify for entities in the relations (if any) passed to the fetch method. Normally, you don't need to alias entities and therefore don't need to specify an alias for the entity in the DefineField . Only alias entities if you specify multiple times the same entity in the relations.