Jump to content


This is a ready-only archive of the InstallSite Forum. You cannot post any new content here. / Dies ist ein Archiv des InstallSite Forums. Hier können keine neuen Beiträge veröffentlicht werden.
Photo

Windows Installer SQL syntax


2 replies to this topic

AntonS

AntonS
  • Full Members
  • 94 posts

Posted 06 August 2004 - 15:50

Hi,

I am start to work with MSI Database from Automation Interface.

When I try to execute SQL query for MSI, Database.OpenQuery fails with an error:

-2147467259 Msi API Error OpenView,Sql

Here SQL query:

CODE
SELECT `File` FROM `SelfReg`


For the first time in my experience I encounter with grave accent marks in SQL. wink.gif

Any suggestions will be helpful.
Sincerely your,
Anton Spitsyn
http://www.installsite.ru

luke_s

luke_s
  • Full Members
  • 532 posts

Posted 09 August 2004 - 07:20

Maybe post your complete code.
Its hard to tell from the detail you have posted.
Try a simple query like SELECT * From 'Property'.

AntonS

AntonS
  • Full Members
  • 94 posts

Posted 09 August 2004 - 10:38

Thank you!

Misprint in column name, there must be `File_`
Sincerely your,
Anton Spitsyn
http://www.installsite.ru