Using SQL to kick off a build

[cab]

Hi,

newbie here, is there a way to query a SQL table, and use the results to kick off a build?

We have a number of builds, some need to be run in a specific order, and others may or may not need to be run depending.

So far I can see we can run SQL updates, but nothing that brings back information to Visual Build and Allows you to work with it, something like, if status is Active then run the build name what ever was returned....

Anyone got any suggestions how this could be done please.

cab

[kinook]

http://www.visualbuild.com/Manual/serversample.htm
http://www.visualbuild.com/Manual/ado.htm

[cab]

Thanks for that, I had tried ADO but the wrong provider try :-( now it works :-)

Is there an easy way to either Jump to a step if a certain condition is true? Something like if the SQL query returns a result showing an Active build, I need to repeat the process. I suppose I need to unflag all the steps status from completed, and repeat the build? Is that possible...

cab

[kinook]

You could put your whole project within a repeating build rule that builds the main project steps only if a build is not active (start with the ContinuousIntegration.bld sample, for instance).

http://www.visualbuild.com/Manual/contintegsample.htm
http://www.visualbuild.com/Manual/buildrules.htm