Hi, I've got the following problem:

I have in my XSD document a TableAdapter with several queries in it. One of them is a query in which I replace null-values by another value (like: ISNULL(field_name,'value') AS field_name).

All is well to this point, but when I reconfigure the 'standard' GetData() query of that TableAdapter (for example because I have added a new field in the TableAdapter), the ISNULL's are gone! This is really a problem, because in that case several queries should be checked to see if they are all still correct.

Does anyone else have this problem? Or better: a solution?

Thanks.

Hello my friend,

A solution would be to have your query in a View and then base your TableAdapter on the View. 

Kind regards

Scotty