U++ forum: Welcome to the forum

Re: SQL - option for real case of column/table/database names [message #57937 is a reply to message #57936]

Wed, 29 December 2021 21:47

mezise
Messages: 54
Registered: April 2006

Member

Guys, could you apply those changes?
Example usage:

MySqlSession session;
session.UseRealcase();

Diff:

diff -r old_ver15947/uppsrc/Sql/Sql.cpp new/uppsrc/Sql/Sql.cpp
151,152c151,153
< 	for(int i = 0; i < cn->info.GetCount(); i++)
< 		cn->info[i].name = ToUpper(cn->info[i].name);
---
> 	if(!session.IsUseRealcase())
> 		for(int i = 0; i < cn->info.GetCount(); i++)
> 			cn->info[i].name = ToUpper(cn->info[i].name);
347c348,349
< 		s = ToUpper(s);
---
> 		if(!GetSession().IsUseRealcase())
> 			s = ToUpper(s);
364c366,367
< 		s = ToUpper(s);
---
> 		if(!GetSession().IsUseRealcase())
> 			s = ToUpper(s);
diff -r old_ver15947/uppsrc/Sql/Sqls.h new/uppsrc/Sql/Sqls.h
320a321
> 	bool                          use_realcase = false;
376a378,379
> 	bool                          IsUseRealcase() const                   { return use_realcase; }
> 	void                          UseRealcase()                           { use_realcase = true; }

[Updated on: Thu, 30 December 2021 14:41]

Report message to a moderator