Home » RDBMS Server » Server Administration » Insert into long column
Insert into long column [message #373271] Mon, 09 April 2001 03:21 Go to next message
Siddharth Bahri
Messages: 18
Registered: March 2001
Junior Member
Hi friends,

I have a problem.
I cannot insert values into a long column using

Insert into table1(field list) select field list from table2.

Both table1 and table2 contain one column of long datatype.
When I run the query I get error 'Illegal use of long datatype".

Any suggestions?

-Siddharth

Report message to a moderator

Re: Insert into long column [message #373275 is a reply to message #373271] Mon, 09 April 2001 07:48 Go to previous message
lp
Messages: 8
Registered: April 2001
Junior Member
Hi,
You cannot use the insert into...select from syntax with LONG datatypes.A LONG value can
only be used in a SELECT clause.

Regards
lp

Report message to a moderator

Previous Topic: Re: Insert into a view
Next Topic: count in an update query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 05:30:16 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.