Multi line sql

[emozley]

Hi

I am trying to execute a IF NOT THEN...BEGIN....END statement stored in a string in VB.NET but am not having much luck. It says there is an error at "BEGIN":

strSQL = "IF NOT EXISTS(SELECT * FROM AppsCheck_Apps WHERE ApplicationName='" & InstalledPrograms(i).DisplayName & "' " _
                                 & "BEGIN " _
                                 & "INSERT INTO AppsCheck_Apps (ApplicationName) VALUES ('" & InstalledPrograms(i).DisplayName & "')" _
                                 & "END"

Any ideas?

Thanks!

Ed

 

[SgtJarrow]

Missing a closing paranthesis...

strSQL = "IF NOT EXISTS(SELECT * FROM AppsCheck_Apps WHERE ApplicationName='" & InstalledPrograms(i).DisplayName & "'[highlight #EF2929])[/highlight] " _
                                 & "BEGIN " _
                                 & "INSERT INTO AppsCheck_Apps (ApplicationName) VALUES ('" & InstalledPrograms(i).DisplayName & "')" _
                                 & "END"

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
C#.NET Programmer

 

[emozley]

As simple as that! Well spotted thank you.

Ed