|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Wednesday, January 28, 2009 1:11 AM
Points: 78,
Visits: 53
|
|
Hi friends I have got a typical problem ,may look bit odd nowadaz ,
will the Crystal Reports Shipped along VB 5 work with SQL 2005 any problem regarding joins
john
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: Today @ 1:24 PM
Points: 2,731,
Visits: 22,032
|
|
The query builder uses ANSI 89 SQL Syntax. So, it's join syntax will be a problem for any outer joins and for other joins, the syntax is deprecated. If you write queries directly rather than using the builder, it should work ok.
It's about time you abandon VB5.
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Wednesday, January 28, 2009 1:11 AM
Points: 78,
Visits: 53
|
|
Thanx Michael , You are absolutely right ,but so much of reports are there and it will take much time to conversion
Regards john
|
|
|
|