Hi Set,

I'm trying this in SQL Editor window in IB Expert:

insert into USERS2(USER_ID, USER_ROLE_ID,USER_NAME)
select USER_ID, USER_ROLE_ID,USER_NAME from USER;

I'm getting:

Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 2, column 45.
USER.

Is the syntax for 2.0 slightly different?

I'm using an embedded version(if that makes any difference).

Vlad



----- Original Message ----
From: Svein Erling Tysvaer <svein.erling.tysvaer@...>
To: firebird-support@yahoogroups.com
Sent: Wednesday, January 24, 2007 4:00:36 PM
Subject: Re: [firebird-support] SELECT INTO TABLE













I'd be shocked if it doesn't work, Vlad, I know it works for me without

problems in Firebird 1.5 (Well, with other table and field names, if you

use reserved words you have to double quote the table and field names).



Though you should write it like Martijn wrote, without any VALUES clause:



insert into USERS2(USER_ NAME, USER_ROLE)

select USER_NAME, USER_ROLE from USER



This should work,

Set



Vlad Orlovsky wrote:

> Hi,

>

> That's not working.

>

> I'd like to copy some data from USERS to USERS2 without using temp variables(FOR SELECT ... INTO :TEMP_USER_NAME, TEMP_USER_ROLE. ....)

>

> What is the correct syntax for something like this in Firebird 2.0?

>

> insert into USERS2(USER_ NAME, USER_ROLE)

> VALUES (

> select USER_NAME, USER_ROLE from USER)

>

> Thanks in advance,

> Vlad

>

>> Is there a way to do this in Firebird 2.0:

>

>

>> SELECT * INTO Employees2 FROM Employees -- SQL Server Syntax

>

>> Employees and Employees2 are identical tables.

>

> insert into employees2

>

> select * from employees

>

> I believe :)

<!--

#ygrp-mlmsg {font-size:13px;font-family:arial,helvetica,clean,sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial,helvetica,clean,sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;
}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;
}
#ygrp-vitnav{
padding-top:10px;
font-family:Verdana;
font-size:77%;
margin:0;
}
#ygrp-vitnav a{
padding:0 1px;
}
#ygrp-actbar{
clear:both;
margin:25px 0;
white-space:nowrap;
color:#666;
text-align:right;
}
#ygrp-actbar .left{
float:left;
white-space:nowrap;
}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;
font-size:77%;
padding:15px 0;
}
#ygrp-ft{
font-family:verdana;
font-size:77%;
border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;
}

#ygrp-vital{
background-color:#e0ecee;
margin-bottom:20px;
padding:2px 0 8px 8px;
}
#ygrp-vital #vithd{
font-size:77%;
font-family:Verdana;
font-weight:bold;
color:#333;
text-transform:uppercase;
}
#ygrp-vital ul{
padding:0;
margin:2px 0;
}
#ygrp-vital ul li{
list-style-type:none;
clear:both;
border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;
color:#ff7900;
float:right;
width:2em;
text-align:right;
padding-right:.5em;
}
#ygrp-vital ul li .cat{
font-weight:bold;
}
#ygrp-vital a {
text-decoration:none;
}

#ygrp-vital a:hover{
text-decoration:underline;
}

#ygrp-sponsor #hd{
color:#999;
font-size:77%;
}
#ygrp-sponsor #ov{
padding:6px 13px;
background-color:#e0ecee;
margin-bottom:20px;
}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;
margin:0;
}
#ygrp-sponsor #ov li{
list-style-type:square;
padding:6px 0;
font-size:77%;
}
#ygrp-sponsor #ov li a{
text-decoration:none;
font-size:130%;
}
#ygrp-sponsor #nc {
background-color:#eee;
margin-bottom:20px;
padding:0 8px;
}
#ygrp-sponsor .ad{
padding:8px 0;
}
#ygrp-sponsor .ad #hd1{
font-family:Arial;
font-weight:bold;
color:#628c2a;
font-size:100%;
line-height:122%;
}
#ygrp-sponsor .ad a{
text-decoration:none;
}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;
}
#ygrp-sponsor .ad p{
margin:0;
}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;
}
#ygrp-text tt{
font-size:120%;
}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
-->









____________________________________________________________________________________
Need a quick answer? Get one in minutes from people who know.
Ask your question on www.Answers.yahoo.com

[Non-text portions of this message have been removed]