Click here to Skip to main content
15,503,579 members

Comments by Mohan Subramani (Top 6 by date)

Mohan Subramani 11-Sep-14 1:37am View    
I got the tips from msdn link, to do SELECT in a MSI database.
(Am using below code to SELECT a Feature named Complete)

View = database.OpenView("SELECT `Feature`.`Feature` FROM `Feature` WHERE `Feature`.`Feature`= 'Complete'")
View.Execute()
database.commit()

fetchDB = View.fetch()
MessageBox.Show(fetchDB)

If (fetchDB = "") Then
MessageBox.Show("This Database doesnt contain Feature 'COMPLETE'")
End If



i get error in the line "MessageBox.Show(fetchDB)" -- Am not able to convert _COMobject ot String
How can i convert the fetch data from dtabase to string to Check whether it is Null or not

Error:

Invalid CaseException was handled.
Conversion from type '_ComObject' to type 'String' is not valid.


Please assist
Mohan Subramani 10-Sep-14 8:42am View    
Thanks for your reply,
I have gone through the documentation. I will use SELECT and INSERT commands seperatly.
I have a question here,
Can i get value of the executing SELECT statement in a binary 1 or Zero value.
For e.g
SQLquery = "SELECT * FROM database WHERE `Feature` = 'Complete'"
View = database.OpenView(SQLquery) ---> This statement to give values 1 if YES, 0 is No

So that i can execute my next INSERT command accordingly ?
Mohan Subramani 8-Sep-14 16:31pm View    
thank you sir.
Mohan Subramani 2-Sep-14 12:46pm View    
Sorry guys, for the incomplete question.
"COMException was unhandled
ApplyTransform, TransformFile,ErrorConditions"

for the line "instDb.ApplyTransform(MSTpath, MsiTransformError.msiTransformErrorViewTransform);"
Mohan Subramani 29-Jun-14 5:41am View    
Not able to post my XML code here .. replacing < > with ? ?


?configuration?

?configSections?
?sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System.Version=2.0.0.0, Culture=neutral, PublicToken=b77a5c5619348089"?

?section name="Timer.Properties.Settings" type="System.Configuration.ApplicationSettingsGroup, System.Version=2.0.0.0, Culture=neutral, PublicToken=b77a5c5619348089" requirePermission="false"/?
?/sectionGroup?
?/configSections?

?applicationSettings?
?Timer.Properties.Settings?
?settings name="DefaultTimer" serializeAs="String"?
?value?90?/value?
?/settings?


?/Timer.Properties.Settings?
?/applicationSettings?
?startup?
?supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" /?
?/startup?
?/configuration?