Kinook Software Forum

Go Back   Kinook Software Forum > Visual Build Professional > [VBP] General Discussion
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-10-2004, 10:39 AM
helena helena is online now
Registered User
 
Join Date: 02-10-2004
Posts: 1
Call VBP steps from within script?

Is there anyway to call a VBP step from within a Script block?

The problem that I'm trying to solve is that I have a folder filled with .sql files. Each file name starts with a number, such as 100, 200, 1100, and the sql files need to be run in numeric order (rather than alphabetical).

I created a jscript step that would go through all the files in the directory and stick the paths into an array so that they're in the correct order.

After all the files are ordered correctly, I would like to run the all the sql files in the appropriate order. This is where I run into the problem. How do I run all these file in the correct order?

Ideally, I'd like to loop through all the items and call the Run Sql step with the information or run the %DOSCMD% with the correct command from within the script code. I haven't been able to figure out how to call any VBP steps from within the script, or how to pass the list of file paths out to another step to run all of them in order.

Any ideas?

Thanks!
Reply With Quote
 


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 03:58 PM.


Copyright © 1999-2023 Kinook Software, Inc.