Re: Looking for Version in System Tables

In article <326F5FEE.3055@airmail.net>, Partha Dutta <pdutta@airmail.net> writes >PairOShoes wrote: >> >> Is the version string ('Online Dynamic Server 7.12.UC1') stored in any of >> the system tables? If so, where? >> >> Thanks, >> >> Lee > > >I don't believe that string is stored in the system tables. The closest >possibility is the version number, which can be found in systables: > > select * > from systables > where tabid = 99;> >I think the owner field will have the version of the engine. > >Partha Dutta >pdutta@airmail.net It is not stored anywhere. The version in systables is not neccessarily 'correct'. It only appears to change when a significant version number change happens which changes the structure of the system tables E.g. v5.xx -> v 7.xx. -- David Williams