| Subject | Re: [firebird-support] Re: Error defining a Firebird view in VFP |
|---|---|
| Author | Anderson Farias |
| Post date | 2011-02-23T20:23:02Z |
Hi,
|Must add that, if Firebird became "SQL 2008 compliant" in this regard at
|some point, it is undocumented. So, if you would be so kind, please
|prepare a test case demonstrating that you are able to get away with
|ORDER BY in a view definition, without encountering an "Unknown token:
|ORDER" error at commit, and submit it to the Tracker.
Well, I could easily confirm that (with FB 2.1) one can create a VIEW with an ORDER BY clause without problems.
I could not, though, reproduce any "bad" behavior on a view containing a an ORDER BY. It's wierd but seems to work (at least for simple views)
Regards,
Anderson
|Must add that, if Firebird became "SQL 2008 compliant" in this regard at
|some point, it is undocumented. So, if you would be so kind, please
|prepare a test case demonstrating that you are able to get away with
|ORDER BY in a view definition, without encountering an "Unknown token:
|ORDER" error at commit, and submit it to the Tracker.
Well, I could easily confirm that (with FB 2.1) one can create a VIEW with an ORDER BY clause without problems.
I could not, though, reproduce any "bad" behavior on a view containing a an ORDER BY. It's wierd but seems to work (at least for simple views)
Regards,
Anderson