Products » Support Forums 

Support Forums

 
  iFinity Support Forum  General  Feature and Dev...  Insert / Update SQL Script Generator Not Compatible with Case Sensitive DBs
Previous Previous
 
Next Next
New Post 5/20/2009 1:14 AM
  remleseyer
1 posts
No Ranking


Insert / Update SQL Script Generator Not Compatible with Case Sensitive DBs 

I encountered a problem with your Insert/Update SQL Script Generator tool when running it against a case sensitive database.  For this to work, you will have to rewrite the script so all case matches, for example when calling variables, system objects or system stored procs, you should exactly follow the case of the object's/variable's name.

 
New Post 5/20/2009 10:28 AM
  Bruce Chapman
1648 posts
1st Level Poster


Re: Insert / Update SQL Script Generator Not Compatible with Case Sensitive DBs 

That's a good point, it probably contains a lot of mixed case text.  I never use case sensitive databases myself, so it's unlikely in the short term that I'll be able to go through and make the required changes.  It shouldn't be too hard for someone to go through and work it out, though, seeing as it is just a case of making sure that all the mixed case statements are in the correct case.  I currently don't have a case insensitive database to test on.  I'll post back if this ever changes.

 
Previous Previous
 
Next Next
  iFinity Support Forum  General  Feature and Dev...  Insert / Update SQL Script Generator Not Compatible with Case Sensitive DBs

Support Guidelines.. Please read before posting

To get support on iFinity products and services, please search the forums for the the answer to the problem you are seeking. If you cannot find a solution, post a question in the relevant forum.   Ensure that you specify the relevant versions of the problem, and the actual error message or a detailed description of the problem.    You will need to register with this site to post on the forum.  If you have a Microsoft Live (Hotmail/Passport) account you can use that.  If you have a Open Id account you can use that.  If you neither of these, you will need to register a user Id and password.