Using order by in a view

[rewob65]

I am new to sql but pasted the sql from cystal into a pervasive sql command and it ran.

I then made it into a view and it does not like the "order by". Does order by work in pervasive sql views or is there another way?

Thanks

 

[mirtheil]

What version of PSQL are you using?
What's the exact error being returned?
How are you creating the view (what's the actual SQL statement)?
The following works for me using PSQL v10.10:

create view view1 as select * from class order by name#
select * from view1

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[rewob65]

Version 9.00.066.000

The View is :-

CREATE VIEW ME AS
SELECT "SUND__B6Price_Table"."PTABPrice_Table_No", "SUND__B6Price_Table"."DESCDescription"
FROM "SUND__B6Price_Table" "SUND__B6Price_Table"
ORDER BY "SUND__B6Price_Table"."PTABPrice_Table_No

and the error shows first a load of text about links then:-

order<<???>> By "SUND__B6Price_Table"

This is just a simple report but seems to dislike the order function. I have read the order can be in the select area but I do not understand the syntax

 

[mirtheil]

According to the documentation (

http://www.pervasive.com/library/docs/psql/950/sqlref/sqlref-04-27.html),

Views cannot contain ORDER BY clauses in PSQL v9.x. They are supported in v10.x. You should be able to add the ORDER BY when running the view:
select * from ME order by "SUND__B6Price_Table"

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com