U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » size of S_XXX struct members

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

size of S_XXX struct members [message #41560]

Mon, 30 December 2013 15:53

Alboni
Messages: 216
Registered: January 2012
Location: Kajaani, Finland

Experienced Member

I problem im running into a lot is users entering strings that are longer than defined in the sql tables.

for example if I have a .sch file like

TABLE_ (PAYMENT_METHOD)
	INT_	(PM_ID) PRIMARY_KEY UNIQUE AUTO_INCREMENT
	STRING_	(PM_DESCRIPTION, 30)
END_TABLE

and a user enters a description of 35 characters, then the sql insert fails with an errormessage that the value for PM_DESCRIPTION is too long.

I know I can use EditString::MaxLen(30) to limit the input, but that means entering the length of the field in 2 places.
So, can I do something like:

dialog.pm_description.MaxLen(sizeof(S_PAYMENT_METHOD::PM_DESCRIPTION));

dialog.pm_description being the EditString for editing the field
for editing PM_DESCRIPTION in the PAYMENT_METHOD table.

I know sizeof() won't work here, but what will?

[Updated on: Mon, 30 December 2013 15:56]

Report message to a moderator

Re: size of S_XXX struct members [message #41627 is a reply to message #41560]

Mon, 06 January 2014 16:06

mirek
Messages: 14255
Registered: November 2005

Ultimate Member

Right now, it is unfortunately not possible, but it is reasonable request that could be relatively easily implemented - RM task added:

http://www.ultimatepp.org/redmine/issues/630

Mirek

Report message to a moderator

Re: size of S_XXX struct members [message #41634 is a reply to message #41627]

Mon, 06 January 2014 19:28

Didier
Messages: 725
Registered: November 2008
Location: France

Contributor

Message deleted ==> I replied the wrong message

[Updated on: Mon, 06 January 2014 22:17]

Report message to a moderator

Re: size of S_XXX struct members [message #41649 is a reply to message #41560]

Tue, 07 January 2014 22:53

Alboni
Messages: 216
Registered: January 2012
Location: Kajaani, Finland

Experienced Member

Being able to do something like this would be grand also:

S_PAYMENT_METHOD rec;
int n=rec.GetCount();
for (int i=0; i<n; i++)
{
	switch (rec[i].type)
	{
		case S_INT: DoSomethingWithAnInt(rec[i].Value, rec[i].MaxLength); break;
		case S_STRING: DoSomethingWithAnString(rec[i].Value, rec[i].MaxLength); break;
		................
	}
}

[Updated on: Tue, 07 January 2014 23:13]

Report message to a moderator

Re: size of S_XXX struct members [message #41665 is a reply to message #41649]

Wed, 08 January 2014 12:05

mirek
Messages: 14255
Registered: November 2005

Ultimate Member

Alboni wrote on Tue, 07 January 2014 16:53

Being able to do something like this would be grand also:

S_PAYMENT_METHOD rec;
int n=rec.GetCount();
for (int i=0; i<n; i++)
{
	switch (rec[i].type)
	{
		case S_INT: DoSomethingWithAnInt(rec[i].Value, rec[i].MaxLength); break;
		case S_STRING: DoSomethingWithAnString(rec[i].Value, rec[i].MaxLength); break;
		................
	}
}

This is actually already possible; rec has GetRef method and Ref has GetType or even Is<> methods...

Mirek

Report message to a moderator