PDA

View Full Version : Run SQL Scripts in SB7



NewsArchive
10-10-2009, 02:56 AM
Hi Folks

Does anyone know how to run some SQL scripts in SB7.

Been trying to look for this function which Friedrich mentioned back on 18
April 2008
" Run SQL Scripts Visualizer

The Run SQL Scripts feature (available as script function and Visualizer)
lets you run Microsoft SQL Server Scripts as part of your installation."

At the moment its looking like I'll need to create a dll function so before
I jump in the deep end thought I'd check first.<g>
--
--
Cheers
Richard

NewsArchive
10-10-2009, 02:56 AM
For MS SQL, I think your best bet is to use the Run Command Line or Run
Program script function to invoke sqlcmd or osql to run the script.

Jane

NewsArchive
10-12-2009, 01:32 AM
Hi Jane

Ok I'll stick with OSQL for now.

Thanks!<g>

--
--
Cheers
Richard