Well, it would have been attached, if the server didn't strip attachments...

I'm doing this:

str_proc = :str_proc || 'First line \n';
str_proc = :str_proc || 'Second line\n';

and so forth.

(If you'd rather see the actual source, I can email it directly;-)

-----Original Message-----
From: Nigel Weeks [mailto:nigel@...]
Sent: Wednesday, 21 May 2003 12:47
To: Ib-Support (E-mail)
Subject: [ib-support] Endlines from a Stored Proc
Importance: High


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]



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/