U++ framework: U++ SQL » Simple SQL question

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

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

Re: Simple SQL question [message #31475 is a reply to message #31464]

Sat, 05 March 2011 09:10

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

koldo wrote on Fri, 04 March 2011 07:36

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

Then define it locally:

SqlId FULLDATA("FULLDATA");

(perhaps I would rather use something more simple as "F").

Quote:

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

That is weird, in SqlExp '|' should be string cat. It could be a bug in SqlExp for specific target DB - what DB is it?

(FYI, it is quite simple, check operator| in SqlExp and see how SqlCase is used to provide different code for different DBs....)

Quote:

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

Select(SqlAll(), FULLDATA)

should work here.

Mirek

Report message to a moderator

[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) ] [

] [

]

Current Time: Mon Sep 07 05:06:18 GMT+2 2026

Total time taken to generate the page: 0.00673 seconds