Kinook Software Forum

Kinook Software Forum (https://www.kinook.com/Forum/index.php)
-   [VBP] Third Party Tools (https://www.kinook.com/Forum/forumdisplay.php?f=3)
-   -   Using SQL to kick off a build (https://www.kinook.com/Forum/showthread.php?t=1677)

cab 04-09-2006 05:32 PM

Using SQL to kick off a build
 
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 04-10-2006 06:48 AM

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

cab 04-10-2006 10: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...

cab

kinook 04-11-2006 06: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).

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


All times are GMT -5. The time now is 02:34 AM.


Copyright © 1999-2023 Kinook Software, Inc.