Set temp macro from result of Run SQL action

[raghuk]

Hello,

I have a need to set a local variable macro based on if the database exists or not.

I have the following query in "Run SQL" action.

if db_id('%CurrentDatabaseName%') is null
BEGIN
-- ???? STEP TO set local variable which effectively says 'NO DB'
END

How can I achieve this?

Thanks!

[raghuk]

Hello,

I have a need to set a local variable macro based on if the database exists or not.

I have the following query in "Run SQL" action.

if db_id('%CurrentDatabaseName%') is null
BEGIN
-- ???? STEP TO set local variable which effectively says 'NO DB'
END

How can I achieve this?

Thanks!

In fact, if there is an "expression" that I could use to call this I would love that so that I can use the expression in "Build only if macro or expression" is true!

Thank you!

[kinook]

http://msdn.microsoft.com/en-us/library/ms189484.aspx

[raghuk]

http://msdn.microsoft.com/en-us/library/ms189484.aspx

Thanks :), I am aware of the T-SQL syntax and I'm sure this is not the forum to discuss T-SQL issues.

The real question being, how do I set the value from T-SQL variable back to a macro defined within Visual Build Pro?

Thanks again!

[kinook]

Print the variable's value, parse it out of the LASTSTEP_OUTPUT macro value, and store in a macro.
http://msdn.microsoft.com/en-us/library/ms176047%28SQL.90%29.aspx
http://www.kinook.com/VisBuildPro/Manual/scriptevents.htm

[raghuk]

Thank you! You are amazing as always!

[raghuk]

name
--------------------------------------------------------------------------------------------------------------------------------
Music_log




Hello,

When I run the SQL to assign it to a variable, above is the output that I get from SQL. How do I parse to get only "Music_log"?

Thank you!

[kinook]

See the attached sample.

[Shiamak]

Do you have this .bld sample for v7.7 pro?

[kinook]

No, but it might work if you change the version in the .bld file (in a text editor) from 8 to 7.