Does any one know how can I do to upgrade a text field from sybase store procedure? I am working with Sybase 12.5.2 in SUN Solaris
I want to do next:
1) Actually in the field "comments" I have this value
Id=001
Comments= "The Life of Wolfgang Amadeus Mozart, The main facts of
Mozart's life are generally familiar. Born at Salzburg in January 1756,
he startled the musical world as an infant prodigy, playing the clavier
and composing little pieces before he was five. When only six, he was
taken on tour by his father, and astonished everybody by his marvellous
powers at the keyboard. He came to London in 1764, when he was eight;
played in public and before George III and his Queen. To the Queen he
dedicated six sonatas, and got fifty guineas for them. Advertisements
invited people put the talents of the "wonderful boy" to the proof by
giving him anything to play at sight, or any theme upon which to
extemporise. Probably it was the feverish excitements on this juvenile
"exhibition" which undermined his constitution, and helped to bring
about his early death."
2) The Store Procedure receive 2 parameters: Id to locate the record and
new_comment, whit the second part of the story.
Id= 001
New_comment=" By the time he was fourteen, Mozart was supposed to
have the technique of his art. Then he proceeded to Italy. The Italians
were amazed at his genius. He played so magnificently at Naples that the
audience declared the ring of his finger must be a talisman, and
demanded its removal. He removed it, and -- played better than ever.
Such useful triumphs are unique in musical biography"
3) After executing the Store Procedure field comments must be with the
following information:
Comments=" The Life of Wolfgang Amadeus Mozart, The main facts of
Mozart's life are generally familiar. Born at Salzburg in January 1756,
he startled the musical world as an infant prodigy, playing the clavier
and composing little pieces before he was five. When only six, he was
taken on tour by his father, and astonished everybody by his marvellous
powers at the keyboard. He came to London in 1764, when he was eight;
played in public and before George III and his Queen. To the Queen he
dedicated six sonatas, and got fifty guineas for them. Advertisements
invited people put the talents of the "wonderful boy" to the proof by
giving him anything to play at sight, or any theme upon which to
extemporise. Probably it was the feverish excitements on this juvenile
"exhibition" which undermined his constitution, and helped to bring
about his early death.
By the time he was fourteen, Mozart was supposed to have the technique
of his art. Then he proceeded to Italy. The Italians were amazed at his
genius. He played so magnificently at Naples that the audience declared
the ring of his finger must be a talisman, and demanded its removal. He
removed it, and -- played better than ever. Such useful triumphs are
unique in musical biography""
Any Idea or reference is welcome
<<img001.jpg>>
-----------------------------------------
Este mensaje y cualquier archivo que se adjunte al mismo es
propiedad de Grupo Iusacell y contiene informacion privada y
privilegiada para uso exclusivo del destinatario. Si usted recibe
esta comunicacion por error, no esta autorizado para copiar,
retransmitir, utilizar o divulgar este mensaje ni los archivos
adjuntos. En este caso por favor notifique inmediatamente al
remitente por este mismo conducto. Gracias.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"<<attachment: img001.jpg>>
