U++ framework: ArrayCtrl, HeaderCtrl & GridCtrl

Home » U++ Library support » ArrayCtrl, HeaderCtrl & GridCtrl » SqlArray bad select?

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

SqlArray bad select? [message #14645]

Wed, 05 March 2008 19:22

indiocolifa
Messages: 49
Registered: January 2008
Location: Argentina

Member

With this code for a SqlArray:

	userList.SetSession(*(G_STATE->GetPsqlSession()));
	userList.SetTable(OPERADOR);
	userList.AddKey(LOGIN);
	userList.SetOrderBy(LOGIN);
	userList.AddColumn(LOGIN,"Usuario de login");
	userList.AddColumn(NOMBRE,"Nombre operador");
	userList.AddColumn(CLASE,"Clase");
	userList.Query();

I'm getting this SQL (in Log):

select LOGIN, LOGIN, NOMBRE, CLASE from OPERADOR order by LOGIN

Why two LOGIN fields in the query? Should be I think:

select LOGIN, NOMBRE, CLASE from OPERADOR order by LOGIN

I'm using U++ 2008.1 beta

Hernan

Report message to a moderator

[Message index]

		SqlArray bad select? By: indiocolifa on Wed, 05 March 2008 19:22
		Re: SqlArray bad select? By: mirek on Sat, 08 March 2008 17:22

Previous Topic:	Bugfix: ArrayCtrl Black info popups
Next Topic:	Deleting more than one selected records in ArrayCtrl

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Oct 15 02:07:40 GMT+2 2026

Total time taken to generate the page: 0.02991 seconds