insert with quotas in oracle


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: insert with quotas in oracle

  1. #1
    Mr. Martin Guest

    insert with quotas in oracle


    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


  2. #2
    Robert Gelb Guest

    Re: insert with quotas in oracle

    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
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center