Hi,
I want to execute an IF expression against a SQL Server using SQLEXEC() and return some "meaningful" result that will tell me if IF was True or False. For example: Here is the IF expression:
cExpr4Sql = "IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.Columns WHERE Table_Name = 'MyTable'
AND COLUMN_NAME = 'MyField1' AND CHARACTER_MAXIMUM_LENGTH = 50 )"
When executing the above expression in SSMS it tells me if the column MyField1 has a length of 50 char or not.
If I pass the above expression to SQLEXEC() how do I return the result? E.g.
xReturn = SQLEXEC( nConn, cExpr4Sql )
TIA for any suggestions.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham