unable to create this query

[Nobody/Anonymous]

select id from employees where parentid is null

[Richard Banks]

1. Create a CRetrieveCriteria and use CEmployees as the classmap.

2. Add a selectequalto to the where condition and pass parentid as the attribute and Nothing as the value (vb syntax).

Eg:
Dim rc as new CRetrieveCriteria
rc.ClassMap = emp.getClassMap
rc.WhereCondition.addSelectEqualTo("ParentID",Nothing)

- Richard.