Take this for example:
I have a old table with movies. And now I want split this table in a movie table and a genre table.
In the old table I have a column with genres. I want to move them to another table genres. And store the id in the movie table and not the name of the genre.
So I need a...
I want to find records where the date is less than the given date.
But the date needs to be the highest than the other records.
Where the customer history id is equal to the customer history id where the date is equal to the given date.
For example:
If I give the date 27/08/2007 in. It needs...
It works almost great.
But take for example this table:
26 43 5 25/08/2007 00:00:00
27 43 5 26/08/2007 00:00:00
28 43 6 27/08/2007 00:00:00
From these records I only the second one and not the first and the second.
So I need all the records where the date is less than the given date and the...
Both of these queries give me the records with the ID's 23 and 29.
I don't need the record with the ID 29 because the cardnumber is equal to the cardnumber from the record with the ID 30 and where the date is equal to the given date.
Nyh
This is my entire query.
In the first subselect I select all the records where the date are less than the given date.
In the second subselect I select all the records where the cardnumber are not null and the date is equal to the given date. And the cardnumber is different than the cardnumber...
I will use a better subjet next time.
But I can't use A.CARDNUMBER because that is from another subselect.
And if I change the query to this:
SELECT CARDNUMBER
FROM CUSTOMER_HISTORY
WHERE CAST(DATE_CREATED AS DATE) = (SELECT MAX(CAST(A.DATE_CREATED AS DATE))
FROM CUSTOMER_HISTORY A
WHERE...
What is wrong with this query?
This query only need to select the record where the id is 23.
The problem occurs with this line: AND B.CARDNUMBER <> CARDNUMBER.
But it doesn't give me a record at all.
If I leave this code out of the query it gives me the records 23 and 29.
But I only need the...
i only have to do this
03 RADIO-BUTTON SELF-ACT
TITLE "13 - 16"
LINE + 1.5 COL 46
LINES 1 CELLS SIZE 8 CELLS
VALUE ws-aanvr-uur
GROUP 1 GROUP-VALUE 2
AFTER PROCEDURE 1-ZOEK-PERS...
Here is a example from my program:
SCREEN SECTION.
01 INVOER-SCHERM.
03 BLANK SCREEN.
03 LABEL TITLE "Datum aanvraag" RIGHT
LINES 2 CELLS SIZE 18 CELLS
LINE 2 COL 5.
03...
Hi
(using version 4.1)
Can you calculate dates?
ex.: 20030530 - 20030602 = 3 days.
Because I have to do the following:
A customer may only use 1/week during a half day a odd-jobber.
So when they ask him (today 2003-06-03 - Tuesday) to come on Friday between 9 and 12, then they may ask him...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.