Using order by in a view
Using order by in a view
(OP)
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
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
Talk To Other Members
RE: Using order by in a view
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:
CODE
select * from view1
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Using order by in a view
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
RE: Using order by in a view
select * from ME order by "SUND__B6Price_Table"
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com