SQL query with datareader or dataadapter

[DaveRook]

Hello

One of my colleagues has done this in vbscript. His code within the recordset is

"SELECT DISTINCT (ProductNumber), NoOfContacts, Height, Style, Type FROM view WHERE ProfileHeight between 3.0 and 3.9"

How can he be calling the column ProfileHeight when it is not declared?

I am trying to do this in C#, and I can't - if it goes to the dataapater it fails because it wants the column ProfileHeight to be declared.

Any ideas?

[Oralloy]

Dave,

Try asking the first questions first - does his code actually work?

Assume it does. Then the next question is if you and he are looking at the same "view".

If not, sort that out.

If, however, the view is the same, then I'm as confused as you are.

Luck!

[DaveRook]

Hello

His code works perectly.

The view and my view are pretty much the same (different data) but the actual set up is identical.

[Oralloy]

Dave,

It sounds like his view has a ProfileHeight field, where yours doesn't.

Is there any way you can do something like "SELECT * FROM view" on his system and see what fields are actually there?

[DaveRook]

Hi

Had another look.

It appears when you build a recordset or dataadapter, the where clause ignores what columns appear in your select command and looks at the columns available on the actual view on SQL.

I've managed to replicate this now with my C# code and it is fine.

Thank you

[Oralloy]

Good on you, and good luck with your assignment.