Kinook Software Forums

Kinook Software Forums (
-   [VBP] Third Party Tools (
-   -   Using SQL to kick off a build (

cab 04-09-2006 06:32 PM

Using SQL to kick off a build

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.


kinook 04-10-2006 07:48 AM

cab 04-10-2006 11:17 PM

jump to step
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...


kinook 04-11-2006 07:44 AM

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).

All times are GMT -5. The time now is 05:45 PM.

Copyright 1999-2019 Kinook Software, Inc.