SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 
        
Home       Members    Calendar    Who's On



VB5 Crystal Reports and SQL 2005 Expand / Collapse
Author
Message
Posted Monday, August 25, 2008 5:13 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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




Post #558059
Posted Monday, August 25, 2008 6:09 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

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.
Post #558077
Posted Tuesday, August 26, 2008 9:41 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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



Post #559318
« Prev Topic | Next Topic »


Permissions Expand / Collapse