Kinook Software Forums

Go Back   Kinook Software Forums > Visual Build Professional > [VBP] Third Party Tools

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 04-09-2006, 05:32 PM
cab cab is online now
Registered User
 
Join Date: 04-03-2006
Posts: 7
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
Reply With Quote
  #2  
Old 04-10-2006, 06:48 AM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 5,752
http://www.visualbuild.com/Manual/serversample.htm
http://www.visualbuild.com/Manual/ado.htm
Reply With Quote
  #3  
Old 04-10-2006, 10:17 PM
cab cab is online now
Registered User
 
Join Date: 04-03-2006
Posts: 7
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

Last edited by cab; 04-10-2006 at 10:21 PM.
Reply With Quote
  #4  
Old 04-11-2006, 06:44 AM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 5,752
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
Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 06:15 AM.


Copyright 1999-2019 Kinook Software, Inc.