Hi,
the execution is currently not the problem, because the number of records is
too small.
I have the impression that the first query looks for DATUM >= x and the
second one for DATUM <= y and finally delivers the number of records that is
included in both result sets.
My main interesst is to
Niko,
> Hello all,
>
> i am running a simple query where the result contains 3 records. The
> query should provide all records in a specific week.
>
> SELECT * FROM ARBEITSEINTEILUNG AS a where a.baustelle = '12345' AND
> WOCHE = '2015-41';
>
> Some times I dont have a week but two dates:
>
> In
Hi-
I hope this doesn't double post.
RDB$ denotes a system table.
Stilll not sure where RNAME gets its value.
thanks - jim
Hi-
I have 2 questions from the code below.
Where do you come up with RDB$FIELD_NAME?
Is FIELDNAME part THE NAME OF A FIELD IN an actual TABLE AND
RELATION_FIELDS THE NAME OF A REAL TABLE?
How can you use :RNAME IN THE WHERE clause?
Where is it getting its value from? It seems like it
Hi-
I since figured out part of it. RDB$ prefix denotes system tables.
Okay, so I am still wondering where RNAME gets it values.
thanks for any help.
jim
At 06:43 a.m. 13/10/2015, thirdshiftco...@yahoo.com [firebird-support] wrote:
>I have 2 questions from the code below.
>
>Where do you come up with RDB$FIELD_NAME?
It is a column in the system table RDB$RELATION_FIELDS. The RDB$-- tables
exist in all Firebird databases. They store your