DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: how to pass sub query from form design to crystal report

  1. #1
    makoks Guest

    how to pass sub query from form design to crystal report


    How can i pass string query from form design to crystal report?
    this is my source code
    " EMP.DEPTNO IN (SELECT DEPT.DEPTNO " & _
    " From DEPT " & _
    " WHERE DEPT.LOC = 'CHICAGO'
    "
    it have Runtime error"20515"
    '...............'
    the remaining text does not appear to be part of the formular.
    How can i od?.

    thank you for advice.
    makoks

  2. #2
    Dean Earley Guest

    Re: how to pass sub query from form design to crystal report

    > How can i pass string query from form design to crystal report?
    > this is my source code
    > " EMP.DEPTNO IN (SELECT DEPT.DEPTNO " & _
    > " From DEPT " & _
    > " WHERE DEPT.LOC = 'CHICAGO'
    > "
    > it have Runtime error"20515"
    > '...............'
    > the remaining text does not appear to be part of the formular.
    > How can i od?.


    umm, that is not valid SQL

    If you do have valid SQL, you can pass it by doing:

    CrystalReportsOCX.SQLQuery = SQL

    --
    Dean Earley (dean.earley@icode.co.uk)
    Assistant Developer

    iCode Systems



  3. #3
    Dean Earley Guest

    Re: how to pass sub query from form design to crystal report

    "makoks" <makoks@hotmail.com> wrote in message news:3d06dd26$1@10.1.10.29...
    >
    > How can i pass string query from form design to crystal report?
    > this is my source code
    > " EMP.DEPTNO IN (SELECT DEPT.DEPTNO " & _
    > " From DEPT " & _
    > " WHERE DEPT.LOC = 'CHICAGO'
    > "
    > it have Runtime error"20515"
    > '...............'


    Also, can you not post the same question to different groups.

    --
    Dean Earley (dean.earley@icode.co.uk)
    Assistant Developer

    iCode Systems



  4. #4
    makoks Guest

    Re: how to pass sub query from form design to crystal report


    "Dean Earley" <dean.earley@icode.co.uk> wrote:
    >> How can i pass string query from form design to crystal report?
    >> this is my source code
    >> " EMP.DEPTNO IN (SELECT DEPT.DEPTNO " & _
    >> " From DEPT " & _
    >> " WHERE DEPT.LOC = 'CHICAGO'
    >> "
    >> it have Runtime error"20515"
    >> '...............'
    >> the remaining text does not appear to be part of the formular.
    >> How can i do?.

    >
    >umm, that is not valid SQL
    >
    >If you do have valid SQL, you can pass it by doing:
    >
    > CrystalReportsOCX.SQLQuery = SQL
    >
    >--
    >Dean Earley (dean.earley@icode.co.uk)
    >Assistant Developer
    >
    >iCode Systems
    >
    >thank you Dean Earley it greate



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