×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Visual Interdev 6.0 - Query Sorting

Visual Interdev 6.0 - Query Sorting

Visual Interdev 6.0 - Query Sorting

(OP)
Yes, I am a Newbie. I have InterDev 6.0 and SQL Server 2000 loaded on my home computer. I don't see the "Sort Order" or "Sort Number" columns in the query grid pane nor do I see the combo box that enables you select the type of query. Can these features be turned on somehow?

Some background on me:
I have created many programs using Microsoft Access. I am trying to learn InterDev 6.0 so I can begin moving my programs to SQL Server.

Thanks for this basic help!!

RE: Visual Interdev 6.0 - Query Sorting

Can you use an ORDER BY clause at the end of your SQL statement?

Also, the SQL Server "Query Analyzer" is a better program to use when hacking at queryies in SQL Server.

RE: Visual Interdev 6.0 - Query Sorting

(OP)
Dear Sheco,

Thanks for the response. I will look into the SQL server query analyzer. I know about using the "order by" clause but I am hoping to find the same query building tool I am very familar with in Microsoft Access. It should be there because... I see it in the books I bought and in the help screens!!! For some reason when I call for a new query, the "sort order" and "sort number columns are not there (along with a combo box that allows you to select the type of query you want to write.

Look at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vdbref/html/dvhoworderingqueryresults.asp

I am going to try to reload/update my software tonight.

Thanks for any additional help.

RE: Visual Interdev 6.0 - Query Sorting

(OP)
I think I answered my own question. The functionality I was looking for was only available when I would right click "add item" to a project from the Project Explorer window. I was in "View Designer" instead of "Query Designer" by mistake.

Thanks anyway.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close