accessin Summary Table
Hi All,
I'm writing a CUB file checking Title and Subject in Summary table as per my company standards. But I'm unable to get the SQL queried record set.
I'm using the following code :
Set View = Database.OpenView("SELECT * FROM `Summary`")
View.Execute
Records = View.Fetch
After the 2nd line my function exists without error. Is Summary table not accessible for such queries. Someone told me to use MsiSummaryInfoGetProperty function. I'm not sure how to use it. Please advise
I'm writing a CUB file checking Title and Subject in Summary table as per my company standards. But I'm unable to get the SQL queried record set.
I'm using the following code :
Set View = Database.OpenView("SELECT * FROM `Summary`")
View.Execute
Records = View.Fetch
After the 2nd line my function exists without error. Is Summary table not accessible for such queries. Someone told me to use MsiSummaryInfoGetProperty function. I'm not sure how to use it. Please advise
0 Comments
[ + ] Show comments
Answers (3)
Please log in to answer
Posted by:
spartacus
15 years ago
The sample script WISumInf.vbs from the Microsoft Platform SDK could give you some clues as to how to access / modify the Summary Information stream. However, as you mention that you are developing a CUB file, I would imagine the VB Script for this particular ICE would look something like
Regards,
Spartacus
'Checks the Summary table for the appropriate Title and Subject
Function SumInf()
On Error Resume Next
Set recInfo = Installer.CreateRecord(1)
If Err <> 0 Then
SumInf=1
Exit Function
End If
Set sInfo = Session.Database.SummaryInformation
sTitle = sInfo.Property(2)
sSubject = sInfo.Property(3)
'Enter your code to check the Title and Subject against defined standards below
'**
'**
'**
SumInf=1
Exit Function
End Function
Regards,
Spartacus
Posted by:
upkaar
15 years ago
Hi Spartacus,
This works so wonderfully... Thank you so much! :)
Also, came to know Summary table does not exists... It's in GUI.
Regards,
Upkar
This works so wonderfully... Thank you so much! :)
Also, came to know Summary table does not exists... It's in GUI.
Regards,
Upkar
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.