Dear All,
    We have a Application that is running on VB 5.0, Crystal Reports 4.6 and SQL Server 6.5.
    It contains Query written in Microsoft Old Format .
    For eg:
    There is a Crystal Report which contains this kind of Query
    Select emp_no,emp_name,dept_name from emp, dept
    where dept_no = dept.no and
    status ='L'

    Now We have installed a Application that is running on VB6.0, and Crystal Reports 7.0 and
    MSDE Database
    Now the Same Query is converted into ANSI Format
    For eg
    Select emp_no,emp_name,dept_name
    from emp INNER JOIN dept
    ON dept_no = dept.no
    where
    and
    status ='L'

    Due to this Conversion(Normal Join format to ANSI Standard One) the and alone stays in
    the Where clause which results in the Query Error

    Thanking You for your Solutions in Advance

Regards,
AL.Ramanathan

hi there..

are you doing the conversion?? is automatic???

can you just take out the and from it???

HTH...

Gonzalo Bianchi

Hi,
Thanx for your Reply.
This application is installed in around 50 machines.
I need to remove this 'and' and install in all the 50 machines
Is there any way in which we can stop this kind of conversion

Regards,
AL.Ramanathan

hi there..

do you have the report in all the 50 pc???
maybe it's easy to use a new report, and your app. copy it when you install the new version???

HTH...

Gonzalo Bianchi