U++ forum: Welcome to the forum

Re: Lowercase field name in table - error [message #36795 is a reply to message #36781]

Thu, 05 July 2012 18:32

Sender Ghost
Messages: 301
Registered: November 2008

Senior Member

Hello, Mirek.

mirek wrote on Wed, 04 July 2012 15:25

Should be now fixed. Anyway, the cause is that you are using lower-cased SqlIds, which is somewhat, well, unexpected; DB column names are uppercased.

From the source code point of view, there is no problem to create case-sensitive column names, at least for SQLite. The code, which uppercase column names, is on U++ side:

for(int i = 0; i < cn->info.GetCount(); i++)
	cn->info[i].name = ToUpper(cn->info[i].name);

Commenting such part of code removes "case-insensitive restriction" of reading column names (but not the other restrictions with the same case-insensitive characters, inside other U++ source code, e.g. id, ID).
In opposite of uppercase, I read about lowercase identifiers on MySQL documentation.
So, in conclusion, I think, it is related to various database support on U++ side, but not a real restrictions of concrete database (e.g. SQLite) or even C++ identifiers, which are case-sensitive. Therefore, "the fix" fixes the effects, but not the cause, which created by some purpose.

[Updated on: Thu, 05 July 2012 19:09]

Report message to a moderator