hello..

is it possible to read Major and Minor version of a table by a Query ??
which is the SQL command ?

thanks.
Davide.

Davide,

<< is it possible to read Major and Minor version of a table by a Query ??
which is the SQL command ? >>

Unfortunately, no.  You have to use the TDBISAMTable component to do so.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:F92A7E79-984B-4F51-A471-335AA8DA29EB@news.elevatesoft.com...
> Davide,
>
> << is it possible to read Major and Minor version of a table by a Query ??
> which is the SQL command ? >>
>
> Unfortunately, no.  You have to use the TDBISAMTable component to do so.
>

No big deal, Tim, but if you ever have a few days of nothing to do, it would
be useful to me to get that info using SQL.

Robert

You could write a Custom Function that would return this info into SQL quite
easily.


"Robert" <ngsemail2005withoutthis@yahoo.com.ar> wrote in message
news:90232C55-EC06-4C70-8609-EE9943388BBA@news.elevatesoft.com...
>
> "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
> news:F92A7E79-984B-4F51-A471-335AA8DA29EB@news.elevatesoft.com...
>> Davide,
>>
>> << is it possible to read Major and Minor version of a table by a Query
>> ?? which is the SQL command ? >>
>>
>> Unfortunately, no.  You have to use the TDBISAMTable component to do so.
>>
>
> No big deal, Tim, but if you ever have a few days of nothing to do, it
> would be useful to me to get that info using SQL.
>
> Robert
>

Clive,

<< You could write a Custom Function that would return this info into SQL
quite easily. >>

Damn, even I keep forgetting to suggest custom functions for this type of
thing.

--
Tim Young
Elevate Software
www.elevatesoft.com

I was just passing by this, and thinking that it would be good to have a
standard name for some of these so people could share them, and then
thinking that would be silly, when I realised that I haven't a clue how
I'd create the SQL to do this.

The basic custom function would be easy - let's say I wanted one to
generate the Blue Cheese result for a value:

SELECT BlueCheese(MyColumn)
FROM MyTable

But if I wanted to know the table version, how would I structure it? Would
it be as simple as:

SELECT TableVersionMajor(), TableVersionMinor()
From MyTable

If so, wouldn't that get a row for each row in the table?

/Matthew Jones/

Matthew,

<< Would  it be as simple as:

SELECT TableVersionMajor(), TableVersionMinor()
From MyTable

If so, wouldn't that get a row for each row in the table?  >>

Yes, but you can just use MaxRowCount=1 when you run the query and it will
quit after one row.  It won't be an issue for long, anyways, since with
ElevateDB you can just do this:

SELECT UserVersion
FROM System.Tables
WHERE DatabaseName='Test' AND TableName='MyTable'

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks!

/Matthew Jones/