Results 1 to 5 of 5

Thread: What's wrong with this SQL statement?

Threaded View

  1. Feb 27th, 2007, 12:10 PM #1
    Pirre001
    Pirre001 is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2002
    Posts
    665

    Question What's wrong with this SQL statement?

    I use Oracle 10g with Client9

    In SQL Navigator this works:
    Code:
    SELECT (SELECT Count(*) from tbllev) totalrows, salesorder, customer, idt FROM tblLev
    But when I use exactly same SQL from VB it doesen't work?
    vb Code:
    1. SQL = "SELECT (SELECT Count(*) from tblLev) totalrows, salesorder, customer, idt FROM tblLev"

    I get error "ORA-00936: missing expression"

    If I remove this from the SQL string: (SELECT Count(*) from tblLev) totalrows, it works from VB?
    Last edited by Pirre001; Feb 27th, 2007 at 12:19 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width