Re: copy a long from one row to another

Nicolas DEZAIRE wrote:

> Hello
>
> I'm looking for a method to duplicate a row is should be something like
> that :
>
> insert into psources
> (pid, doc)
> select 999, pdoc
> from psources
> where pid = 111;
>
> where doc is a long.
> Long are a little bit unsual to manage, so what can i do ?
>
> Thanks
>
> Nico

Insert long value indirect.
Use variable of type long and insert/values clause after select/into.

Marcin.

Received on Thu Nov 25 1999 - 06:30:22 CST