U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Simple SQL question

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

Return to the default flat view

Create a new topic

Submit Reply

Re: Simple SQL question [message #31463 is a reply to message #31386]

Fri, 04 March 2011 12:00

mirek is currently offline

mirek
Messages: 14261
Registered: November 2005

Ultimate Member

koldo wrote on Sun, 27 February 2011 03:19

Hello Mirek

For the question it could be used:

SQL.Execute("select *, [Name] || '.' || [Surname] || '.' || [Location] as FULLDATA from PERSONAS where FULLDATA like '%" + pin1 + "%' and FULLDATA like '%" + pin2 + "%'");

The '.' is just to avoid that "aryPop" would match with register MaryPoppinsBruxelles.

Is it possible to do this and use ALIAS with SqlExp or it has to be done with plain SQL?

I have to admin I do not know what '[' and ']' mean in [Name] Smile

Smile

However, this excluded:

Select((NAME|"."|SURNAME).As(FULLDATA)).Where(Like(FULLDATA, "%"+pin1+"%");

should work.

Mirek

Report message to a moderator

Send a private message to this user

[Message index]

		Simple SQL question By: koldo on Fri, 25 February 2011 12:43
		Re: Simple SQL question By: mirek on Fri, 25 February 2011 20:00
		Re: Simple SQL question By: koldo on Sun, 27 February 2011 09:19
		Re: Simple SQL question By: mirek on Fri, 04 March 2011 12:00
		Re: Simple SQL question By: koldo on Fri, 04 March 2011 13:36
		Re: Simple SQL question By: mirek on Sat, 05 March 2011 09:10
		Re: Simple SQL question By: koldo on Sat, 05 March 2011 15:11
		Re: Simple SQL question By: mirek on Sun, 06 March 2011 19:00
		Re: Simple SQL question By: koldo on Sun, 06 March 2011 21:31

Previous Topic:	SQLArray + Like() + Accents problem
Next Topic:	Demo Package of FieldOperator usage

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sun Jun 15 01:06:53 CEST 2025

Total time taken to generate the page: 0.04393 seconds