TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Make SQL Queries Case Insensitive
When using DML SQL statements like Select, Update, Insert and Delete I’ve noticed that field names must be case sensitive is there any way to allow field names to be case insensitive?
ID
632
Category
TeamDesk
Author

Blake Cabot
Date Created
5/8/2013 9:39:41 AM
Date Updated
5/13/2013 10:26:47 AM
Status
New Idea
Score
20
Promoted By
Philipp Matuschka (MMB)Blake Cabot
Comments
Kirill Bondar  Staff  5/13/2013 7:32:21 AM
API methods already resolve table and column names in case insensitive manner. Could you please clarify where you ran into case sensitive name resolution?
Blake Cabot 5/13/2013 9:58:15 AM
For example on our Products table, we have a key: "SKU" If we use "sku", in the api we get an error.

Best,
Blake
Kirill Bondar  Staff  5/13/2013 10:26:47 AM
You can call Query() with either "SELECT [SKU] FROM [PRODUCT]" or "select [sku] from [product]" with no error. Yet, the data returned by the API is converted to PHP key-value array and keys are indeed case-sensitive, but this is PHP implementation feature.


Feedback
 
Back to Search Results