Member Avatar for hdhere
hdhere 0 Newbie Poster

The following SQL results in an "invalid procedure call" message.

SELECT ViewtimeHCPick1WRes1.X
FROM ViewtimeHCPick1WRes1
where (((ViewtimeHCPick1WRes1.X)>2));

SELECT ViewtimeHCPick1WRes1.X
FROM ViewtimeHCPick1WRes1;

works fine.

ViewtimeHCPick1WRes1 is a query.
X is a calculated field that results in a number of format x.y or x.

Any suggestions as to why the where clause is not working?

  • 1 Contributor
  • 0 Replies
  • 79 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.