Printable View
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
> 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
"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
"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