Subject | Endlines from a Stored Proc |
---|---|
Author | Nigel Weeks |
Post date | 2003-05-21T02:47:14Z |
I'm making a stored procedure wizard in a stored procedure, and I'm having
trouble returning standard end-lines.
Is there a special character other than '\n'?
Using the procedure:
isql into your database
in sp_autoproc.sql;
out sp_tbl_test_ins;
select * from sp_autoproc('tbl_test','insert');
exit;
the file sp_tbl_test_ins then contains a rather ugly insert procedure.
Any ideas?
PLEASE DON'T PINCH THE CODE, though!!
The source is attached for your perusal
--------------------------------------------------------
Nigel Weeks
E-Easy
15 Wellington St. Launceston Tas 7250
Ph. 61 3 6334 6664
Fax. 61 3 6331 7032
Email. nigel@...
Web: www.e-easy.com.au
--------------------------------------------------------
[Non-text portions of this message have been removed]
trouble returning standard end-lines.
Is there a special character other than '\n'?
Using the procedure:
isql into your database
in sp_autoproc.sql;
out sp_tbl_test_ins;
select * from sp_autoproc('tbl_test','insert');
exit;
the file sp_tbl_test_ins then contains a rather ugly insert procedure.
Any ideas?
PLEASE DON'T PINCH THE CODE, though!!
The source is attached for your perusal
--------------------------------------------------------
Nigel Weeks
E-Easy
15 Wellington St. Launceston Tas 7250
Ph. 61 3 6334 6664
Fax. 61 3 6331 7032
Email. nigel@...
Web: www.e-easy.com.au
--------------------------------------------------------
[Non-text portions of this message have been removed]