Urgent!!!:Update [message #373150] |
Thu, 29 March 2001 13:59 |
KP
Messages: 4 Registered: March 2001
|
Junior Member |
|
|
Hi All,
I am having a table schema with a long field in it. Now it contains a about more than 50,000 chars. Now I have update it, how can I do that the simple update does not work. It can only take upto 4000 chars for a usual update on a long.
Can anybody help me in this
thanks
KP
|
|
|
Re: Urgent!!!:Update [message #373180 is a reply to message #373150] |
Mon, 02 April 2001 12:46 |
Cindy
Messages: 88 Registered: November 1999
|
Member |
|
|
Hi,
I have used the substr function to get around this problem.
For example:
Update table
set field = substr('String', 1, 4000)
where condition1
and condition2;
update table
set field = substr('String', 4001, 8000)
where condition1
and condition2;
update table
set field = substr('String', 8001, 12000)
where condition1
and condition2;
Continue with update statements until you input full string with same conditions until you finish update data into field. Make sure that your sub string only contain 4000 or less characters (including spaces) in each update statement.
If you have problem with the signal quote ' around the string then try using a double quote " around your string, because some clients application use a double " to wrap around string. Be careful with special characters within your long string.
Hope this help.
-- Cindy
|
|
|