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 #31464 is a reply to message #31463]

Fri, 04 March 2011 13:36

koldo is currently offline

koldo
Messages: 3442
Registered: August 2008

Senior Veteran

Hello Mirek

There are some problems (I use sqlite):

- Instead of FULLDATA it has to be used "FULLDATA", as it is a new column so it is not in .sch file

- NAME|"."|SURNAME is translated to "NAME + '.' + SURNAME". It does not produce any SQL error, but no register is found.
However this works: "NAME || '.' || SURNAME"

- I would like to select all columns plus FULLDATA. How is it done in the Select()?

- A comment: As() is replaced by "" in sqlite. sqlite understands it well, although it also understands the classic "AS"

Thank you for your answer.

Best regards
Iñaki

[Updated on: Fri, 04 March 2011 13:37]

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: Sat Aug 02 16:36:52 CEST 2025

Total time taken to generate the page: 0.14546 seconds