This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Nov 5, 2012 10:35 AM by glauser RSS

Bug EA 4 (3.0.03.97) Bind Variable Not Declared on Insert from select

pkatsoulis Newbie
Currently Being Moderated
Executing the following query

insert into table1
select column1, column2
from table2
where column1 = :variable;

i get "Bind Variable variable Not Declared"


when i run the (remove the insert into line)

select column1, column2
from table2
where column1 = :variable;

everything works fine...

i guess a bug(?)

Edited by: pkatsoulis on 2 Μαρ 2011 6:07 πμ

Edited by: pkatsoulis on 6 Μαρ 2011 11:49 πμ
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points