Views in P.Sql v7?

[dgillz]

Are views available in P.Sql v7? I'd like to create a view in order to simplfy a crystal report.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[mirtheil]

Well, there's really two PSQL v7s.. There was PSQL v7 that used Scalable SQL 4.0 and was versioned as PSQL v7.0. Then there was PSQL 2000 which started as v7.50 (and went to 7.51, 7.52, 7.82, 7.9, and 7.94).

Both supported Views using the CREATE VIEW statement.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[dgillz]

OK, Now I am at my customer's location and I cannot find the v7 equivalent of Pervasive Control Center. Where do I go to create my view?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[mirtheil]

If it's Scalable SQL 4 (PSQL v7.0) then it's called SQLScope. If it's PSQL 2000, it's still the PCC but there was a SQLDM.EXE as well.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com