Error In Creating Sql Expression Com Parser
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Business Objects: Crystal Reports 2 Data Access Forum at Tek-Tips HomeForumsProgrammersReporting SolutionsBusiness Objects: Crystal Reports 2 Data Access Forum SQL expressions not working in CR 8.5 and freezing in 11 thread766-1307013 Forum Search FAQs Links MVPs SQL expressions not working in CR 8.5 and freezing in 11 SQL expressions not working in CR 8.5 and freezing in 11 Planchardo (Programmer) (OP) 29 Nov 06 11:13 I have been trying to write an SQL query in a report in CR 8.5 and 11, but having problems in both. Here is the query:(select employee.memberid from employeewhere DateDiff("m",EMPLOYEE.dateOfBirth,{fn CURDATE()}) > 462and DateDiff("m",EMPLOYEE.dateOfBirth,{fn CURDATE()}) <= 522and EMPLOYEE.sex <> 'F'and COVERAGEMSTR.groupNo = '0000094001'and PRODUCT.productId in ('GAD&D', 'GLIFE'))Basically, I am trying to select the member IDs of employees in a certain age range with certain criteria, and pass that list of IDs into a running total. The best way I figured was to use an SQL query, but every time the syntax is checked in 8.5, I keep on getting the error message"Error in compiling SQL expression : . Error in initialising SQL Expression parser. Error in creating SQL Expression COM parser.", no matter how simple the expression (such as (select * from employee)). Even when I make a new report and have only the sql expression field in the report, I still get the same error whe
the error message from Crystal Reports 8.5 "Error in creating SQL Expression COM Parser" when I set the SqlQueryString. I cannot figure out what is wrong. what does this error generally indicate? Sat, 21 Aug 2004 08:04:03 GMT Luke Zhang [M#2 / 2 http://www.tek-tips.com/viewthread.cfm?qid=1307013 Error in creating SQL Expression COM Parser? You may need to double check the SqlQuerystring to see if it is correct. Additionally, here is a article about the problem from crystaldecisions http://support.crystaldecisions.com/library/kbase/articles/c2008047.asp Luke (This posting is provided "AS IS", with no warranties, http://computer-programming-forum.com/67-vb-crystal-report/bb8bc267b0eeab56.htm and confers no rights.) Sat, 21 Aug 2004 15:25:44 GMT Page 1 of 1 [ 2 post ] Relevant Pages 1. Error 20639: SQL Expression error - Error in creating SQL Expression COM Parser (cpeaut32) 2. Looking for good COM SQL Parser... 3. Looking for good COM SQL Parser... 4. Looking for good COM SQL Parser... 5. Looking for good COM SQL Parser... 6. Looking for good COM SQL Parser... 7. Crystal error: error ocurred reading records: error in compiling sql expression 8. Expression parser in VB 9. Expression parser in VB 10. String expression Parser (evaluator) needed 11. String expression parser (evaluator) needed 12. Use of IsNull() in SQL expression and Error 3085 (VB4-16 Powered by phpBB Forum Software
VB calculated field - unbound?" In reply to: dave: "Re: "Error in creating error in SQL Expression COM parser"" Messages sorted by: [ date ] [ thread ] Date: 10 Mar 2005 18:25:04 -0800 > Have you error in creating tried registering S2sqlprs.dll? Yes, still nothing :\ kp Next message: Jacques Wentworth: "Property 'Keycode' is non-nullable - ERROR!" Previous message: iceman: "Write to Crystal field from VB calculated field - unbound?" In reply to: dave: "Re: "Error in creating SQL Expression COM parser"" Messages sorted by: [ date ] [ thread ] Flag as inappropriate (AWS) Windows Science Usenet ArchiveAboutPrivacyImprint www.tech-archive.net >Archive >VB >microsoft.public.vb.crystal >2005-03
Microsoft Tech Companion App Microsoft Technical Communities Microsoft Virtual Academy Script Center Server and Tools Blogs TechNet Blogs TechNet Flash Newsletter TechNet Gallery TechNet Library TechNet Magazine TechNet Subscriptions TechNet Video TechNet Wiki Windows Sysinternals Virtual Labs Solutions Networking Cloud and Datacenter Security Virtualization Downloads Updates Service Packs Security Bulletins Windows Update Trials Windows Server 2012 R2 System Center 2012 R2 Microsoft SQL Server 2014 SP1 Windows 8.1 Enterprise See all trials » Related Sites Microsoft Download Center TechNet Evaluation Center Drivers Windows Sysinternals TechNet Gallery Training Training Expert-led, virtual classes Training Catalog Class Locator Microsoft Virtual Academy Free Windows Server 2012 courses Free Windows 8 courses SQL Server training Microsoft Official Courses On-Demand Certifications Certification overview MCSA: Windows 10 Windows Server Certification (MCSE) Private Cloud Certification (MCSE) SQL Server Certification (MCSE) Other resources TechNet Events Second shot for certification Born To Learn blog Find technical communities in your area Support Support options For business For developers For IT professionals For technical support Support offerings More support Microsoft Premier Online TechNet Forums MSDN Forums Security Bulletins & Advisories Not an IT pro? Microsoft Customer Support Microsoft Community Forums United States (English) Sign in Home Library Wiki Learn Gallery Downloads Support Forums Blogs We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Technical Reference Errors and Events Reference Error Messages in Visual Database Tools Error Messages in Visual Database Tools Unable to parse statement. Unable to parse statement. Unable to