Search results for query: *

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...

That's it. It works the way I wanted. Thank you very much. Sorry that my question was not very clear at the beginning. Thanks again. Nyh

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

It is a typo. It should be CUSTOMER_HISTORY. But I typed it wrong here not in my application. So the problem still exist. 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 &quot;13 - 16&quot; 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 &quot;Datum aanvraag&quot; RIGHT LINES 2 CELLS SIZE 18 CELLS LINE 2 COL 5. 03...

Do I need to set project options? Because current-date and function aren't accepted.

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...