Is it possible to display the version of the businessspace ?
I expected it should be possible with something like :
DISPLAY MESSAGE Version() .. ?
= Jannes
Display version businesspace
Re: Display version businesspace
here's 1 way
This is a table in your Aware installation database - its that 1st DB you created when you installed aware.
You could write a Stored Procedure to go retrieve this (maybe every night, or based on a trigger on this table) and store it in one of your tables (like SystemSettings), then display that in a banner. Of course that # doesn't mean anything to your users, but if you needed to know this for some reason, this IS the exact # that displays in the Config Tool for that BSV.
The EventType field is for "Published". So you'd want to sort them and get the most recent 1 for the result of the SP.
Code: Select all
SELECT [DNAME]
,[VERSIONSTR]
,[EVENTTYPE]
,[EVENTTIME]
,[DESCR]
FROM [AIM].[dbo].[DVHISTORIES] WHERE DNAME='OEM' and EVENTTYPE=4 order by EVENTTIME
You could write a Stored Procedure to go retrieve this (maybe every night, or based on a trigger on this table) and store it in one of your tables (like SystemSettings), then display that in a banner. Of course that # doesn't mean anything to your users, but if you needed to know this for some reason, this IS the exact # that displays in the Config Tool for that BSV.
The EventType field is for "Published". So you'd want to sort them and get the most recent 1 for the result of the SP.
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL
Re: Display version businesspace
PS: Take a look at this :
https://www.awareim.com/forum/viewtopic ... n+function
https://www.awareim.com/forum/viewtopic ... n+function
Henrik (V8 Developer Ed. - Windows)
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Display version businesspace
Yes, you can use BSV_VERSION()
It's not documented, unfortunately, but we will fix that
It's not documented, unfortunately, but we will fix that
Aware IM Support Team