| Subject | how to form a memo in StoredProc and post it to table |
|---|---|
| Author | d_dude_2003 |
| Post date | 2004-05-14T06:37:10Z |
Hi,
I need to create a text for memo field and post it to table
in my stored procedure.
1. Do i have to declare VARCHAR(2000) variable or something like that
to create a text?
2. How do i add #13 and #10 chars when adding text to this variable?
3. Will the following syntax work
INSERT INTO SomeTable(MemoField) VALUES (:MyLongVarCharVar)?
I am using FireBird 1.5 .
Thanx.
I need to create a text for memo field and post it to table
in my stored procedure.
1. Do i have to declare VARCHAR(2000) variable or something like that
to create a text?
2. How do i add #13 and #10 chars when adding text to this variable?
3. Will the following syntax work
INSERT INTO SomeTable(MemoField) VALUES (:MyLongVarCharVar)?
I am using FireBird 1.5 .
Thanx.