ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anderson, Robert H - MWT" <Anderson.Rob...@menlolog.com>
Subject RE: Using <sql> task to create SQLServer stored procs
Date Wed, 02 Jul 2003 17:21:42 GMT
This issue has been fixed in ant 1.6 beta. Download a nightly build and your
problem should be resolved. Here is the link to the bug in bugzilla...

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=10719

-Rob A

-----Original Message-----
From: Chris Doran [mailto:cdoran@pts.com] 
Sent: Wednesday, July 02, 2003 9:15 AM
To: user@ant.apache.org
Subject: Using <sql> task to create SQLServer stored procs


Hi All

I've written a build.xml that retrieves several sqlserver scripts from a 
VisualSourceSafe repository. Each of these creates a stored procedure that 
contains microsoft specific wrapper code to drop the stored proc if it 
already exists before recreating it. In essence each script contains 
batches that are separated by the text 'GO'.

Setting the src task delimiter attribute to 'GO' ensures each script runs 
correctly.

However, when I view my stored procs via sqlserver's enterprise manager, 
each stored proc appears as a single line, making it difficult to read.

Any way I can maintain the cr/lf's in the original script files ?

Thanx


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


Mime
View raw message