U++ forum: Welcome to the forum

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

Sat, 05 March 2011 09:10

mirek
Messages: 14267
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