Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL Query Analyzer

Posted on 2006-04-04
4
Medium Priority
?
1,107 Views
Last Modified: 2008-02-01
Hi:
   I am creating an application in powerbuilder 6.5 and I am using Sybase SQL anywhere as my database. I am creating a datawindow that requires sorting of the data. I tried all means but nothing worked. I was told that I need to create a view

"you create the view under SQL Enterprise Manager. Open the DB you use and in
the objects tab select views. Than create your view with the SQL commands
you have write (you can use SQL Query Analyzer fro creating the SQL command)".

Now what is SQL Query analyzer. I am able to create a view in the database but I am unable to write SQL commands to it. I was told I can SQL Query Analyzer. Where is it? How do I access it? Please help

Thank You
Sushma Sriram


0
Comment
Question by:sushmasriram
  • 3
4 Comments
 
LVL 29

Expert Comment

by:leonstryker
ID: 16371984
>"you create the view under SQL Enterprise Manager. Open the DB you use and in
the objects tab select views. Than create your view with the SQL commands
you have write (you can use SQL Query Analyzer fro creating the SQL command)".

These instructions are for MS SQL Server. Take a look here on how to create a view in ASA:

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbrfen9/00000383.htm

Leon
0
 

Author Comment

by:sushmasriram
ID: 16380972
Where do I write this code? I went to objects and create view. Iselected the tables and the columns I need for the view. But there is no place where I can write the code.
0
 
LVL 29

Accepted Solution

by:
leonstryker earned 2000 total points
ID: 16381003
I am not familiar with Sybase ASA, but this is site the complete reference to using it:

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/

Leon
0
 
LVL 29

Expert Comment

by:leonstryker
ID: 16440504
Thanks for the grade,

Leon
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What happened when I tried to make my phone, a Samsung Galaxy S8, stop dropping all WiFi signals was a saga I won't repeat here, but what you might want to know is how it started and how I got it working again.
Ready to kick start your career in 2018? Add app developer skills to your resume. January’s Course of the Month features Android App Development training with hands-on learning.  Read on to learn why these skills are important.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question