RE:[peopletools-l] Does the AppEngine SQL Editor Force SQL into Uppercase?

Reply from Todd Kummer on Apr 16 at 5:47 PM Looks like the meta-sql %NoUpperCase should handle this. ---------------Original Message--------------- From: Flynn Kinkade Sent: Monday, April 16, 2012 4:05 PM Subject: Does the AppEngine SQL Editor Force SQL into Uppercase? SQL error. Stmt #: 1603 Error Position: 0 Return: 8010 - [Microsoft][SQL Native Client][SQL Server]Invalid column name 'DEF_DATE'. SELECT MAX(DEF_Date) FROM [PIGSQL2].[CSA History].[dbo].[DataEntryForms_a] Process 840927 ABENDED at Step PW_CCBANKRCN.CSA.Step01 (SQL) -- RC = 8010 (108,524) Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s My DBA has shown me that the above SQL statement is being forced into all CAPS when it hits the database. The problem is that the database PIGSQL2 is a MS Sql Server 2000 database, and the field name (as well as the record name) is in mixed case. Any thoughts on this, or how I can get around it? Thanks!   Reply to this email to post your response.   __.____._ Manage Settings | Unsubscribe | Create FAQ | Send Feedback    Copyright © 2012 Toolbox.com and message author. Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251

Todd Kummer   PeopleSoft Consultant 4 achievements   Mark as helpful View this online Ask a new question   In the Spotlight Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements _.____.__