Case Sensitive Table Names not working

Scriptcase 9 Bugs
#1

After recently upgrading to SC9 from 8…it appears to me that SC9 is not using the correct case sensitivity in the table names. Its working locally in the SC9 environment, but in production when I deploy it is using all lowercase table names. Which is wrong as I have the grid set to “Use Case Sensitive” turned on.

After deploy I get error that table can’t be found and its using all lowercase for the name.

I did create the grid using “Batch Application” function of SC9… not sure if that makes a difference or not.

#2

I have not experienced this in SC9, but thought I would lend some moral support.

Are you using the setting at the bottom of the SQL settings? [TABLE]
[TR]
[TD]Case sensitive[/TD]
[TD]Allows you to configure whether the connection will be case sensitive or not. (Differentiating case).

[/TD]
[/TR]
[/TABLE]

I pulled that from help… are you sure that means the table name. It says connection? Make sure the SQL Select Statement has the proper capitalization, you should be able to change it there.

I would recommend also going to Application - Settings - debug mode = on. This should show you every SQL actually getting executed.

Hope that helps some. Maybe the bug is actually in the batch creator???
Good luck,
Jamie

#3

Thanks so much for offering help! I did find the solution and it wasn’t a bug after all. When I moved to a new development DB it was MySQL on a Windows server where the default setting is to use lower case table names… I ended up having to change the default setting in the my.cnf file then copy over all my databases again to the Dev DB that I use to build my apps.
So Scriptcase wasn’t wrong after all… the table names actually were all lower case in my Dev… just not in my Prod DB.

This can me marked closed and or deleted from Bugs.
Thanks!

#4

yourguide, that is great! Thanks for the follow-up as someday someone else will have the same issue with a DB and find your post :slight_smile: That is why I like forums - they help provide clues and solutions.
Have a great weekend,
Jamie