derived attributes in qualifier?

Is it normal that one can't use derived attributes in qualifier (when fetching), or am I doing something wrong in my model? It seems to me that since they are defined SQL-side, they should be able to limit the fetch, should they not? Anyway whenever I try to fetch with a qualifier which

Re: FrontBase SQL: date formatting, „local variable“?

Hi OC, The easiest way to get a date a MMDD is this: CAST(EXTRACT(year FROM "dateColumn") * 1 + EXTRACT(month FROM "dateColumn") * 100 + EXTRACT(day FROM "dateColumn") as CHAR(8)) A more flexible way is to create a function (you can adjust the format): create function formatDateOC(IN

Re: FrontBase SQL: date formatting, „local variable“?

Well... On 11. 3. 2016, at 22:06, OC wrote: > Still, it can be solvable (perhaps even easily) > > (a) in standard SQL92 which I don't know well enough > (b) in some FrontBase-specific extension > > which is why I am asking. ... without better knowledge the SQL used to derive the

Re: FrontBase SQL: date formatting, „local variable“?

looks like my iphone didn't decoded from base64, weird > On 11 mar 2016, at 21:58, Chuck Hill wrote: > > The message looked fine to me both on my iPhone and in my mail client. > > > > > On 2016-03-11, 12:52 PM, >

Re: FrontBase SQL: date formatting, „local variable“?

Chuck, On 11. 3. 2016, at 21:59, Chuck Hill wrote: > It is supposed to be SQL92 compliant. If standard SQL can’t do it, you might > be out of luck. I am no SQL guru myself; the google results look like there is a terrible mess of standard- and server-specific tools. Eg.,

Re: FrontBase SQL: date formatting, „local variable“?

It is supposed to be SQL92 compliant. If standard SQL can’t do it, you might be out of luck. This is not something you can do client-side? Chuck On 2016-03-11, 12:47 PM, "webobjects-dev-bounces+chill=gevityinc@lists.apple.com on behalf of OC"

Re: FrontBase SQL: date formatting, „local variable“?

The message looked fine to me both on my iPhone and in my mail client. On 2016-03-11, 12:52 PM, "webobjects-dev-bounces+chill=gevityinc@lists.apple.com on behalf of Amedeo Mantica" wrote:

Re: FrontBase SQL: date formatting, „local variable“?

sgvscohsvosvhpveusvvuvssvvubwbwbibebiwbibeubvusv !?? Sent from my iPhone > On 11 Mar 2016, at 21:47, OC wrote: > > SGVsbG8gdGhlcmUsCgphbnkgRnJvbnRCYXNlIFNRTCBndXJ1cyBvbi1saW5lPyBGb3IgYSBkZXJp > dmVkIGF0dHJpYnV0ZSwgSSB3b3VsZCBuZWVkCgotLSAoYSkgdG8gZm9ybWF0IGEgVElNRVNUQU1Q >

FrontBase SQL: date formatting, „local variable“?

Hello there, any FrontBase SQL gurus on-line? For a derived attribute, I would need -- (a) to format a TIMESTAMP as “%Y%n%e” So far the best I have found is CAST(EXTRACT(year FROM DATE) AS VARCHAR(4)) || CAST(EXTRACT(month FROM DATE) AS VARCHAR(2)) || CAST(EXTRACT(day FROM DATE) AS VARCHAR(2))

Re: Performance in many objects manipulation

Hi List, well, I need to thank Mark for the advice. I've used the ERXFetchSpecificationBatchIterator in this way: @Override public Object performAction() { // TODO Auto-generated method stub EOEditingContext ec = ERXEC.newEditingContext(); EOFetchSpecification fs = new