Hi,

when I would like to get a single value from the database, based on filter criteria, not using any aggragate functions, for example

select CustomerName where CustomerNo = '123'

while customerNo is the PK. I only need the customerName as read only. Is the best way using a simple ResultSetFields? Doesn't this mean extra work? Is there a simple function that gets a single value from the DB? I am using Selfservicing at the moment.

Gr.,

G.I.

Use a scalar query, using GetScalar() on either an entitycollection (selfservicing) or DataAccessAdapter (adapter).

OK, I'm using selfservicing, but I just have a filter, not an expression, and not an aggregate function, but when I fill 'null' for both I get an error that aggregate function cannot be null, what should I do in this case?

G.I. wrote:

OK, I'm using selfservicing, but I just have a filter, not an expression, and not an aggregate function, but when I fill 'null' for both I get an error that aggregate function cannot be null, what should I do in this case?

Fill in AggregateFunction.None