Hello

LLBLGen Pro 2.0 - Adapter

Given variables XLoc, YLoc, ZLoc, DD, ClientID, ZoneID, and RefMeterMeshDeviceID. And fields from A table X, Y, Z, ClientID, ZoneID.

I want to perform the LLBLGen equivalent of:

SELECT TOP 20 * FROM tblDeviceData as A WHERE (((A.X-XLoc)(A.X-X.Loc) + (A.Y-YLoc)(A.Y-YLoc) + (A.Z-ZLoc)(A.Z-ZLoc)) <= DD)* AND A.ClientID = ClientID AND A.ZoneID = ZoneID

Specifically, I am interested in how to represent the where clause phrase highlighted in bold.

Could you please point me in the right direction?

Thank you, BV

Thats an 'expression' so you should use an Expression in the where, and from the looks of it, it looks like you'd need a FieldCompareExpressionPredicate, whree you compare DD with the expression in bold and the >= operator.

See for more info about expressions the section 'Field expressions and aggregates' for examples and more info.