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


I can't open a Advantage Database view with sql

Posted on 2009-04-30
Medium Priority
Last Modified: 2012-05-06
I made a view in advantage architect, I'm able to open it in architect just fine but when I type: SELECT *
FROM view1

I get an error.

what can I do?

my other views work as normal.
AdsQuery1: Error 7200:  AQE Error:  State = 42000;   NativeError = 2228;  [iAnywhere Solutions][Advantage SQL Engine]Invalid view definition: View1. Unexpected token after the 
view statement.

Open in new window

Question by:yankel1
  • 2
LVL 22

Accepted Solution

8080_Diver earned 2000 total points
ID: 24276349
Look carefully at the text of your view statement.  THe error message is indicating that something is not quite right after the view statement.  You might have a doubled up semicolon (been there, done that ;-) or something like that.  If nothing else, compare the end of the failing view with the end of a working view.  

Author Comment

ID: 24276351
but I'm able to open the view in architect that means the view is good!

also this view worked in the past!
LVL 22

Expert Comment

ID: 24279634
Let me repeat my point:
The error message in you original post indicates that there is a problem with something following the end of the SQL statement in the view.  Normally, error messages such as this are generated because of extraneous (often non-displayable) characters following the desired SQL statement.  They are not randomly generated.
Try highlightinh and copying the SQL in the View to a Notepad window, deleting the viewentirely, and then highlighting the text in the Notepad window and using it to create a new view.
Cycling the text of the SQL through Notepad will most commonly remove any extraneous trailing (non-displayable) characters.
also this view worked in the past!
So, what changed?  Did you modify the view at some point (immediately prior to it starting to fail?).  

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Blockchain technology enhances society similar to the Internet. Its effects are broad, disruptive, and will boost global productivity.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

581 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