insert with quotas in oracle

[Mr. Martin]

hi
please Help me

I am using VB5 and ORACLE8

SQL=" select field1 from table where field1='Jenny'"
db.Execute "insert into tbl values ('" & SQL & "')"

traduction

db.Execute "insert into tbl values ('select field1 from table
where field1='Jenny''"
^ Error

thanks very much

[Robert Gelb]

Perhaps remove the quote before the SELECT

--
Robert Gelb
www.vbRad.com
Source, Tips, Tricks, Components

"Mr. Martin" <mpalaciost@yahoo.com> wrote in message
news:3af9a058$3@news.devx.com...
>
> hi
> please Help me
>
> I am using VB5 and ORACLE8
>
> SQL=" select field1 from table where field1='Jenny'"
> db.Execute "insert into tbl values ('" & SQL & "')"
>
> traduction
>
> db.Execute "insert into tbl values ('select field1 from table
> where field1='Jenny''"
> ^ Error
>
> thanks very much
>