Member Avatar for pennylynne

Hi, working on a project at the moment and the question is "List the full name and age of all directors. For those who are still alive, list their current age (as of 2011), otherwise list how old they were when they died". We are required to translate this to Tutorial D.

Through trial and error, we have learnt that we are required to use the EXTEND function and the following code is all we can get to work:

((Extend a2.Director ADD (2011-Year_Born AS Age) WHERE Year_Died <>0 OR Year_Died=0)) { Firstnames, Surname, Age)

The above statement returns the first names, surnames and the age of all the directors. But we are unable to use two "AS" functions in a statement meaning we can't return the Living Age and Age at Death, is anyone able to help?

Cheers

  • 2 Contributors
  • 1 Reply
  • 105 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by rubberman
Member Avatar for rubberman

I used to teach relational algebra and calculus, but this was before Tutorial D came along (mid 1980's). What system are you using, D4?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.